APPS.GMS_PA_COSTING_PKG dependencies on GMS_BC_PACKET_ARRIVAL_ORDER

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

2200: END Mark_ExpItem_As_Failed;
2201:
2202: -------------------------------------------------------------------------------
2203: ----------------------------------------------------------------------------------------------------------
2204: -- This Procedure inserts record in gms_bc_packet_arrival_order, once record is
2205: -- inserted lock is released.
2206: -- from gms_concurrency_control using COMMIT;
2207:
2208: -- gms_bc_packet_arrival_order Table will store the order in which packets

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

2204: -- This Procedure inserts record in gms_bc_packet_arrival_order, once record is
2205: -- inserted lock is released.
2206: -- from gms_concurrency_control using COMMIT;
2207:
2208: -- gms_bc_packet_arrival_order Table will store the order in which packets
2209: -- have completed there setup and are ready for funds check.
2210: -- This is required becase packets arrived later can pass fundscheck as setup
2211: -- has not been completed for large packets arrived before.
2212: ----------------------------------------------------------------------------------------------------------

Line 2256: SELECT gms_bc_packet_arrival_order_s.NEXTVAL

2252: -1
2253: );
2254: end; -- end changes for bug 7364172
2255:
2256: SELECT gms_bc_packet_arrival_order_s.NEXTVAL
2257: INTO x_arrival_order_seq
2258: FROM DUAL;
2259:
2260: g_error_stage := 'IN ARRIVAL ORD: INSRT';

Line 2262: INSERT INTO gms_bc_packet_arrival_order

2258: FROM DUAL;
2259:
2260: g_error_stage := 'IN ARRIVAL ORD: INSRT';
2261:
2262: INSERT INTO gms_bc_packet_arrival_order
2263: (packet_id,
2264: arrival_seq,
2265: last_update_date,
2266: last_updated_by)