DBA Data[Home] [Help]

APPS.ZX_GL_EXTRACT_PKG dependencies on ZX_RATES_VL

Line 253: P_TAX IN zx_rates_vl.tax%TYPE,

249: PROCEDURE INIT_GL_GT_TABLES;
250:
251: PROCEDURE populate_tax_reg_num(
252: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
253: P_TAX IN zx_rates_vl.tax%TYPE,
254: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
255: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
256: i IN BINARY_INTEGER);
257:

Line 254: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,

250:
251: PROCEDURE populate_tax_reg_num(
252: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
253: P_TAX IN zx_rates_vl.tax%TYPE,
254: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
255: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
256: i IN BINARY_INTEGER);
257:
258: PROCEDURE GET_ACCOUNTING_SEGMENTS (

Line 255: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,

251: PROCEDURE populate_tax_reg_num(
252: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
253: P_TAX IN zx_rates_vl.tax%TYPE,
254: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
255: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
256: i IN BINARY_INTEGER);
257:
258: PROCEDURE GET_ACCOUNTING_SEGMENTS (
259: P_TRX_ID IN NUMBER,

Line 910: zx_rates_vl zx_rate,

906: -- gl_tax_options gto,
907: gl_code_combinations gcc2,
908: gl_je_lines gjl2,
909: -- ar_ap_tax_codes_v tax,
910: zx_rates_vl zx_rate,
911: zx_taxes_vl zx_tax,
912: gl_code_combinations gcc1,
913: gl_je_lines gjl1,
914: gl_je_batches gjb,

Line 1124: zx_rates_vl zx_rate,

1120: -- gl_tax_options gto,
1121: gl_code_combinations gcc2,
1122: gl_je_lines gjl2,
1123: --ar_ap_tax_codes_v tax,
1124: zx_rates_vl zx_rate,
1125: zx_taxes_vl zx_tax,
1126: gl_code_combinations gcc1,
1127: gl_je_lines gjl1,
1128: gl_je_batches gjb,

Line 1316: ZX_RATES_VL ZX_RATE,

1312: (nvl(GJL1.ENTERED_CR,0)-nvl(GJL1.ENTERED_DR,0)) ETAXABLEAM
1313: from FND_DOCUMENT_SEQUENCES SEQ,
1314: GL_JE_LINES GJL2,
1315: -- AR_AP_TAX_CODES_V TAX,
1316: ZX_RATES_VL ZX_RATE,
1317: GL_JE_LINES GJL1,
1318: GL_JE_HEADERS GJH
1319: where gjh.je_header_id = p_trx_id and
1320: gjh.je_header_id = gjl1.je_header_id and

Line 2868: P_TAX IN zx_rates_vl.tax%TYPE,

2864:
2865:
2866: PROCEDURE populate_tax_reg_num(
2867: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
2868: P_TAX IN zx_rates_vl.tax%TYPE,
2869: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
2870: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
2871: i IN BINARY_INTEGER) IS
2872:

Line 2869: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,

2865:
2866: PROCEDURE populate_tax_reg_num(
2867: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
2868: P_TAX IN zx_rates_vl.tax%TYPE,
2869: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
2870: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
2871: i IN BINARY_INTEGER) IS
2872:
2873: l_ptp_id number;

Line 2870: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,

2866: PROCEDURE populate_tax_reg_num(
2867: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
2868: P_TAX IN zx_rates_vl.tax%TYPE,
2869: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
2870: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
2871: i IN BINARY_INTEGER) IS
2872:
2873: l_ptp_id number;
2874: l_return_status varchar2(30);