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 882: Update bom_bill_of_mtls_interface

878: l_process_flag := 3;
879: l_ret_status := 1;
880: end if;
881:
882: Update bom_bill_of_mtls_interface
883: set process_flag = l_process_flag,
884: REQUEST_ID = Fnd_Global.Conc_Request_Id,
885: PROGRAM_ID = Fnd_Global.Conc_program_Id,
886: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1025: DELETE FROM BOM_BILL_OF_MTLS_INTERFACE

1021: BEGIN
1022:
1023: stmt_num := 1;
1024: loop
1025: DELETE FROM BOM_BILL_OF_MTLS_INTERFACE
1026: WHERE PROCESS_FLAG = 7
1027: AND
1028: (
1029: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )