[Home] [Help]
PACKAGE: APPS.GL_PERIOD_SETS_PKG
Source
1 PACKAGE gl_period_sets_pkg AS
2 /* $Header: gliprses.pls 120.9 2005/05/05 01:18:32 kvora ship $ */
3 --
4 -- Package
5 -- gl_period_sets_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_period_sets
8 -- History
9 -- 10-07-93 D. J. Ogg Created
10 --
11 -- Procedure
12 -- check_unique
13 -- Purpose
14 -- Checks to make sure that the name of the calendar
15 -- is unique.
16 -- History
17 -- 10-01-93 D. J. Ogg Created
18 -- Arguments
19 -- calendar_name The name of the calendar
20 -- row_id The current rowid
21 -- Example
22 -- gl_period_sets_pkg.check_unique('Standard', 'ABCDEDF');
23 -- Notes
24 --
25 PROCEDURE check_unique(calendar_name VARCHAR2, row_id VARCHAR2);
26
27
28 --
29 -- Procedure
30 -- get_unique_id
31 -- Purpose
32 -- Gets a unique calendar id
33 -- History
34 -- 06-10-03 D. J. Ogg Created
35 -- Arguments
36 -- none
37 -- Example
38 -- bid := gl_period_sets_pkg.get_unique_id;
39 -- Notes
40 --
41 FUNCTION get_unique_id RETURN NUMBER;
42
43 --
44 -- Procedure
45 -- Insert_Row
46 -- Purpose
47 -- Inserts a row in the gl_period_sets table.
48 -- History
49 -- 10-09-02 N Kasu Created
50 -- Example
51 -- gl_period_sets_pkg.Insert_Row(...);
52 -- Notes
53 --
54 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
55 X_Period_Set_Name VARCHAR2,
56 X_Security_Flag VARCHAR2,
57 X_Creation_Date DATE,
58 X_Created_By NUMBER,
59 X_Last_Updated_By NUMBER,
60 X_Last_Update_Login NUMBER,
61 X_Last_Update_Date DATE,
62 X_Description VARCHAR2,
63 X_Context VARCHAR2,
64 X_Attribute1 VARCHAR2,
65 X_Attribute2 VARCHAR2,
66 X_Attribute3 VARCHAR2,
67 X_Attribute4 VARCHAR2,
68 X_Attribute5 VARCHAR2);
69
70 --
71 -- Procedure
72 -- Update_Row
73 -- Purpose
74 -- Updates a row in the gl_period_sets table.
75 -- History
76 -- 10-09-02 N Kasu Created
77 -- Example
78 -- gl_period_sets_pkg.Update_Row(...);
79 -- Notes
80 --
81 PROCEDURE Update_Row(X_Rowid VARCHAR2,
82 X_Period_Set_Name VARCHAR2,
83 X_Security_Flag VARCHAR2,
84 X_Last_Updated_By NUMBER,
85 X_Last_Update_Login NUMBER,
86 X_Last_Update_Date DATE,
87 X_Description VARCHAR2,
88 X_Context VARCHAR2,
89 X_Attribute1 VARCHAR2,
90 X_Attribute2 VARCHAR2,
91 X_Attribute3 VARCHAR2,
92 X_Attribute4 VARCHAR2,
93 X_Attribute5 VARCHAR2);
94
95 --
96 -- Procedure
97 -- Load_Row
98 -- Purpose
99 -- Loads a row in the gl_period_sets table.
100 -- History
101 -- 10-09-02 N Kasu Created
102 -- Example
103 -- gl_period_sets_pkg.Load_Row(...);
104 -- Notes
105 --
106 PROCEDURE Load_Row(X_Period_Set_Name VARCHAR2,
107 X_Owner VARCHAR2,
108 X_Description VARCHAR2,
109 X_Context VARCHAR2,
110 X_Attribute1 VARCHAR2,
111 X_Attribute2 VARCHAR2,
112 X_Attribute3 VARCHAR2,
113 X_Attribute4 VARCHAR2,
114 X_Attribute5 VARCHAR2);
115
116 --
117 -- Procedure
118 -- Lock_Row
119 -- Purpose
120 -- used to lock a period set record
121 -- History
122 -- 10/21/02 C Ma Created
123 -- Notes
124 --
125 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
126 X_Period_Set_Name VARCHAR2,
127 X_Last_Update_Date DATE,
128 X_Last_Updated_By NUMBER,
129 X_Creation_Date DATE,
130 X_Created_By NUMBER,
131 X_Last_Update_Login NUMBER,
132 X_Description VARCHAR2,
133 X_Attribute1 VARCHAR2,
134 X_Attribute2 VARCHAR2,
135 X_Attribute3 VARCHAR2,
136 X_Attribute4 VARCHAR2,
137 X_Attribute5 VARCHAR2,
138 X_Context VARCHAR2,
139 X_Security_Flag VARCHAR2);
140
141 --
142 -- Function
143 -- submit_concurrent
144 -- Purpose
145 -- Submit the Calendar Validation report.
146 -- Created specifically for the Calendar BC4J API.
147 -- History
148 -- 05/09/03 T Cheng Created
149 -- Arguments
150 -- ledger_id GL ledger ID.
151 -- period_set_name Calendar to be validated.
152 -- Example
153 -- req_id = gl_period_sets_pkg.submit_concurrent(p_ledger_id, p_cal_name);
154 -- Notes
155 -- Ledger id is used for the report header. If there is no
156 -- ledger context, pass in -1 is fine.
157 --
158 FUNCTION submit_concurrent(ledger_id NUMBER,
159 period_set_name VARCHAR2) RETURN NUMBER;
160
161 END gl_period_sets_pkg;