[Home] [Help]
190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
194: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
195: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
196: RETURN BOOLEAN;
197:
198: PROCEDURE evaluate_condition(
205: p_return_status OUT NOCOPY VARCHAR2,
206: p_error_buffer OUT NOCOPY VARCHAR2);
207:
208: PROCEDURE check_condition_group_result(
209: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
210: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
211: p_trx_line_index IN BINARY_INTEGER,
212: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
213: p_template_evaluated OUT NOCOPY BOOLEAN,
213: p_template_evaluated OUT NOCOPY BOOLEAN,
214: p_result OUT NOCOPY BOOLEAN);
215:
216: PROCEDURE insert_condition_group_result(
217: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
218: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
219: p_result IN BOOLEAN,
220: p_trx_line_index IN BINARY_INTEGER,
221: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
284: PROCEDURE proc_condition_group_per_templ(
285: p_structure_name IN VARCHAR2,
286: p_structure_index IN BINARY_INTEGER,
287: p_det_factor_templ_code IN
288: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
289: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
290: p_tax IN ZX_TAXES_B.TAX%TYPE,
291: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
292: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
370:
371: -- Bug 4166241 : Added new private procedure to process only those templates
372: -- whose determining factors are supported by the product
373: PROCEDURE check_templ_tax_parameter(
374: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
375: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
376: p_valid OUT NOCOPY BOOLEAN,
377: p_return_status OUT NOCOPY VARCHAR2,
378: p_error_buffer OUT NOCOPY VARCHAR2);
2075: p_return_status OUT NOCOPY VARCHAR2,
2076: p_error_buffer OUT NOCOPY VARCHAR2)
2077: IS
2078: l_count NUMBER;
2079: l_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE;
2080: l_result BOOLEAN;
2081: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
2082: l_valid BOOLEAN;
2083:
2250: PROCEDURE proc_condition_group_per_templ(
2251: p_structure_name IN VARCHAR2,
2252: p_structure_index IN BINARY_INTEGER,
2253: p_det_factor_templ_code IN
2254: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
2255: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2256: p_tax IN ZX_TAXES_B.TAX%TYPE,
2257: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2258: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2395: -- cursor for condition groups
2396: --
2397:
2398: CURSOR get_condition_group_codes_csr
2399: (c_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
2400: c_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE,
2401: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
2402: IS
2403: SELECT s.CONDITION_GROUP_ID, s.CONDITION_GROUP_CODE, More_Than_Max_Cond_Flag,
7027: -- Helen Si 5-OCT-01 Created
7028: --
7029: PROCEDURE check_condition_group_result(
7030: p_det_factor_templ_code IN
7031: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7032: p_condition_group_code IN
7033: ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
7034: p_trx_line_index IN BINARY_INTEGER,
7035: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7133: -- Helen / Rajeev 1-OCT-01 Created
7134: --
7135: --
7136: PROCEDURE insert_condition_group_result(
7137: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7138: p_condition_group_code IN ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
7139: p_result IN BOOLEAN,
7140: p_trx_line_index IN BINARY_INTEGER,
7141: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
7201: --
7202: --
7203:
7204: PROCEDURE check_templ_tax_parameter(
7205: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7206: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7207: p_valid OUT NOCOPY BOOLEAN,
7208: p_return_status OUT NOCOPY VARCHAR2,
7209: p_error_buffer OUT NOCOPY VARCHAR2)
7222: -- determining factor in any condition sets defined under this DF
7223: -- template. If it is 'Y', this DF template needs to be processed.
7224: --
7225: CURSOR chk_taxevnt_parameter_code_csr
7226: (c_det_factor_templ_cd ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7227: c_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%TYPE)
7228: IS
7229: SELECT param.tax_parameter_code
7230: FROM zx_det_factor_templ_dtl dtl,
7227: c_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%TYPE)
7228: IS
7229: SELECT param.tax_parameter_code
7230: FROM zx_det_factor_templ_dtl dtl,
7231: zx_det_factor_templ_b templ,
7232: zx_event_class_params param
7233: WHERE templ.det_factor_templ_code = c_det_factor_templ_cd
7234: AND dtl.det_factor_templ_id = templ.det_factor_templ_id
7235: AND param.event_class_mapping_id = c_event_class_mapping_id
7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
7562: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7563: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
7564: RETURN BOOLEAN IS
7565: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
7566: -- Start : Added for Bug#7412888 by ssohal