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

Line 32: Called cursor c_ap_invoices_all to generate the vendor_id and vendor_site_id.

28: In case of an insert into jai_ap_tds_payments for invoices created
29: prior to TDS clean up, vendor_id and vendor_site_id are passed as null.
30:
31: Fix :
32: Called cursor c_ap_invoices_all to generate the vendor_id and vendor_site_id.
33: Inserted these values into the jai_ap_tds_payments table.
34:
35: Dependency due to this Bug :
36: Yes.

Line 203: ap_invoices_all aia ,

199: jattt.vendor_site_id vendor_site_id
200: from
201: ap_checks_all aca ,
202: ap_invoice_payments_all aipa ,
203: ap_invoices_all aia ,
204: jai_ap_tds_thhold_trxs jattt,
205: JAI_CMN_TAXES_ALL jitc
206: where
207: aca.check_id = aipa.check_id

Line 274: ap_invoices_all aia

270: aia.attribute1 parent_invoice_id
271: from
272: ap_checks_all aca,
273: ap_invoice_payments_all aipa,
274: ap_invoices_all aia
275: where aca.check_id = aipa.check_id
276: and aipa.invoice_id = aia.invoice_id
277: and aia.source = lv_source
278: and aia.invoice_date between pd_tds_payment_from_date and pd_tds_payment_to_date

Line 312: cursor c_ap_invoices_all(pn_invoice_id number) is

308: )/*bduvarag for Bug#5647725*/
309:
310: ;
311:
312: cursor c_ap_invoices_all(pn_invoice_id number) is
313: select
314: vendor_id,
315: vendor_site_id,
316: cancelled_date

Line 318: ap_invoices_all

314: vendor_id,
315: vendor_site_id,
316: cancelled_date
317: from
318: ap_invoices_all
319: where invoice_id = pn_invoice_id;
320:
321: cursor c_JAI_AP_TDS_INVOICES(pn_parent_invoice_id number, pv_tds_invoice_num varchar2) is
322: select

Line 408: ap_invoices_all aia,

404: aia.attribute1 parent_invoice_id ,
405: aida_prepayment.invoice_id prepay_invoice_id ,
406: -1 * sum(aida.amount) prepaid_amount
407: from
408: ap_invoices_all aia,
409: ap_invoice_distributions_all aida,
410: ap_invoice_distributions_all aida_prepayment
411: where aia.invoice_id = aida.invoice_id
412: and aida.prepay_distribution_id = aida_prepayment.invoice_distribution_id

Line 536: r_ap_invoices_all c_ap_invoices_all%rowtype;

532: ln_vendor_id number(15);
533: ln_vendor_site_id number(15);
534:
535:
536: r_ap_invoices_all c_ap_invoices_all%rowtype;
537: r_JAI_AP_TDS_INVOICES c_JAI_AP_TDS_INVOICES%rowtype;
538: ln_record_count number;
539: ln_threshold_trx_id number;
540: r_get_payment_details c_get_payment_details%rowtype;

Line 574: ap_invoices_all aia ,

570: aca.check_id check_id
571: from
572: ap_checks_all aca ,
573: ap_invoice_payments_all aipa ,
574: ap_invoices_all aia ,
575: jai_ap_tds_thhold_trxs jattt,
576: JAI_CMN_TAXES_ALL jitc
577: where
578: aca.check_id = aipa.check_id

Line 634: open c_ap_invoices_all(cur_rec.parent_invoice_id);

630: /* For prepayment application, taxable basis should be negative */
631: ln_taxable_basis := -1 * ln_taxable_basis;
632: end if;
633:
634: open c_ap_invoices_all(cur_rec.parent_invoice_id);
635: fetch c_ap_invoices_all into r_ap_invoices_all;
636: close c_ap_invoices_all;
637:
638: if r_ap_invoices_all.cancelled_date is not null then

Line 635: fetch c_ap_invoices_all into r_ap_invoices_all;

631: ln_taxable_basis := -1 * ln_taxable_basis;
632: end if;
633:
634: open c_ap_invoices_all(cur_rec.parent_invoice_id);
635: fetch c_ap_invoices_all into r_ap_invoices_all;
636: close c_ap_invoices_all;
637:
638: if r_ap_invoices_all.cancelled_date is not null then
639: lv_parent_invoice_cancel_flag := 'Y';

Line 636: close c_ap_invoices_all;

632: end if;
633:
634: open c_ap_invoices_all(cur_rec.parent_invoice_id);
635: fetch c_ap_invoices_all into r_ap_invoices_all;
636: close c_ap_invoices_all;
637:
638: if r_ap_invoices_all.cancelled_date is not null then
639: lv_parent_invoice_cancel_flag := 'Y';
640: end if;

Line 638: if r_ap_invoices_all.cancelled_date is not null then

634: open c_ap_invoices_all(cur_rec.parent_invoice_id);
635: fetch c_ap_invoices_all into r_ap_invoices_all;
636: close c_ap_invoices_all;
637:
638: if r_ap_invoices_all.cancelled_date is not null then
639: lv_parent_invoice_cancel_flag := 'Y';
640: end if;
641:
642: insert into JAI_AP_TDS_INV_PAYMENTS

Line 741: r_ap_invoices_all := null;

737: ln_taxable_basis := null;
738: ln_vendor_id := null;
739: ln_vendor_site_id := null;
740:
741: r_ap_invoices_all := null;
742: r_JAI_AP_TDS_INVOICES := null;
743:
744: ln_tax_amount := cur_rec.tax_amount;
745:

Line 763: /* parent is not found in ap_invoices_all or JAI_AP_TDS_INVOICES,

759: close c_JAI_AP_TDS_INVOICES_1;
760: end if;
761:
762: if ln_parent_invoice_id is null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
763: /* parent is not found in ap_invoices_all or JAI_AP_TDS_INVOICES,
764: no other details can be found */
765: goto populate_old_invoice_details;
766: end if;
767:

Line 770: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );

766: end if;
767:
768: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
769: if pn_vendor_id is not null or pn_vendor_site_id is not null then
770: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
771: fetch c_ap_invoices_all into r_ap_invoices_all;
772: close c_ap_invoices_all;
773:
774: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or

Line 771: fetch c_ap_invoices_all into r_ap_invoices_all;

767:
768: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
769: if pn_vendor_id is not null or pn_vendor_site_id is not null then
770: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
771: fetch c_ap_invoices_all into r_ap_invoices_all;
772: close c_ap_invoices_all;
773:
774: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
775: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)

Line 772: close c_ap_invoices_all;

768: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
769: if pn_vendor_id is not null or pn_vendor_site_id is not null then
770: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
771: fetch c_ap_invoices_all into r_ap_invoices_all;
772: close c_ap_invoices_all;
773:
774: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
775: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
776: then

Line 774: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or

770: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
771: fetch c_ap_invoices_all into r_ap_invoices_all;
772: close c_ap_invoices_all;
773:
774: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
775: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
776: then
777: goto continue_with_next_record;
778: end if;

Line 775: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)

771: fetch c_ap_invoices_all into r_ap_invoices_all;
772: close c_ap_invoices_all;
773:
774: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
775: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
776: then
777: goto continue_with_next_record;
778: end if;
779:

Line 819: open c_ap_invoices_all(ln_parent_invoice_id );

815:
816: end if;
817:
818: -- added, Harshita for Bug 4643633
819: open c_ap_invoices_all(ln_parent_invoice_id );
820: fetch c_ap_invoices_all into r_ap_invoices_all;
821: close c_ap_invoices_all;
822: -- ended, Harshita for Bug 4643633
823:

Line 820: fetch c_ap_invoices_all into r_ap_invoices_all;

816: end if;
817:
818: -- added, Harshita for Bug 4643633
819: open c_ap_invoices_all(ln_parent_invoice_id );
820: fetch c_ap_invoices_all into r_ap_invoices_all;
821: close c_ap_invoices_all;
822: -- ended, Harshita for Bug 4643633
823:
824: << populate_old_invoice_details >>

Line 821: close c_ap_invoices_all;

817:
818: -- added, Harshita for Bug 4643633
819: open c_ap_invoices_all(ln_parent_invoice_id );
820: fetch c_ap_invoices_all into r_ap_invoices_all;
821: close c_ap_invoices_all;
822: -- ended, Harshita for Bug 4643633
823:
824: << populate_old_invoice_details >>
825: insert into JAI_AP_TDS_INV_PAYMENTS

Line 880: r_ap_invoices_all.vendor_id, --ln_vendor_id , Harshita for Bug 4643633

876: ln_taxable_basis ,
877: ln_tax_amount ,
878: cur_rec.tax_authority_id ,
879: cur_rec.tax_authority_site_id ,
880: r_ap_invoices_all.vendor_id, --ln_vendor_id , Harshita for Bug 4643633
881: r_ap_invoices_all.vendor_site_id , --ln_vendor_site_id , Harshita for Bug 4643633
882: pv_org_tan_num ,
883: cur_rec.org_id ,
884: 'Invoice prior to threshold' ,

Line 881: r_ap_invoices_all.vendor_site_id , --ln_vendor_site_id , Harshita for Bug 4643633

877: ln_tax_amount ,
878: cur_rec.tax_authority_id ,
879: cur_rec.tax_authority_site_id ,
880: r_ap_invoices_all.vendor_id, --ln_vendor_id , Harshita for Bug 4643633
881: r_ap_invoices_all.vendor_site_id , --ln_vendor_site_id , Harshita for Bug 4643633
882: pv_org_tan_num ,
883: cur_rec.org_id ,
884: 'Invoice prior to threshold' ,
885: ln_user_id ,

Line 929: r_ap_invoices_all := null;

925: ln_taxable_basis := null;
926: ln_vendor_id := null;
927: ln_vendor_site_id := null;
928:
929: r_ap_invoices_all := null;
930: r_JAI_AP_TDS_INVOICES := null;
931:
932:
933: /* Get payment information against the prepayment */

Line 976: /* parent is not found in ap_invoices_all or JAI_AP_TDS_INVOICES,

972: close c_JAI_AP_TDS_INVOICES_1;
973: end if;
974:
975: if ln_parent_invoice_id is null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
976: /* parent is not found in ap_invoices_all or JAI_AP_TDS_INVOICES,
977: no other details can be found */
978: goto populate_invoice_details;
979: end if;
980:

Line 983: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );

979: end if;
980:
981: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
982: if pn_vendor_id is not null or pn_vendor_site_id is not null then
983: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
984: fetch c_ap_invoices_all into r_ap_invoices_all;
985: close c_ap_invoices_all;
986:
987: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or

Line 984: fetch c_ap_invoices_all into r_ap_invoices_all;

980:
981: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
982: if pn_vendor_id is not null or pn_vendor_site_id is not null then
983: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
984: fetch c_ap_invoices_all into r_ap_invoices_all;
985: close c_ap_invoices_all;
986:
987: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
988: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)

Line 985: close c_ap_invoices_all;

981: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
982: if pn_vendor_id is not null or pn_vendor_site_id is not null then
983: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
984: fetch c_ap_invoices_all into r_ap_invoices_all;
985: close c_ap_invoices_all;
986:
987: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
988: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
989: then

Line 987: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or

983: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
984: fetch c_ap_invoices_all into r_ap_invoices_all;
985: close c_ap_invoices_all;
986:
987: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
988: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
989: then
990: goto continue_with_next_record;
991: end if;

Line 988: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)

984: fetch c_ap_invoices_all into r_ap_invoices_all;
985: close c_ap_invoices_all;
986:
987: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
988: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
989: then
990: goto continue_with_next_record;
991: end if;
992:

Line 1422: ln_prev_parent_invoice_id ap_invoices_all.invoice_id%TYPE;

1418: from jai_ap_tds_years
1419: where fin_year = p_fin_year;
1420:
1421: ln_cert_line_num NUMBER(15);
1422: ln_prev_parent_invoice_id ap_invoices_all.invoice_id%TYPE;
1423: -- lv_prev_tds_event jai_ap_tds_thhold_trxs.tds_event%TYPE;
1424: /*Bug 5647725 bduvarag*/
1425: lv_tds_event jai_ap_tds_thhold_trxs.tds_event%TYPE;
1426: