APPS.GMS_PA_COSTING_PKG dependencies on GMS_BC_PACKET_ARRIVAL_ORDER

Line 2149: -- This Procedure inserts record in gms_bc_packet_arrival_order, once record is

2145: END Mark_ExpItem_As_Failed;
2146:
2147: -------------------------------------------------------------------------------
2148: ----------------------------------------------------------------------------------------------------------
2149: -- This Procedure inserts record in gms_bc_packet_arrival_order, once record is
2150: -- inserted lock is released.
2151: -- from gms_concurrency_control using COMMIT;
2152:
2153: -- gms_bc_packet_arrival_order Table will store the order in which packets

Line 2153: -- gms_bc_packet_arrival_order Table will store the order in which packets

2149: -- This Procedure inserts record in gms_bc_packet_arrival_order, once record is
2150: -- inserted lock is released.
2151: -- from gms_concurrency_control using COMMIT;
2152:
2153: -- gms_bc_packet_arrival_order Table will store the order in which packets
2154: -- have completed there setup and are ready for funds check.
2155: -- This is required becase packets arrived later can pass fundscheck as setup
2156: -- has not been completed for large packets arrived before.
2157: ----------------------------------------------------------------------------------------------------------

Line 2176: SELECT gms_bc_packet_arrival_order_s.NEXTVAL

2172: FROM gms_concurrency_control
2173: WHERE process_name = 'GMSFCTRL'
2174: FOR UPDATE;
2175:
2176: SELECT gms_bc_packet_arrival_order_s.NEXTVAL
2177: INTO x_arrival_order_seq
2178: FROM DUAL;
2179:
2180: g_error_stage := 'IN ARRIVAL ORD: INSRT';

Line 2182: INSERT INTO gms_bc_packet_arrival_order

2178: FROM DUAL;
2179:
2180: g_error_stage := 'IN ARRIVAL ORD: INSRT';
2181:
2182: INSERT INTO gms_bc_packet_arrival_order
2183: (packet_id,
2184: arrival_seq,
2185: last_update_date,
2186: last_updated_by)