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_PREPAYMENTS_PKG dependencies on STANDARD

Line 809: This will be STANDARD INVOICE if the SI has already been validated, else it will be PREPAYMENT */

805:
806: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.populate_section_tax', 'START'); /* 1 */
807:
808: /* Get the tds_application_basis :
809: This will be STANDARD INVOICE if the SI has already been validated, else it will be PREPAYMENT */
810: open c_get_tds_application_basis(p_invoice_id);
811: fetch c_get_tds_application_basis into lv_is_si_validated_flag;
812: close c_get_tds_application_basis;
813:

Line 815: lv_application_basis := 'STANDARD INVOICE';

811: fetch c_get_tds_application_basis into lv_is_si_validated_flag;
812: close c_get_tds_application_basis;
813:
814: if nvl(lv_is_si_validated_flag, 'Y') = 'Y' then
815: lv_application_basis := 'STANDARD INVOICE';
816: else
817: lv_application_basis := 'PREPAYMENT';
818: end if;
819:

Line 943: decode(application_basis, 'STANDARD INVOICE', tds_tax_id_other, tds_tax_id_prepay),

939: select tds_prepayment_id,
940: application_amount,
941: application_basis,
942: decode(tds_applicable_flag, 'Y',
943: decode(application_basis, 'STANDARD INVOICE', tds_tax_id_other, tds_tax_id_prepay),
944: null) tds_tax_id,
945: decode(wct_applicable_flag, 'Y',
946: decode(application_basis, 'STANDARD INVOICE', wct_tax_id_other, wct_tax_id_prepay),
947: null) wct_tax_id,

Line 946: decode(application_basis, 'STANDARD INVOICE', wct_tax_id_other, wct_tax_id_prepay),

942: decode(tds_applicable_flag, 'Y',
943: decode(application_basis, 'STANDARD INVOICE', tds_tax_id_other, tds_tax_id_prepay),
944: null) tds_tax_id,
945: decode(wct_applicable_flag, 'Y',
946: decode(application_basis, 'STANDARD INVOICE', wct_tax_id_other, wct_tax_id_prepay),
947: null) wct_tax_id,
948: decode(essi_applicable_flag, 'Y',
949: decode(application_basis, 'STANDARD INVOICE', essi_tax_id_other, essi_tax_id_prepay),
950: null) essi_tax_id

Line 949: decode(application_basis, 'STANDARD INVOICE', essi_tax_id_other, essi_tax_id_prepay),

945: decode(wct_applicable_flag, 'Y',
946: decode(application_basis, 'STANDARD INVOICE', wct_tax_id_other, wct_tax_id_prepay),
947: null) wct_tax_id,
948: decode(essi_applicable_flag, 'Y',
949: decode(application_basis, 'STANDARD INVOICE', essi_tax_id_other, essi_tax_id_prepay),
950: null) essi_tax_id
951: from jai_ap_tds_prepayments
952: where invoice_id = p_invoice_id
953: and invoice_distribution_id_prepay = p_invoice_distribution_id;

Line 1308: or else against the standard invoice */

1304:
1305: /* Get the invoice number against which the tds invoices are to be generated */
1306:
1307: /* if application_basis is prepayment it shd be generated against the prepayment
1308: or else against the standard invoice */
1309:
1310: if lv_application_basis = 'STANDARD INVOICE' then
1311: /* get the standard invoice number */
1312: open c_ap_invoices_all(p_invoice_distribution_id);

Line 1310: if lv_application_basis = 'STANDARD INVOICE' then

1306:
1307: /* if application_basis is prepayment it shd be generated against the prepayment
1308: or else against the standard invoice */
1309:
1310: if lv_application_basis = 'STANDARD INVOICE' then
1311: /* get the standard invoice number */
1312: open c_ap_invoices_all(p_invoice_distribution_id);
1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1314: close c_ap_invoices_all;

Line 1311: /* get the standard invoice number */

1307: /* if application_basis is prepayment it shd be generated against the prepayment
1308: or else against the standard invoice */
1309:
1310: if lv_application_basis = 'STANDARD INVOICE' then
1311: /* get the standard invoice number */
1312: open c_ap_invoices_all(p_invoice_distribution_id);
1313: fetch c_ap_invoices_all into lv_invoice_num_prepay_apply;
1314: close c_ap_invoices_all;
1315: else

Line 1595: -- the standard invoice does not have tds attached to it.

1591: fetch c_tds_count into ln_tds_count_attribute1;
1592: close c_tds_count;
1593:
1594: if ln_tds_count_attribute1 = 0 then
1595: -- the standard invoice does not have tds attached to it.
1596: -- check if there is TDS record in temp table, this would happen when the invoice is unapproved.
1597: -- Bug 4754213. Added by Lakshmi Gopalsami
1598: open c_tds_count_unapp(p_invoice_id, 'TDS_SECTION'); --rchandan for bug#4428980
1599: fetch c_tds_count_unapp into ln_tds_count_attribute1;

Line 1666: -- the standard invoice does not have tds attached to it.

1662: fetch c_tds_count into ln_tds_count_attribute2;
1663: close c_tds_count;
1664:
1665: if ln_tds_count_attribute2 = 0 then
1666: -- the standard invoice does not have tds attached to it.
1667: -- check if there is TDS record in temp table, this would happen when the invoice is unapproved.
1668: open c_tds_count_unapp(p_invoice_id, 'WCT_SECTION');
1669: fetch c_tds_count_unapp into ln_tds_count_attribute2;
1670: close c_tds_count_unapp;

Line 1736: -- the standard invoice does not have tds attached to it.

1732: fetch c_tds_count into ln_tds_count_attribute3;
1733: close c_tds_count;
1734:
1735: if ln_tds_count_attribute3 = 0 then
1736: -- the standard invoice does not have tds attached to it.
1737: -- check if there is TDS record in temp table, this would happen when the invoice is unapproved.
1738: open c_tds_count_unapp(p_invoice_id, 'ESSI_SECTION');
1739: fetch c_tds_count_unapp into ln_tds_count_attribute3;
1740: close c_tds_count_unapp;