DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on FND_GLOBAL

Line 811: fnd_global.user_id,

807: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
808: l_detail_tax_line_id_tbl(i),
809: l_vat_amt_tbl(i),
810: l_dgi_doc_type_tbl(i),
811: fnd_global.user_id,
812: sysdate,
813: fnd_global.user_id,
814: sysdate,
815: fnd_global.login_id);

Line 813: fnd_global.user_id,

809: l_vat_amt_tbl(i),
810: l_dgi_doc_type_tbl(i),
811: fnd_global.user_id,
812: sysdate,
813: fnd_global.user_id,
814: sysdate,
815: fnd_global.login_id);
816:
817: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 815: fnd_global.login_id);

811: fnd_global.user_id,
812: sysdate,
813: fnd_global.user_id,
814: sysdate,
815: fnd_global.login_id);
816:
817: IF ( g_level_statement>= g_current_runtime_level ) THEN
818: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
819: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 1010: fnd_global.user_id,

1006: nvl(l_non_taxable_amt_tbl(i),0)+nvl(l_vat_perc_amt_tbl(i),0)
1007: +nvl(l_taxable_amt_tbl(i),0)+nvl(l_vat_amt_tbl(i),0), --Bug 5415028
1008: l_gdf_ap_inv_att11_tbl(i),
1009: l_gdf_ap_inv_att12_tbl(i),
1010: fnd_global.user_id,
1011: sysdate,
1012: fnd_global.user_id,
1013: sysdate,
1014: fnd_global.login_id,

Line 1012: fnd_global.user_id,

1008: l_gdf_ap_inv_att11_tbl(i),
1009: l_gdf_ap_inv_att12_tbl(i),
1010: fnd_global.user_id,
1011: sysdate,
1012: fnd_global.user_id,
1013: sysdate,
1014: fnd_global.login_id,
1015: p_request_id);
1016:

Line 1014: fnd_global.login_id,

1010: fnd_global.user_id,
1011: sysdate,
1012: fnd_global.user_id,
1013: sysdate,
1014: fnd_global.login_id,
1015: p_request_id);
1016:
1017: IF ( g_level_statement>= g_current_runtime_level ) THEN
1018: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',

Line 1448: fnd_global.user_id,

1444: l_fiscal_printer_tbl(i),
1445: l_dgi_doc_type_tbl(i),
1446: l_taxpayerid_type_tbl(i),
1447: l_reg_status_code_tbl(i),
1448: fnd_global.user_id,
1449: sysdate,
1450: fnd_global.user_id,
1451: sysdate,
1452: fnd_global.login_id,

Line 1450: fnd_global.user_id,

1446: l_taxpayerid_type_tbl(i),
1447: l_reg_status_code_tbl(i),
1448: fnd_global.user_id,
1449: sysdate,
1450: fnd_global.user_id,
1451: sysdate,
1452: fnd_global.login_id,
1453: p_request_id);
1454:

Line 1452: fnd_global.login_id,

1448: fnd_global.user_id,
1449: sysdate,
1450: fnd_global.user_id,
1451: sysdate,
1452: fnd_global.login_id,
1453: p_request_id);
1454:
1455: IF ( g_level_statement>= g_current_runtime_level ) THEN
1456: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',

Line 1670: fnd_global.user_id,

1666: -- l_total_doc_taxab_amt_tbl(i),
1667: nvl(l_cl_total_exempt_tbl(i),0)+nvl(l_cl_total_effective_tbl(i),0)+nvl(l_cl_total_vat_tax_tbl(i),0)+nvl(l_cl_total_other_tax_tbl(i),0),
1668: l_order_by_doc_type_tbl(i),
1669: l_jlcl_ap_doc_type_mng_tbl(i),
1670: fnd_global.user_id,
1671: sysdate,
1672: fnd_global.user_id,
1673: sysdate,
1674: fnd_global.login_id);

Line 1672: fnd_global.user_id,

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

Line 1674: fnd_global.login_id);

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

Line 1761: fnd_global.user_id,

1757: last_update_login)
1758: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1759: l_detail_tax_line_id_tbl(i),
1760: l_tax_auth_categ_tbl(i),
1761: fnd_global.user_id,
1762: sysdate,
1763: fnd_global.user_id,
1764: sysdate,
1765: fnd_global.login_id);

Line 1763: fnd_global.user_id,

1759: l_detail_tax_line_id_tbl(i),
1760: l_tax_auth_categ_tbl(i),
1761: fnd_global.user_id,
1762: sysdate,
1763: fnd_global.user_id,
1764: sysdate,
1765: fnd_global.login_id);
1766:
1767: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1765: fnd_global.login_id);

1761: fnd_global.user_id,
1762: sysdate,
1763: fnd_global.user_id,
1764: sysdate,
1765: fnd_global.login_id);
1766:
1767: IF ( g_level_statement>= g_current_runtime_level ) THEN
1768: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
1769: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 2009: fnd_global.user_id,

2005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2006: l_detail_tax_line_id_tbl(i),
2007: l_vat_amt_tbl(i),
2008: l_dgi_code_tbl(i),
2009: fnd_global.user_id,
2010: sysdate,
2011: fnd_global.user_id,
2012: sysdate,
2013: fnd_global.login_id,

Line 2011: fnd_global.user_id,

2007: l_vat_amt_tbl(i),
2008: l_dgi_code_tbl(i),
2009: fnd_global.user_id,
2010: sysdate,
2011: fnd_global.user_id,
2012: sysdate,
2013: fnd_global.login_id,
2014: p_request_id);
2015:

Line 2013: fnd_global.login_id,

2009: fnd_global.user_id,
2010: sysdate,
2011: fnd_global.user_id,
2012: sysdate,
2013: fnd_global.login_id,
2014: p_request_id);
2015:
2016: IF ( g_level_statement>= g_current_runtime_level ) THEN
2017: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 2189: fnd_global.user_id,

2185: l_tax_authority_code,
2186: l_cust_condition_code_tbl(i),
2187: l_dgi_tax_regime_code_tbl(i),
2188: p_request_id,
2189: fnd_global.user_id,
2190: sysdate,
2191: fnd_global.user_id,
2192: sysdate,
2193: fnd_global.login_id);

Line 2191: fnd_global.user_id,

2187: l_dgi_tax_regime_code_tbl(i),
2188: p_request_id,
2189: fnd_global.user_id,
2190: sysdate,
2191: fnd_global.user_id,
2192: sysdate,
2193: fnd_global.login_id);
2194:
2195: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2193: fnd_global.login_id);

2189: fnd_global.user_id,
2190: sysdate,
2191: fnd_global.user_id,
2192: sysdate,
2193: fnd_global.login_id);
2194:
2195: IF ( g_level_statement>= g_current_runtime_level ) THEN
2196: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2197: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 2475: fnd_global.user_id,

2471: l_vat_exempt_amt_tbl(i),
2472: l_vat_perc_amt_tbl(i),
2473: l_total_doc_amt_tbl(i),
2474: l_dgi_code_tbl(i),
2475: fnd_global.user_id,
2476: sysdate,
2477: fnd_global.user_id,
2478: sysdate,
2479: fnd_global.login_id);

Line 2477: fnd_global.user_id,

2473: l_total_doc_amt_tbl(i),
2474: l_dgi_code_tbl(i),
2475: fnd_global.user_id,
2476: sysdate,
2477: fnd_global.user_id,
2478: sysdate,
2479: fnd_global.login_id);
2480:
2481: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2479: fnd_global.login_id);

2475: fnd_global.user_id,
2476: sysdate,
2477: fnd_global.user_id,
2478: sysdate,
2479: fnd_global.login_id);
2480:
2481: IF ( g_level_statement>= g_current_runtime_level ) THEN
2482: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
2483: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 2976: fnd_global.user_id,

2972: l_vat_reg_stat_code_tbl(i),
2973: l_fiscal_printer_tbl(i),
2974: l_cai_number_tbl(i),
2975: l_cai_due_date_tbl(i),
2976: fnd_global.user_id,
2977: sysdate,
2978: fnd_global.user_id,
2979: sysdate,
2980: fnd_global.login_id,

Line 2978: fnd_global.user_id,

2974: l_cai_number_tbl(i),
2975: l_cai_due_date_tbl(i),
2976: fnd_global.user_id,
2977: sysdate,
2978: fnd_global.user_id,
2979: sysdate,
2980: fnd_global.login_id,
2981: p_request_id);
2982:

Line 2980: fnd_global.login_id,

2976: fnd_global.user_id,
2977: sysdate,
2978: fnd_global.user_id,
2979: sysdate,
2980: fnd_global.login_id,
2981: p_request_id);
2982:
2983: IF ( g_level_statement>= g_current_runtime_level ) THEN
2984: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 3139: fnd_global.user_id,

3135: l_munic_perc_amt_tbl(i),
3136: l_dgi_code_tbl(i),
3137: l_prov_juris_code_tbl(i),
3138: l_mun_juris_code_tbl(i),
3139: fnd_global.user_id,
3140: sysdate,
3141: fnd_global.user_id,
3142: sysdate,
3143: fnd_global.login_id,

Line 3141: fnd_global.user_id,

3137: l_prov_juris_code_tbl(i),
3138: l_mun_juris_code_tbl(i),
3139: fnd_global.user_id,
3140: sysdate,
3141: fnd_global.user_id,
3142: sysdate,
3143: fnd_global.login_id,
3144: p_request_id);
3145:

Line 3143: fnd_global.login_id,

3139: fnd_global.user_id,
3140: sysdate,
3141: fnd_global.user_id,
3142: sysdate,
3143: fnd_global.login_id,
3144: p_request_id);
3145:
3146: IF ( g_level_statement>= g_current_runtime_level ) THEN
3147: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',

Line 3320: fnd_global.user_id,

3316: l_vat_amt_tbl(i),
3317: l_taxable_amt_tbl(i),
3318: l_vat_exempt_amt_tbl(i),
3319: l_other_tax_amt_tbl(i),
3320: fnd_global.user_id,
3321: sysdate,
3322: fnd_global.user_id,
3323: sysdate,
3324: fnd_global.login_id);

Line 3322: fnd_global.user_id,

3318: l_vat_exempt_amt_tbl(i),
3319: l_other_tax_amt_tbl(i),
3320: fnd_global.user_id,
3321: sysdate,
3322: fnd_global.user_id,
3323: sysdate,
3324: fnd_global.login_id);
3325:
3326: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 3324: fnd_global.login_id);

3320: fnd_global.user_id,
3321: sysdate,
3322: fnd_global.user_id,
3323: sysdate,
3324: fnd_global.login_id);
3325:
3326: IF ( g_level_statement>= g_current_runtime_level ) THEN
3327: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AR',
3328: 'After insertion into zx_rep_trx_jx_ext_t ');

Line 3454: fnd_global.user_id,

3450: l_detail_tax_line_id_tbl(i),
3451: (l_total_doc_amt_tbl(i) + l_vat_amt_tbl(i)) * l_exchange_rate_tbl(i), --Bug 5396444
3452: l_extended_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3453: l_vat_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3454: fnd_global.user_id,
3455: sysdate,
3456: fnd_global.user_id,
3457: sysdate,
3458: fnd_global.login_id);

Line 3456: fnd_global.user_id,

3452: l_extended_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3453: l_vat_amt_tbl(i) * l_exchange_rate_tbl(i),--Bug 5396444
3454: fnd_global.user_id,
3455: sysdate,
3456: fnd_global.user_id,
3457: sysdate,
3458: fnd_global.login_id);
3459:
3460: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 3458: fnd_global.login_id);

3454: fnd_global.user_id,
3455: sysdate,
3456: fnd_global.user_id,
3457: sysdate,
3458: fnd_global.login_id);
3459:
3460: IF ( g_level_statement>= g_current_runtime_level ) THEN
3461: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.POPULATE_JL_AP',
3462: 'After insertion into zx_rep_trx_jx_ext_t ');