[Home] [Help]
PACKAGE: APPS.GL_RECURRING_LINES_PKG
Source
1 PACKAGE GL_RECURRING_LINES_PKG AS
2 /* $Header: glirecls.pls 120.3 2005/05/05 01:20:17 kvora ship $ */
3 --
4 -- Package
5 -- GL_RECURRING_LINES_PKG
6 -- Purpose
7 -- To group all the procedures/functions for GL_RECURRING_LINES_PKG.
8 -- History
9 -- 20-FEB-1994 ERumanan Created.
10 --
11
12
13 --
14 -- Procedure
15 -- check_unique
16 -- Purpose
17 -- Ensure new recurring formula name is unique.
18 -- History
19 -- 20-FEB-1994 ERumanan Created.
20 -- Arguments
21 -- x_rowid The ID of the row to be checked
22 -- x_line_num The recurring line number to be checked
23 -- x_header_id The recurring header id to be checked
24 -- Example
25 -- GL_RECURRING_LINES_PKG.check_unique( '12345', 1, 100 );
26 -- Notes
27 --
28 PROCEDURE check_unique( x_rowid VARCHAR2,
29 x_line_num NUMBER,
30 x_header_id NUMBER );
31
32 --
33 -- Procedure
34 -- check_dup_budget_acct
35 -- Purpose
36 -- Ensure a budget batch has unique line account because budget formula
37 -- replaces account balances.
38 -- History
39 -- 12-SEP-1997 Charmaine Wang Created.
40 -- Arguments
41 -- x_rowid The ID of the gl_iea_recur_lines row to be checked
42 -- x_ccid The account id
43 -- x_batch_id The recurring batch id
44 -- Example
45 -- GL_RECURRING_LINES_PKG.check_dup_budget_acct( '12345', 100, 1 );
46 -- Notes
47 --
48 PROCEDURE check_dup_budget_acct( x_rowid VARCHAR2,
49 x_ccid NUMBER,
50 x_batch_id NUMBER );
51
52
53 --
54 -- Procedure
55 -- delete_rows
56 -- Purpose
57 -- Delete rows for all the detail blocks.
58 -- History
59 -- 20-MAR-1994 ERumanan Created.
60 -- Arguments
61 -- x_header_id The recurring header id.
62 -- Example
63 -- GL_RECURRING_LINES_PKG.delete_rows( 10 );
64 -- Notes
65 --
66 PROCEDURE delete_rows( x_header_id NUMBER );
67
68
69
70
71 ------------------------------------
72
73
74 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
75 X_Recurring_Header_Id NUMBER,
76 X_Recurring_Line_Num NUMBER,
77 X_Last_Update_Date DATE,
78 X_Last_Updated_By NUMBER,
79 X_Code_Combination_Id NUMBER,
80 X_Entered_Currency_Code VARCHAR2,
81 X_Creation_Date DATE,
82 X_Created_By NUMBER,
83 X_Last_Update_Login NUMBER,
84 X_Description VARCHAR2,
85 X_Entered_Dr NUMBER,
86 X_Entered_Cr NUMBER,
87 X_Attribute1 VARCHAR2,
88 X_Attribute2 VARCHAR2,
89 X_Attribute3 VARCHAR2,
90 X_Attribute4 VARCHAR2,
91 X_Attribute5 VARCHAR2,
92 X_Attribute6 VARCHAR2,
93 X_Attribute7 VARCHAR2,
94 X_Attribute8 VARCHAR2,
95 X_Attribute9 VARCHAR2,
96 X_Attribute10 VARCHAR2,
97 X_Context VARCHAR2,
98 X_Budget_Flag VARCHAR2,
99 X_Batch_Id NUMBER
100 );
101
102 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
103 X_Recurring_Header_Id NUMBER,
104 X_Recurring_Line_Num NUMBER,
105 X_Code_Combination_Id NUMBER,
106 X_Entered_Currency_Code VARCHAR2,
107 X_Description VARCHAR2,
108 X_Entered_Dr NUMBER,
109 X_Entered_Cr NUMBER,
110 X_Attribute1 VARCHAR2,
111 X_Attribute2 VARCHAR2,
112 X_Attribute3 VARCHAR2,
113 X_Attribute4 VARCHAR2,
114 X_Attribute5 VARCHAR2,
115 X_Attribute6 VARCHAR2,
116 X_Attribute7 VARCHAR2,
117 X_Attribute8 VARCHAR2,
118 X_Attribute9 VARCHAR2,
119 X_Attribute10 VARCHAR2,
120 X_Context VARCHAR2
121 );
122
123
124
125 PROCEDURE Update_Row(X_Rowid VARCHAR2,
126 X_Recurring_Header_Id NUMBER,
127 X_Recurring_Line_Num NUMBER,
128 X_Last_Update_Date DATE,
129 X_Last_Updated_By NUMBER,
130 X_Code_Combination_Id NUMBER,
131 X_Entered_Currency_Code VARCHAR2,
132 X_Last_Update_Login NUMBER,
133 X_Description VARCHAR2,
134 X_Entered_Dr NUMBER,
135 X_Entered_Cr NUMBER,
136 X_Attribute1 VARCHAR2,
137 X_Attribute2 VARCHAR2,
138 X_Attribute3 VARCHAR2,
139 X_Attribute4 VARCHAR2,
140 X_Attribute5 VARCHAR2,
141 X_Attribute6 VARCHAR2,
142 X_Attribute7 VARCHAR2,
143 X_Attribute8 VARCHAR2,
144 X_Attribute9 VARCHAR2,
145 X_Attribute10 VARCHAR2,
146 X_Context VARCHAR2,
147 X_Budget_Flag VARCHAR2,
148 X_Batch_Id NUMBER
149 );
150
151 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
152
153
154 ------------------------------------
155
156
157
158 END GL_RECURRING_LINES_PKG;