DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 1367: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

1363: IS
1364: l_user_id NUMBER;
1365: l_login_id NUMBER;
1366: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1367: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1368: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1369: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1370: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1371:

Line 1368: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

1364: l_user_id NUMBER;
1365: l_login_id NUMBER;
1366: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1367: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1368: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1369: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1370: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1371:
1372: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1369: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1365: l_login_id NUMBER;
1366: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1367: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1368: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1369: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1370: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1371:
1372: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1373: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1370: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;

1366: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1367: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1368: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1369: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1370: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1371:
1372: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1373: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1374: TYPE var_30_tab_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 2074: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

2070:
2071: ELSE
2072: -- validate and populate tax_regime_id
2073: --
2074: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
2075: l_tax_regime_code_tab(i),
2076: l_tax_determine_date_tab(i),
2077: l_tax_regime_rec,
2078: x_return_status,

Line 2086: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');

2082: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2083: FND_LOG.STRING(g_level_unexpected,
2084: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2085: 'Incorrect return_status after calling ' ||
2086: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2087: FND_LOG.STRING(g_level_unexpected,
2088: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2089: 'RETURN_STATUS = ' || x_return_status);
2090: FND_LOG.STRING(g_level_unexpected,

Line 2101: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

2097: l_tax_regime_id_tab(i) := l_tax_regime_rec.tax_regime_id;
2098:
2099: -- validate and populate tax_id
2100: --
2101: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2102: l_tax_regime_code_tab(i),
2103: l_tax_tab(i),
2104: l_tax_determine_date_tab(i),
2105: l_tax_rec,

Line 2114: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

2110: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2111: FND_LOG.STRING(g_level_unexpected,
2112: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2113: 'Incorrect return_status after calling ' ||
2114: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2115: FND_LOG.STRING(g_level_unexpected,
2116: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2117: 'RETURN_STATUS = ' || x_return_status);
2118: FND_LOG.STRING(g_level_unexpected,

Line 2128: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

2124:
2125: l_tax_id_tab(i) := l_tax_rec.tax_id;
2126:
2127: IF l_tax_jurisdiction_code_tab(i) IS NOT NULL THEN
2128: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
2129: l_tax_regime_code_tab(i),
2130: l_tax_tab(i),
2131: l_tax_jurisdiction_code_tab(i),
2132: l_tax_determine_date_tab(i),

Line 2142: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');

2138: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2139: FND_LOG.STRING(g_level_unexpected,
2140: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2141: 'Incorrect return_status after calling ' ||
2142: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2143: FND_LOG.STRING(g_level_unexpected,
2144: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2145: 'RETURN_STATUS = ' || x_return_status);
2146: FND_LOG.STRING(g_level_unexpected,

Line 2159: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

2155:
2156: l_tax_jur_id_tab(i) := NULL;
2157: END IF;
2158:
2159: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
2160: l_tax_tab(i),
2161: l_tax_regime_code_tab(i),
2162: l_tax_status_code_tab(i),
2163: l_tax_determine_date_tab(i),

Line 2173: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

2169: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2170: FND_LOG.STRING(g_level_unexpected,
2171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2172: 'Incorrect return_status after calling ' ||
2173: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2174: FND_LOG.STRING(g_level_unexpected,
2175: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2176: 'RETURN_STATUS = ' || x_return_status);
2177: FND_LOG.STRING(g_level_unexpected,

Line 2188: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

2184: l_tax_status_id_tab(i) := l_tax_status_rec.tax_status_id;
2185:
2186: -- validate and populate tax_rate_id
2187: --
2188: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
2189: l_tax_regime_code_tab(i),
2190: l_tax_tab(i),
2191: l_tax_jurisdiction_code_tab(i),
2192: l_tax_status_code_tab(i),

Line 2205: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

2201: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2202: FND_LOG.STRING(g_level_unexpected,
2203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2204: 'Incorrect return_status after calling ' ||
2205: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2206: FND_LOG.STRING(g_level_unexpected,
2207: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2208: 'RETURN_STATUS = ' || x_return_status);
2209: FND_LOG.STRING(g_level_unexpected,

Line 2276: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

2272:
2273: l_user_id NUMBER;
2274: l_login_id NUMBER;
2275: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2276: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2277: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2278: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2279: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2280:

Line 2277: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

2273: l_user_id NUMBER;
2274: l_login_id NUMBER;
2275: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2276: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2277: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2278: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2279: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2280:
2281: l_tax_class ZX_RATES_B.tax_class%TYPE;

Line 2278: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

2274: l_login_id NUMBER;
2275: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2276: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2277: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2278: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2279: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2280:
2281: l_tax_class ZX_RATES_B.tax_class%TYPE;
2282:

Line 2279: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;

2275: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2276: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2277: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2278: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2279: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2280:
2281: l_tax_class ZX_RATES_B.tax_class%TYPE;
2282:
2283: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 3370: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

3366: FOR i in 1 .. l_tax_line_id_tab.count LOOP
3367:
3368: -- validate and populate tax_regime_id
3369: --
3370: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
3371: l_tax_regime_code_tab(i),
3372: l_tax_determine_date_tab(i),
3373: l_tax_regime_rec,
3374: x_return_status,

Line 3382: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');

3378: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3379: FND_LOG.STRING(g_level_unexpected,
3380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3381: 'Incorrect return_status after calling ' ||
3382: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3383: FND_LOG.STRING(g_level_unexpected,
3384: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3385: 'RETURN_STATUS = ' || x_return_status);
3386: FND_LOG.STRING(g_level_unexpected,

Line 3397: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

3393: l_tax_regime_id_tab(i) := l_tax_regime_rec.tax_regime_id;
3394:
3395: -- validate and populate tax_id
3396: --
3397: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
3398: l_tax_regime_code_tab(i),
3399: l_tax_tab(i),
3400: l_tax_determine_date_tab(i),
3401: l_tax_rec,

Line 3410: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

3406: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3407: FND_LOG.STRING(g_level_unexpected,
3408: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3409: 'Incorrect return_status after calling ' ||
3410: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
3411: FND_LOG.STRING(g_level_unexpected,
3412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3413: 'RETURN_STATUS = ' || x_return_status);
3414: FND_LOG.STRING(g_level_unexpected,

Line 3424: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

3420:
3421: l_tax_id_tab(i) := l_tax_rec.tax_id;
3422:
3423: IF l_tax_jurisdiction_code_tab(i) IS NOT NULL THEN
3424: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
3425: l_tax_regime_code_tab(i),
3426: l_tax_tab(i),
3427: l_tax_jurisdiction_code_tab(i),
3428: l_tax_determine_date_tab(i),

Line 3438: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');

3434: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3435: FND_LOG.STRING(g_level_unexpected,
3436: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3437: 'Incorrect return_status after calling ' ||
3438: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
3439: FND_LOG.STRING(g_level_unexpected,
3440: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3441: 'RETURN_STATUS = ' || x_return_status);
3442: FND_LOG.STRING(g_level_unexpected,

Line 3458: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

3454: END IF;
3455:
3456: -- validate and populate tax_status_id
3457: --
3458: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
3459: l_tax_tab(i),
3460: l_tax_regime_code_tab(i),
3461: l_tax_status_code_tab(i),
3462: l_tax_determine_date_tab(i),

Line 3472: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

3468: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3469: FND_LOG.STRING(g_level_unexpected,
3470: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3471: 'Incorrect return_status after calling ' ||
3472: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
3473: FND_LOG.STRING(g_level_unexpected,
3474: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3475: 'RETURN_STATUS = ' || x_return_status);
3476: FND_LOG.STRING(g_level_unexpected,

Line 3487: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

3483: l_tax_status_id_tab(i) := l_tax_status_rec.tax_status_id;
3484:
3485: -- validate and populate tax_rate_id
3486: --
3487: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
3488: l_tax_regime_code_tab(i),
3489: l_tax_tab(i),
3490: l_tax_jurisdiction_code_tab(i),
3491: l_tax_status_code_tab(i),

Line 3504: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

3500: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3501: FND_LOG.STRING(g_level_unexpected,
3502: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3503: 'Incorrect return_status after calling ' ||
3504: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
3505: FND_LOG.STRING(g_level_unexpected,
3506: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3507: 'RETURN_STATUS = ' || x_return_status);
3508: FND_LOG.STRING(g_level_unexpected,