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.

APPS.JE_ES_MODELO_EXT_PKG dependencies on JE_ES_MODELO_EXT_PKG

Line 1: PACKAGE BODY je_es_modelo_ext_pkg

1: PACKAGE BODY je_es_modelo_ext_pkg
2: -- $Header: jeesmodeloextb.pls 120.47.12020000.13 2013/04/12 09:00:07 abhijsar ship $
3: AS
4:
5: G_LE_TRN VARCHAR2(150);

Line 4371: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)) KEY_ID, -- BUG 8946271

4367: lc_jgzz_mod_query_340 :=
4368: 'SELECT decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',
4369: jzvtd.billing_tp_taxpayer_id) DECLARED_NIF,
4370: substrb(jzvtd.billing_tp_name,1,40) DECLARED_NAME,
4371: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)) KEY_ID, -- BUG 8946271
4372: decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',null,
4373: substrb(jzvtd.billing_tp_taxpayer_id,1,17)) FISCAL_ID,
4374: decode(substr(api.document_sub_type,1,6), ''MOD340'', substr(api.document_sub_type,8,1),
4375: decode(substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3)

Line 4449: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)),

4445: AND jzvtd.reporting_code <> ''OFFSET'' ))
4446: GROUP BY decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',
4447: jzvtd.billing_tp_taxpayer_id),
4448: substrb(jzvtd.billing_tp_name,1,40),
4449: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)),
4450: decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',null,
4451: substrb(jzvtd.billing_tp_taxpayer_id,1,17)),
4452: decode(substr(api.document_sub_type,1,6), ''MOD340'', substr(api.document_sub_type,8,1),
4453: decode(substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3)

Line 4473: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)) KEY_ID, --BUG 8946271

4469: lc_jgzz_mod_query_340_exp :=
4470: 'UNION SELECT decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',
4471: NVL(JZVTD.merchant_party_taxpayer_id, JZVTD.billing_tp_taxpayer_id)) DECLARED_NIF,
4472: substrb(NVL(JZVTD.merchant_party_name,JZVTD.billing_tp_name),1,40) DECLARED_NAME,
4473: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)) KEY_ID, --BUG 8946271
4474: decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',null,
4475: substrb(jzvtd.billing_tp_taxpayer_id,1,17)) FISCAL_ID,
4476: decode(substr(api.document_sub_type,1,6), ''MOD340'', substr(api.document_sub_type,8,1),
4477: decode(substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3)

Line 4554: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)),

4550: GROUP BY decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',
4551: NVL(JZVTD.merchant_party_taxpayer_id,
4552: JZVTD.billing_tp_taxpayer_id)),
4553: substrb(NVL(JZVTD.merchant_party_name,JZVTD.billing_tp_name),1,40),
4554: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)),
4555: decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',null,
4556: substrb(jzvtd.billing_tp_taxpayer_id,1,17)),
4557: decode(substr(api.document_sub_type,1,6), ''MOD340'', substr(api.document_sub_type,8,1),
4558: decode(substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3)

Line 4849: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)) KEY_ID, --BUG 8946271

4845: lc_jgzz_mod_query_340 :=
4846: 'SELECT decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',
4847: jzvtd.billing_tp_taxpayer_id) DECLARED_NIF,
4848: substrb(jzvtd.billing_tp_name,1,40) DECLARED_NAME,
4849: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)) KEY_ID, --BUG 8946271
4850: decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',null,
4851: substrb(jzvtd.billing_tp_taxpayer_id,1,17)) FISCAL_ID,
4852: decode(substr(zxdf.document_sub_type,1,6), ''MOD340'', substr(zxdf.document_sub_type,8,1),
4853: decode(substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3)

Line 4910: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)),

4906: AND jzvtd.trx_id = trx.customer_trx_id
4907: GROUP BY decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',
4908: jzvtd.billing_tp_taxpayer_id),
4909: substrb(jzvtd.billing_tp_name,1,40),
4910: je_es_modelo_ext_pkg.getKeyID(substrb(jzvtd.billing_tp_tax_reg_num,1,2)),
4911: decode(substrb(jzvtd.billing_tp_tax_reg_num,1,2),''ES'',null,
4912: substrb(jzvtd.billing_tp_taxpayer_id,1,17)),
4913: decode(substr(zxdf.document_sub_type,1,6), ''MOD340'', substr(zxdf.document_sub_type,8,1),
4914: decode(substr(zxdf.trx_business_category,(instr(zxdf.trx_business_category,''MOD'',1,1)+3),3)

Line 5566: END je_es_modelo_ext_pkg;

5562: NULL;
5563: RETURN (TRUE);
5564: END after_Report;
5565:
5566: END je_es_modelo_ext_pkg;