DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 1395: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

1391: IS
1392: l_user_id NUMBER;
1393: l_login_id NUMBER;
1394: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1395: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1396: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1397: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1398: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1399:

Line 1396: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

1392: l_user_id NUMBER;
1393: l_login_id NUMBER;
1394: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1395: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1396: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1397: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1398: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1399:
1400: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1397: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1393: l_login_id NUMBER;
1394: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1395: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1396: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1397: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1398: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1399:
1400: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1401: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1398: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;

1394: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1395: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1396: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1397: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1398: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1399:
1400: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1401: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1402: TYPE var_30_tab_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 2687: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

2683:
2684: ELSE
2685: -- validate and populate tax_regime_id
2686: --
2687: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
2688: l_tax_regime_code_tab(i),
2689: l_tax_determine_date_tab(i),
2690: l_tax_regime_rec,
2691: x_return_status,

Line 2699: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');

2695: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2696: FND_LOG.STRING(g_level_unexpected,
2697: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2698: 'Incorrect return_status after calling ' ||
2699: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2700: FND_LOG.STRING(g_level_unexpected,
2701: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2702: 'RETURN_STATUS = ' || x_return_status);
2703: FND_LOG.STRING(g_level_unexpected,

Line 2714: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

2710: l_tax_regime_id_tab(i) := l_tax_regime_rec.tax_regime_id;
2711:
2712: -- validate and populate tax_id
2713: --
2714: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
2715: l_tax_regime_code_tab(i),
2716: l_tax_tab(i),
2717: l_tax_determine_date_tab(i),
2718: l_tax_rec,

Line 2727: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

2723: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2724: FND_LOG.STRING(g_level_unexpected,
2725: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2726: 'Incorrect return_status after calling ' ||
2727: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2728: FND_LOG.STRING(g_level_unexpected,
2729: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2730: 'RETURN_STATUS = ' || x_return_status);
2731: FND_LOG.STRING(g_level_unexpected,

Line 2741: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

2737:
2738: l_tax_id_tab(i) := l_tax_rec.tax_id;
2739:
2740: IF l_tax_jurisdiction_code_tab(i) IS NOT NULL THEN
2741: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
2742: l_tax_regime_code_tab(i),
2743: l_tax_tab(i),
2744: l_tax_jurisdiction_code_tab(i),
2745: l_tax_determine_date_tab(i),

Line 2755: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');

2751: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2752: FND_LOG.STRING(g_level_unexpected,
2753: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2754: 'Incorrect return_status after calling ' ||
2755: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2756: FND_LOG.STRING(g_level_unexpected,
2757: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2758: 'RETURN_STATUS = ' || x_return_status);
2759: FND_LOG.STRING(g_level_unexpected,

Line 2772: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

2768:
2769: l_tax_jur_id_tab(i) := NULL;
2770: END IF;
2771:
2772: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
2773: l_tax_tab(i),
2774: l_tax_regime_code_tab(i),
2775: l_tax_status_code_tab(i),
2776: l_tax_determine_date_tab(i),

Line 2786: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

2782: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2783: FND_LOG.STRING(g_level_unexpected,
2784: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2785: 'Incorrect return_status after calling ' ||
2786: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2787: FND_LOG.STRING(g_level_unexpected,
2788: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2789: 'RETURN_STATUS = ' || x_return_status);
2790: FND_LOG.STRING(g_level_unexpected,

Line 2801: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

2797: l_tax_status_id_tab(i) := l_tax_status_rec.tax_status_id;
2798:
2799: -- validate and populate tax_rate_id
2800: --
2801: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
2802: l_tax_regime_code_tab(i),
2803: l_tax_tab(i),
2804: l_tax_jurisdiction_code_tab(i),
2805: l_tax_status_code_tab(i),

Line 2818: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

2814: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2815: FND_LOG.STRING(g_level_unexpected,
2816: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2817: 'Incorrect return_status after calling ' ||
2818: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2819: FND_LOG.STRING(g_level_unexpected,
2820: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2821: 'RETURN_STATUS = ' || x_return_status);
2822: FND_LOG.STRING(g_level_unexpected,

Line 2889: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

2885:
2886: l_user_id NUMBER;
2887: l_login_id NUMBER;
2888: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2889: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2890: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2891: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2892: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2893:

Line 2890: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

2886: l_user_id NUMBER;
2887: l_login_id NUMBER;
2888: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2889: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2890: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2891: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2892: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2893:
2894: l_tax_class ZX_RATES_B.tax_class%TYPE;

Line 2891: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

2887: l_login_id NUMBER;
2888: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2889: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2890: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2891: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2892: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2893:
2894: l_tax_class ZX_RATES_B.tax_class%TYPE;
2895:

Line 2892: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;

2888: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2889: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2890: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2891: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2892: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2893:
2894: l_tax_class ZX_RATES_B.tax_class%TYPE;
2895:
2896: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 3985: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

3981: FOR i in 1 .. l_tax_line_id_tab.count LOOP
3982:
3983: -- validate and populate tax_regime_id
3984: --
3985: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
3986: l_tax_regime_code_tab(i),
3987: l_tax_determine_date_tab(i),
3988: l_tax_regime_rec,
3989: x_return_status,

Line 3997: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');

3993: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3994: FND_LOG.STRING(g_level_unexpected,
3995: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3996: 'Incorrect return_status after calling ' ||
3997: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3998: FND_LOG.STRING(g_level_unexpected,
3999: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4000: 'RETURN_STATUS = ' || x_return_status);
4001: FND_LOG.STRING(g_level_unexpected,

Line 4012: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

4008: l_tax_regime_id_tab(i) := l_tax_regime_rec.tax_regime_id;
4009:
4010: -- validate and populate tax_id
4011: --
4012: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
4013: l_tax_regime_code_tab(i),
4014: l_tax_tab(i),
4015: l_tax_determine_date_tab(i),
4016: l_tax_rec,

Line 4025: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

4021: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4022: FND_LOG.STRING(g_level_unexpected,
4023: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4024: 'Incorrect return_status after calling ' ||
4025: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
4026: FND_LOG.STRING(g_level_unexpected,
4027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4028: 'RETURN_STATUS = ' || x_return_status);
4029: FND_LOG.STRING(g_level_unexpected,

Line 4039: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

4035:
4036: l_tax_id_tab(i) := l_tax_rec.tax_id;
4037:
4038: IF l_tax_jurisdiction_code_tab(i) IS NOT NULL THEN
4039: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
4040: l_tax_regime_code_tab(i),
4041: l_tax_tab(i),
4042: l_tax_jurisdiction_code_tab(i),
4043: l_tax_determine_date_tab(i),

Line 4053: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');

4049: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4050: FND_LOG.STRING(g_level_unexpected,
4051: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4052: 'Incorrect return_status after calling ' ||
4053: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
4054: FND_LOG.STRING(g_level_unexpected,
4055: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4056: 'RETURN_STATUS = ' || x_return_status);
4057: FND_LOG.STRING(g_level_unexpected,

Line 4073: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

4069: END IF;
4070:
4071: -- validate and populate tax_status_id
4072: --
4073: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
4074: l_tax_tab(i),
4075: l_tax_regime_code_tab(i),
4076: l_tax_status_code_tab(i),
4077: l_tax_determine_date_tab(i),

Line 4087: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

4083: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4084: FND_LOG.STRING(g_level_unexpected,
4085: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4086: 'Incorrect return_status after calling ' ||
4087: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
4088: FND_LOG.STRING(g_level_unexpected,
4089: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4090: 'RETURN_STATUS = ' || x_return_status);
4091: FND_LOG.STRING(g_level_unexpected,

Line 4102: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

4098: l_tax_status_id_tab(i) := l_tax_status_rec.tax_status_id;
4099:
4100: -- validate and populate tax_rate_id
4101: --
4102: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
4103: l_tax_regime_code_tab(i),
4104: l_tax_tab(i),
4105: l_tax_jurisdiction_code_tab(i),
4106: l_tax_status_code_tab(i),

Line 4119: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

4115: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4116: FND_LOG.STRING(g_level_unexpected,
4117: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4118: 'Incorrect return_status after calling ' ||
4119: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
4120: FND_LOG.STRING(g_level_unexpected,
4121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4122: 'RETURN_STATUS = ' || x_return_status);
4123: FND_LOG.STRING(g_level_unexpected,