[Home] [Help]
PACKAGE: APPS.PAY_ELEMENT_TYPE_RULES_PKG
Source
1 PACKAGE PAY_ELEMENT_TYPE_RULES_PKG AUTHID CURRENT_USER as
2 /* $Header: pyetr01t.pkh 115.0 99/07/17 06:02:16 porting ship $ */
3 --
4 /*==========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +===========================================================================+
9 Name
10 pay_element_type_rules_pkg
11 Purpose
12 Supports the ETR block in the form PAYWSDRP (Define Element and
13 Distributuion Set.
14 Notes
15
16 History
17 24-Mar-94 J.S.Hobbs 40.0 Date created.
18 ============================================================================*/
19 --
20 -----------------------------------------------------------------------------
21 -- Name --
22 -- include_element --
23 -- Purpose --
24 -- Adds an element to a set NB. this may involve adding an include --
25 -- element rule or removing an exclude element rule. --
26 -- Arguments --
27 -- See below. --
28 -- Notes --
29 -- None. --
30 -----------------------------------------------------------------------------
31 --
32 procedure include_element
33 (
34 p_element_set_id number,
35 p_element_type_id number,
36 p_classification_id number,
37 p_element_set_type varchar2
38 );
39 --
40 -----------------------------------------------------------------------------
41 -- Name --
42 -- exclude_element --
43 -- Purpose --
44 -- Removes an element from a set NB. this may involve adding an exclude --
45 -- element rule or removing an include element rule. --
46 -- Arguments --
47 -- See below. --
48 -- Notes --
49 -- None. --
50 -----------------------------------------------------------------------------
51 --
52 procedure exclude_element
53 (
54 p_element_set_id number,
55 p_element_type_id number
56 );
57 --
58 -----------------------------------------------------------------------------
59 -- Name --
60 -- Insert_Row --
61 -- Purpose --
62 -- Table handler procedure that supports the insert of an element rule --
63 -- via the Define Element and Distributuion Set form. --
64 -- Arguments --
65 -- See below. --
66 -- Notes --
67 -- None. --
68 -----------------------------------------------------------------------------
69 --
70 PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
71 X_Element_Type_Id NUMBER,
72 X_Element_Set_Id NUMBER,
73 X_Include_Or_Exclude VARCHAR2,
74 X_Last_Update_Date DATE,
75 X_Last_Updated_By NUMBER,
76 X_Last_Update_Login NUMBER,
77 X_Created_By NUMBER,
78 X_Creation_Date DATE);
79 --
80 -----------------------------------------------------------------------------
81 -- Name --
82 -- Lock_Row --
83 -- Purpose --
84 -- Table handler procedure that supports the insert , update and delete --
85 -- of an element rule by applying a lock on an element rule within the --
86 -- Define Element and Distribution Set form. --
87 -- Arguments --
88 -- See below. --
89 -- None. --
90 -----------------------------------------------------------------------------
91 --
92 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
93 X_Element_Type_Id NUMBER,
94 X_Element_Set_Id NUMBER,
95 X_Include_Or_Exclude VARCHAR2);
96 --
97 -----------------------------------------------------------------------------
98 -- Name --
99 -- Update_Row --
100 -- Purpose --
101 -- Table handler procedure that supports the update of an element rule --
102 -- via the Define Element and Distributuion Set form. --
103 -- Arguments --
104 -- See below. --
105 -- Notes --
106 -- None. --
107 -----------------------------------------------------------------------------
108 --
109 PROCEDURE Update_Row(X_Rowid VARCHAR2,
110 X_Element_Type_Id NUMBER,
111 X_Element_Set_Id NUMBER,
112 X_Include_Or_Exclude VARCHAR2,
113 X_Last_Update_Date DATE,
114 X_Last_Updated_By NUMBER,
115 X_Last_Update_Login NUMBER);
116 --
117 -----------------------------------------------------------------------------
118 -- Name --
119 -- Delete_Row --
120 -- Purpose --
121 -- Table handler procedure that supports the delete of an element rule --
122 -- via the Define Element and Distributuion Set form. --
123 -- Arguments --
124 -- See below. --
125 -- Notes --
126 -- None. --
127 -----------------------------------------------------------------------------
128 --
129 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
130 --
131 END PAY_ELEMENT_TYPE_RULES_PKG;