APPS.WMS_TASK_DISPATCH_ENGINE dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 11433: --SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;

11429: EXIT WHEN task_list%NOTFOUND;
11430: END IF;
11431:
11432: l_parent_task_count := l_parent_task_count + 1;
11433: --SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;
11434:
11435: IF (l_debug = 1) THEN
11436: print_debug('Creating a Parent Line with the values...', 4);
11437: print_debug(' --> Txn Header ID => ' || l_transaction_header_id, 4);

Line 11516: , mtl_material_transactions_s.NEXTVAL --Bug 5535030

11512: )
11513: VALUES (
11514: l_transaction_header_id
11515: --, l_new_txn_temp_id
11516: , mtl_material_transactions_s.NEXTVAL --Bug 5535030
11517: , 'N'
11518: , 2
11519: , l_last_update_date
11520: , l_last_updated_by

Line 11550: , mtl_material_transactions_s.CURRVAL

11546: , l_cartonization_id
11547: , l_operation_plan_id
11548: , l_wms_task_status
11549: -- , l_new_txn_temp_id -- have the same as patchset J
11550: , mtl_material_transactions_s.CURRVAL
11551: -- Bug 4584538
11552: , l_primary_uom_code
11553: , l_lot_control_code
11554: , l_serial_control_code

Line 12175: -- SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;

12171: END IF;
12172: end if;
12173:
12174: l_parent_task_count := l_parent_task_count + 1;
12175: -- SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;
12176:
12177: IF (l_debug = 1) THEN
12178: print_debug('Creating a Parent Line with the values...', 4);
12179: print_debug(' --> Txn Header ID => ' || l_transaction_header_id, 4);

Line 12241: , mtl_material_transactions_s.NEXTVAL --Bug 5535030

12237: )
12238: VALUES (
12239: l_transaction_header_id
12240: --, l_new_txn_temp_id
12241: , mtl_material_transactions_s.NEXTVAL --Bug 5535030
12242: , 'N'
12243: , 2
12244: , l_last_update_date
12245: , l_last_updated_by

Line 12269: , mtl_material_transactions_s.CURRVAL

12265: , l_container_item_id
12266: , l_operation_plan_id
12267: , l_wms_task_status
12268: --, l_new_txn_temp_id
12269: , mtl_material_transactions_s.CURRVAL
12270: , l_primary_uom_code
12271: , l_lot_control_code
12272: , l_serial_control_code
12273: , l_serial_allocated_flag

Line 12964: SELECT mtl_material_transactions_s.NEXTVAL

12960: end if;
12961: l_progress := '130';
12962:
12963: -- generate new transaction_temp_id primary key
12964: SELECT mtl_material_transactions_s.NEXTVAL
12965: INTO l_new_temp_id
12966: FROM DUAL;
12967:
12968: l_progress := '140';

Line 13058: SELECT mtl_material_transactions_s.NEXTVAL

13054: where transaction_temp_id = l_child_rec.transaction_temp_id;
13055:
13056: -- split the child task
13057: -- generate new transaction_temp_id primary key
13058: SELECT mtl_material_transactions_s.NEXTVAL
13059: INTO l_new_child_temp_id
13060: FROM DUAL;
13061:
13062: l_progress := '140.1';