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 JAI_AP_TDS_INVOICES

Line 321: cursor c_JAI_AP_TDS_INVOICES(pn_parent_invoice_id number, pv_tds_invoice_num varchar2) is

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
323: invoice_id parent_invoice_id ,
324: invoice_amount taxable_basis ,
325: tds_tax_id tds_tax_id ,

Line 330: JAI_AP_TDS_INVOICES

326: tds_section tds_section ,
327: tds_tax_rate tds_tax_rate ,
328: tds_amount tax_amount
329: from
330: JAI_AP_TDS_INVOICES
331: where invoice_id = nvl(pn_parent_invoice_id, invoice_id)
332: and tds_invoice_num = pv_tds_invoice_num
333: and source_attribute = lv_source_attribute;
334:

Line 336: cursor c_JAI_AP_TDS_INVOICES_1(pv_tds_invoice_num varchar2) is

332: and tds_invoice_num = pv_tds_invoice_num
333: and source_attribute = lv_source_attribute;
334:
335: /* identifies parent on basis of invoice number */
336: cursor c_JAI_AP_TDS_INVOICES_1(pv_tds_invoice_num varchar2) is
337: select
338: invoice_id parent_invoice_id ,
339: invoice_amount taxable_basis ,
340: tds_tax_id tds_tax_id ,

Line 345: JAI_AP_TDS_INVOICES

341: tds_section tds_section ,
342: tds_tax_rate tds_tax_rate ,
343: tds_amount tax_amount
344: from
345: JAI_AP_TDS_INVOICES
346: where tds_invoice_num = pv_tds_invoice_num
347: and source_attribute = lv_source_attribute;
348:
349:

Line 353: from JAI_AP_TDS_INVOICES jiati_1

349:
350:
351: cursor c_get_section_if_one(pn_invoice_id number) is
352: select jiati_1.tds_section
353: from JAI_AP_TDS_INVOICES jiati_1
354: where jiati_1.invoice_id = pn_invoice_id
355: and source_attribute = lv_source_attribute
356: and not exists
357: (

Line 359: from JAI_AP_TDS_INVOICES jiati_2

355: and source_attribute = lv_source_attribute
356: and not exists
357: (
358: select '1'
359: from JAI_AP_TDS_INVOICES jiati_2
360: where jiati_1.rowid <> jiati_2.rowid
361: and source_attribute = lv_source_attribute
362: and jiati_1.invoice_id = jiati_2.invoice_id
363: and jiati_1.tds_section <> jiati_2.tds_section

Line 371: from JAI_AP_TDS_INVOICES jiati_1

367: cursor c_get_tax_if_one(pn_invoice_id number) is
368: select
369: jiati_1.tds_tax_id ,
370: jiati_1.tds_tax_rate
371: from JAI_AP_TDS_INVOICES jiati_1
372: where jiati_1.invoice_id = pn_invoice_id
373: and source_attribute = lv_source_attribute
374: and not exists
375: (

Line 377: from JAI_AP_TDS_INVOICES jiati_2

373: and source_attribute = lv_source_attribute
374: and not exists
375: (
376: select '1'
377: from JAI_AP_TDS_INVOICES jiati_2
378: where jiati_1.rowid <> jiati_2.rowid
379: and source_attribute = lv_source_attribute
380: and jiati_1.invoice_id = jiati_2.invoice_id
381: and jiati_1.tds_tax_id <> jiati_2.tds_tax_id

Line 537: r_JAI_AP_TDS_INVOICES c_JAI_AP_TDS_INVOICES%rowtype;

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;
541:

Line 742: r_JAI_AP_TDS_INVOICES := 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:
746:

Line 752: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);

748: ln_parent_invoice_id := cur_rec.parent_invoice_id;
749: end if;
750:
751: if ln_parent_invoice_id is not null then
752: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);
753: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
754: close c_JAI_AP_TDS_INVOICES;
755: else
756: /* try n find the parent based on invoice number */

Line 753: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;

749: end if;
750:
751: if ln_parent_invoice_id is not null then
752: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);
753: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
754: close c_JAI_AP_TDS_INVOICES;
755: else
756: /* try n find the parent based on invoice number */
757: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);

Line 754: close c_JAI_AP_TDS_INVOICES;

750:
751: if ln_parent_invoice_id is not null then
752: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);
753: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
754: close c_JAI_AP_TDS_INVOICES;
755: else
756: /* try n find the parent based on invoice number */
757: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
758: fetch c_JAI_AP_TDS_INVOICES_1 into r_JAI_AP_TDS_INVOICES;

Line 757: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);

753: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
754: close c_JAI_AP_TDS_INVOICES;
755: else
756: /* try n find the parent based on invoice number */
757: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
758: fetch c_JAI_AP_TDS_INVOICES_1 into r_JAI_AP_TDS_INVOICES;
759: close c_JAI_AP_TDS_INVOICES_1;
760: end if;
761:

Line 758: fetch c_JAI_AP_TDS_INVOICES_1 into r_JAI_AP_TDS_INVOICES;

754: close c_JAI_AP_TDS_INVOICES;
755: else
756: /* try n find the parent based on invoice number */
757: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
758: fetch c_JAI_AP_TDS_INVOICES_1 into r_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

Line 759: close c_JAI_AP_TDS_INVOICES_1;

755: else
756: /* try n find the parent based on invoice number */
757: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
758: fetch c_JAI_AP_TDS_INVOICES_1 into r_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,

Line 762: if ln_parent_invoice_id is null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then

758: fetch c_JAI_AP_TDS_INVOICES_1 into r_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;

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 783: if ln_parent_invoice_id is not null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then

779:
780: end if; /* checking parent vendor or site */
781:
782:
783: if ln_parent_invoice_id is not null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
784: /* parent invoice has been found, but details not captured in JAI_AP_TDS_INVOICES.
785: could be a return invoice, check if only one section was applicable against the parent and populate if so */
786: open c_get_section_if_one(ln_parent_invoice_id);
787: fetch c_get_section_if_one into lv_section_code;

Line 784: /* parent invoice has been found, but details not captured in JAI_AP_TDS_INVOICES.

780: end if; /* checking parent vendor or site */
781:
782:
783: if ln_parent_invoice_id is not null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
784: /* parent invoice has been found, but details not captured in JAI_AP_TDS_INVOICES.
785: could be a return invoice, check if only one section was applicable against the parent and populate if so */
786: open c_get_section_if_one(ln_parent_invoice_id);
787: fetch c_get_section_if_one into lv_section_code;
788: close c_get_section_if_one;

Line 802: elsif r_JAI_AP_TDS_INVOICES.parent_invoice_id is not null then

798:
799: ln_taxable_basis := ln_tax_amount * (100/ln_tax_rate);
800: end if;
801:
802: elsif r_JAI_AP_TDS_INVOICES.parent_invoice_id is not null then
803: /* A record in ja_in_ap_tds_invoice has been identified */
804:
805: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then
806: goto continue_with_next_record;

Line 805: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then

801:
802: elsif r_JAI_AP_TDS_INVOICES.parent_invoice_id is not null then
803: /* A record in ja_in_ap_tds_invoice has been identified */
804:
805: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then
806: goto continue_with_next_record;
807: end if;
808:
809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;

Line 809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;

805: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then
806: goto continue_with_next_record;
807: end if;
808:
809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;

Line 810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;

806: goto continue_with_next_record;
807: end if;
808:
809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
814: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;

Line 811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;

807: end if;
808:
809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
814: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
815:

Line 812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;

808:
809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
814: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
815:
816: end if;

Line 813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;

809: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
814: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
815:
816: end if;
817:

Line 814: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;

810: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
811: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
812: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
813: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
814: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
815:
816: end if;
817:
818: -- added, Harshita for Bug 4643633

Line 930: r_JAI_AP_TDS_INVOICES := 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 */
934: r_get_payment_details := null;

Line 965: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);

961: ln_parent_invoice_id := cur_rec.parent_invoice_id;
962: end if;
963:
964: if ln_parent_invoice_id is not null then
965: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);
966: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
967: close c_JAI_AP_TDS_INVOICES;
968: else
969: /* try n find the parent based on invoice number */

Line 966: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;

962: end if;
963:
964: if ln_parent_invoice_id is not null then
965: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);
966: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
967: close c_JAI_AP_TDS_INVOICES;
968: else
969: /* try n find the parent based on invoice number */
970: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);

Line 967: close c_JAI_AP_TDS_INVOICES;

963:
964: if ln_parent_invoice_id is not null then
965: open c_JAI_AP_TDS_INVOICES(ln_parent_invoice_id, cur_rec.invoice_num);
966: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
967: close c_JAI_AP_TDS_INVOICES;
968: else
969: /* try n find the parent based on invoice number */
970: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
971: fetch c_JAI_AP_TDS_INVOICES_1 into r_JAI_AP_TDS_INVOICES;

Line 970: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);

966: fetch c_JAI_AP_TDS_INVOICES into r_JAI_AP_TDS_INVOICES;
967: close c_JAI_AP_TDS_INVOICES;
968: else
969: /* try n find the parent based on invoice number */
970: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
971: fetch c_JAI_AP_TDS_INVOICES_1 into r_JAI_AP_TDS_INVOICES;
972: close c_JAI_AP_TDS_INVOICES_1;
973: end if;
974:

Line 971: fetch c_JAI_AP_TDS_INVOICES_1 into r_JAI_AP_TDS_INVOICES;

967: close c_JAI_AP_TDS_INVOICES;
968: else
969: /* try n find the parent based on invoice number */
970: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
971: fetch c_JAI_AP_TDS_INVOICES_1 into r_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

Line 972: close c_JAI_AP_TDS_INVOICES_1;

968: else
969: /* try n find the parent based on invoice number */
970: open c_JAI_AP_TDS_INVOICES_1(cur_rec.invoice_num);
971: fetch c_JAI_AP_TDS_INVOICES_1 into r_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,

Line 975: if ln_parent_invoice_id is null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then

971: fetch c_JAI_AP_TDS_INVOICES_1 into r_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;

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 996: if ln_parent_invoice_id is not null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then

992:
993: end if; /* checking parent vendor or site */
994:
995:
996: if ln_parent_invoice_id is not null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
997: /* parent invoice has been found, but details not captured in JAI_AP_TDS_INVOICES.
998: could be a return invoice, check if only one section was applicable against the parent and populate if so */
999: open c_get_section_if_one(ln_parent_invoice_id);
1000: fetch c_get_section_if_one into lv_section_code;

Line 997: /* parent invoice has been found, but details not captured in JAI_AP_TDS_INVOICES.

993: end if; /* checking parent vendor or site */
994:
995:
996: if ln_parent_invoice_id is not null and r_JAI_AP_TDS_INVOICES.parent_invoice_id is null then
997: /* parent invoice has been found, but details not captured in JAI_AP_TDS_INVOICES.
998: could be a return invoice, check if only one section was applicable against the parent and populate if so */
999: open c_get_section_if_one(ln_parent_invoice_id);
1000: fetch c_get_section_if_one into lv_section_code;
1001: close c_get_section_if_one;

Line 1015: elsif r_JAI_AP_TDS_INVOICES.parent_invoice_id is not null then

1011:
1012: ln_taxable_basis := ln_tax_amount * (100/ln_tax_rate);
1013: end if;
1014:
1015: elsif r_JAI_AP_TDS_INVOICES.parent_invoice_id is not null then
1016: /* A record in ja_in_ap_tds_invoice has been identified */
1017:
1018: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then
1019: goto continue_with_next_record;

Line 1018: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then

1014:
1015: elsif r_JAI_AP_TDS_INVOICES.parent_invoice_id is not null then
1016: /* A record in ja_in_ap_tds_invoice has been identified */
1017:
1018: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then
1019: goto continue_with_next_record;
1020: end if;
1021:
1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;

Line 1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;

1018: if r_JAI_AP_TDS_INVOICES.tds_section <> nvl(pv_tds_section, r_JAI_AP_TDS_INVOICES.tds_section) then
1019: goto continue_with_next_record;
1020: end if;
1021:
1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;

Line 1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;

1019: goto continue_with_next_record;
1020: end if;
1021:
1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
1027: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;

Line 1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;

1020: end if;
1021:
1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
1027: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
1028:

Line 1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;

1021:
1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
1027: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
1028:
1029: end if;

Line 1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;

1022: ln_parent_invoice_id := r_JAI_AP_TDS_INVOICES.parent_invoice_id;
1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
1027: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
1028:
1029: end if;
1030:

Line 1027: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;

1023: lv_section_code := r_JAI_AP_TDS_INVOICES.tds_section;
1024: ln_tax_id := r_JAI_AP_TDS_INVOICES.tds_tax_id;
1025: ln_tax_rate := r_JAI_AP_TDS_INVOICES.tds_tax_rate;
1026: ln_taxable_basis := r_JAI_AP_TDS_INVOICES.taxable_basis;
1027: ln_tax_amount := r_JAI_AP_TDS_INVOICES.tax_amount;
1028:
1029: end if;
1030:
1031: << populate_invoice_details >>