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_HA_TRIGGER_PKG dependencies on AP_INVOICES_ALL

Line 16: from ap_invoices_all

12: */
13: PROCEDURE BRI_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14: cursor c_get_cm_details(p_invoice_id number) is
15: select source
16: from ap_invoices_all
17: where invoice_id = p_invoice_id;
18:
19: v_source ap_invoices_all.source%type;
20:

Line 19: v_source ap_invoices_all.source%type;

15: select source
16: from ap_invoices_all
17: where invoice_id = p_invoice_id;
18:
19: v_source ap_invoices_all.source%type;
20:
21:
22: BEGIN
23: pv_return_code := jai_constants.successful ;

Line 105: CURSOR c_ap_invoices_all (p_invoice_id number) is

101: REM
102: REM +======================================================================+
103: */
104: PROCEDURE BRIUD_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
105: CURSOR c_ap_invoices_all (p_invoice_id number) is
106: SELECT vendor_id,
107: vendor_site_id,
108: invoice_currency_code,
109: exchange_rate,

Line 120: FROM ap_invoices_all

116: invoice_amount,
117: payment_status_flag,
118: invoice_type_lookup_code
119:
120: FROM ap_invoices_all
121: WHERE invoice_id = p_invoice_id;
122:
123: c_rec_ap_invoices_all c_ap_invoices_all%rowtype;
124: lv_codepath VARCHAR2(1996);

Line 123: c_rec_ap_invoices_all c_ap_invoices_all%rowtype;

119:
120: FROM ap_invoices_all
121: WHERE invoice_id = p_invoice_id;
122:
123: c_rec_ap_invoices_all c_ap_invoices_all%rowtype;
124: lv_codepath VARCHAR2(1996);
125: lv_is_invoice_validated varchar2(1);
126: lv_process_flag varchar2(20);
127: lv_process_message varchar2(200);

Line 131: ln_org_id ap_invoices_all.org_id%type;

127: lv_process_message varchar2(200);
128:
129: lb_result boolean;
130: ln_req_id number;
131: ln_org_id ap_invoices_all.org_id%type;
132: lv_request_id number ; -- added, Harshita for Bug#5131075(5346558)
133: BEGIN
134: pv_return_code := jai_constants.successful ;
135: /*------------------------------------------------------------------------------------------

Line 198: open c_ap_invoices_all(pr_new.invoice_id);

194:
195: /*
196: || TDS Invoice generation Functionality Bug # 4088186
197: */
198: open c_ap_invoices_all(pr_new.invoice_id);
199: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
200: close c_ap_invoices_all;
201:
202: if pv_action = jai_constants.updating and

Line 199: fetch c_ap_invoices_all into c_rec_ap_invoices_all;

195: /*
196: || TDS Invoice generation Functionality Bug # 4088186
197: */
198: open c_ap_invoices_all(pr_new.invoice_id);
199: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
200: close c_ap_invoices_all;
201:
202: if pv_action = jai_constants.updating and
203: pr_new.release_reason is not null and

Line 200: close c_ap_invoices_all;

196: || TDS Invoice generation Functionality Bug # 4088186
197: */
198: open c_ap_invoices_all(pr_new.invoice_id);
199: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
200: close c_ap_invoices_all;
201:
202: if pv_action = jai_constants.updating and
203: pr_new.release_reason is not null and
204: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /* 'TDS' and --Ramanand for bug#4388958 */

Line 204: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /* 'TDS' and --Ramanand for bug#4388958 */

200: close c_ap_invoices_all;
201:
202: if pv_action = jai_constants.updating and
203: pr_new.release_reason is not null and
204: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /* 'TDS' and --Ramanand for bug#4388958 */
205: c_rec_ap_invoices_all.cancelled_date is null
206: then
207:
208: /* Bug#5131075(4683207). Added by Lakshmi Gopalsami

Line 205: c_rec_ap_invoices_all.cancelled_date is null

201:
202: if pv_action = jai_constants.updating and
203: pr_new.release_reason is not null and
204: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /* 'TDS' and --Ramanand for bug#4388958 */
205: c_rec_ap_invoices_all.cancelled_date is null
206: then
207:
208: /* Bug#5131075(4683207). Added by Lakshmi Gopalsami
209: Don't proceed for TDS invoice creation if the invoice type

Line 213: If c_rec_ap_invoices_all.invoice_type_lookup_code

209: Don't proceed for TDS invoice creation if the invoice type
210: is either 'CREDIT' or 'DEBIT'
211: */
212:
213: If c_rec_ap_invoices_all.invoice_type_lookup_code
214: IN ('CREDIT', 'DEBIT')
215: Then
216: return;
217: End if;

Line 243: c_rec_ap_invoices_all.invoice_amount,

239: 'India - Generate TDS Invoices after Holds release',
240: '',
241: FALSE,
242: pr_new.invoice_id,
243: c_rec_ap_invoices_all.invoice_amount,
244: c_rec_ap_invoices_all.payment_status_flag,
245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,

Line 244: c_rec_ap_invoices_all.payment_status_flag,

240: '',
241: FALSE,
242: pr_new.invoice_id,
243: c_rec_ap_invoices_all.invoice_amount,
244: c_rec_ap_invoices_all.payment_status_flag,
245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,

Line 245: c_rec_ap_invoices_all.invoice_type_lookup_code,

241: FALSE,
242: pr_new.invoice_id,
243: c_rec_ap_invoices_all.invoice_amount,
244: c_rec_ap_invoices_all.payment_status_flag,
245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,

Line 246: c_rec_ap_invoices_all.vendor_id,

242: pr_new.invoice_id,
243: c_rec_ap_invoices_all.invoice_amount,
244: c_rec_ap_invoices_all.payment_status_flag,
245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,

Line 247: c_rec_ap_invoices_all.vendor_site_id,

243: c_rec_ap_invoices_all.invoice_amount,
244: c_rec_ap_invoices_all.payment_status_flag,
245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,
251: c_rec_ap_invoices_all.set_of_books_id,

Line 248: c_rec_ap_invoices_all.gl_date,

244: c_rec_ap_invoices_all.payment_status_flag,
245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,
251: c_rec_ap_invoices_all.set_of_books_id,
252: c_rec_ap_invoices_all.org_id,

Line 249: c_rec_ap_invoices_all.invoice_currency_code,

245: c_rec_ap_invoices_all.invoice_type_lookup_code,
246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,
251: c_rec_ap_invoices_all.set_of_books_id,
252: c_rec_ap_invoices_all.org_id,
253: 'JAI_AP_HA_TRIGGER_PKG.BRIUD_T1',

Line 250: c_rec_ap_invoices_all.exchange_rate,

246: c_rec_ap_invoices_all.vendor_id,
247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,
251: c_rec_ap_invoices_all.set_of_books_id,
252: c_rec_ap_invoices_all.org_id,
253: 'JAI_AP_HA_TRIGGER_PKG.BRIUD_T1',
254: lv_process_flag,

Line 251: c_rec_ap_invoices_all.set_of_books_id,

247: c_rec_ap_invoices_all.vendor_site_id,
248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,
251: c_rec_ap_invoices_all.set_of_books_id,
252: c_rec_ap_invoices_all.org_id,
253: 'JAI_AP_HA_TRIGGER_PKG.BRIUD_T1',
254: lv_process_flag,
255: lv_process_message,

Line 252: c_rec_ap_invoices_all.org_id,

248: c_rec_ap_invoices_all.gl_date,
249: c_rec_ap_invoices_all.invoice_currency_code,
250: c_rec_ap_invoices_all.exchange_rate,
251: c_rec_ap_invoices_all.set_of_books_id,
252: c_rec_ap_invoices_all.org_id,
253: 'JAI_AP_HA_TRIGGER_PKG.BRIUD_T1',
254: lv_process_flag,
255: lv_process_message,
256: lv_codepath,