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.JAI_AP_IA_DTC_TRIGGER_PKG dependencies on AP_INVOICES_ALL

Line 27: ln_org_id ap_invoices_all.org_id%type;

23: lb_result boolean;
24: ln_req_id number;
25: lv_process_flag varchar2(20);
26: lv_process_message varchar2(1100);
27: ln_org_id ap_invoices_all.org_id%type;
28: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
29: lv_proc_name VARCHAR2 (100) := 'BRIUD_T1';
30: lv_open_period ap_invoice_distributions_all.period_name%type;
31: ld_accounting_date DATE;

Line 28: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;

24: ln_req_id number;
25: lv_process_flag varchar2(20);
26: lv_process_message varchar2(1100);
27: ln_org_id ap_invoices_all.org_id%type;
28: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
29: lv_proc_name VARCHAR2 (100) := 'BRIUD_T1';
30: lv_open_period ap_invoice_distributions_all.period_name%type;
31: ld_accounting_date DATE;
32: ld_out_accounting_date DATE;

Line 59: CURSOR get_dist_gl_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS

55: and tds_rollbacked is NULL
56: order by threshold_trx_id;
57:
58: --Get GL_date from distribution
59: CURSOR get_dist_gl_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
60: SELECT accounting_date
61: FROM ap_invoice_distributions_all
62: WHERE invoice_id = cp_invoice_id
63: AND distribution_line_number = 1;

Line 68: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS

64: -- Only one distribution will be created for TDS invoices and so
65: -- hard coded the distribution line number to 1.
66:
67: --If GL date in distribution is NULL, get from invoice header
68: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
69: SELECT accounting_date
70: FROM ap_invoice_lines_all
71: WHERE invoice_id = cp_invoice_id
72: AND line_number = 1;

Line 87: lv_invoice_payment_status ap_invoices_all.payment_status_flag%TYPE;

83: and not exists (select '1'
84: from jai_ap_tds_thhold_trxs
85: where invoice_id = jatit.invoice_id); /*to ensure that no TDS is deducted*/
86:
87: lv_invoice_payment_status ap_invoices_all.payment_status_flag%TYPE;
88:
89: FUNCTION get_invoice_org_id(p_invoice_id IN NUMBER)
90: RETURN NUMBER
91: IS

Line 94: cursor c_ap_invoices_all(p_invoice_id number) is

90: RETURN NUMBER
91: IS
92: PRAGMA AUTONOMOUS_TRANSACTION;
93:
94: cursor c_ap_invoices_all(p_invoice_id number) is
95: select org_id
96: from ap_invoices_all
97: where invoice_id = p_invoice_id;
98:

Line 96: from ap_invoices_all

92: PRAGMA AUTONOMOUS_TRANSACTION;
93:
94: cursor c_ap_invoices_all(p_invoice_id number) is
95: select org_id
96: from ap_invoices_all
97: where invoice_id = p_invoice_id;
98:
99: r_ap_invoices_all c_ap_invoices_all%ROWTYPE;
100: BEGIN

Line 99: r_ap_invoices_all c_ap_invoices_all%ROWTYPE;

95: select org_id
96: from ap_invoices_all
97: where invoice_id = p_invoice_id;
98:
99: r_ap_invoices_all c_ap_invoices_all%ROWTYPE;
100: BEGIN
101: OPEN c_ap_invoices_all(p_invoice_id);
102: FETCH c_ap_invoices_all INTO r_ap_invoices_all;
103: CLOSE c_ap_invoices_all;

Line 101: OPEN c_ap_invoices_all(p_invoice_id);

97: where invoice_id = p_invoice_id;
98:
99: r_ap_invoices_all c_ap_invoices_all%ROWTYPE;
100: BEGIN
101: OPEN c_ap_invoices_all(p_invoice_id);
102: FETCH c_ap_invoices_all INTO r_ap_invoices_all;
103: CLOSE c_ap_invoices_all;
104:
105: RETURN r_ap_invoices_all.org_id;

Line 102: FETCH c_ap_invoices_all INTO r_ap_invoices_all;

98:
99: r_ap_invoices_all c_ap_invoices_all%ROWTYPE;
100: BEGIN
101: OPEN c_ap_invoices_all(p_invoice_id);
102: FETCH c_ap_invoices_all INTO r_ap_invoices_all;
103: CLOSE c_ap_invoices_all;
104:
105: RETURN r_ap_invoices_all.org_id;
106: END get_invoice_org_id;

Line 103: CLOSE c_ap_invoices_all;

99: r_ap_invoices_all c_ap_invoices_all%ROWTYPE;
100: BEGIN
101: OPEN c_ap_invoices_all(p_invoice_id);
102: FETCH c_ap_invoices_all INTO r_ap_invoices_all;
103: CLOSE c_ap_invoices_all;
104:
105: RETURN r_ap_invoices_all.org_id;
106: END get_invoice_org_id;
107:

Line 105: RETURN r_ap_invoices_all.org_id;

101: OPEN c_ap_invoices_all(p_invoice_id);
102: FETCH c_ap_invoices_all INTO r_ap_invoices_all;
103: CLOSE c_ap_invoices_all;
104:
105: RETURN r_ap_invoices_all.org_id;
106: END get_invoice_org_id;
107:
108:
109: FUNCTION get_invoice_payment_status(p_invoice_id IN NUMBER)

Line 117: FROM ap_invoices_all

113:
114: CURSOR c_payment_status(cp_invoice_id NUMBER)
115: IS
116: SELECT payment_status_flag
117: FROM ap_invoices_all
118: WHERE invoice_id = cp_invoice_id;
119:
120: r_payment_status c_payment_status%ROWTYPE;
121: BEGIN

Line 357: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);

353:
354:
355: exception
356: when others then
357: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);
358: /* Added an exception block by Ramananda for bug#4570303 */
359: Pv_return_code := jai_constants.unexpected_error;
360: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.BRIUD_T1 ' ||
361: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);

Line 361: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);

357: --raise_application_error(-20003, 'Error - trigger ja_in_ap_aia_before_trg on ap_invoices_all : ' || sqlerrm);
358: /* Added an exception block by Ramananda for bug#4570303 */
359: Pv_return_code := jai_constants.unexpected_error;
360: Pv_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.BRIUD_T1 ' ||
361: 'Error on ap_invoices_all : ' || substr(sqlerrm,1,1800);
362: JAI_CMN_UTILS_PKG.WRITE_FND_LOG(G_LEVEL_ERROR, GV_MODULE_PREFIX ||'.'|| lv_proc_name, pv_return_message);
363: END BRIUD_T1 ;
364:
365: END JAI_AP_IA_DTC_TRIGGER_PKG ;