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.ZX_JA_EXTRACT_PKG dependencies on FND_GLOBAL

Line 969: fnd_global.user_id,

965: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
966: l_detail_tax_line_id_tbl(i),
967: X_GOVERNMENT_TAX_TYPE_TBL(i),
968: X_DEDUCTIBLE_TYPE_TBL(i),
969: fnd_global.user_id,
970: sysdate,
971: fnd_global.user_id,
972: sysdate,
973: fnd_global.login_id,

Line 971: fnd_global.user_id,

967: X_GOVERNMENT_TAX_TYPE_TBL(i),
968: X_DEDUCTIBLE_TYPE_TBL(i),
969: fnd_global.user_id,
970: sysdate,
971: fnd_global.user_id,
972: sysdate,
973: fnd_global.login_id,
974: p_trl_global_variables_rec.request_id);
975:

Line 973: fnd_global.login_id,

969: fnd_global.user_id,
970: sysdate,
971: fnd_global.user_id,
972: sysdate,
973: fnd_global.login_id,
974: p_trl_global_variables_rec.request_id);
975:
976:
977: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRUIL' and l_detail_tax_line_id_tbl.count <> 0 then

Line 1045: fnd_global.user_id,

1041: X_INITIAL_TRX_NUM_TBL(i),
1042: X_INVOICE_WORD_TBL(i),
1043: X_FINAL_TRX_NUM_TBL(i),
1044: x_trx_date_tbl(i), --Bug 5251425
1045: fnd_global.user_id,
1046: sysdate,
1047: fnd_global.user_id,
1048: sysdate,
1049: fnd_global.login_id,

Line 1047: fnd_global.user_id,

1043: X_FINAL_TRX_NUM_TBL(i),
1044: x_trx_date_tbl(i), --Bug 5251425
1045: fnd_global.user_id,
1046: sysdate,
1047: fnd_global.user_id,
1048: sysdate,
1049: fnd_global.login_id,
1050: p_trl_global_variables_rec.request_id);
1051:

Line 1049: fnd_global.login_id,

1045: fnd_global.user_id,
1046: sysdate,
1047: fnd_global.user_id,
1048: sysdate,
1049: fnd_global.login_id,
1050: p_trl_global_variables_rec.request_id);
1051:
1052: IF ( g_level_statement>= g_current_runtime_level ) THEN
1053: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

Line 1112: fnd_global.user_id,

1108: X_GDF_RA_CUST_TRX_ATT5_TBL(i),
1109: X_GDF_RA_CUST_TRX_ATT6_TBL(i),
1110: X_GDF_RA_CUST_TRX_ATT7_TBL(i),
1111: X_GDF_RA_CUST_TRX_ATT8_TBL(i),
1112: fnd_global.user_id,
1113: sysdate,
1114: fnd_global.user_id,
1115: sysdate,
1116: fnd_global.login_id,

Line 1114: fnd_global.user_id,

1110: X_GDF_RA_CUST_TRX_ATT7_TBL(i),
1111: X_GDF_RA_CUST_TRX_ATT8_TBL(i),
1112: fnd_global.user_id,
1113: sysdate,
1114: fnd_global.user_id,
1115: sysdate,
1116: fnd_global.login_id,
1117: p_trl_global_variables_rec.request_id);
1118:

Line 1116: fnd_global.login_id,

1112: fnd_global.user_id,
1113: sysdate,
1114: fnd_global.user_id,
1115: sysdate,
1116: fnd_global.login_id,
1117: p_trl_global_variables_rec.request_id);
1118:
1119: IF ( g_level_statement>= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

Line 1139: fnd_global.user_id,

1135: SELECT
1136: zx_rep_trx_jx_ext_t_s.nextval,
1137: dtl.detail_tax_line_id,
1138: types.global_attribute1,
1139: fnd_global.user_id,
1140: sysdate,
1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.login_id,

Line 1141: fnd_global.user_id,

1137: dtl.detail_tax_line_id,
1138: types.global_attribute1,
1139: fnd_global.user_id,
1140: sysdate,
1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.login_id,
1144: p_trl_global_variables_rec.request_id
1145: FROM zx_rep_trx_detail_t dtl,

Line 1143: fnd_global.login_id,

1139: fnd_global.user_id,
1140: sysdate,
1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.login_id,
1144: p_trl_global_variables_rec.request_id
1145: FROM zx_rep_trx_detail_t dtl,
1146: ra_cust_trx_types_all types
1147: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID

Line 1271: fnd_global.user_id,

1267: l_loc_tax_reg_num_tbl(i),
1268: l_taxable_person_tbl(i),
1269: l_ind_sub_classif_tbl(i),
1270: l_ind_classif_tbl(i),
1271: fnd_global.user_id,
1272: sysdate,
1273: fnd_global.user_id,
1274: sysdate,
1275: fnd_global.login_id,

Line 1273: fnd_global.user_id,

1269: l_ind_sub_classif_tbl(i),
1270: l_ind_classif_tbl(i),
1271: fnd_global.user_id,
1272: sysdate,
1273: fnd_global.user_id,
1274: sysdate,
1275: fnd_global.login_id,
1276: p_trl_global_variables_rec.request_id);
1277:

Line 1275: fnd_global.login_id,

1271: fnd_global.user_id,
1272: sysdate,
1273: fnd_global.user_id,
1274: sysdate,
1275: fnd_global.login_id,
1276: p_trl_global_variables_rec.request_id);
1277:
1278: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGGF5' THEN
1279: bank_info(P_TRL_GLOBAL_VARIABLES_REC);

Line 1545: fnd_global.user_id,

1541: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1542: l_detail_tax_line_id_tbl(i),
1543: X_GOVERNMENT_TAX_TYPE_TBL(i),
1544: X_DEDUCTIBLE_TYPE_TBL(i),
1545: fnd_global.user_id,
1546: sysdate,
1547: fnd_global.user_id,
1548: sysdate,
1549: fnd_global.login_id,

Line 1547: fnd_global.user_id,

1543: X_GOVERNMENT_TAX_TYPE_TBL(i),
1544: X_DEDUCTIBLE_TYPE_TBL(i),
1545: fnd_global.user_id,
1546: sysdate,
1547: fnd_global.user_id,
1548: sysdate,
1549: fnd_global.login_id,
1550: p_trl_global_variables_rec.request_id);
1551:

Line 1549: fnd_global.login_id,

1545: fnd_global.user_id,
1546: sysdate,
1547: fnd_global.user_id,
1548: sysdate,
1549: fnd_global.login_id,
1550: p_trl_global_variables_rec.request_id);
1551:
1552: IF ( g_level_statement>= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1624: fnd_global.user_id,

1620: l_detail_tax_line_id_tbl(i),
1621: X_GOVERNMENT_TAX_TYPE_TBL(i),
1622: X_DEDUCTIBLE_TYPE_TBL(i),
1623: X_GUI_TYPE_TBL(i),
1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: sysdate,
1628: fnd_global.login_id,

Line 1626: fnd_global.user_id,

1622: X_DEDUCTIBLE_TYPE_TBL(i),
1623: X_GUI_TYPE_TBL(i),
1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: sysdate,
1628: fnd_global.login_id,
1629: p_trl_global_variables_rec.request_id);
1630:

Line 1628: fnd_global.login_id,

1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: sysdate,
1628: fnd_global.login_id,
1629: p_trl_global_variables_rec.request_id);
1630:
1631: IF ( g_level_statement>= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1681: fnd_global.user_id,

1677: l_detail_tax_line_id_tbl(i),
1678: X_PRINT_DATE_TBL(i),
1679: X_INVOICE_AMOUNT_TBL(i),
1680: X_BASE_AMOUNT_TBL(i),
1681: fnd_global.user_id,
1682: sysdate,
1683: fnd_global.user_id,
1684: sysdate,
1685: fnd_global.login_id,

Line 1683: fnd_global.user_id,

1679: X_INVOICE_AMOUNT_TBL(i),
1680: X_BASE_AMOUNT_TBL(i),
1681: fnd_global.user_id,
1682: sysdate,
1683: fnd_global.user_id,
1684: sysdate,
1685: fnd_global.login_id,
1686: p_trl_global_variables_rec.request_id);
1687:

Line 1685: fnd_global.login_id,

1681: fnd_global.user_id,
1682: sysdate,
1683: fnd_global.user_id,
1684: sysdate,
1685: fnd_global.login_id,
1686: p_trl_global_variables_rec.request_id);
1687:
1688: IF ( g_level_statement>= g_current_runtime_level ) THEN
1689: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1724: fnd_global.user_id,

1720: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1721: l_detail_tax_line_id_tbl(i),
1722: X_INVOICE_AMOUNT_TBL(i),
1723: X_BASE_AMOUNT_TBL(i),
1724: fnd_global.user_id,
1725: sysdate,
1726: fnd_global.user_id,
1727: sysdate,
1728: fnd_global.login_id,

Line 1726: fnd_global.user_id,

1722: X_INVOICE_AMOUNT_TBL(i),
1723: X_BASE_AMOUNT_TBL(i),
1724: fnd_global.user_id,
1725: sysdate,
1726: fnd_global.user_id,
1727: sysdate,
1728: fnd_global.login_id,
1729: p_trl_global_variables_rec.request_id);
1730:

Line 1728: fnd_global.login_id,

1724: fnd_global.user_id,
1725: sysdate,
1726: fnd_global.user_id,
1727: sysdate,
1728: fnd_global.login_id,
1729: p_trl_global_variables_rec.request_id);
1730:
1731: IF ( g_level_statement>= g_current_runtime_level ) THEN
1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1760: fnd_global.user_id,

1756: numeric4
1757: )
1758: SELECT
1759: p_trl_global_variables_rec.request_id,
1760: fnd_global.user_id,
1761: sysdate,
1762: fnd_global.user_id,
1763: sysdate,
1764: fnd_global.login_id,

Line 1762: fnd_global.user_id,

1758: SELECT
1759: p_trl_global_variables_rec.request_id,
1760: fnd_global.user_id,
1761: sysdate,
1762: fnd_global.user_id,
1763: sysdate,
1764: fnd_global.login_id,
1765: zx_rep_trx_jx_ext_t_s.NEXTVAL,
1766: detail_tax_line_id,

Line 1764: fnd_global.login_id,

1760: fnd_global.user_id,
1761: sysdate,
1762: fnd_global.user_id,
1763: sysdate,
1764: fnd_global.login_id,
1765: zx_rep_trx_jx_ext_t_s.NEXTVAL,
1766: detail_tax_line_id,
1767: document_sub_type,
1768: CASE WHEN tax_line_change= 1 OR tax_recoverable_flag = 'N' THEN taxable_amt

Line 1903: fnd_global.user_id,

1899: X_INHOUSE_TAX_AMT_TBL(i),
1900: X_SUPPLIER_TAX_AMT_TBL(i),
1901: X_TAXABLE_GAINLOSS_TBL(i),
1902: X_TAX_GAINLOSS_TBL(i),
1903: fnd_global.user_id,
1904: sysdate,
1905: fnd_global.user_id,
1906: sysdate,
1907: fnd_global.login_id,

Line 1905: fnd_global.user_id,

1901: X_TAXABLE_GAINLOSS_TBL(i),
1902: X_TAX_GAINLOSS_TBL(i),
1903: fnd_global.user_id,
1904: sysdate,
1905: fnd_global.user_id,
1906: sysdate,
1907: fnd_global.login_id,
1908: p_trl_global_variables_rec.request_id);
1909:

Line 1907: fnd_global.login_id,

1903: fnd_global.user_id,
1904: sysdate,
1905: fnd_global.user_id,
1906: sysdate,
1907: fnd_global.login_id,
1908: p_trl_global_variables_rec.request_id);
1909:
1910: IF ( g_level_statement>= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 2024: fnd_global.user_id,

2020: l_loc_tax_reg_num_tbl(i),
2021: l_taxable_person_tbl(i),
2022: l_ind_sub_classif_tbl(i),
2023: l_ind_classif_tbl(i),
2024: fnd_global.user_id,
2025: sysdate,
2026: fnd_global.user_id,
2027: sysdate,
2028: fnd_global.login_id,

Line 2026: fnd_global.user_id,

2022: l_ind_sub_classif_tbl(i),
2023: l_ind_classif_tbl(i),
2024: fnd_global.user_id,
2025: sysdate,
2026: fnd_global.user_id,
2027: sysdate,
2028: fnd_global.login_id,
2029: p_trl_global_variables_rec.request_id);
2030:

Line 2028: fnd_global.login_id,

2024: fnd_global.user_id,
2025: sysdate,
2026: fnd_global.user_id,
2027: sysdate,
2028: fnd_global.login_id,
2029: p_trl_global_variables_rec.request_id);
2030:
2031: end if;
2032:

Line 2705: fnd_global.user_id,

2701: l_detail_tax_line_id_tbl(i),
2702: l_bank_name,
2703: l_branch_name,
2704: l_bank_account_num,
2705: fnd_global.user_id,
2706: sysdate,
2707: fnd_global.user_id,
2708: sysdate,
2709: fnd_global.login_id,

Line 2707: fnd_global.user_id,

2703: l_branch_name,
2704: l_bank_account_num,
2705: fnd_global.user_id,
2706: sysdate,
2707: fnd_global.user_id,
2708: sysdate,
2709: fnd_global.login_id,
2710: p_trl_global_variables_rec.request_id);
2711: END;

Line 2709: fnd_global.login_id,

2705: fnd_global.user_id,
2706: sysdate,
2707: fnd_global.user_id,
2708: sysdate,
2709: fnd_global.login_id,
2710: p_trl_global_variables_rec.request_id);
2711: END;
2712:
2713: ELSE

Line 2732: fnd_global.user_id,

2728: dtl.detail_tax_line_id,
2729: loc.global_attribute5,
2730: loc.global_attribute6,
2731: loc.global_attribute7,
2732: fnd_global.user_id,
2733: sysdate,
2734: fnd_global.user_id,
2735: sysdate,
2736: fnd_global.login_id,

Line 2734: fnd_global.user_id,

2730: loc.global_attribute6,
2731: loc.global_attribute7,
2732: fnd_global.user_id,
2733: sysdate,
2734: fnd_global.user_id,
2735: sysdate,
2736: fnd_global.login_id,
2737: p_trl_global_variables_rec.request_id
2738: FROM hr_all_organization_units ou,

Line 2736: fnd_global.login_id,

2732: fnd_global.user_id,
2733: sysdate,
2734: fnd_global.user_id,
2735: sysdate,
2736: fnd_global.login_id,
2737: p_trl_global_variables_rec.request_id
2738: FROM hr_all_organization_units ou,
2739: hr_organization_information oi,
2740: hr_locations loc,