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.

[Home] [Help]

APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on FND_GLOBAL

Line 509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;

505: END IF;
506:
507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:

Line 511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;

507: r_jai_ap_tds_repository.MIGRATED := G_N;
508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:
514: --get repsitory id from sequence
515: OPEN c_get_tds_repository_id;

Line 512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;

508: r_jai_ap_tds_repository.CREATION_DATE := sysdate;
509: r_jai_ap_tds_repository.CREATED_BY := fnd_global.user_id;
510: r_jai_ap_tds_repository.LAST_UPDATE_DATE := sysdate;
511: r_jai_ap_tds_repository.LAST_UPDATE_LOGIN := fnd_global.login_id;
512: r_jai_ap_tds_repository.LAST_UPDATED_BY := fnd_global.user_id;
513:
514: --get repsitory id from sequence
515: OPEN c_get_tds_repository_id;
516: FETCH c_get_tds_repository_id INTO r_jai_ap_tds_repository.TDS_REPOSITORY_ID;

Line 662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;

658: --calculate the proportion surcharge amount and round it by TDS rounding rule
659: r_jai_ap_tds_repo_lines.tax_amount := round(ln_surcharge_tax_amount * ln_proportion , ln_tax_rounding_rule);
660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:

Line 664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;

660:
661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:
667: --Insert one repository line
668: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);

Line 665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;

661: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
662: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
663: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
664: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
665: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
666:
667: --Insert one repository line
668: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
669: END LOOP;

Line 1055: ,fnd_global.user_id

1051: ,jattt.taxable_amount --BASE_TAX_AMOUNT
1052: ,G_N --required for eTDS
1053: ,G_Y --MIGRATED
1054: ,sysdate
1055: ,fnd_global.user_id
1056: ,sysdate
1057: ,fnd_global.login_id
1058: ,fnd_global.user_id
1059: from jai_ap_tds_thhold_trxs jattt

Line 1057: ,fnd_global.login_id

1053: ,G_Y --MIGRATED
1054: ,sysdate
1055: ,fnd_global.user_id
1056: ,sysdate
1057: ,fnd_global.login_id
1058: ,fnd_global.user_id
1059: from jai_ap_tds_thhold_trxs jattt
1060: , ap_invoices_all base_invoices
1061: , ap_invoices_all tds_invoices

Line 1058: ,fnd_global.user_id

1054: ,sysdate
1055: ,fnd_global.user_id
1056: ,sysdate
1057: ,fnd_global.login_id
1058: ,fnd_global.user_id
1059: from jai_ap_tds_thhold_trxs jattt
1060: , ap_invoices_all base_invoices
1061: , ap_invoices_all tds_invoices
1062: , ap_invoices_all vendor_invoices

Line 1432: ,fnd_global.user_id

1428: aia.invoice_amount,
1429: G_Y,
1430: G_Y,
1431: sysdate
1432: ,fnd_global.user_id
1433: ,sysdate
1434: ,fnd_global.login_id
1435: ,fnd_global.user_id
1436: FROM ap_invoices_all aia

Line 1434: ,fnd_global.login_id

1430: G_Y,
1431: sysdate
1432: ,fnd_global.user_id
1433: ,sysdate
1434: ,fnd_global.login_id
1435: ,fnd_global.user_id
1436: FROM ap_invoices_all aia
1437: ,ap_invoice_distributions_all aida
1438: ,jai_ap_tds_inv_taxes jatit

Line 1435: ,fnd_global.user_id

1431: sysdate
1432: ,fnd_global.user_id
1433: ,sysdate
1434: ,fnd_global.login_id
1435: ,fnd_global.user_id
1436: FROM ap_invoices_all aia
1437: ,ap_invoice_distributions_all aida
1438: ,jai_ap_tds_inv_taxes jatit
1439: ,JAI_AP_TDS_VENDOR_HDRS jte

Line 1564: ,fnd_global.user_id

1560: aia.invoice_amount,
1561: G_Y,
1562: G_Y,
1563: sysdate
1564: ,fnd_global.user_id
1565: ,sysdate
1566: ,fnd_global.login_id
1567: ,fnd_global.user_id
1568: FROM ap_invoices_all aia

Line 1566: ,fnd_global.login_id

1562: G_Y,
1563: sysdate
1564: ,fnd_global.user_id
1565: ,sysdate
1566: ,fnd_global.login_id
1567: ,fnd_global.user_id
1568: FROM ap_invoices_all aia
1569: ,ap_invoice_distributions_all aida
1570: ,jai_ap_tds_inv_taxes jatit

Line 1567: ,fnd_global.user_id

1563: sysdate
1564: ,fnd_global.user_id
1565: ,sysdate
1566: ,fnd_global.login_id
1567: ,fnd_global.user_id
1568: FROM ap_invoices_all aia
1569: ,ap_invoice_distributions_all aida
1570: ,jai_ap_tds_inv_taxes jatit
1571: ,JAI_AP_TDS_VENDOR_HDRS jte

Line 1762: ,fnd_global.user_id

1758: ,tbl.BASE_TAX_AMOUNT
1759: ,tbl.REQUIRED_FOR_ETDS
1760: ,tbl.MIGRATED
1761: ,sysdate
1762: ,fnd_global.user_id
1763: ,sysdate
1764: ,fnd_global.login_id
1765: ,fnd_global.user_id
1766: FROM (SELECT -9999 INVOICE_ID

Line 1764: ,fnd_global.login_id

1760: ,tbl.MIGRATED
1761: ,sysdate
1762: ,fnd_global.user_id
1763: ,sysdate
1764: ,fnd_global.login_id
1765: ,fnd_global.user_id
1766: FROM (SELECT -9999 INVOICE_ID
1767: ,NULL INVOICE_NUMBER
1768: ,NULL TDS_INVOICE_TYPE

Line 1765: ,fnd_global.user_id

1761: ,sysdate
1762: ,fnd_global.user_id
1763: ,sysdate
1764: ,fnd_global.login_id
1765: ,fnd_global.user_id
1766: FROM (SELECT -9999 INVOICE_ID
1767: ,NULL INVOICE_NUMBER
1768: ,NULL TDS_INVOICE_TYPE
1769: ,nvl(jatit.THRESHOLD_GRP_ID,jatit.DEFAULT_THRESHOLD_GRP_ID) THRESHOLD_GRP_ID

Line 1896: ,fnd_global.user_id

1892: ,BASE_TAX_AMOUNT
1893: ,REQUIRED_FOR_ETDS
1894: ,MIGRATED
1895: ,sysdate
1896: ,fnd_global.user_id
1897: ,sysdate
1898: ,fnd_global.login_id
1899: ,fnd_global.user_id
1900: FROM (select distinct

Line 1898: ,fnd_global.login_id

1894: ,MIGRATED
1895: ,sysdate
1896: ,fnd_global.user_id
1897: ,sysdate
1898: ,fnd_global.login_id
1899: ,fnd_global.user_id
1900: FROM (select distinct
1901: 9999 INVOICE_ID
1902: ,NULL INVOICE_NUMBER

Line 1899: ,fnd_global.user_id

1895: ,sysdate
1896: ,fnd_global.user_id
1897: ,sysdate
1898: ,fnd_global.login_id
1899: ,fnd_global.user_id
1900: FROM (select distinct
1901: 9999 INVOICE_ID
1902: ,NULL INVOICE_NUMBER
1903: ,NULL TDS_INVOICE_TYPE

Line 2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;

2057: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2058: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;
2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:

Line 2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;

2059: r_jai_ap_tds_repo_lines.tax_amount := round(r_tds_rpsty_rec.tds_inv_tax_amount * r_c_get_taxes_info.tax_rate / r_tds_rpsty_rec.tax_rate, 2);
2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:
2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2067: END LOOP;

Line 2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;

2060: r_jai_ap_tds_repo_lines.CREATION_DATE := sysdate;
2061: r_jai_ap_tds_repo_lines.CREATED_BY := fnd_global.user_id;
2062: r_jai_ap_tds_repo_lines.LAST_UPDATE_DATE := sysdate;
2063: r_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN := fnd_global.login_id;
2064: r_jai_ap_tds_repo_lines.LAST_UPDATED_BY := fnd_global.user_id;
2065:
2066: insert_jai_ap_tds_repo_lines(r_jai_ap_tds_repo_lines);
2067: END LOOP;
2068: