[Home] [Help]
PACKAGE: APPS.PAY_STATUS_RULES_PKG
Source
1 package PAY_STATUS_RULES_PKG AUTHID CURRENT_USER as
2 /* $Header: pyspr.pkh 120.0.12020000.1 2012/06/28 19:09:18 appldev ship $ */
3 --
4 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5 X_Status_Processing_Rule_Id IN OUT NOCOPY NUMBER,
6 X_Effective_Start_Date DATE,
7 X_Effective_End_Date DATE,
8 X_Business_Group_Id NUMBER,
9 X_Legislation_Code VARCHAR2,
10 X_Element_Type_Id NUMBER,
11 X_Assignment_Status_Type_Id NUMBER,
12 X_Formula_Id NUMBER,
13 X_Processing_Rule VARCHAR2,
14 X_Comment_Id NUMBER,
15 X_Legislation_Subgroup VARCHAR2,
16 X_Last_Update_Date DATE,
17 X_Last_Updated_By NUMBER,
18 X_Last_Update_Login NUMBER,
19 X_Created_By NUMBER,
20 X_Creation_Date DATE);
21
22 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
23 X_Status_Processing_Rule_Id NUMBER,
24 X_Effective_Start_Date DATE,
25 X_Effective_End_Date DATE,
26 X_Business_Group_Id NUMBER,
27 X_Legislation_Code VARCHAR2,
28 X_Element_Type_Id NUMBER,
29 X_Assignment_Status_Type_Id NUMBER,
30 X_Formula_Id NUMBER,
31 X_Processing_Rule VARCHAR2,
32 X_Comment_Id NUMBER,
33 X_Legislation_Subgroup VARCHAR2);
34
35 PROCEDURE Update_Row(X_Rowid VARCHAR2,
36 X_Status_Processing_Rule_Id NUMBER,
37 X_Effective_Start_Date DATE,
38 X_Effective_End_Date DATE,
39 X_Business_Group_Id NUMBER,
40 X_Legislation_Code VARCHAR2,
41 X_Element_Type_Id NUMBER,
42 X_Assignment_Status_Type_Id NUMBER,
43 X_Formula_Id NUMBER,
44 X_Processing_Rule VARCHAR2,
45 X_Comment_Id NUMBER,
46 X_Legislation_Subgroup VARCHAR2,
47 X_Last_Update_Date DATE,
48 X_Last_Updated_By NUMBER,
49 X_Last_Update_Login NUMBER);
50
51 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
52 p_session_date date,
53 p_delete_mode varchar2,
54 p_status_processing_rule_id number);
55
56 --------------------------------------------------------------------------------
57 procedure PARENT_DELETED (
58 --
59 --******************************************************************************
60 --* Handles the case when any row referenced by a foreign key of the base *
61 --* is deleted (in whatever Date Track mode). ie If a parent record is zapped *
62 --* then the deletion is cascaded; if it is date-effectively deleted, then the *
63 --* rows referencing it are updated to have the same end-date. *
64 --******************************************************************************
65 --
66 -- Parameters to be passed in are:
67 --
68 -- The value of the foreign key for the deleted parent
69 p_element_type_id number,
70 --
71 -- The date of date-effective deletion
72 p_session_date date default trunc (sysdate),
73 --
74 -- The type of deletion action being performed
75 p_delete_mode varchar2 default 'DELETE' );
76 --------------------------------------------------------------------------------
77 function DATE_EFFECTIVELY_UPDATED (p_status_processing_rule_id number,
78 p_rowid varchar2) return boolean;
79 --------------------------------------------------------------------------------
80 function SPR_END_DATE (p_status_processing_rule_id number,
81 p_formula_id number) return date;
82 --------------------------------------------------------------------------------
83 function NO_INPUT_VALUES_MATCH_FORMULA (p_element_type_id number,
84 p_formula_id number)
85 return boolean;
86 --------------------------------------------------------------------------------
87 function RESULT_RULES_EXIST (p_status_processing_rule_id number,
88 p_start_date date,
89 p_end_date date) return boolean;
90 --------------------------------------------------------------------------------
91 function STATUS_RULE_END_DATE (p_status_processing_rule_id number,
92 p_element_type_id number,
93 p_formula_id number,
94 p_assignment_status_type_id number,
95 p_processing_rule varchar2,
96 p_session_date date,
97 p_max_element_end_date date,
98 p_validation_start_date date,
99 p_business_group_id number,
100 p_legislation_code varchar2) return date;
101 --------------------------------------------------------------------------------
102 end PAY_STATUS_RULES_PKG;