APPS.GL_FUNDS_CHECKER_PKG dependencies on GL_BC_PACKETS

Line 31: g_packet_id gl_bc_packets.packet_id%TYPE;

27: --
28:
29: -- Packet ID for the Packet being processed
30:
31: g_packet_id gl_bc_packets.packet_id%TYPE;
32:
33:
34: -- Funds Check Return Code for the Packet processed. Valid Return Codes
35: -- are : 'S' for Success, 'A' for Advisory, 'F' for Failure, 'P' for Partial,

Line 38: g_return_code gl_bc_packets.result_code%TYPE;

34: -- Funds Check Return Code for the Packet processed. Valid Return Codes
35: -- are : 'S' for Success, 'A' for Advisory, 'F' for Failure, 'P' for Partial,
36: -- and 'T' for Fatal
37:
38: g_return_code gl_bc_packets.result_code%TYPE;
39:
40: -- Message Token Name
41:
42: msg_tok_names TokNameArray;

Line 109: /* GL_BC_PACKETS */

105: /* FND_FLEX_APIS */
106: /* */
107: /* GL Tables which are being used include : */
108: /* */
109: /* GL_BC_PACKETS */
110: /* GL_BC_PACKET_ARRIVAL_ORDER */
111: /* GL_BC_OPTIONS */
112: /* GL_BC_OPTION_DETAILS */
113: /* GL_BC_PERIOD_MAP */

Line 244: -- This Module deletes all transaction lines of a packet in gl_bc_packets and

240: -- to rollback Funds Reserved after the Funds Checker call. This must be
241: -- called before any commit that would otherwise confirm the final Funds
242: -- Check Status of the packet
243:
244: -- This Module deletes all transaction lines of a packet in gl_bc_packets and
245: -- the associated Arrival Order record in gl_bc_packet_arrival_order
246:
247: -- This Module also deletes the corresponding records for a packet being
248: -- Unreserved

Line 267: delete from gl_bc_packets bp

263: BEGIN
264:
265: -- Delete Packet Transactions
266:
267: delete from gl_bc_packets bp
268: where bp.packet_id in (p_packetid, p_packetid_ursvd);
269:
270:
271: -- Delete Packet Arrival Order Record

Line 322: update gl_bc_packets bp

318: BEGIN
319:
320: -- Update Status Code for the Packet Transactions
321:
322: update gl_bc_packets bp
323: set bp.status_code = 'T'
324: where bp.packet_id = g_packet_id;
325:
326: g_dbug := g_dbug ||