APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 120: select * from BOM_BILL_OF_MTLS_INTERFACE

116: p_batch_id IN NUMBER)
117: return integer IS
118:
119: cursor get_bills is
120: select * from BOM_BILL_OF_MTLS_INTERFACE
121: where process_flag = 1
122: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
123: and transaction_id is not null
124: and

Line 873: Update bom_bill_of_mtls_interface

869: l_process_flag := 3;
870: l_ret_status := 1;
871: end if;
872:
873: Update bom_bill_of_mtls_interface
874: set process_flag = l_process_flag,
875: REQUEST_ID = Fnd_Global.Conc_Request_Id,
876: PROGRAM_ID = Fnd_Global.Conc_program_Id,
877: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1016: DELETE FROM BOM_BILL_OF_MTLS_INTERFACE

1012: BEGIN
1013:
1014: stmt_num := 1;
1015: loop
1016: DELETE FROM BOM_BILL_OF_MTLS_INTERFACE
1017: WHERE PROCESS_FLAG = 7
1018: AND
1019: (
1020: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )