[Home] [Help]
465: , p_calling_sequence VARCHAR2)
466: RETURN BOOLEAN
467: IS
468: -- For the following CURSOR the ap_invoice_distributions table is used
469: -- instead of the ap_invoices table to avoid a mutating table problem.
470: -- This occurs when this package which is called from the trigger
471: -- igi_exp_hold_trx on the ap_invoices table queries the ap_invoices
472: -- table. to avoid this use the ap_invoices_distribution table.
473: -- also true for igi_exp_hold_t1 asmales
467: IS
468: -- For the following CURSOR the ap_invoice_distributions table is used
469: -- instead of the ap_invoices table to avoid a mutating table problem.
470: -- This occurs when this package which is called from the trigger
471: -- igi_exp_hold_trx on the ap_invoices table queries the ap_invoices
472: -- table. to avoid this use the ap_invoices_distribution table.
473: -- also true for igi_exp_hold_t1 asmales
474:
475: -- bug 2885976
468: -- For the following CURSOR the ap_invoice_distributions table is used
469: -- instead of the ap_invoices table to avoid a mutating table problem.
470: -- This occurs when this package which is called from the trigger
471: -- igi_exp_hold_trx on the ap_invoices table queries the ap_invoices
472: -- table. to avoid this use the ap_invoices_distribution table.
473: -- also true for igi_exp_hold_t1 asmales
474:
475: -- bug 2885976
476: CURSOR c_check_hold_exclusions ( pv_invoice_id NUMBER
618: a.temp_cancelled_amount
619: INTO l_source,
620: l_cancelled_date,
621: l_temp_cancelled_amount
622: FROM AP_INVOICES_ALL a
623: WHERE a.invoice_id = l_invoice_id;
624:
625: -- =============== START DEBUG LOG ================
626: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg4',
717: a.temp_cancelled_Amount
718: INTO l_source,
719: l_cancelled_date,
720: l_temp_cancelled_amount
721: FROM AP_INVOICES_ALL a
722: WHERE a.invoice_id = l_invoice_id;
723:
724: -- =============== START DEBUG LOG ================
725: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg4',
781: l_hold_lookup_code VARCHAR2(200) := 'AWAIT EXP APP';
782: l_calling_sequence VARCHAR2(1000);
783: l_temp_cancelled_amount NUMBER;
784: l_approval_status_code VARCHAR2(100);
785: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
786:
787: BEGIN
788:
789: -- =============== START DEBUG LOG ================
814:
815: SELECT a.source,
816: a.cancelled_date,
817: a.temp_cancelled_Amount,
818: ap_invoices_pkg.get_approval_status (a.invoice_id, a.invoice_amount, a.payment_status_flag, a.invoice_type_lookup_code),
819: a.invoice_type_lookup_code
820: INTO l_source,
821: l_cancelled_date,
822: l_temp_cancelled_amount,
821: l_cancelled_date,
822: l_temp_cancelled_amount,
823: l_approval_status_code,
824: l_invoice_type_lookup_code
825: FROM AP_INVOICES_ALL a
826: WHERE a.invoice_id = l_invoice_id;
827:
828: -- =============== START DEBUG LOG ================
829: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg4',
902: l_inv_dist_amt NUMBER;
903: l_temp_cancelled_amount NUMBER;
904: l_inv_line_amt NUMBER;
905:
906: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)
907: IS
908: Select hold_lookup_code
909: From AP_HOLDS_ALL
910: Where invoice_id = p_inv_id
1027:
1028: -- Check if invoice amount different from distribution amount
1029: SELECT invoice_amount
1030: INTO l_inv_amt
1031: FROM ap_invoices
1032: WHERE invoice_id = p_invoice_id;
1033:
1034: ELSE
1035: l_inv_amt := p_invoice_amt;