APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on AP_INVOICE_LINES_ALL

Line 83: Fetch Accounting Date from AP_INVOICE_LINES_ALL if distributions is not saved.

79: 11. 17-Jul-2009 Bgowrava for Bug#8682951 , File Version 120.4.12000000.4
80: Changed the parameter ld_accounting_date to sysdate while calling process_threshold_rollback in the loop c_jai_ap_tds_inv_taxes.
81:
82: 12. 25-Aug-2009 Bug 8830302
83: Fetch Accounting Date from AP_INVOICE_LINES_ALL if distributions is not saved.
84: This will prevent failure during cancellation.
85:
86: 13. 07-Jan-2010 Jia for FP Bug#7312295, File Version 120.4.12000000.5
87: Issue: This is a forward port bug for the bug7252683.

Line 213: /*Bug 8830302 - Get Accounting Date from AP_INVOICE_LINES_ALL.

209: AND distribution_line_number = 1;
210: -- Only one distribution will be created for TDS invoices and so
211: -- hard coded the distribution line number to 1.
212:
213: /*Bug 8830302 - Get Accounting Date from AP_INVOICE_LINES_ALL.
214: This is fail safe if Distributions does not have accounting date*/
215: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
216: IS
217: SELECT accounting_date

Line 218: FROM ap_invoice_lines_all

214: This is fail safe if Distributions does not have accounting date*/
215: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
216: IS
217: SELECT accounting_date
218: FROM ap_invoice_lines_all
219: WHERE invoice_id = cp_invoice_id
220: AND line_number = 1;
221:
222: -- Added by Jia for FP Bug#7312295, Begin

Line 445: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/

441: OPEN get_dist_gl_date(cur_rec.invoice_to_tds_authority_id);
442: FETCH get_dist_gl_date INTO ld_accounting_date;
443: CLOSE get_dist_gl_date;
444:
445: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/
446: if (ld_accounting_date is NULL) then
447: OPEN c_get_lines_acct_date(cur_rec.invoice_to_tds_authority_id);
448: FETCH c_get_lines_acct_date INTO ld_accounting_date;
449: CLOSE c_get_lines_acct_date;

Line 616: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/

612: OPEN get_dist_gl_date(cur_rec.invoice_to_vendor_id );
613: FETCH get_dist_gl_date INTO ld_accounting_date;
614: CLOSE get_dist_gl_date;
615:
616: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/
617: if (ld_accounting_date is NULL) then
618: OPEN c_get_lines_acct_date(cur_rec.invoice_to_vendor_id);
619: FETCH c_get_lines_acct_date INTO ld_accounting_date;
620: CLOSE c_get_lines_acct_date;