APPS.GMS_FUNDS_POSTING_PKG dependencies on GL_BC_PACKETS

Line 203: UPDATE gl_bc_packets gl

199: ELSIF t_stage = 'POSTING' THEN
200: x_gl_return_code := 'Z';
201: END IF; -- Bug 2337897 : Added End If
202:
203: UPDATE gl_bc_packets gl
204: SET gl.result_code = DECODE (
205: NVL (SUBSTR (result_code, 1, 1), 'P'),
206: 'P', 'F71',
207: result_code)

Line 408: gl_bc_packets gl

404: FROM ap_invoice_distributions_all ap,
405: gms_award_distributions adl,
406: pa_projects_all pp,
407: gms_project_types gpt,
408: gl_bc_packets gl
409: WHERE gl.packet_id = p_packet_id
410: AND gl.je_source_name = 'Payables'
411: AND gl.template_id IS NULL
412: AND gl.je_category_name = 'Purchase Invoices'

Line 437: gl_bc_packets gl

433: SELECT gl.packet_id
434: FROM ap_invoice_distributions_all ap,
435: pa_projects_all pp,
436: gms_project_types gpt,
437: gl_bc_packets gl
438: WHERE gl.packet_id = p_packet_id
439: AND gl.je_source_name = 'Payables'
440: AND gl.template_id IS NULL
441: AND gl.je_category_name = 'Purchase Invoices'

Line 455: gl_bc_packets gl

451: SELECT gl.packet_id
452: FROM pa_projects_all pp,
453: gms_project_types gpt,
454: po_req_distributions_all pord,
455: gl_bc_packets gl
456: WHERE gl.packet_id = p_packet_id
457: AND gl.reference1 = 'REQ'
458: AND gl.template_id IS NULL
459: AND gl.reference3 = pord.distribution_id

Line 467: FROM gl_bc_packets gl,

463: AND gpt.sponsored_flag = 'Y';
464:
465: CURSOR c_non_gms_ip is
466: SELECT gl.packet_id
467: FROM gl_bc_packets gl,
468: pa_projects pp,
469: gms_project_types gpt
470: WHERE gl.packet_id = p_packet_id
471: AND pp.project_id = TO_NUMBER (gl.reference7)

Line 478: FROM po_distributions_all pod, pa_projects_all pp, gms_project_types gpt, gl_bc_packets gl

474: AND NVL (gl.reference6, 'XXXXX') = 'GMSIP' ;
475:
476: CURSOR c_non_gms_po IS
477: SELECT gl.packet_id
478: FROM po_distributions_all pod, pa_projects_all pp, gms_project_types gpt, gl_bc_packets gl
479: WHERE gl.packet_id = p_packet_id
480: AND gl.reference1 = 'PO'
481: AND gl.template_id IS NULL
482: AND gl.reference3 = pod.po_distribution_id

Line 494: FROM gl_bc_packets

490: CURSOR c_document_type IS
491: SELECT DISTINCT NVL (reference1, 'X'),
492: je_source_name,
493: je_category_name
494: FROM gl_bc_packets
495: WHERE packet_id = p_packet_id
496: AND template_id IS NULL
497: AND ( ( reference1 in ('PO', 'REQ') ) OR
498: ( je_source_name = 'Payables' AND je_category_name = 'Purchase Invoices' ) OR

Line 658: -- Procedure will update the result codes on gl_bc_packets record,

654:
655: -- ==================================================================
656: -- Bug : 2557041 - Added for IP check funds Enhancement
657: -- This procedure is called from procedure gms_gl_return_code .
658: -- Procedure will update the result codes on gl_bc_packets record,
659: -- if the records have:
660: -- A. Failed grants funds check process.
661: -- B. Passed grants funds check process in advisory mode.
662: -- ==================================================================

Line 693: UPDATE gl_bc_packets glc

689: FETCH c_gl_update_required INTO l_dummy;
690: IF c_gl_update_required%FOUND THEN
691:
692: g_error_stage := 'GL_RESULT_CODE UPD :REC_FOUND';
693: UPDATE gl_bc_packets glc
694: SET glc.result_code = (SELECT DECODE (
695: SUBSTR (bp.result_code, 1, 1),
696: 'P', DECODE (
697: bp.result_code,

Line 751: -- Update gl_bc_packets with Failure status if gl.result_code

747: 'F79', 'F67', --Funds Check processing error
748: 'F82', 'F67', --Funds Check processing error
749: 'F94', 'F67', --Funds Check processing error
750: 'F95', 'F67', --Funds Check processing error
751: -- Update gl_bc_packets with Failure status if gl.result_code
752: -- is Pxx and gms.result_code is Fxx but the result_code is
753: -- not there in the above List
754: DECODE(NVL(SUBSTR(glc.result_code,1,1),'P'),'P','F67',glc.result_code)
755: )

Line 758: WHERE bp.gl_bc_packets_rowid = ROWIDTOCHAR(glc.ROWID)

754: DECODE(NVL(SUBSTR(glc.result_code,1,1),'P'),'P','F67',glc.result_code)
755: )
756: )
757: FROM gms_bc_packets bp
758: WHERE bp.gl_bc_packets_rowid = ROWIDTOCHAR(glc.ROWID)
759: AND bp.result_code NOT IN ('F63', 'F75')
760: AND bp.packet_id = p_packet_id
761: AND ROWNUM = 1)
762: WHERE glc.packet_id = p_packet_id

Line 771: AND gms1.gl_bc_packets_rowid = ROWIDTOCHAR(glc.ROWID)

767: -- update result_code on Non-GMS Transactions.
768: AND EXISTS (SELECT 1
769: FROM gms_bc_packets gms1
770: WHERE gms1.packet_id = glc.packet_id
771: AND gms1.gl_bc_packets_rowid = ROWIDTOCHAR(glc.ROWID)
772: );
773:
774: END IF;
775:

Line 791: -- in synch with gl_bc_Packets and updates the result_code in

787:
788: -- =============================================================================
789: -- GMS_RESULT_CODE_UPDATE
790: -- Purpose: This is called from gms_gl_return_code to have gms_bc_packet
791: -- in synch with gl_bc_Packets and updates the result_code in
792: -- gms_bc_packets with 'F30', 'F31', 'F32' values.
793: -- =============================================================================
794: PROCEDURE gms_result_code_update ( x_gl_return_code IN OUT NOCOPY VARCHAR2,
795: p_packet_id IN NUMBER,

Line 903: -- code value assigned to gl bc packets record.

899:
900: -- ====================================================================
901: -- GET_GL_RETURN_CODE
902: -- Following function determines the gl return code based on the result
903: -- code value assigned to gl bc packets record.
904: -- ====================================================================
905: FUNCTION get_gl_return_code ( p_packet_id IN NUMBER,
906: p_gms_partial_flag IN VARCHAR2)
907: RETURN VARCHAR2 IS

Line 926: FROM gl_bc_packets bp

922: 1, 'A'),
923: COUNT (DECODE (SUBSTR (bp.result_code, 1, 1), 'F', 1)), 'F',
924: DECODE (p_gms_partial_flag, 'Y', 'P', 'F'))
925: INTO t_return_code
926: FROM gl_bc_packets bp
927: WHERE bp.packet_id = p_packet_id
928: AND bp.template_id IS NULL; /* detail transactions only */
929:
930: RETURN t_return_code;