DBA Data[Home] [Help]

APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_LINES_DET_FACTORS

Line 136: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

132:
133:
134: --l_tax_classification_code varchar2(30) := NULL;
135: -- Bug#4574838
136: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
137:
138: BEGIN
139:
140: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 255: l_output_tax_code zx_lines_det_factors.output_tax_classification_code%TYPE;

251: AND rownum = 1
252: ORDER BY l.org_id desc
253: ;
254:
255: l_output_tax_code zx_lines_det_factors.output_tax_classification_code%TYPE;
256:
257: BEGIN
258:
259: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 329: l_output_tax_code zx_lines_det_factors.output_tax_classification_code%TYPE;

325:
326:
327: -- l_output_tax_code varchar2(50) := NULL; bug#4574838
328:
329: l_output_tax_code zx_lines_det_factors.output_tax_classification_code%TYPE;
330: BEGIN
331:
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,

Line 503: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

499:
500: l_site_use_id NUMBER;
501: l_default_level VARCHAR2(30);
502: --l_tax_classification_code VARCHAR2(30);
503: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
504:
505: l_vat_tax_id NUMBER;
506: l_count NUMBER;
507: l_party_flag VARCHAR2(1);

Line 913: v_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

909: p_ccid IN NUMBER default null
910: ) IS
911:
912: -- v_tax_classification_code VARCHAR2(50) := NULL;
913: v_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
914: l_use_acct_line_flag BOOLEAN;
915:
916: l_default_level VARCHAR2(30);
917: l_site_use_id NUMBER;

Line 1774: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

1770: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1771: ) RETURN VARCHAR2 IS
1772:
1773: -- l_tax_classification_code varchar2(30);
1774: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1775:
1776: CURSOR sel_memo_line_tax(
1777: c_memo_line_id AR_MEMO_LINES.memo_line_id%type,
1778: c_trx_date DATE,

Line 1933: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

1929:
1930: l_country hz_locations.country%TYPE := null;
1931: -- l_tax_classification_code ar_vat_tax.tax_code%TYPE := null;
1932:
1933: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1934:
1935: CURSOR sel_addr_country(
1936: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1937: IS

Line 2086: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

2082: ,p_check_override_only IN VARCHAR2 ) RETURN VARCHAR2 IS
2083:
2084:
2085: -- l_tax_classification_code varchar2(30);
2086: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
2087:
2088: l_dummy CHAR;
2089:
2090: BEGIN

Line 2185: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

2181: ,p_tax_classification_code OUT NOCOPY VARCHAR2
2182: ,p_override_flag OUT NOCOPY CHAR
2183: ,p_validate_tax_code_flag IN BOOLEAN default TRUE) IS
2184:
2185: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
2186:
2187: l_override_flag CHAR;
2188: statement varchar2(2000);
2189: