[Home] [Help]
192: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
193: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
194: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
195: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
196: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
197: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
198: RETURN BOOLEAN;
199:
200: PROCEDURE evaluate_condition(
207: p_return_status OUT NOCOPY VARCHAR2,
208: p_error_buffer OUT NOCOPY VARCHAR2);
209:
210: PROCEDURE check_condition_group_result(
211: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
212: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
213: p_trx_line_index IN BINARY_INTEGER,
214: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
215: p_template_evaluated OUT NOCOPY BOOLEAN,
215: p_template_evaluated OUT NOCOPY BOOLEAN,
216: p_result OUT NOCOPY BOOLEAN);
217:
218: PROCEDURE insert_condition_group_result(
219: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
220: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
221: p_result IN BOOLEAN,
222: p_trx_line_index IN BINARY_INTEGER,
223: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
275: PROCEDURE proc_condition_group_per_templ(
276: p_structure_name IN VARCHAR2,
277: p_structure_index IN BINARY_INTEGER,
278: p_det_factor_templ_code IN
279: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
280: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
281: p_tax IN ZX_TAXES_B.TAX%TYPE,
282: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
283: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
361:
362: -- Bug 4166241 : Added new private procedure to process only those templates
363: -- whose determining factors are supported by the product
364: PROCEDURE check_templ_tax_parameter(
365: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
366: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
367: p_valid OUT NOCOPY BOOLEAN,
368: p_return_status OUT NOCOPY VARCHAR2,
369: p_error_buffer OUT NOCOPY VARCHAR2);
2410: p_return_status OUT NOCOPY VARCHAR2,
2411: p_error_buffer OUT NOCOPY VARCHAR2)
2412: IS
2413: l_count NUMBER;
2414: l_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE;
2415: l_result BOOLEAN;
2416: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
2417: l_valid BOOLEAN;
2418:
2585: PROCEDURE proc_condition_group_per_templ(
2586: p_structure_name IN VARCHAR2,
2587: p_structure_index IN BINARY_INTEGER,
2588: p_det_factor_templ_code IN
2589: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
2590: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2591: p_tax IN ZX_TAXES_B.TAX%TYPE,
2592: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2593: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2733: -- cursor for condition groups
2734: --
2735:
2736: CURSOR get_condition_group_codes_csr
2737: (c_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
2738: c_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE,
2739: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
2740: IS
2741: SELECT /*+ leading(P) use_nl_with_index(s ZX_CONDITION_GROUPS_B_U1) */
7563: -- Helen Si 5-OCT-01 Created
7564: --
7565: PROCEDURE check_condition_group_result(
7566: p_det_factor_templ_code IN
7567: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7568: p_condition_group_code IN
7569: ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
7570: p_trx_line_index IN BINARY_INTEGER,
7571: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7666: -- Helen / Rajeev 1-OCT-01 Created
7667: --
7668: --
7669: PROCEDURE insert_condition_group_result(
7670: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7671: p_condition_group_code IN ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
7672: p_result IN BOOLEAN,
7673: p_trx_line_index IN BINARY_INTEGER,
7674: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
7733: --
7734: --
7735:
7736: PROCEDURE check_templ_tax_parameter(
7737: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7738: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7739: p_valid OUT NOCOPY BOOLEAN,
7740: p_return_status OUT NOCOPY VARCHAR2,
7741: p_error_buffer OUT NOCOPY VARCHAR2)
7754: -- determining factor in any condition sets defined under this DF
7755: -- template. If it is 'Y', this DF template needs to be processed.
7756: --
7757: CURSOR chk_taxevnt_parameter_code_csr
7758: (c_det_factor_templ_cd ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7759: c_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%TYPE)
7760: IS
7761: SELECT param.tax_parameter_code
7762: FROM zx_det_factor_templ_dtl dtl,
7759: c_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%TYPE)
7760: IS
7761: SELECT param.tax_parameter_code
7762: FROM zx_det_factor_templ_dtl dtl,
7763: zx_det_factor_templ_b templ,
7764: zx_event_class_params param
7765: WHERE templ.det_factor_templ_code = c_det_factor_templ_cd
7766: AND dtl.det_factor_templ_id = templ.det_factor_templ_id
7767: AND param.event_class_mapping_id = c_event_class_mapping_id
8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
8091: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
8092: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
8093: RETURN BOOLEAN IS
8094: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
8095: