Close and Reopen batch order

This post I will show how to close and reopen the batch with an API. This batch order is win completed status. Execute this below command: DECLARE l_api_version NUMBER := 2.0; l_validation_level NUMBER default GME_COMMON_PVT.g_max_errors; l_message_count NUMBER; l_message_list VARCHAR2(500); l_return_status VARCHAR2(1); p_org_code VARCHAR2(10); p_batch_no VARCHAR2(10); p_batch_rec gme_batch_header%ROWTYPE; x_batch_rec gme_batch_header%ROWTYPE; xitem VARCHAR2(16); BEGIN FND_GLOBAL.apps_initialize(user_id => 1139,... Continuar Lendo →

Create OPM Batch – New Materials Operations-Activities-Routings-Resources-Transactions on OPM

This post I will show a API to create Operations, Activities, Generic Resources and Routings on OPM. Create OPM Batch DECLARE l_api_version NUMBER := 2.0; l_validation_level NUMBER DEFAULT GME_COMMON_PVT.G_MAX_ERRORS; p_init_msg_list BOOLEAN DEFAULT FALSE; P_batch_type NUMBER := 0; p_batch_qty NUMBER := 5; l_batch_header gme_batch_header%ROWTYPE; x_batch_header gme_batch_header%ROWTYPE; l_message_count NUMBER; l_message_list VARCHAR2 (500); l_return_status VARCHAR2 (1); l_msg_index_out NUMBER;... Continuar Lendo →

Powered by por Anders Noren

Acima ↑