1 PACKAGE PAY_CALENDARS_PKG as
2 /* $Header: pycal01t.pkh 120.1 2005/10/05 21:58:44 saurgupt noship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9 Name
10 pay_calendars_pkg
11 Purpose
12 Table Handler for the block CAL in the Define Budgetary Calendar form.
13 Notes
14 Used by the PAYWSDCL (Define Budgetary Calendar) form.
15 History
16 11-Mar-94 J.S.Hobbs 40.0 Date created.
17 02-Feb-95 J.S.Hobbs 40.4 Removed aol WHO columns.
18 ============================================================================*/
19 --
20 -----------------------------------------------------------------------------
21 -- Name --
22 -- Insert_Row --
23 -- Purpose --
24 -- Table handler procedure that supports the insert of a calendar via the--
25 -- Define Budgetary Calendar form. --
26 -- Arguments --
27 -- See below. --
28 -- Notes --
29 -- --
30 -----------------------------------------------------------------------------
31 --
32 PROCEDURE Insert_Row(X_Rowid IN OUT nocopy VARCHAR2,
33 X_Period_Set_Name VARCHAR2,
34 X_Actual_Period_Type VARCHAR2,
35 X_Proc_Period_Type VARCHAR2,
36 X_Start_Date DATE,
37 X_Comments VARCHAR2,
38 X_Attribute_Category VARCHAR2,
39 X_Attribute1 VARCHAR2,
40 X_Attribute2 VARCHAR2,
41 X_Attribute3 VARCHAR2,
42 X_Attribute4 VARCHAR2,
43 X_Attribute5 VARCHAR2,
44 X_Attribute6 VARCHAR2,
45 X_Attribute7 VARCHAR2,
46 X_Attribute8 VARCHAR2,
47 X_Attribute9 VARCHAR2,
48 X_Attribute10 VARCHAR2,
49 X_Attribute11 VARCHAR2,
50 X_Attribute12 VARCHAR2,
51 X_Attribute13 VARCHAR2,
52 X_Attribute14 VARCHAR2,
53 X_Attribute15 VARCHAR2,
54 X_Attribute16 VARCHAR2,
55 X_Attribute17 VARCHAR2,
56 X_Attribute18 VARCHAR2,
57 X_Attribute19 VARCHAR2,
58 X_Attribute20 VARCHAR2,
59 -- Extra Columns
60 X_Midpoint_Offset NUMBER);
61 --
62 -----------------------------------------------------------------------------
63 -- Name --
64 -- Lock_Row --
65 -- Purpose --
66 -- Table handler procedure that supports the insert , update and delete --
67 -- of a calendar by applying a lock on a calendar in the Define --
68 -- Budgetary Calendar form. --
69 -- Arguments --
70 -- See below. --
71 -- Notes --
72 -- None. --
73 -----------------------------------------------------------------------------
74 --
75 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
76 X_Period_Set_Name VARCHAR2,
77 X_Actual_Period_Type VARCHAR2,
78 X_Proc_Period_Type VARCHAR2,
79 X_Start_Date DATE,
80 X_Comments VARCHAR2,
81 X_Attribute_Category VARCHAR2,
82 X_Attribute1 VARCHAR2,
83 X_Attribute2 VARCHAR2,
84 X_Attribute3 VARCHAR2,
85 X_Attribute4 VARCHAR2,
86 X_Attribute5 VARCHAR2,
87 X_Attribute6 VARCHAR2,
88 X_Attribute7 VARCHAR2,
89 X_Attribute8 VARCHAR2,
90 X_Attribute9 VARCHAR2,
91 X_Attribute10 VARCHAR2,
92 X_Attribute11 VARCHAR2,
93 X_Attribute12 VARCHAR2,
94 X_Attribute13 VARCHAR2,
95 X_Attribute14 VARCHAR2,
96 X_Attribute15 VARCHAR2,
97 X_Attribute16 VARCHAR2,
98 X_Attribute17 VARCHAR2,
99 X_Attribute18 VARCHAR2,
100 X_Attribute19 VARCHAR2,
101 X_Attribute20 VARCHAR2);
102 --
103 -----------------------------------------------------------------------------
104 -- Name --
105 -- Update_Row --
106 -- Purpose --
107 -- Table handler procedure that supports the update of a calendar via the--
108 -- Define Budgetary Calendar form. --
109 -- Arguments --
110 -- See below. --
111 -- Notes --
112 -- None. --
113 -----------------------------------------------------------------------------
114 --
115 PROCEDURE Update_Row(X_Rowid VARCHAR2,
116 X_Period_Set_Name VARCHAR2,
117 X_Actual_Period_Type VARCHAR2,
118 X_Proc_Period_Type VARCHAR2,
119 X_Start_Date DATE,
120 X_Comments VARCHAR2,
121 X_Attribute_Category VARCHAR2,
122 X_Attribute1 VARCHAR2,
123 X_Attribute2 VARCHAR2,
124 X_Attribute3 VARCHAR2,
125 X_Attribute4 VARCHAR2,
126 X_Attribute5 VARCHAR2,
127 X_Attribute6 VARCHAR2,
128 X_Attribute7 VARCHAR2,
129 X_Attribute8 VARCHAR2,
130 X_Attribute9 VARCHAR2,
131 X_Attribute10 VARCHAR2,
132 X_Attribute11 VARCHAR2,
133 X_Attribute12 VARCHAR2,
134 X_Attribute13 VARCHAR2,
135 X_Attribute14 VARCHAR2,
136 X_Attribute15 VARCHAR2,
137 X_Attribute16 VARCHAR2,
138 X_Attribute17 VARCHAR2,
139 X_Attribute18 VARCHAR2,
140 X_Attribute19 VARCHAR2,
141 X_Attribute20 VARCHAR2);
142 --
143 -----------------------------------------------------------------------------
144 -- Name --
145 -- Delete_Row --
146 -- Purpose --
147 -- Table handler procedure that supports the delete of a calendar via the--
148 -- Define Budgetary Calendar form. --
149 -- Arguments --
150 -- See below. --
151 -- Notes --
152 -- --
153 -----------------------------------------------------------------------------
154 --
155 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
156 -- Extra Columns
157 X_Period_Set_Name VARCHAR2);
158 --
159 END PAY_CALENDARS_PKG;
|
|
|