1 PACKAGE PQH_RBC_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: pqrbcval.pkh 120.1 2006/03/02 03:32 srenukun noship $ */
3
4 --checks if matrix has atleast one criteira added
5 function matrix_has_criteria(p_copy_entity_txn_id in number) return varchar2;
6 --checks if matrix has atleast one criteira values added
7 function matrix_has_criteria_values(p_copy_entity_txn_id in number) return varchar2;
8 --checks if matrix has atleast one criteira nodes added
9 function matrix_has_criteria_nodes(p_copy_entity_txn_id in number) return varchar2;
10 --checks if matrix has atleast one rate type added
11 function matrix_has_rate_type(p_copy_entity_txn_id in number) return varchar2;
12 --checks if matrix has duplicate criteria added
13 function matrix_has_criteria_dup(p_copy_entity_txn_id in number) return varchar2;
14 --checks if matrix has used plan name already existing
15 function plan_name_exists(l_pl_id in number,p_name in varchar2, p_business_group_id in number) return varchar2;
16 --checks if matrix has used plan short code already existing
17 function plan_short_code_exists(l_pl_id in number,p_short_code in varchar2, p_business_group_id in number) return varchar2;
18 --checks if matrix has used plan short name already existing
19 function plan_short_name_exists(l_pl_id in number,p_short_name in varchar2, p_business_group_id in number) return varchar2;
20 --checks if matrix has rates
21 function matrix_has_rates(p_copy_entity_txn_id in number) return varchar2;
22
23 --checks if matrix has used plan already existing
24 -- it in turn calls plan_short_code_exists,plan_name_exists,plan_short_name_exists
25 function check_plan_duplicate(p_copy_entity_txn_id in number)return varchar2;
26 -- checks if rate type is added twice
27 function matrix_has_ratetype_dup(p_copy_entity_txn_id in number) return varchar2;
28
29 -- checks if we have any criteria values added twice
30 -- it takes help of check_critval_dup_in_rmn,check_critval_row to make it more modular
31 function check_critval_dup_in_txn(p_copy_entity_txn_id number) return varchar2;
32 function check_critval_dup_in_rmn(p_copy_entity_result_id_node number,p_copy_entity_result_id_val number) return varchar2;
33 function check_critval_row (p_copy_entity_result_id_row1 number
34 ,p_copy_entity_result_id_row2 number
35 ) return varchar2 ;
36
37 -- MAIN FUCTION TO BE CALLED
38 procedure check_warnings(p_copy_entity_txn_id in number,p_status out nocopy varchar2,p_warning_message out nocopy varchar2);
39 --validation before submit to be called
40 procedure pre_validate_matrix(p_copy_entity_txn_id in number,p_status out nocopy varchar2);
41 -- validations on submit button called
42 procedure on_validate_matrix(p_copy_entity_txn_id in number,p_status out nocopy varchar2);
43 -- all validations on before and on submit
44 procedure validate_matrix(p_copy_entity_txn_id in number,p_status out nocopy varchar2);
45
46
47 end PQH_RBC_VALIDATE;
[Home] [Help]