[Home] [Help]
PACKAGE: APPS.PAY_SUB_CLASS_RULES_PKG
Source
1 package PAY_SUB_CLASS_RULES_PKG AUTHID CURRENT_USER as
2 /* $Header: pysbr.pkh 115.1 2003/06/27 12:17:25 scchakra ship $ */
3 --------------------------------------------------------------------------------
4 --Start of auto-generated code
5 --------------------------------------------------------------------------------
6 PROCEDURE Insert_Row(
7
8 p_Rowid IN OUT NOCOPY VARCHAR2,
9 p_Sub_Classification_Rule_Id IN OUT NOCOPY NUMBER,
10 p_Effective_Start_Date DATE,
11 p_Effective_End_Date DATE,
12 p_Element_Type_Id NUMBER,
13 p_Classification_Id NUMBER,
14 p_Business_Group_Id NUMBER,
15 p_Legislation_Code VARCHAR2,
16 p_Last_Update_Date DATE,
17 p_Last_Updated_By NUMBER,
18 p_Last_Update_Login NUMBER,
19 p_Created_By NUMBER,
20 p_Creation_Date DATE);
21
22 --------------------------------------------------------------------------------
23 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
24 p_Sub_Classification_Rule_Id NUMBER,
25 p_Effective_Start_Date DATE,
26 p_Effective_End_Date DATE,
27 p_Element_Type_Id NUMBER,
28 p_Classification_Id NUMBER,
29 p_Business_Group_Id NUMBER,
30 p_Legislation_Code VARCHAR2);
31
32 --------------------------------------------------------------------------------
33 PROCEDURE Update_Row(p_Rowid VARCHAR2,
34 p_Sub_Classification_Rule_Id NUMBER,
35 p_Effective_Start_Date DATE,
36 p_Effective_End_Date DATE,
37 p_Element_Type_Id NUMBER,
38 p_Classification_Id NUMBER,
39 p_Business_Group_Id NUMBER,
40 p_Legislation_Code VARCHAR2,
41 p_Last_Update_Date DATE,
42 p_Last_Updated_By NUMBER,
43 p_Last_Update_Login NUMBER);
44 --------------------------------------------------------------------------------
45 -- End of auto-generated code
46 --------------------------------------------------------------------------------
47 function next_rule_id return number;
48 --------------------------------------------------------------------------------
49 procedure INSERT_DEFAULTS (
50 --
51 p_element_type_id number,
52 p_classification_id number,
53 p_effective_start_date date,
54 p_effective_end_date date,
55 p_business_group_id number,
56 p_legislation_code varchar2 );
57 --------------------------------------------------------------------------------
58 procedure DELETE_ROW (
59 --
60 p_rowid varchar2,
61 p_sub_classification_rule_id number,
62 p_delete_mode varchar2,
63 p_validation_start_date date,
64 p_validation_end_date date );
65 --------------------------------------------------------------------------------
66 procedure PARENT_DELETED (
67 --
68 p_parent_id number,
69 p_session_date date default trunc (sysdate),
70 p_validation_start_date date,
71 p_validation_end_date date,
72 p_delete_mode varchar2 default 'DELETE',
73 p_parent_name varchar2 default 'PAY_ELEMENT_TYPES_F');
74 --------------------------------------------------------------------------------
75 function MAX_ALLOWABLE_END_DATE (
76 --
77 p_element_type_id number,
78 p_classification_id number,
79 p_session_date date,
80 p_error_if_true boolean default FALSE )
81 --
82 return date;
83 --------------------------------------------------------------------------------
84 end PAY_SUB_CLASS_RULES_PKG;