DBA Data[Home] [Help]

PACKAGE: APPS.AR_MEMO_LINES_PKG

Source


1 package AR_MEMO_LINES_PKG as
2 /* $Header: ARPAMLSS.pls 120.3 2005/04/15 16:40:03 djancis ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_org_id in number default null, --SSA changes anukumar
6   X_MEMO_LINE_ID in NUMBER,
7   X_SET_OF_BOOKS_ID in NUMBER,
8   X_LINE_TYPE in VARCHAR2,
9   X_START_DATE in DATE,
10   X_GL_ID_REV in NUMBER,
11   X_TAX_CODE in VARCHAR2,
12   X_UOM_CODE in VARCHAR2,
13   X_UNIT_STD_PRICE in NUMBER,
14   X_INVOICING_RULE_ID in NUMBER,
15   X_ACCOUNTING_RULE_ID in NUMBER,
16   X_END_DATE in DATE,
17   X_ATTRIBUTE_CATEGORY in VARCHAR2,
18   X_ATTRIBUTE1 in VARCHAR2,
19   X_ATTRIBUTE2 in VARCHAR2,
20   X_ATTRIBUTE3 in VARCHAR2,
21   X_ATTRIBUTE4 in VARCHAR2,
22   X_ATTRIBUTE5 in VARCHAR2,
23   X_ATTRIBUTE6 in VARCHAR2,
24   X_ATTRIBUTE7 in VARCHAR2,
25   X_ATTRIBUTE8 in VARCHAR2,
26   X_ATTRIBUTE9 in VARCHAR2,
27   X_ATTRIBUTE10 in VARCHAR2,
28   X_ATTRIBUTE11 in VARCHAR2,
29   X_ATTRIBUTE12 in VARCHAR2,
30   X_ATTRIBUTE13 in VARCHAR2,
31   X_ATTRIBUTE14 in VARCHAR2,
32   X_ATTRIBUTE15 in VARCHAR2,
33   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
34   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
35   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
36   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
37   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
38   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
39   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
40   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
41   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
42   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
43   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
44   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
45   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
46   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
47   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
48   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
49   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
50   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
51   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
52   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
53   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
54   X_NAME in VARCHAR2,
55   X_DESCRIPTION in VARCHAR2,
56   X_CREATION_DATE in DATE,
57   X_CREATED_BY in NUMBER,
58   X_LAST_UPDATE_DATE in DATE,
59   X_LAST_UPDATED_BY in NUMBER,
60   X_LAST_UPDATE_LOGIN in NUMBER,
61   X_TAX_PRODUCT_CATEGORY in VARCHAR2 /* ETax */
62 );
63 
64 procedure LOCK_ROW (
65   X_org_id in number default null, --SSA changes anukumar
66   X_MEMO_LINE_ID in NUMBER,
67   X_SET_OF_BOOKS_ID in NUMBER,
68   X_LINE_TYPE in VARCHAR2,
69   X_START_DATE in DATE,
70   X_GL_ID_REV in NUMBER,
71   X_TAX_CODE in VARCHAR2,
72   X_UOM_CODE in VARCHAR2,
73   X_UNIT_STD_PRICE in NUMBER,
74   X_INVOICING_RULE_ID in NUMBER,
75   X_ACCOUNTING_RULE_ID in NUMBER,
76   X_END_DATE in DATE,
77   X_ATTRIBUTE_CATEGORY in VARCHAR2,
78   X_ATTRIBUTE1 in VARCHAR2,
79   X_ATTRIBUTE2 in VARCHAR2,
80   X_ATTRIBUTE3 in VARCHAR2,
81   X_ATTRIBUTE4 in VARCHAR2,
82   X_ATTRIBUTE5 in VARCHAR2,
83   X_ATTRIBUTE6 in VARCHAR2,
84   X_ATTRIBUTE7 in VARCHAR2,
85   X_ATTRIBUTE8 in VARCHAR2,
86   X_ATTRIBUTE9 in VARCHAR2,
87   X_ATTRIBUTE10 in VARCHAR2,
88   X_ATTRIBUTE11 in VARCHAR2,
89   X_ATTRIBUTE12 in VARCHAR2,
90   X_ATTRIBUTE13 in VARCHAR2,
91   X_ATTRIBUTE14 in VARCHAR2,
92   X_ATTRIBUTE15 in VARCHAR2,
93   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
94   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
95   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
96   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
97   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
98   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
99   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
100   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
101   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
102   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
103   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
104   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
105   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
106   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
107   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
108   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
109   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
110   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
111   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
112   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
113   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
114   X_NAME in VARCHAR2,
115   X_DESCRIPTION in VARCHAR2,
116   X_TAX_PRODUCT_CATEGORY in VARCHAR2 /* ETax */
117 );
118 
119 procedure UPDATE_ROW (
120   X_org_id in number default null, --SSA changes anukumar
121   X_MEMO_LINE_ID in NUMBER,
122   X_SET_OF_BOOKS_ID in NUMBER,
123   X_LINE_TYPE in VARCHAR2,
124   X_START_DATE in DATE,
125   X_GL_ID_REV in NUMBER,
126   X_TAX_CODE in VARCHAR2,
127   X_UOM_CODE in VARCHAR2,
128   X_UNIT_STD_PRICE in NUMBER,
129   X_INVOICING_RULE_ID in NUMBER,
130   X_ACCOUNTING_RULE_ID in NUMBER,
131   X_END_DATE in DATE,
132   X_ATTRIBUTE_CATEGORY in VARCHAR2,
133   X_ATTRIBUTE1 in VARCHAR2,
134   X_ATTRIBUTE2 in VARCHAR2,
135   X_ATTRIBUTE3 in VARCHAR2,
136   X_ATTRIBUTE4 in VARCHAR2,
137   X_ATTRIBUTE5 in VARCHAR2,
138   X_ATTRIBUTE6 in VARCHAR2,
139   X_ATTRIBUTE7 in VARCHAR2,
140   X_ATTRIBUTE8 in VARCHAR2,
141   X_ATTRIBUTE9 in VARCHAR2,
142   X_ATTRIBUTE10 in VARCHAR2,
143   X_ATTRIBUTE11 in VARCHAR2,
144   X_ATTRIBUTE12 in VARCHAR2,
145   X_ATTRIBUTE13 in VARCHAR2,
146   X_ATTRIBUTE14 in VARCHAR2,
147   X_ATTRIBUTE15 in VARCHAR2,
148   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
149   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
150   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
151   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
152   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
153   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
154   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
155   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
156   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
157   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
158   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
159   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
160   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
161   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
162   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
163   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
164   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
165   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
166   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
167   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
168   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
169   X_NAME in VARCHAR2,
170   X_DESCRIPTION in VARCHAR2,
171   X_LAST_UPDATE_DATE in DATE,
172   X_LAST_UPDATED_BY in NUMBER,
173   X_LAST_UPDATE_LOGIN in NUMBER,
174   X_TAX_PRODUCT_CATEGORY in VARCHAR2 /* ETax */
175 );
176 
177 procedure DELETE_ROW (
178   X_org_id in number default null, --SSA changes anukumar
179   X_MEMO_LINE_ID in NUMBER
180 );
181 
182 procedure ADD_LANGUAGE;
183 
184 procedure LOAD_ROW (
185   X_org_id in number default null, --SSA changes anukumar
186   X_MEMO_LINE_ID in NUMBER,
187   X_SET_OF_BOOKS_ID in NUMBER,
188   X_LINE_TYPE in VARCHAR2,
189   X_START_DATE in DATE,
190   X_GL_ID_REV in NUMBER,
191   X_TAX_CODE in VARCHAR2,
192   X_UOM_CODE in VARCHAR2,
193   X_UNIT_STD_PRICE in NUMBER,
194   X_INVOICING_RULE_ID in NUMBER,
195   X_ACCOUNTING_RULE_ID in NUMBER,
196   X_END_DATE in DATE,
197   X_ATTRIBUTE_CATEGORY in VARCHAR2,
198   X_ATTRIBUTE1 in VARCHAR2,
199   X_ATTRIBUTE2 in VARCHAR2,
200   X_ATTRIBUTE3 in VARCHAR2,
201   X_ATTRIBUTE4 in VARCHAR2,
202   X_ATTRIBUTE5 in VARCHAR2,
203   X_ATTRIBUTE6 in VARCHAR2,
204   X_ATTRIBUTE7 in VARCHAR2,
205   X_ATTRIBUTE8 in VARCHAR2,
206   X_ATTRIBUTE9 in VARCHAR2,
207   X_ATTRIBUTE10 in VARCHAR2,
208   X_ATTRIBUTE11 in VARCHAR2,
209   X_ATTRIBUTE12 in VARCHAR2,
210   X_ATTRIBUTE13 in VARCHAR2,
211   X_ATTRIBUTE14 in VARCHAR2,
212   X_ATTRIBUTE15 in VARCHAR2,
213   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
214   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
215   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
216   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
217   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
218   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
219   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
220   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
221   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
222   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
223   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
224   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
225   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
226   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
227   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
228   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
229   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
230   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
231   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
232   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
233   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
234   X_NAME in VARCHAR2,
235   X_DESCRIPTION in VARCHAR2,
236   X_OWNER       in VARCHAR2,
237   X_TAX_PRODUCT_CATEGORY in VARCHAR2
238 );
239 
240 procedure TRANSLATE_ROW (
241   X_MEMO_LINE_ID in NUMBER,
242   X_NAME         in VARCHAR2,
243   X_DESCRIPTION  in VARCHAR2,
244   X_OWNER        in VARCHAR2);
245 
246 
247 end AR_MEMO_LINES_PKG;