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

Line 249: cursor c_ap_invoices_all is

245: lv_process_flag varchar2(20);
246: lv_process_message varchar2(200);
247: ln_final_tds_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
248:
249: cursor c_ap_invoices_all is
250: select vendor_id,
251: vendor_site_id,
252: invoice_currency_code,
253: exchange_rate,

Line 260: from ap_invoices_all

256: cancelled_date,
257: -- Bug#5131075(4683207). Added by Lakshmi Gopalsami
258: invoice_type_lookup_code,
259: invoice_num /*added for bug 6493858 ref-6318997*/
260: from ap_invoices_all
261: where invoice_id = pr_new.invoice_id;
262:
263: --Added by Sanjikum for Bug#5131075(4722011)
264: CURSOR c_check_prepayment_apply IS

Line 278: c_rec_ap_invoices_all c_ap_invoices_all%rowtype;

274:
275: lv_prepay_flag VARCHAR2(1);
276: --End addition by Sanjikum for Bug#5131075(4722011)
277:
278: c_rec_ap_invoices_all c_ap_invoices_all%rowtype;
279: lv_codepath VARCHAR2(1996);
280: lv_is_invoice_validated varchar2(1);
281: lv_new_transaction_si varchar2(1);
282: lv_new_transaction_pp varchar2(1);

Line 283: ln_org_id ap_invoices_all.org_id%type;

279: lv_codepath VARCHAR2(1996);
280: lv_is_invoice_validated varchar2(1);
281: lv_new_transaction_si varchar2(1);
282: lv_new_transaction_pp varchar2(1);
283: ln_org_id ap_invoices_all.org_id%type;
284: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
285: /* bug 5640993 FP of 5553489. Added by JMEENA
286: * Created variable which decides whether the prepayment
287: * created prior to upgrade(TDS-Threshold) has to be processed

Line 284: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;

280: lv_is_invoice_validated varchar2(1);
281: lv_new_transaction_si varchar2(1);
282: lv_new_transaction_pp varchar2(1);
283: ln_org_id ap_invoices_all.org_id%type;
284: ln_set_of_books_id ap_invoices_all.set_of_books_id%type;
285: /* bug 5640993 FP of 5553489. Added by JMEENA
286: * Created variable which decides whether the prepayment
287: * created prior to upgrade(TDS-Threshold) has to be processed
288: */

Line 324: lv_invoice_payment_status ap_invoices_all.payment_status_flag%TYPE;

320: WHERE invoice_id = cp_invoice_id;
321:
322: r_tds_invoice_id c_tds_invoice_id%ROWTYPE;
323:
324: lv_invoice_payment_status ap_invoices_all.payment_status_flag%TYPE;
325:
326: FUNCTION get_invoice_payment_status(p_invoice_id IN NUMBER)
327: RETURN VARCHAR2
328: IS

Line 334: FROM ap_invoices_all

330:
331: CURSOR c_payment_status(cp_invoice_id NUMBER)
332: IS
333: SELECT payment_status_flag
334: FROM ap_invoices_all
335: WHERE invoice_id = cp_invoice_id;
336:
337: r_payment_status c_payment_status%ROWTYPE;
338: BEGIN

Line 386: p_vendor_id => c_rec_ap_invoices_all.vendor_id,

382: p_invoice_distribution_id => pr_new.invoice_distribution_id,
383: p_prepay_distribution_id => pr_new.prepay_distribution_id,
384: p_parent_reversal_id => pr_new.parent_reversal_id,
385: p_prepay_amount => pr_new.amount,
386: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
387: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
388: p_accounting_date => pr_new.accounting_date,
389: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
390: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

Line 387: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,

383: p_prepay_distribution_id => pr_new.prepay_distribution_id,
384: p_parent_reversal_id => pr_new.parent_reversal_id,
385: p_prepay_amount => pr_new.amount,
386: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
387: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
388: p_accounting_date => pr_new.accounting_date,
389: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
390: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
391: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

Line 389: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,

385: p_prepay_amount => pr_new.amount,
386: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
387: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
388: p_accounting_date => pr_new.accounting_date,
389: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
390: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
391: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
392: p_org_id => pr_new.org_id,
393: p_creation_date => pr_new.creation_date, /*Bug 5989740 bduvarag*/

Line 390: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

386: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
387: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
388: p_accounting_date => pr_new.accounting_date,
389: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
390: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
391: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
392: p_org_id => pr_new.org_id,
393: p_creation_date => pr_new.creation_date, /*Bug 5989740 bduvarag*/
394: p_process_flag => lv_process_flag,

Line 391: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

387: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
388: p_accounting_date => pr_new.accounting_date,
389: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
390: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
391: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
392: p_org_id => pr_new.org_id,
393: p_creation_date => pr_new.creation_date, /*Bug 5989740 bduvarag*/
394: p_process_flag => lv_process_flag,
395: p_process_message => lv_process_message,

Line 544: open c_ap_invoices_all;

540: --end if;
541:
542:
543: /* TDS Tax Defaultation Functionality Bug # 4088186 */
544: open c_ap_invoices_all;
545: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
546: close c_ap_invoices_all;
547:
548: /* Bug 5640993 FP of 5553489. Added by JMEENA

Line 545: fetch c_ap_invoices_all into c_rec_ap_invoices_all;

541:
542:
543: /* TDS Tax Defaultation Functionality Bug # 4088186 */
544: open c_ap_invoices_all;
545: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
546: close c_ap_invoices_all;
547:
548: /* Bug 5640993 FP of 5553489. Added by JMEENA
549: * Initialized the variable lv_process_old_trxn to 'Y' so that

Line 546: close c_ap_invoices_all;

542:
543: /* TDS Tax Defaultation Functionality Bug # 4088186 */
544: open c_ap_invoices_all;
545: fetch c_ap_invoices_all into c_rec_ap_invoices_all;
546: close c_ap_invoices_all;
547:
548: /* Bug 5640993 FP of 5553489. Added by JMEENA
549: * Initialized the variable lv_process_old_trxn to 'Y' so that
550: * prepayments will be processed during insert event.

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

568: if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
569:
570: if nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS' and -- rchandan for bug#4333488
571: pr_new.line_type_lookup_code <> 'PREPAY' and
572: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
573: c_rec_ap_invoices_all.cancelled_date is null
574: then
575:
576: jai_ap_tds_tax_defaultation.process_invoice

Line 573: c_rec_ap_invoices_all.cancelled_date is null

569:
570: if nvl(pr_new.global_attribute_category, 'JA.IN.APXINWKB.DISTRIBUTIONS' ) = 'JA.IN.APXINWKB.DISTRIBUTIONS' and -- rchandan for bug#4333488
571: pr_new.line_type_lookup_code <> 'PREPAY' and
572: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
573: c_rec_ap_invoices_all.cancelled_date is null
574: then
575:
576: jai_ap_tds_tax_defaultation.process_invoice
577: (

Line 586: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,

582: p_distribution_line_number => pr_new.distribution_line_number,
583: p_parent_reversal_id => pr_new.parent_reversal_id,
584: p_reversal_flag => pr_new.reversal_flag,
585: p_amount => pr_new.amount,
586: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
587: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
588: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
589: p_po_distribution_id => pr_new.po_distribution_id,
590: p_rcv_transaction_id => pr_new.rcv_transaction_id,

Line 587: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

583: p_parent_reversal_id => pr_new.parent_reversal_id,
584: p_reversal_flag => pr_new.reversal_flag,
585: p_amount => pr_new.amount,
586: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
587: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
588: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
589: p_po_distribution_id => pr_new.po_distribution_id,
590: p_rcv_transaction_id => pr_new.rcv_transaction_id,
591: p_vendor_id => c_rec_ap_invoices_all.vendor_id,

Line 588: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

584: p_reversal_flag => pr_new.reversal_flag,
585: p_amount => pr_new.amount,
586: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
587: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
588: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
589: p_po_distribution_id => pr_new.po_distribution_id,
590: p_rcv_transaction_id => pr_new.rcv_transaction_id,
591: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
592: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,

Line 591: p_vendor_id => c_rec_ap_invoices_all.vendor_id,

587: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
588: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
589: p_po_distribution_id => pr_new.po_distribution_id,
590: p_rcv_transaction_id => pr_new.rcv_transaction_id,
591: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
592: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
593: p_input_dff_value_tds => pr_new.global_attribute1, -- rchandan for bug#4333488
594: p_input_dff_value_wct => pr_new.global_attribute2, -- rchandan for bug#4333488
595: --p_old_input_dff_value_wct => pr_old.global_attribute2,-- Bug 5911913 Added by vkantamn --commented by Sanjikum for Bug#6708042

Line 592: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,

588: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
589: p_po_distribution_id => pr_new.po_distribution_id,
590: p_rcv_transaction_id => pr_new.rcv_transaction_id,
591: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
592: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
593: p_input_dff_value_tds => pr_new.global_attribute1, -- rchandan for bug#4333488
594: p_input_dff_value_wct => pr_new.global_attribute2, -- rchandan for bug#4333488
595: --p_old_input_dff_value_wct => pr_old.global_attribute2,-- Bug 5911913 Added by vkantamn --commented by Sanjikum for Bug#6708042
596: p_input_dff_value_essi => pr_new.global_attribute3, -- rchandan for bug#4333488

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

629: if pv_action = jai_constants.updating then
630:
631: if nvl(pr_old.match_status_flag, 'Q') <> nvl(pr_new.match_status_flag, 'Q') and
632: pr_new.match_status_flag = 'A' and
633: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
634: c_rec_ap_invoices_all.cancelled_date is null
635: then
636:
637: /* Bug#5131075(4683207). Added by Lakshmi Gopalsami

Line 634: c_rec_ap_invoices_all.cancelled_date is null

630:
631: if nvl(pr_old.match_status_flag, 'Q') <> nvl(pr_new.match_status_flag, 'Q') and
632: pr_new.match_status_flag = 'A' and
633: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
634: c_rec_ap_invoices_all.cancelled_date is null
635: then
636:
637: /* Bug#5131075(4683207). Added by Lakshmi Gopalsami
638: Don't proceed for TDS invoice creation if the invoice type

Line 642: If c_rec_ap_invoices_all.invoice_type_lookup_code

638: Don't proceed for TDS invoice creation if the invoice type
639: is either 'CREDIT' or 'DEBIT'
640: */
641:
642: If c_rec_ap_invoices_all.invoice_type_lookup_code
643: IN ('CREDIT', 'DEBIT')
644: Then
645: return;
646: End if;

Line 674: p_vendor_id => c_rec_ap_invoices_all.vendor_id,

670: lv_codepath := null;
671: jai_ap_tds_generation_pkg.process_tds_at_inv_validate
672: (
673: p_invoice_id => pr_new.invoice_id,
674: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
675: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
676: p_accounting_date => pr_new.accounting_date,
677: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
678: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

Line 675: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,

671: jai_ap_tds_generation_pkg.process_tds_at_inv_validate
672: (
673: p_invoice_id => pr_new.invoice_id,
674: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
675: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
676: p_accounting_date => pr_new.accounting_date,
677: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
678: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
679: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

Line 677: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,

673: p_invoice_id => pr_new.invoice_id,
674: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
675: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
676: p_accounting_date => pr_new.accounting_date,
677: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
678: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
679: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
680: p_org_id => pr_new.org_id,
681: p_call_from => 'ja_in_ap_aida_before_trg',

Line 678: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

674: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
675: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
676: p_accounting_date => pr_new.accounting_date,
677: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
678: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
679: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
680: p_org_id => pr_new.org_id,
681: p_call_from => 'ja_in_ap_aida_before_trg',
682: p_creation_date => pr_new.creation_date,/*Bug 5989740 bduvarag*/

Line 679: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

675: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
676: p_accounting_date => pr_new.accounting_date,
677: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
678: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
679: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
680: p_org_id => pr_new.org_id,
681: p_call_from => 'ja_in_ap_aida_before_trg',
682: p_creation_date => pr_new.creation_date,/*Bug 5989740 bduvarag*/
683: p_process_flag => lv_process_flag,

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

738: /* Prepayment functionality */
739: if pv_action = jai_constants.inserting then
740:
741: if pr_new.line_type_lookup_code = 'PREPAY' and
742: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
743: c_rec_ap_invoices_all.cancelled_date is null
744: then
745:
746: /* Bug#5131075(4683207). Added by Lakshmi Gopalsami

Line 743: c_rec_ap_invoices_all.cancelled_date is null

739: if pv_action = jai_constants.inserting then
740:
741: if pr_new.line_type_lookup_code = 'PREPAY' and
742: c_rec_ap_invoices_all.source <> 'INDIA TDS' and /*'TDS' and --Ramanand for bug#4388958 */
743: c_rec_ap_invoices_all.cancelled_date is null
744: then
745:
746: /* Bug#5131075(4683207). Added by Lakshmi Gopalsami
747: Don't proceed for TDS invoice creation if the invoice type

Line 751: If c_rec_ap_invoices_all.invoice_type_lookup_code

747: Don't proceed for TDS invoice creation if the invoice type
748: is either 'CREDIT' or 'DEBIT'
749: */
750:
751: If c_rec_ap_invoices_all.invoice_type_lookup_code
752: IN ('CREDIT', 'DEBIT')
753: Then
754: return;
755: End if;

Line 823: p_vendor_id => c_rec_ap_invoices_all.vendor_id,

819: p_invoice_distribution_id => pr_new.invoice_distribution_id,
820: p_prepay_distribution_id => pr_new.prepay_distribution_id,
821: p_parent_reversal_id => pr_new.parent_reversal_id,
822: p_prepay_amount => pr_new.amount,
823: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
824: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
825: p_accounting_date => pr_new.accounting_date,
826: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
827: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

Line 824: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,

820: p_prepay_distribution_id => pr_new.prepay_distribution_id,
821: p_parent_reversal_id => pr_new.parent_reversal_id,
822: p_prepay_amount => pr_new.amount,
823: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
824: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
825: p_accounting_date => pr_new.accounting_date,
826: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
827: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
828: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

Line 826: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,

822: p_prepay_amount => pr_new.amount,
823: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
824: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
825: p_accounting_date => pr_new.accounting_date,
826: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
827: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
828: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
829: p_org_id => pr_new.org_id,
830: p_process_flag => lv_process_flag,

Line 827: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,

823: p_vendor_id => c_rec_ap_invoices_all.vendor_id,
824: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
825: p_accounting_date => pr_new.accounting_date,
826: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
827: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
828: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
829: p_org_id => pr_new.org_id,
830: p_process_flag => lv_process_flag,
831: p_process_message => lv_process_message,

Line 828: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,

824: p_vendor_site_id => c_rec_ap_invoices_all.vendor_site_id,
825: p_accounting_date => pr_new.accounting_date,
826: p_invoice_currency_code => c_rec_ap_invoices_all.invoice_currency_code,
827: p_exchange_rate => c_rec_ap_invoices_all.exchange_rate,
828: p_set_of_books_id => c_rec_ap_invoices_all.set_of_books_id,
829: p_org_id => pr_new.org_id,
830: p_process_flag => lv_process_flag,
831: p_process_message => lv_process_message,
832: p_codepath => lv_codepath

Line 877: IF pr_new.cancellation_flag = 'Y' AND c_rec_ap_invoices_all.source <> 'INDIA TDS'

873:
874: end if; /* Prepayment functionality */
875:
876: /*Code Started start changes for bug 6493858 - cancellation functionality*/
877: IF pr_new.cancellation_flag = 'Y' AND c_rec_ap_invoices_all.source <> 'INDIA TDS'
878: THEN
879: OPEN c_tds_invoice_id(pr_new.invoice_id);
880: FETCH c_tds_invoice_id INTO r_tds_invoice_id;
881: CLOSE c_tds_invoice_id;