PACKAGE: APPS.PQH_GSP_GRD_STEP_REMOVE

Source

1 Package Pqh_Gsp_Grd_Step_Remove AUTHID CURRENT_USER As
2 /* $Header: pqgspsde.pkh 115.2 2004/04/23 09:48 ggnanagu noship $ */
3 
4 Function get_ovn(p_copy_entity_result_id In Number)
5     Return Number;
6 Function get_dml_operation (p_copy_entity_result_id In Number)
7     Return Varchar;
8 
9 
10 -- To Remove Pay Scale
11 Procedure purge_pay_scale(p_opt_result_id In Number,
12                           p_effective_date IN Date,
13                           p_Copy_Entity_txn_Id 	 In Number );
14 
15 -- Purge Grade Step Standard Rates and Criteria Rates
16 Procedure purge_opt_abr_hrrate_crrate
17 ( p_Opt_Result_Id                In Number,
18   p_Copy_Entity_txn_Id 		   In Number,
19   p_Effective_Date		  In Date
20  );
21 
22 
23 Procedure remove_elig_profile
24 (p_Copy_Entity_txn_Id 		  In Number,
25  p_Copy_Entity_Result_Id        In Number
26  );
27 
28 -- To Remove OPT Rec
29 Procedure remove_opt
30 (p_Copy_Entity_txn_Id 		  In Number,
31  p_Copy_Entity_Result_Id        In Number,
32  p_Effective_Date		        In Date
33  );
34 
35 Procedure remove_oipl_STEP_flavour
36 (p_Copy_Entity_txn_Id 		  In Number,
37  p_Copy_Entity_Result_Id        In Number,
38  p_Effective_Date		        In Date,
39 p_remove_opt           IN VARCHAR2 default 'Y'
40  );
41 
42 Procedure remove_oipl_POINT_flavour
43 (p_Copy_Entity_txn_Id 		  In Number,
44  p_Copy_Entity_Result_Id        In Number,
45  p_Effective_Date		        In Date
46  );
47 
48 Procedure remove_oipl
49 (p_Copy_Entity_txn_Id 		  In Number,
50  p_Copy_Entity_Result_Id        In Number,
51  p_Effective_Date		        In Date,
52 p_remove_opt           IN VARCHAR2 default 'Y'
53  );
54 
55 
56 Procedure remove_plip
57 (p_Copy_Entity_txn_Id 		  In Number,
58  p_Copy_Entity_Result_Id        In Number,
59  p_Effective_Date		        In Date
60  );
61 
62 -- Unlink Grade Step Standard Rates and Criteria Rates
63 Procedure unlink_opt_abr_hrrate_crrate
64 ( p_Opt_Result_Id                In Number,
65   p_Copy_Entity_txn_Id 		   In Number,
66   p_Effective_Date		  In Date
67  );
68 
69 End Pqh_Gsp_Grd_Step_Remove ;