DBA Data[Home] [Help]

APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 162: SET transaction_id = mtl_system_items_interface_s.nextval,

158: */
159: stmt_num := 2;
160: LOOP
161: UPDATE bom_ref_desgs_interface
162: SET transaction_id = mtl_system_items_interface_s.nextval,
163: transaction_type = upper(transaction_type)
164: WHERE transaction_id is null
165: AND (UPPER(interface_entity_type) = 'BILL'
166: OR interface_entity_type is null)

Line 447: SELECT mtl_system_items_interface_s.nextval

443: /******************* Removed as a fix for bug 916428 *************************
444: stmt_num := 16;
445: FOR c3rec in c3 LOOP
446: commit_cnt := commit_cnt + 1;
447: SELECT mtl_system_items_interface_s.nextval
448: INTO dummy_txn
449: FROM sys.dual;
450:
451: stmt_num := 17;