DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T_S

Line 807: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

803: creation_date,
804: last_updated_by,
805: last_update_date,
806: last_update_login)
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,

Line 999: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

995: last_updated_by,
996: last_update_date,
997: last_update_login,
998: request_id)
999: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1000: l_detail_tax_line_id_tbl(i),
1001: l_vat_amt_tbl(i),
1002: l_taxable_amt_tbl(i),
1003: l_non_taxable_amt_tbl(i),

Line 1429: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1425: last_updated_by,
1426: last_update_date,
1427: last_update_login,
1428: request_id)
1429: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1430: l_detail_tax_line_id_tbl(i),
1431: l_vat_amt_tbl(i),
1432: l_taxable_amt_tbl(i),
1433: l_non_taxable_amt_tbl(i),

Line 1654: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1650: creation_date,
1651: last_updated_by,
1652: last_update_date,
1653: last_update_login)
1654: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1655: l_detail_tax_line_id_tbl(i),
1656: l_vat_amt_tbl(i),
1657: l_taxable_amt_tbl(i),
1658: l_vat_exempt_amt_tbl(i),

Line 1758: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1754: creation_date,
1755: last_updated_by,
1756: last_update_date,
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,

Line 2005: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2001: last_updated_by,
2002: last_update_date,
2003: last_update_login,
2004: request_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,

Line 2180: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2176: creation_date,
2177: last_updated_by,
2178: last_update_date,
2179: last_update_login)
2180: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2181: l_detail_tax_line_id_tbl(i),
2182: l_taxable_amt_tbl(i),
2183: l_vat_perc_amt_tbl(i),
2184: l_total_doc_amt_tbl(i),

Line 2465: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2461: creation_date,
2462: last_updated_by,
2463: last_update_date,
2464: last_update_login)
2465: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2466: l_detail_tax_line_id_tbl(i),
2467: l_vat_amt_tbl(i),
2468: l_taxable_amt_tbl(i),
2469: l_non_taxable_amt_tbl(i),

Line 2955: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2951: last_updated_by,
2952: last_update_date,
2953: last_update_login,
2954: request_id)
2955: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2956: l_detail_tax_line_id_tbl(i),
2957: l_vat_amt_tbl(i),
2958: l_taxable_amt_tbl(i),
2959: l_non_taxable_amt_tbl(i),

Line 3132: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3128: last_updated_by,
3129: last_update_date,
3130: last_update_login,
3131: request_id)
3132: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3133: l_detail_tax_line_id_tbl(i),
3134: l_prov_perc_amt_tbl(i),
3135: l_munic_perc_amt_tbl(i),
3136: l_dgi_code_tbl(i),

Line 3314: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3310: creation_date,
3311: last_updated_by,
3312: last_update_date,
3313: last_update_login)
3314: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
3315: l_detail_tax_line_id_tbl(i),
3316: l_vat_amt_tbl(i),
3317: l_taxable_amt_tbl(i),
3318: l_vat_exempt_amt_tbl(i),

Line 3449: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

3445: creation_date,
3446: last_updated_by,
3447: last_update_date,
3448: last_update_login)
3449: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
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

Line 3522: (SELECT zx_rep_trx_jx_ext_t_s.nextval,

3518: creation_date,
3519: last_updated_by,
3520: last_update_date,
3521: last_update_login)
3522: (SELECT zx_rep_trx_jx_ext_t_s.nextval,
3523: dtl.detail_tax_line_id,
3524: l_tax_catg_desc,
3525: dtl.created_by,
3526: dtl.creation_date,