[Home] [Help]
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 */
114: /* GL_BC_DUAL */
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
249:
269:
270:
271: -- Delete Packet Arrival Order Record
272:
273: delete from gl_bc_packet_arrival_order ao
274: where ao.packet_id in (p_packetid, p_packetid_ursvd);
275:
276:
277: EXCEPTION
288:
289: -- Update Status Code for Transactions to Fatal
290:
291: -- Updates Status Code for all transactions in the Packet to 'T'; it also
292: -- updates affect_funds_flag in gl_bc_packet_arrival_order to 'N' so that
293: -- the available Funds calculation of packets arriving later is not affected
294: -- in case an irrecoverable error halts Funds Check. SQLs for updating the
295: -- columns are not guaranteed to succeed in many drastic cases. However, this
296: -- step tries to ensure that the current packet does not affect the Funds
329:
330:
331: -- Update Affect Funds Flag
332:
333: update gl_bc_packet_arrival_order ao
334: set ao.affect_funds_flag = 'N'
335: where ao.packet_id = g_packet_id;
336:
337: if PSA_FUNDS_CHECKER_PKG.glzfrs_public