APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BC_PACKETS_BVID

Line 121: (select budget_version_id from gms_bc_packets_bvid)

117: Cursor c_lock_bvid is
118: select budget_version_id
119: from gms_budget_versions
120: where budget_version_id in
121: (select budget_version_id from gms_bc_packets_bvid)
122: for update;
123: Begin
124: for x in c_lock_bvid loop
125: null; -- Dummy code to lock gms_budget_versions

Line 6058: INSERT INTO gms_bc_packets_bvid

6054: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');
6055: END IF;
6056: x_date := sysdate;
6057: g_error_stage := 'FC PR : INSRT SUMM';
6058: INSERT INTO gms_bc_packets_bvid
6059: (packet_id,
6060: budget_version_id,
6061: creation_date)
6062: SELECT DISTINCT x_packetid,

Line 6070: -- Bug 4053891 Do not change code flow ..as lock_budget_versions uses gms_bc_packets_bvid

6066: WHERE packet_id = x_packetid
6067: AND status_code = 'P' -- This is to ignore Transactions which failed during setup.
6068: ;
6069:
6070: -- Bug 4053891 Do not change code flow ..as lock_budget_versions uses gms_bc_packets_bvid
6071: -- Costing and Funds check is incompatible to Sweeper. 'EXP' has been added to the list for
6072: -- interface (VI->EXP)
6073:
6074: If g_doc_type in ('REQ','PO','AP','FAB','EXP') then

Line 6109: gms_bc_packets_bvid a

6105: nvl(sum(decode(bcpkt.status_code || bcpkt.actual_flag, 'AE',nvl(entered_dr,0) - nvl(entered_cr,0),0)),0),
6106: nvl(sum(decode(bcpkt.status_code || bcpkt.actual_flag, 'PE',nvl(entered_dr,0) - nvl(entered_cr,0),0)),0)
6107: FROM gms_bc_packets bcpkt,
6108: gms_bc_packet_arrival_order ao,
6109: gms_bc_packets_bvid a
6110: WHERE bcpkt.status_code IN ('A', 'P')
6111: AND bcpkt.budget_version_id = a.budget_version_id
6112: AND bcpkt.packet_id = ao.packet_id
6113: AND a.packet_id = x_packetid

Line 7500: DELETE gms_bc_packets_bvid

7496: --================================================================================--
7497: g_error_stage := 'FC PR : DELETE';
7498: DELETE gms_bc_packets_summary
7499: WHERE packet_id = x_packetid;
7500: DELETE gms_bc_packets_bvid
7501: WHERE packet_id = x_packetid;
7502:
7503: -- Added commit for the base bug 3848201
7504: commit;