[Home] [Help]
PACKAGE: APPS.PAY_ACCRUAL_PLANS_PKG
Source
1 PACKAGE PAY_ACCRUAL_PLANS_PKG AUTHID CURRENT_USER as
2 /* $Header: pyappap.pkh 115.0 99/07/17 05:42:24 porting ship $ */
3 --
4 PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
5 X_Accrual_Plan_Id IN OUT NUMBER,
6 X_Business_Group_Id NUMBER,
7 X_Accrual_Plan_Element_Type_Id NUMBER,
8 X_Pto_Input_Value_Id NUMBER,
9 X_Co_Input_Value_Id NUMBER,
10 X_Residual_Input_Value_Id NUMBER,
11 X_Accrual_Category VARCHAR2,
12 X_Accrual_Plan_Name VARCHAR2,
13 X_Accrual_Start VARCHAR2,
14 X_Accrual_Units_Of_Measure VARCHAR2,
15 X_Ineligible_Period_Length NUMBER,
16 X_Ineligible_Period_Type VARCHAR2
17 );
18 --
19 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
20 X_Accrual_Plan_Id NUMBER,
21 X_Business_Group_Id NUMBER,
22 X_Accrual_Plan_Element_Type_Id NUMBER,
23 X_Pto_Input_Value_Id NUMBER,
24 X_Co_Input_Value_Id NUMBER,
25 X_Residual_Input_Value_Id NUMBER,
26 X_Accrual_Category VARCHAR2,
27 X_Accrual_Plan_Name VARCHAR2,
28 X_Accrual_Start VARCHAR2,
29 X_Accrual_Units_Of_Measure VARCHAR2,
30 X_Ineligible_Period_Length NUMBER,
31 X_Ineligible_Period_Type VARCHAR2
32 );
33 --
34 PROCEDURE Update_Row(X_Rowid VARCHAR2,
35 X_Accrual_Plan_Id NUMBER,
36 X_Business_Group_Id NUMBER,
37 X_Accrual_Plan_Element_Type_Id NUMBER,
38 X_Pto_Input_Value_Id NUMBER,
39 X_Co_Input_Value_Id NUMBER,
40 X_Residual_Input_Value_Id NUMBER,
41 X_Accrual_Category VARCHAR2,
42 X_Accrual_Plan_Name VARCHAR2,
43 X_Accrual_Start VARCHAR2,
44 X_Accrual_Units_Of_Measure VARCHAR2,
45 X_Ineligible_Period_Length NUMBER,
46 X_Ineligible_Period_Type VARCHAR2
47 );
48 --
49 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
50 --
51 PROCEDURE chk_plan_name(p_plan_name IN varchar2,
52 p_accrual_plan_id IN number);
53 --
54 PROCEDURE insert_validation(p_plan_name IN varchar2,
55 p_accrual_plan_id IN number);
56 --
57 FUNCTION create_element(
58 p_element_name IN varchar2,
59 p_element_description IN varchar2,
60 p_processing_type IN varchar2,
61 p_bg_name IN varchar2,
62 p_classification_name IN varchar2,
63 p_legislation_code IN varchar2,
64 p_currency_code IN varchar2,
65 p_post_termination_rule IN varchar2)
66 RETURN number;
67 --
68 FUNCTION create_input_value(
69 p_element_name IN varchar2,
70 p_input_value_name IN varchar2,
71 p_uom_code IN varchar2,
72 p_bg_name IN varchar2,
73 p_element_type_id IN number,
74 p_primary_classification_id IN number,
75 p_business_group_id IN number,
76 p_recurring_flag IN varchar2,
77 p_legislation_code IN varchar2,
78 p_classification_type IN varchar2)
79 RETURN number;
80 --
81 PROCEDURE pre_insert_actions(
82 p_plan_name IN varchar2,
83 p_bg_name IN varchar2,
84 p_plan_uom IN varchar2,
85 p_business_group_id IN number,
86 p_accrual_plan_element_type_id OUT number,
87 p_co_input_value_id OUT number,
88 p_co_element_type_id OUT number,
89 p_residual_input_value_id OUT number,
90 p_residual_element_type_id OUT number);
91 --
92 PROCEDURE post_insert_actions(
93 p_accrual_plan_id IN number,
94 p_business_group_id IN number,
95 p_pto_input_value_id IN number,
96 p_co_input_value_id IN number);
97 --
98 PROCEDURE update_validation(p_plan_name IN varchar2,
99 p_old_plan_name IN varchar2,
100 p_accrual_plan_id IN number);
101 --
102 PROCEDURE post_update_actions(
103 p_accrual_plan_id IN number,
104 p_business_group_id IN number,
105 p_pto_input_value_id IN number,
106 p_old_pto_input_value_id IN number);
107 --
108 PROCEDURE pre_delete_actions(p_accrual_plan_id IN number,
109 p_accrual_plan_element_type_id IN number,
110 p_co_element_type_id IN number,
111 p_residual_element_type_id IN number,
112 p_session_date IN date);
113 END PAY_ACCRUAL_PLANS_PKG;