[Home] [Help]
PACKAGE: APPS.PAY_FORMULA_RESULT_RULES_PKG
Source
1 package PAY_FORMULA_RESULT_RULES_PKG AUTHID CURRENT_USER as
2 /* $Header: pyfrr.pkh 115.2 2002/12/10 18:44:49 dsaxby ship $ */
3 -------------------------------------------------------------------------------
4 --------------------------------------------------------------------------------
5 function TARGET_PAY_VALUE ( p_element_type_id number,
6 p_result_data_type varchar2) return number;
7 --------------------------------------------------------------------------------
8 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
9 p_Formula_Result_Rule_Id IN OUT NOCOPY NUMBER,
10 p_Effective_Start_Date DATE,
11 p_Effective_End_Date DATE,
12 p_Business_Group_Id NUMBER,
13 p_Legislation_Code VARCHAR2,
14 p_Element_Type_Id NUMBER,
15 p_Status_Processing_Rule_Id NUMBER,
16 p_Result_Name VARCHAR2,
17 p_Result_Rule_Type VARCHAR2,
18 p_Legislation_Subgroup VARCHAR2,
19 p_Severity_Level VARCHAR2,
20 p_Input_Value_Id NUMBER,
21 p_Created_By NUMBER,
22 p_session_date DATE
23 );
24
25 --------------------------------------------------------------------------------
26 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
27 p_Formula_Result_Rule_Id NUMBER,
28 p_Effective_Start_Date DATE,
29 p_Effective_End_Date DATE,
30 p_Business_Group_Id NUMBER,
31 p_Legislation_Code VARCHAR2,
32 p_Element_Type_Id NUMBER,
33 p_Status_Processing_Rule_Id NUMBER,
34 p_Result_Name VARCHAR2,
35 p_Result_Rule_Type VARCHAR2,
36 p_Legislation_Subgroup VARCHAR2,
37 p_Severity_Level VARCHAR2,
38 p_Input_Value_Id NUMBER);
39
40 --------------------------------------------------------------------------------
41 PROCEDURE Update_Row(p_Rowid VARCHAR2,
42 p_Formula_Result_Rule_Id NUMBER,
43 p_Effective_Start_Date DATE,
44 p_Effective_End_Date DATE,
45 p_Business_Group_Id NUMBER,
46 p_Legislation_Code VARCHAR2,
47 p_Element_Type_Id NUMBER,
48 p_Status_Processing_Rule_Id NUMBER,
49 p_Result_Name VARCHAR2,
50 p_Result_Rule_Type VARCHAR2,
51 p_Legislation_Subgroup VARCHAR2,
52 p_Severity_Level VARCHAR2,
53 p_Input_Value_Id NUMBER,
54 p_Last_Update_Date DATE,
55 p_Last_Updated_By NUMBER,
56 p_Last_Update_Login NUMBER);
57
58 --------------------------------------------------------------------------------
59 PROCEDURE Delete_Row(p_Rowid VARCHAR2);
60
61
62 --------------------------------------------------------------------------------
63 procedure PARENT_DELETED (
64 p_parent_name varchar2,
65 p_parent_id number,
66 p_session_date date,
67 p_delete_mode varchar2
68 );
69 --------------------------------------------------------------------------------
70 FUNCTION result_rule_end_date(p_formula_result_rule_id number,
71 p_result_rule_type varchar2,
72 p_result_name varchar2,
73 p_status_processing_rule_id number,
74 p_element_type_id number,
75 p_input_value_id number,
76 p_session_date date,
77 p_max_spr_end_date date) return date;
78 --------------------------------------------------------------------------------
79 FUNCTION formula_results_changed(p_formula_id number,
80 p_result_name varchar2,
81 p_result_rule_type varchar2,
82 p_effective_start_date date,
83 p_effective_end_date date) return boolean;
84 --------------------------------------------------------------------------------
85 end PAY_FORMULA_RESULT_RULES_PKG;