DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on DUAL

Line 672: dual;

668: SELECT mtl_material_transactions_s.nextval
669: INTO
670: L_txn_header_id
671: FROM
672: dual;
673: --
674: IF(p_serial_number IS NOT NULL) THEN
675: --
676: SELECT mtl_material_transactions_s.nextval

Line 680: dual;

676: SELECT mtl_material_transactions_s.nextval
677: INTO
678: L_txn_temp_id
679: FROM
680: dual;
681: --
682: SELECT auto_serial_alpha_prefix
683: INTO
684: L_serial_prefix

Line 2453: dual;

2449: MTL_CYCLE_COUNT_ENTRIES_S.nextval
2450: INTO
2451: L_CCEntryId
2452: FROM
2453: dual;
2454: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID := L_CCEntryId;
2455: IF (l_debug = 1) THEN
2456: MDEBUG( 'New CCId : '||to_char(L_CCEntryId));
2457: END IF;

Line 2727: dual;

2723: MTL_CC_ENTRIES_INTERFACE_S1.nextval
2724: INTO
2725: L_CCEOIId
2726: FROM
2727: dual;
2728: EXCEPTION
2729: WHEN OTHERS THEN
2730: IF (l_debug = 1) THEN
2731: mdebug('id creation failed failed');

Line 3090: dual;

3086: SELECT MTL_CC_INTERFACE_ERRORS_S.nextval
3087: INTO
3088: L_interface_error_id
3089: FROM
3090: dual;
3091: --
3092: INSERT INTO mtl_cc_interface_errors(
3093: interface_error_id,
3094: cc_entry_interface_id,