DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GL_ENCUMBRANCE_TYPES

Line 8565: gl_encumbrance_types glet

8561: glbc.accounted_dr entered_dr , -- Bug 5614467
8562: glbc.accounted_cr entered_cr, -- Bug 5614467
8563: source_distribution_type
8564: from gl_bc_packets glbc,
8565: gl_encumbrance_types glet
8566: where glbc.packet_id = p_packet_id
8567: and glbc.encumbrance_type_id = glet.encumbrance_type_id;
8568:
8569: l_dist_id pa_bc_packets.document_header_id%type;

Line 8587: /* Bug 5250793 : Added a join with gl_encumbrance_types so that the gl_bc_packets_rowid on gms_bc_packets is updated

8583: IF g_debug = 'Y' THEN
8584: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Previously establised packet is = '|| l_gms_packet_id,'C');
8585: END IF;
8586:
8587: /* Bug 5250793 : Added a join with gl_encumbrance_types so that the gl_bc_packets_rowid on gms_bc_packets is updated
8588: correctly for an invoice matched to a PO scenario. Before this change , the same gl_bc_packets_rowid was updated on
8589: gms_bc_packets for both the PO reversal and AP reserve records irrespective of the corresponding rowid on gl_bc_packets.*/
8590:
8591: -- Update gms_bc_packets data

Line 8728: FROM gl_encumbrance_types glenc

8724: /* End changes for bug#13975496 */
8725: --and glbc.source_distribution_id_num_1 <> gbc.document_distribution_id
8726: /*Commented the line for bug#13975496 */
8727: and glbc.encumbrance_type_id IN (SELECT glenc.encumbrance_type_id --Seeded encumbrance type for PO
8728: FROM gl_encumbrance_types glenc
8729: WHERE glenc.encumbrance_type_key = 'Obligation')
8730: and rownum = 1)
8731: where gbc.packet_id = l_gms_packet_id
8732: and gbc.status_code = 'I'