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 1788: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

1784: p_memo_line_id IN ar_memo_lines.memo_line_id%TYPE default null
1785: ) RETURN VARCHAR2 IS
1786:
1787: -- l_tax_classification_code varchar2(30);
1788: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1789:
1790: CURSOR sel_memo_line_tax(
1791: c_memo_line_id AR_MEMO_LINES.memo_line_id%type,
1792: c_trx_date DATE,

Line 1947: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

1943:
1944: l_country hz_locations.country%TYPE := null;
1945: -- l_tax_classification_code ar_vat_tax.tax_code%TYPE := null;
1946:
1947: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1948:
1949: CURSOR sel_addr_country(
1950: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1951: IS

Line 2100: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

2096: ,p_check_override_only IN VARCHAR2 ) RETURN VARCHAR2 IS
2097:
2098:
2099: -- l_tax_classification_code varchar2(30);
2100: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
2101:
2102: l_dummy CHAR;
2103:
2104: BEGIN

Line 2199: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;

2195: ,p_tax_classification_code OUT NOCOPY VARCHAR2
2196: ,p_override_flag OUT NOCOPY CHAR
2197: ,p_validate_tax_code_flag IN BOOLEAN default TRUE) IS
2198:
2199: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
2200:
2201: l_override_flag CHAR;
2202: statement varchar2(2000);
2203: