DBA Data[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on FND_GLOBAL

Line 955: fnd_global.user_id,

951: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
952: l_detail_tax_line_id_tbl(i),
953: X_GOVERNMENT_TAX_TYPE_TBL(i),
954: X_DEDUCTIBLE_TYPE_TBL(i),
955: fnd_global.user_id,
956: sysdate,
957: fnd_global.user_id,
958: sysdate,
959: fnd_global.login_id);

Line 957: fnd_global.user_id,

953: X_GOVERNMENT_TAX_TYPE_TBL(i),
954: X_DEDUCTIBLE_TYPE_TBL(i),
955: fnd_global.user_id,
956: sysdate,
957: fnd_global.user_id,
958: sysdate,
959: fnd_global.login_id);
960:
961:

Line 959: fnd_global.login_id);

955: fnd_global.user_id,
956: sysdate,
957: fnd_global.user_id,
958: sysdate,
959: fnd_global.login_id);
960:
961:
962: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRUIL' and l_detail_tax_line_id_tbl.count <> 0 then
963:

Line 1029: fnd_global.user_id,

1025: X_INITIAL_TRX_NUM_TBL(i),
1026: X_INVOICE_WORD_TBL(i),
1027: X_FINAL_TRX_NUM_TBL(i),
1028: x_trx_date_tbl(i), --Bug 5251425
1029: fnd_global.user_id,
1030: sysdate,
1031: fnd_global.user_id,
1032: sysdate,
1033: fnd_global.login_id);

Line 1031: fnd_global.user_id,

1027: X_FINAL_TRX_NUM_TBL(i),
1028: x_trx_date_tbl(i), --Bug 5251425
1029: fnd_global.user_id,
1030: sysdate,
1031: fnd_global.user_id,
1032: sysdate,
1033: fnd_global.login_id);
1034:
1035: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1033: fnd_global.login_id);

1029: fnd_global.user_id,
1030: sysdate,
1031: fnd_global.user_id,
1032: sysdate,
1033: fnd_global.login_id);
1034:
1035: IF ( g_level_statement>= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1037: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1094: fnd_global.user_id,

1090: X_GDF_RA_CUST_TRX_ATT5_TBL(i),
1091: X_GDF_RA_CUST_TRX_ATT6_TBL(i),
1092: X_GDF_RA_CUST_TRX_ATT7_TBL(i),
1093: X_GDF_RA_CUST_TRX_ATT8_TBL(i),
1094: fnd_global.user_id,
1095: sysdate,
1096: fnd_global.user_id,
1097: sysdate,
1098: fnd_global.login_id);

Line 1096: fnd_global.user_id,

1092: X_GDF_RA_CUST_TRX_ATT7_TBL(i),
1093: X_GDF_RA_CUST_TRX_ATT8_TBL(i),
1094: fnd_global.user_id,
1095: sysdate,
1096: fnd_global.user_id,
1097: sysdate,
1098: fnd_global.login_id);
1099:
1100: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1098: fnd_global.login_id);

1094: fnd_global.user_id,
1095: sysdate,
1096: fnd_global.user_id,
1097: sysdate,
1098: fnd_global.login_id);
1099:
1100: IF ( g_level_statement>= g_current_runtime_level ) THEN
1101: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1102: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1141: fnd_global.user_id,

1137: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1138: l_detail_tax_line_id_tbl(i),
1139: X_CNT_TAXABLE_AMT_TBL(i),
1140: X_WINE_CIGARETTE_TBL(i),
1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.user_id,
1144: sysdate,
1145: fnd_global.login_id);

Line 1143: fnd_global.user_id,

1139: X_CNT_TAXABLE_AMT_TBL(i),
1140: X_WINE_CIGARETTE_TBL(i),
1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.user_id,
1144: sysdate,
1145: fnd_global.login_id);
1146:
1147: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1145: fnd_global.login_id);

1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.user_id,
1144: sysdate,
1145: fnd_global.login_id);
1146:
1147: IF ( g_level_statement>= g_current_runtime_level ) THEN
1148: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1149: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1266: fnd_global.user_id,

1262: l_loc_tax_reg_num_tbl(i),
1263: l_taxable_person_tbl(i),
1264: l_ind_sub_classif_tbl(i),
1265: l_ind_classif_tbl(i),
1266: fnd_global.user_id,
1267: sysdate,
1268: fnd_global.user_id,
1269: sysdate,
1270: fnd_global.login_id,

Line 1268: fnd_global.user_id,

1264: l_ind_sub_classif_tbl(i),
1265: l_ind_classif_tbl(i),
1266: fnd_global.user_id,
1267: sysdate,
1268: fnd_global.user_id,
1269: sysdate,
1270: fnd_global.login_id,
1271: p_trl_global_variables_rec.request_id);
1272:

Line 1270: fnd_global.login_id,

1266: fnd_global.user_id,
1267: sysdate,
1268: fnd_global.user_id,
1269: sysdate,
1270: fnd_global.login_id,
1271: p_trl_global_variables_rec.request_id);
1272:
1273: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGGF5' THEN
1274: bank_info(P_TRL_GLOBAL_VARIABLES_REC);

Line 1539: fnd_global.user_id,

1535: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1536: l_detail_tax_line_id_tbl(i),
1537: X_GOVERNMENT_TAX_TYPE_TBL(i),
1538: X_DEDUCTIBLE_TYPE_TBL(i),
1539: fnd_global.user_id,
1540: sysdate,
1541: fnd_global.user_id,
1542: sysdate,
1543: fnd_global.login_id);

Line 1541: fnd_global.user_id,

1537: X_GOVERNMENT_TAX_TYPE_TBL(i),
1538: X_DEDUCTIBLE_TYPE_TBL(i),
1539: fnd_global.user_id,
1540: sysdate,
1541: fnd_global.user_id,
1542: sysdate,
1543: fnd_global.login_id);
1544:
1545: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1543: fnd_global.login_id);

1539: fnd_global.user_id,
1540: sysdate,
1541: fnd_global.user_id,
1542: sysdate,
1543: fnd_global.login_id);
1544:
1545: IF ( g_level_statement>= g_current_runtime_level ) THEN
1546: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1547: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1616: fnd_global.user_id,

1612: l_detail_tax_line_id_tbl(i),
1613: X_GOVERNMENT_TAX_TYPE_TBL(i),
1614: X_DEDUCTIBLE_TYPE_TBL(i),
1615: X_GUI_TYPE_TBL(i),
1616: fnd_global.user_id,
1617: sysdate,
1618: fnd_global.user_id,
1619: sysdate,
1620: fnd_global.login_id);

Line 1618: fnd_global.user_id,

1614: X_DEDUCTIBLE_TYPE_TBL(i),
1615: X_GUI_TYPE_TBL(i),
1616: fnd_global.user_id,
1617: sysdate,
1618: fnd_global.user_id,
1619: sysdate,
1620: fnd_global.login_id);
1621:
1622: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1620: fnd_global.login_id);

1616: fnd_global.user_id,
1617: sysdate,
1618: fnd_global.user_id,
1619: sysdate,
1620: fnd_global.login_id);
1621:
1622: IF ( g_level_statement>= g_current_runtime_level ) THEN
1623: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1624: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1671: fnd_global.user_id,

1667: l_detail_tax_line_id_tbl(i),
1668: X_PRINT_DATE_TBL(i),
1669: X_INVOICE_AMOUNT_TBL(i),
1670: X_BASE_AMOUNT_TBL(i),
1671: fnd_global.user_id,
1672: sysdate,
1673: fnd_global.user_id,
1674: sysdate,
1675: fnd_global.login_id);

Line 1673: fnd_global.user_id,

1669: X_INVOICE_AMOUNT_TBL(i),
1670: X_BASE_AMOUNT_TBL(i),
1671: fnd_global.user_id,
1672: sysdate,
1673: fnd_global.user_id,
1674: sysdate,
1675: fnd_global.login_id);
1676:
1677: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1675: fnd_global.login_id);

1671: fnd_global.user_id,
1672: sysdate,
1673: fnd_global.user_id,
1674: sysdate,
1675: fnd_global.login_id);
1676:
1677: IF ( g_level_statement>= g_current_runtime_level ) THEN
1678: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1679: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1712: fnd_global.user_id,

1708: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1709: l_detail_tax_line_id_tbl(i),
1710: X_INVOICE_AMOUNT_TBL(i),
1711: X_BASE_AMOUNT_TBL(i),
1712: fnd_global.user_id,
1713: sysdate,
1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id);

Line 1714: fnd_global.user_id,

1710: X_INVOICE_AMOUNT_TBL(i),
1711: X_BASE_AMOUNT_TBL(i),
1712: fnd_global.user_id,
1713: sysdate,
1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id);
1717:
1718: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1716: fnd_global.login_id);

1712: fnd_global.user_id,
1713: sysdate,
1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id);
1717:
1718: IF ( g_level_statement>= g_current_runtime_level ) THEN
1719: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1720: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1831: fnd_global.user_id,

1827: X_INHOUSE_TAX_AMT_TBL(i),
1828: X_SUPPLIER_TAX_AMT_TBL(i),
1829: X_TAXABLE_GAINLOSS_TBL(i),
1830: X_TAX_GAINLOSS_TBL(i),
1831: fnd_global.user_id,
1832: sysdate,
1833: fnd_global.user_id,
1834: sysdate,
1835: fnd_global.login_id);

Line 1833: fnd_global.user_id,

1829: X_TAXABLE_GAINLOSS_TBL(i),
1830: X_TAX_GAINLOSS_TBL(i),
1831: fnd_global.user_id,
1832: sysdate,
1833: fnd_global.user_id,
1834: sysdate,
1835: fnd_global.login_id);
1836:
1837: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1835: fnd_global.login_id);

1831: fnd_global.user_id,
1832: sysdate,
1833: fnd_global.user_id,
1834: sysdate,
1835: fnd_global.login_id);
1836:
1837: IF ( g_level_statement>= g_current_runtime_level ) THEN
1838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1839: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1951: fnd_global.user_id,

1947: l_loc_tax_reg_num_tbl(i),
1948: l_taxable_person_tbl(i),
1949: l_ind_sub_classif_tbl(i),
1950: l_ind_classif_tbl(i),
1951: fnd_global.user_id,
1952: sysdate,
1953: fnd_global.user_id,
1954: sysdate,
1955: fnd_global.login_id,

Line 1953: fnd_global.user_id,

1949: l_ind_sub_classif_tbl(i),
1950: l_ind_classif_tbl(i),
1951: fnd_global.user_id,
1952: sysdate,
1953: fnd_global.user_id,
1954: sysdate,
1955: fnd_global.login_id,
1956: p_trl_global_variables_rec.request_id);
1957:

Line 1955: fnd_global.login_id,

1951: fnd_global.user_id,
1952: sysdate,
1953: fnd_global.user_id,
1954: sysdate,
1955: fnd_global.login_id,
1956: p_trl_global_variables_rec.request_id);
1957:
1958: end if;
1959:

Line 2631: fnd_global.user_id,

2627: l_detail_tax_line_id_tbl(i),
2628: l_bank_name,
2629: l_branch_name,
2630: l_bank_account_num,
2631: fnd_global.user_id,
2632: sysdate,
2633: fnd_global.user_id,
2634: sysdate,
2635: fnd_global.login_id);

Line 2633: fnd_global.user_id,

2629: l_branch_name,
2630: l_bank_account_num,
2631: fnd_global.user_id,
2632: sysdate,
2633: fnd_global.user_id,
2634: sysdate,
2635: fnd_global.login_id);
2636: END;
2637:

Line 2635: fnd_global.login_id);

2631: fnd_global.user_id,
2632: sysdate,
2633: fnd_global.user_id,
2634: sysdate,
2635: fnd_global.login_id);
2636: END;
2637:
2638: ELSE
2639:

Line 2656: fnd_global.user_id,

2652: dtl.detail_tax_line_id,
2653: loc.global_attribute5,
2654: loc.global_attribute6,
2655: loc.global_attribute7,
2656: fnd_global.user_id,
2657: sysdate,
2658: fnd_global.user_id,
2659: sysdate,
2660: fnd_global.login_id

Line 2658: fnd_global.user_id,

2654: loc.global_attribute6,
2655: loc.global_attribute7,
2656: fnd_global.user_id,
2657: sysdate,
2658: fnd_global.user_id,
2659: sysdate,
2660: fnd_global.login_id
2661: FROM hr_all_organization_units ou,
2662: hr_organization_information oi,

Line 2660: fnd_global.login_id

2656: fnd_global.user_id,
2657: sysdate,
2658: fnd_global.user_id,
2659: sysdate,
2660: fnd_global.login_id
2661: FROM hr_all_organization_units ou,
2662: hr_organization_information oi,
2663: hr_locations loc,
2664: gl_sets_of_books sob,