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 6414: INSERT INTO gms_bc_packets_bvid

6410: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');
6411: END IF;
6412: x_date := sysdate;
6413: g_error_stage := 'FC PR : INSRT SUMM';
6414: INSERT INTO gms_bc_packets_bvid
6415: (packet_id,
6416: budget_version_id,
6417: creation_date)
6418: SELECT DISTINCT x_packetid,

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

6422: WHERE packet_id = x_packetid
6423: AND status_code = 'P' -- This is to ignore Transactions which failed during setup.
6424: ;
6425:
6426: -- Bug 4053891 Do not change code flow ..as lock_budget_versions uses gms_bc_packets_bvid
6427: -- Costing and Funds check is incompatible to Sweeper. 'EXP' has been added to the list for
6428: -- interface (VI->EXP)
6429:
6430: If g_doc_type in ('REQ','PO','AP','FAB','EXP') then

Line 6465: gms_bc_packets_bvid a

6461: nvl(sum(decode(bcpkt.status_code || bcpkt.actual_flag, 'AE',nvl(entered_dr,0) - nvl(entered_cr,0),0)),0),
6462: nvl(sum(decode(bcpkt.status_code || bcpkt.actual_flag, 'PE',nvl(entered_dr,0) - nvl(entered_cr,0),0)),0)
6463: FROM gms_bc_packets bcpkt,
6464: gms_bc_packet_arrival_order ao,
6465: gms_bc_packets_bvid a
6466: WHERE bcpkt.status_code IN ('A', 'P')
6467: AND bcpkt.budget_version_id = a.budget_version_id
6468: AND bcpkt.packet_id = ao.packet_id
6469: AND a.packet_id = x_packetid

Line 7856: DELETE gms_bc_packets_bvid

7852: --================================================================================--
7853: g_error_stage := 'FC PR : DELETE';
7854: DELETE gms_bc_packets_summary
7855: WHERE packet_id = x_packetid;
7856: DELETE gms_bc_packets_bvid
7857: WHERE packet_id = x_packetid;
7858:
7859: -- Added commit for the base bug 3848201
7860: commit;