eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_EXP_HOLDS dependencies on AP_INVOICES

Line 469: -- instead of the ap_invoices table to avoid a mutating table problem.

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

Line 471: -- igi_exp_hold_trx on the ap_invoices table queries the ap_invoices

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

Line 472: -- table. to avoid this use the ap_invoices_distribution table.

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

Line 622: FROM AP_INVOICES_ALL a

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',

Line 721: FROM AP_INVOICES_ALL a

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',

Line 819: FROM AP_INVOICES_ALL a

815: a.temp_cancelled_Amount
816: INTO l_source,
817: l_cancelled_date,
818: l_temp_cancelled_amount
819: FROM AP_INVOICES_ALL a
820: WHERE a.invoice_id = l_invoice_id;
821:
822: -- =============== START DEBUG LOG ================
823: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg4',

Line 896: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)

892: l_inv_dist_amt NUMBER;
893: l_temp_cancelled_amount NUMBER;
894: l_inv_line_amt NUMBER;
895:
896: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)
897: IS
898: Select hold_lookup_code
899: From AP_HOLDS_ALL
900: Where invoice_id = p_inv_id

Line 1021: FROM ap_invoices

1017:
1018: -- Check if invoice amount different from distribution amount
1019: SELECT invoice_amount
1020: INTO l_inv_amt
1021: FROM ap_invoices
1022: WHERE invoice_id = p_invoice_id;
1023:
1024: ELSE
1025: l_inv_amt := p_invoice_amt;