DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on DUAL

Line 597: dual;

593: SELECT mtl_material_transactions_s.nextval
594: INTO
595: L_txn_header_id
596: FROM
597: dual;
598: --
599: IF(p_serial_number IS NOT NULL) THEN
600: --
601: SELECT mtl_material_transactions_s.nextval

Line 605: dual;

601: SELECT mtl_material_transactions_s.nextval
602: INTO
603: L_txn_temp_id
604: FROM
605: dual;
606: --
607: SELECT auto_serial_alpha_prefix
608: INTO
609: L_serial_prefix

Line 2334: dual;

2330: MTL_CYCLE_COUNT_ENTRIES_S.nextval
2331: INTO
2332: L_CCEntryId
2333: FROM
2334: dual;
2335: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID := L_CCEntryId;
2336: IF (l_debug = 1) THEN
2337: MDEBUG( 'New CCId : '||to_char(L_CCEntryId));
2338: END IF;

Line 2589: dual;

2585: MTL_CC_ENTRIES_INTERFACE_S1.nextval
2586: INTO
2587: L_CCEOIId
2588: FROM
2589: dual;
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: IF (l_debug = 1) THEN
2593: mdebug('id creation failed failed');

Line 2952: dual;

2948: SELECT MTL_CC_INTERFACE_ERRORS_S.nextval
2949: INTO
2950: L_interface_error_id
2951: FROM
2952: dual;
2953: --
2954: INSERT INTO mtl_cc_interface_errors(
2955: interface_error_id,
2956: cc_entry_interface_id,