DBA Data[Home] [Help]

APPS.ZX_GL_EXTRACT_PKG dependencies on ZX_RATES_VL

Line 247: P_TAX IN zx_rates_vl.tax%TYPE,

243: PROCEDURE INIT_GL_GT_TABLES;
244:
245: PROCEDURE populate_tax_reg_num(
246: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
247: P_TAX IN zx_rates_vl.tax%TYPE,
248: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
249: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
250: i IN BINARY_INTEGER);
251:

Line 248: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,

244:
245: PROCEDURE populate_tax_reg_num(
246: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
247: P_TAX IN zx_rates_vl.tax%TYPE,
248: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
249: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
250: i IN BINARY_INTEGER);
251:
252: PROCEDURE GET_ACCOUNTING_SEGMENTS (

Line 249: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,

245: PROCEDURE populate_tax_reg_num(
246: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
247: P_TAX IN zx_rates_vl.tax%TYPE,
248: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
249: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
250: i IN BINARY_INTEGER);
251:
252: PROCEDURE GET_ACCOUNTING_SEGMENTS (
253: P_TRX_ID IN NUMBER,

Line 897: zx_rates_vl zx_rate,

893: -- gl_tax_options gto,
894: gl_code_combinations gcc2,
895: gl_je_lines gjl2,
896: -- ar_ap_tax_codes_v tax,
897: zx_rates_vl zx_rate,
898: zx_taxes_vl zx_tax,
899: gl_code_combinations gcc1,
900: gl_je_lines gjl1,
901: gl_je_batches gjb,

Line 1109: zx_rates_vl zx_rate,

1105: -- gl_tax_options gto,
1106: gl_code_combinations gcc2,
1107: gl_je_lines gjl2,
1108: --ar_ap_tax_codes_v tax,
1109: zx_rates_vl zx_rate,
1110: zx_taxes_vl zx_tax,
1111: gl_code_combinations gcc1,
1112: gl_je_lines gjl1,
1113: gl_je_batches gjb,

Line 1300: ZX_RATES_VL ZX_RATE,

1296: (nvl(GJL1.ENTERED_CR,0)-nvl(GJL1.ENTERED_DR,0)) ETAXABLEAM
1297: from FND_DOCUMENT_SEQUENCES SEQ,
1298: GL_JE_LINES GJL2,
1299: -- AR_AP_TAX_CODES_V TAX,
1300: ZX_RATES_VL ZX_RATE,
1301: GL_JE_LINES GJL1,
1302: GL_JE_HEADERS GJH
1303: where gjh.je_header_id = p_trx_id and
1304: gjh.je_header_id = gjl1.je_header_id and

Line 2775: P_TAX IN zx_rates_vl.tax%TYPE,

2771:
2772:
2773: PROCEDURE populate_tax_reg_num(
2774: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
2775: P_TAX IN zx_rates_vl.tax%TYPE,
2776: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
2777: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
2778: i IN BINARY_INTEGER) IS
2779:

Line 2776: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,

2772:
2773: PROCEDURE populate_tax_reg_num(
2774: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
2775: P_TAX IN zx_rates_vl.tax%TYPE,
2776: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
2777: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
2778: i IN BINARY_INTEGER) IS
2779:
2780: l_ptp_id number;

Line 2777: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,

2773: PROCEDURE populate_tax_reg_num(
2774: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
2775: P_TAX IN zx_rates_vl.tax%TYPE,
2776: P_TAX_REGIME_CODE IN zx_rates_vl.tax_regime_code%TYPE,
2777: P_TAX_JURISDICTION_CODE IN zx_rates_vl.tax_jurisdiction_code%TYPE,
2778: i IN BINARY_INTEGER) IS
2779:
2780: l_ptp_id number;
2781: l_return_status varchar2(30);