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 190: ap_invoices_all aia ,

186: jattt.vendor_site_id vendor_site_id
187: from
188: ap_checks_all aca ,
189: ap_invoice_payments_all aipa ,
190: ap_invoices_all aia ,
191: jai_ap_tds_thhold_trxs jattt,
192: JAI_CMN_TAXES_ALL jitc
193: where
194: aca.check_id = aipa.check_id

Line 261: ap_invoices_all aia

257: aia.attribute1 parent_invoice_id
258: from
259: ap_checks_all aca,
260: ap_invoice_payments_all aipa,
261: ap_invoices_all aia
262: where aca.check_id = aipa.check_id
263: and aipa.invoice_id = aia.invoice_id
264: and aia.source = lv_source
265: and aia.invoice_date between pd_tds_payment_from_date and pd_tds_payment_to_date

Line 299: cursor c_ap_invoices_all(pn_invoice_id number) is

295: )/*bduvarag for Bug#5647725*/
296:
297: ;
298:
299: cursor c_ap_invoices_all(pn_invoice_id number) is
300: select
301: vendor_id,
302: vendor_site_id,
303: cancelled_date

Line 305: ap_invoices_all

301: vendor_id,
302: vendor_site_id,
303: cancelled_date
304: from
305: ap_invoices_all
306: where invoice_id = pn_invoice_id;
307:
308: cursor c_JAI_AP_TDS_INVOICES(pn_parent_invoice_id number, pv_tds_invoice_num varchar2) is
309: select

Line 395: ap_invoices_all aia,

391: aia.attribute1 parent_invoice_id ,
392: aida_prepayment.invoice_id prepay_invoice_id ,
393: -1 * sum(aida.amount) prepaid_amount
394: from
395: ap_invoices_all aia,
396: ap_invoice_distributions_all aida,
397: ap_invoice_distributions_all aida_prepayment
398: where aia.invoice_id = aida.invoice_id
399: and aida.prepay_distribution_id = aida_prepayment.invoice_distribution_id

Line 523: r_ap_invoices_all c_ap_invoices_all%rowtype;

519: ln_vendor_id number(15);
520: ln_vendor_site_id number(15);
521:
522:
523: r_ap_invoices_all c_ap_invoices_all%rowtype;
524: r_JAI_AP_TDS_INVOICES c_JAI_AP_TDS_INVOICES%rowtype;
525: ln_record_count number;
526: ln_threshold_trx_id number;
527: r_get_payment_details c_get_payment_details%rowtype;

Line 561: ap_invoices_all aia ,

557: aca.check_id check_id
558: from
559: ap_checks_all aca ,
560: ap_invoice_payments_all aipa ,
561: ap_invoices_all aia ,
562: jai_ap_tds_thhold_trxs jattt,
563: JAI_CMN_TAXES_ALL jitc
564: where
565: aca.check_id = aipa.check_id

Line 621: open c_ap_invoices_all(cur_rec.parent_invoice_id);

617: /* For prepayment application, taxable basis should be negative */
618: ln_taxable_basis := -1 * ln_taxable_basis;
619: end if;
620:
621: open c_ap_invoices_all(cur_rec.parent_invoice_id);
622: fetch c_ap_invoices_all into r_ap_invoices_all;
623: close c_ap_invoices_all;
624:
625: if r_ap_invoices_all.cancelled_date is not null then

Line 622: fetch c_ap_invoices_all into r_ap_invoices_all;

618: ln_taxable_basis := -1 * ln_taxable_basis;
619: end if;
620:
621: open c_ap_invoices_all(cur_rec.parent_invoice_id);
622: fetch c_ap_invoices_all into r_ap_invoices_all;
623: close c_ap_invoices_all;
624:
625: if r_ap_invoices_all.cancelled_date is not null then
626: lv_parent_invoice_cancel_flag := 'Y';

Line 623: close c_ap_invoices_all;

619: end if;
620:
621: open c_ap_invoices_all(cur_rec.parent_invoice_id);
622: fetch c_ap_invoices_all into r_ap_invoices_all;
623: close c_ap_invoices_all;
624:
625: if r_ap_invoices_all.cancelled_date is not null then
626: lv_parent_invoice_cancel_flag := 'Y';
627: end if;

Line 625: if r_ap_invoices_all.cancelled_date is not null then

621: open c_ap_invoices_all(cur_rec.parent_invoice_id);
622: fetch c_ap_invoices_all into r_ap_invoices_all;
623: close c_ap_invoices_all;
624:
625: if r_ap_invoices_all.cancelled_date is not null then
626: lv_parent_invoice_cancel_flag := 'Y';
627: end if;
628:
629: insert into JAI_AP_TDS_INV_PAYMENTS

Line 728: r_ap_invoices_all := null;

724: ln_taxable_basis := null;
725: ln_vendor_id := null;
726: ln_vendor_site_id := null;
727:
728: r_ap_invoices_all := null;
729: r_JAI_AP_TDS_INVOICES := null;
730:
731: ln_tax_amount := cur_rec.tax_amount;
732:

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

746: close c_JAI_AP_TDS_INVOICES_1;
747: end if;
748:
749: if ln_parent_invoice_id is null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
750: /* parent is not found in ap_invoices_all or JAI_AP_TDS_INVOICES,
751: no other details can be found */
752: goto populate_old_invoice_details;
753: end if;
754:

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

753: end if;
754:
755: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
756: if pn_vendor_id is not null or pn_vendor_site_id is not null then
757: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
758: fetch c_ap_invoices_all into r_ap_invoices_all;
759: close c_ap_invoices_all;
760:
761: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or

Line 758: fetch c_ap_invoices_all into r_ap_invoices_all;

754:
755: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
756: if pn_vendor_id is not null or pn_vendor_site_id is not null then
757: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
758: fetch c_ap_invoices_all into r_ap_invoices_all;
759: close c_ap_invoices_all;
760:
761: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
762: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)

Line 759: close c_ap_invoices_all;

755: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
756: if pn_vendor_id is not null or pn_vendor_site_id is not null then
757: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
758: fetch c_ap_invoices_all into r_ap_invoices_all;
759: close c_ap_invoices_all;
760:
761: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
762: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
763: then

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

757: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
758: fetch c_ap_invoices_all into r_ap_invoices_all;
759: close c_ap_invoices_all;
760:
761: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
762: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
763: then
764: goto continue_with_next_record;
765: end if;

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

758: fetch c_ap_invoices_all into r_ap_invoices_all;
759: close c_ap_invoices_all;
760:
761: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
762: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
763: then
764: goto continue_with_next_record;
765: end if;
766:

Line 806: open c_ap_invoices_all(ln_parent_invoice_id );

802:
803: end if;
804:
805: -- added, Harshita for Bug 4643633
806: open c_ap_invoices_all(ln_parent_invoice_id );
807: fetch c_ap_invoices_all into r_ap_invoices_all;
808: close c_ap_invoices_all;
809: -- ended, Harshita for Bug 4643633
810:

Line 807: fetch c_ap_invoices_all into r_ap_invoices_all;

803: end if;
804:
805: -- added, Harshita for Bug 4643633
806: open c_ap_invoices_all(ln_parent_invoice_id );
807: fetch c_ap_invoices_all into r_ap_invoices_all;
808: close c_ap_invoices_all;
809: -- ended, Harshita for Bug 4643633
810:
811: << populate_old_invoice_details >>

Line 808: close c_ap_invoices_all;

804:
805: -- added, Harshita for Bug 4643633
806: open c_ap_invoices_all(ln_parent_invoice_id );
807: fetch c_ap_invoices_all into r_ap_invoices_all;
808: close c_ap_invoices_all;
809: -- ended, Harshita for Bug 4643633
810:
811: << populate_old_invoice_details >>
812: insert into JAI_AP_TDS_INV_PAYMENTS

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

863: ln_taxable_basis ,
864: ln_tax_amount ,
865: cur_rec.tax_authority_id ,
866: cur_rec.tax_authority_site_id ,
867: r_ap_invoices_all.vendor_id, --ln_vendor_id , Harshita for Bug 4643633
868: r_ap_invoices_all.vendor_site_id , --ln_vendor_site_id , Harshita for Bug 4643633
869: pv_org_tan_num ,
870: cur_rec.org_id ,
871: 'Invoice prior to threshold' ,

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

864: ln_tax_amount ,
865: cur_rec.tax_authority_id ,
866: cur_rec.tax_authority_site_id ,
867: r_ap_invoices_all.vendor_id, --ln_vendor_id , Harshita for Bug 4643633
868: r_ap_invoices_all.vendor_site_id , --ln_vendor_site_id , Harshita for Bug 4643633
869: pv_org_tan_num ,
870: cur_rec.org_id ,
871: 'Invoice prior to threshold' ,
872: ln_user_id ,

Line 916: r_ap_invoices_all := null;

912: ln_taxable_basis := null;
913: ln_vendor_id := null;
914: ln_vendor_site_id := null;
915:
916: r_ap_invoices_all := null;
917: r_JAI_AP_TDS_INVOICES := null;
918:
919:
920: /* Get payment information against the prepayment */

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

959: close c_JAI_AP_TDS_INVOICES_1;
960: end if;
961:
962: if ln_parent_invoice_id is null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
963: /* parent is not found in ap_invoices_all or JAI_AP_TDS_INVOICES,
964: no other details can be found */
965: goto populate_invoice_details;
966: end if;
967:

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

966: end if;
967:
968: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
969: if pn_vendor_id is not null or pn_vendor_site_id is not null then
970: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
971: fetch c_ap_invoices_all into r_ap_invoices_all;
972: close c_ap_invoices_all;
973:
974: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or

Line 971: fetch c_ap_invoices_all into r_ap_invoices_all;

967:
968: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
969: if pn_vendor_id is not null or pn_vendor_site_id is not null then
970: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
971: fetch c_ap_invoices_all into r_ap_invoices_all;
972: close c_ap_invoices_all;
973:
974: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
975: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)

Line 972: close c_ap_invoices_all;

968: /* A parent invoice has been traced, check if it passes filtering condition of vendor and site if given */
969: if pn_vendor_id is not null or pn_vendor_site_id is not null then
970: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
971: fetch c_ap_invoices_all into r_ap_invoices_all;
972: close c_ap_invoices_all;
973:
974: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
975: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
976: then

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

970: open c_ap_invoices_all( nvl(ln_parent_invoice_id, r_JAI_AP_TDS_INVOICES.parent_invoice_id) );
971: fetch c_ap_invoices_all into r_ap_invoices_all;
972: close c_ap_invoices_all;
973:
974: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
975: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
976: then
977: goto continue_with_next_record;
978: end if;

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

971: fetch c_ap_invoices_all into r_ap_invoices_all;
972: close c_ap_invoices_all;
973:
974: if r_ap_invoices_all.vendor_id <> nvl(pn_vendor_id, r_ap_invoices_all.vendor_id) or
975: r_ap_invoices_all.vendor_site_id <> nvl(pn_vendor_site_id, r_ap_invoices_all.vendor_site_id)
976: then
977: goto continue_with_next_record;
978: end if;
979:

Line 1394: ln_prev_parent_invoice_id ap_invoices_all.invoice_id%TYPE;

1390: FROM dual;
1391:
1392:
1393: ln_cert_line_num NUMBER(15);
1394: ln_prev_parent_invoice_id ap_invoices_all.invoice_id%TYPE;
1395: -- lv_prev_tds_event jai_ap_tds_thhold_trxs.tds_event%TYPE;
1396: /*Bug 5647725 bduvarag*/
1397: lv_tds_event jai_ap_tds_thhold_trxs.tds_event%TYPE;
1398: