1 Package Pqh_Gsp_PrgRules AUTHID CURRENT_USER As
2 /* $Header: pqgspelg.pkh 120.5.12000000.2 2007/06/11 10:17:43 sidsaxen noship $ */
3 Function Get_Ref_Level
4 (P_Parent_Cer_Id IN Number,
5 P_prfl_Id IN Number)
6 Return Varchar2;
7
8 Procedure Create_Eligibility_Profile
9 (p_Copy_Entity_txn_Id In Number,
10 P_gs_Parent_Entity_Result_Id In Number,
11 P_Effective_Date In Date,
12 P_Prfl_Id In Number,
13 P_Name In Varchar2,
14 P_Txn_Type In Varchar2,
15 p_Txn_Mode In Varchar2,
16 P_Business_Group_Id In Number,
17 P_Req_opt In Varchar2,
18 P_Ref_level In Varchar2,
19 P_Compute_Score_Flag In Varchar2);
20
21 Procedure Delete_Eligibility
22 (P_Copy_Entity_txn_id IN Number
23 ,P_Copy_Entity_result_id IN NUmber);
24
25 procedure pull_elpro_to_stage
26 (
27 p_copy_entity_txn_id in number,
28 p_eligy_prfl_id in number,
29 p_effective_date in date,
30 p_business_group_id in number
31 );
32 procedure update_crit_records_in_staging(p_copy_entity_txn_id in number);
33 --<-------- procedure prepare_elp_recs4pdw -------->
34 -- purpose - To prepare ELP record for pdw
35 -- accept - cet_id
36 -- do - nullifys all info1 columns of ELP and its child records
37 -- return -
38 --<------------------------------------------------>
39 procedure prepare_elp_recs4pdw (
40 p_copy_entity_txn_id number
41 ,p_business_group_id number
42 );
43
44 procedure nullify_elp_rec (
45 p_copy_entity_result_id number
46 ,p_copy_entity_txn_id number
47 );
48
49 --<-------- function create_duplicate_elp_tree -------->
50 -- purpose - To create duplicate hierarchy of an existing ELPRO in staging area
51 -- accept - a elig pro id
52 -- do - will create a duplicate hierarchy for this elpro
53 -- it will copy paste this elpro and its child and grand children
54 -- return - return cerid of the newly created duplicate elpro record
55 --<----------------------------------------------------->
56 function create_duplicate_elp_tree (
57 p_copy_entity_txn_id number
58 ,p_business_group_id number
59 ,p_eligy_prfl_id number
60 )
61 return number ;
62
63
64 --<-------- procedure purge_elp_tree -------->
65 -- purpose - To purge all duplicate records in the ELP tree created for pdw
66 -- accept - cet_id
67 -- do
68 -- if p_eligy_prfl_id and p_copy_entity_results_id is null then
69 -- this will delete all duplicate elp hierarchy records of all ELPs
70
71 -- if elpro is not null and cer id is null then
72 -- it will delete all duplicate elp hierarchy records of this ELP
73
74 -- if cer id is not null then
75 -- it will delete the hierarchy records of this single duplicate ELP
76 --<------------------------------------------>
77 procedure purge_duplicate_elp_tree (
78 p_copy_entity_txn_id number
79 ,p_eligy_prfl_id number default null
80 ,p_copy_entity_result_id number default null
81 );
82
83 --<-------- procedure sync_elp_records -------->
84 -- purpose -
85 -- accept -
86 -- do -
87 -- return -
88 --<-------------------------------------------->
89 procedure sync_elp_records (
90 p_copy_entity_txn_id number
91 ,p_business_group_id number
92 ,p_eligy_prfl_id number
93 );
94
95 procedure upd_alias_of_dup
96 (p_copy_entity_txn_id in number,
97 p_business_group_id in number
98 );
99
100 procedure reset_alias_of_dup
101 (p_copy_entity_txn_id in number,
102 p_business_group_id in number
103 );
104
105 procedure prepare_drv_fctr4pdw (
106 p_copy_entity_txn_id number,
107 p_business_group_id in number
108 );
109
110 End Pqh_Gsp_PrgRules;