APPS.BOM_RTG_OPEN_INTERFACE dependencies on BOM_OP_ROUTINGS_INTERFACE

Line 82: select * from BOM_OP_ROUTINGS_INTERFACE

78: , p_batch_id IN NUMBER
79: ) RETURN INTEGER IS
80:
81: cursor get_rtg_header is
82: select * from BOM_OP_ROUTINGS_INTERFACE
83: Where process_flag = 1
84: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
85: and transaction_id is not null
86: and

Line 875: Update BOM_OP_ROUTINGS_INTERFACE

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

Line 1015: DELETE FROM BOM_OP_ROUTINGS_INTERFACE

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