DBA Data[Home] [Help]

PACKAGE: APPS.ORG_FREIGHT_TL_PKG

Source


1 package ORG_FREIGHT_TL_PKG as
2 /* $Header: INVORFCS.pls 120.1 2005/06/17 17:18:02 appldev  $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_FREIGHT_CODE in VARCHAR2,
6   X_FREIGHT_CODE_TL in VARCHAR2,
7   X_ORGANIZATION_ID in NUMBER,
8   X_DISABLE_DATE in DATE,
9   X_DISTRIBUTION_ACCOUNT in NUMBER,
10   X_ATTRIBUTE_CATEGORY in VARCHAR2,
11   X_ATTRIBUTE1 in VARCHAR2,
12   X_ATTRIBUTE2 in VARCHAR2,
13   X_ATTRIBUTE3 in VARCHAR2,
14   X_ATTRIBUTE4 in VARCHAR2,
15   X_ATTRIBUTE5 in VARCHAR2,
16   X_ATTRIBUTE6 in VARCHAR2,
17   X_ATTRIBUTE7 in VARCHAR2,
18   X_ATTRIBUTE8 in VARCHAR2,
19   X_ATTRIBUTE9 in VARCHAR2,
20   X_ATTRIBUTE10 in VARCHAR2,
21   X_ATTRIBUTE11 in VARCHAR2,
22   X_ATTRIBUTE12 in VARCHAR2,
23   X_ATTRIBUTE13 in VARCHAR2,
24   X_ATTRIBUTE14 in VARCHAR2,
25   X_ATTRIBUTE15 in VARCHAR2,
26   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
27   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
28   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
29   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
30   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
31   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
32   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
33   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
34   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
35   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
36   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
37   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
38   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
39   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
40   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
41   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
42   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
43   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
44   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
45   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
46   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
47   X_DESCRIPTION in VARCHAR2,
48   X_CREATION_DATE in DATE,
49   X_CREATED_BY in NUMBER,
50   X_LAST_UPDATE_DATE in DATE,
51   X_LAST_UPDATED_BY in NUMBER,
52   X_LAST_UPDATE_LOGIN in NUMBER);
53 
54 procedure LOCK_ROW (
55   X_FREIGHT_CODE in VARCHAR2,
56   X_FREIGHT_CODE_TL in VARCHAR2,
57   X_ORGANIZATION_ID in NUMBER,
58   X_DISABLE_DATE in DATE,
59   X_DISTRIBUTION_ACCOUNT in NUMBER,
60   X_ATTRIBUTE_CATEGORY in VARCHAR2,
61   X_ATTRIBUTE1 in VARCHAR2,
62   X_ATTRIBUTE2 in VARCHAR2,
63   X_ATTRIBUTE3 in VARCHAR2,
64   X_ATTRIBUTE4 in VARCHAR2,
65   X_ATTRIBUTE5 in VARCHAR2,
66   X_ATTRIBUTE6 in VARCHAR2,
67   X_ATTRIBUTE7 in VARCHAR2,
68   X_ATTRIBUTE8 in VARCHAR2,
69   X_ATTRIBUTE9 in VARCHAR2,
70   X_ATTRIBUTE10 in VARCHAR2,
71   X_ATTRIBUTE11 in VARCHAR2,
72   X_ATTRIBUTE12 in VARCHAR2,
73   X_ATTRIBUTE13 in VARCHAR2,
74   X_ATTRIBUTE14 in VARCHAR2,
75   X_ATTRIBUTE15 in VARCHAR2,
76   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
77   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
78   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
79   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
80   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
81   X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
82   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
83   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
84   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
85   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
86   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
87   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
88   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
89   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
90   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
91   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
92   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
93   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
94   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
95   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
96   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
97   X_DESCRIPTION in VARCHAR2
98 );
99 procedure UPDATE_ROW (
100   X_FREIGHT_CODE in VARCHAR2,
101   X_FREIGHT_CODE_TL in VARCHAR2,
102   X_ORGANIZATION_ID in NUMBER,
103   X_DISABLE_DATE in DATE,
104   X_DISTRIBUTION_ACCOUNT in NUMBER,
105   X_ATTRIBUTE_CATEGORY in VARCHAR2,
106   X_ATTRIBUTE1 in VARCHAR2,
107   X_ATTRIBUTE2 in VARCHAR2,
108   X_ATTRIBUTE3 in VARCHAR2,
109   X_ATTRIBUTE4 in VARCHAR2,
110   X_ATTRIBUTE5 in VARCHAR2,
111   X_ATTRIBUTE6 in VARCHAR2,
112   X_ATTRIBUTE7 in VARCHAR2,
113   X_ATTRIBUTE8 in VARCHAR2,
114   X_ATTRIBUTE9 in VARCHAR2,
115   X_ATTRIBUTE10 in VARCHAR2,
116   X_ATTRIBUTE11 in VARCHAR2,
117   X_ATTRIBUTE12 in VARCHAR2,
118   X_ATTRIBUTE13 in VARCHAR2,
119   X_ATTRIBUTE14 in VARCHAR2,
120   X_ATTRIBUTE15 in VARCHAR2,
121   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
122   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
123   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
124   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
125   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
126   x_GLOBAL_ATTRIBUTE6 in VARCHAR2,
127   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
128   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
129   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
130   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
131   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
132   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
133   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
134   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
135   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
136   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
137   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
138   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
139   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
140   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
141   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
142   X_DESCRIPTION in VARCHAR2,
143   X_LAST_UPDATE_DATE in DATE,
144   X_LAST_UPDATED_BY in NUMBER,
145   X_LAST_UPDATE_LOGIN in NUMBER
146 );
147 procedure DELETE_ROW (
148   X_FREIGHT_CODE in VARCHAR2,
149   X_ORGANIZATION_ID in NUMBER
150 );
151 
152 procedure ADD_LANGUAGE;
153 
154 procedure LOAD_ROW(
155   X_FREIGHT_CODE in VARCHAR2,
156   X_ORGANIZATION_CODE in VARCHAR2,
157   X_OWNER in VARCHAR2,
158   X_FREIGHT_CODE_TL in VARCHAR2,
159   X_DISABLE_DATE in DATE,
160   X_DISTRIBUTION_ACCOUNT in NUMBER,
161   X_ATTRIBUTE_CATEGORY in VARCHAR2,
162   X_ATTRIBUTE1 in VARCHAR2,
163   X_ATTRIBUTE2 in VARCHAR2,
164   X_ATTRIBUTE3 in VARCHAR2,
165   X_ATTRIBUTE4 in VARCHAR2,
166   X_ATTRIBUTE5 in VARCHAR2,
167   X_ATTRIBUTE6 in VARCHAR2,
168   X_ATTRIBUTE7 in VARCHAR2,
169   X_ATTRIBUTE8 in VARCHAR2,
170   X_ATTRIBUTE9 in VARCHAR2,
171   X_ATTRIBUTE10 in VARCHAR2,
172   X_ATTRIBUTE11 in VARCHAR2,
173   X_ATTRIBUTE12 in VARCHAR2,
174   X_ATTRIBUTE13 in VARCHAR2,
175   X_ATTRIBUTE14 in VARCHAR2,
176   X_ATTRIBUTE15 in VARCHAR2,
177   X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
178   X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
179   X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
180   X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
181   X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
182   x_GLOBAL_ATTRIBUTE6 in VARCHAR2,
183   X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
184   X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
185   X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
186   X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
187   X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
188   X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
189   X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
190   X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
191   X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
192   X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
193   X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
194   X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
195   X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
196   X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
197   X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
198   X_DESCRIPTION in VARCHAR2,
199   X_LAST_UPDATE_DATE in DATE,
200   X_LAST_UPDATED_BY in NUMBER,
201   X_LAST_UPDATE_LOGIN in NUMBER);
202 
203 procedure TRANSLATE_ROW(
204   X_FREIGHT_CODE in VARCHAR2,
205   X_ORGANIZATION_ID in NUMBER,
206   X_FREIGHT_CODE_TL in VARCHAR2,
207   X_DESCRIPTION in VARCHAR2,
208   X_OWNER in VARCHAR2);
209 
210 end ORG_FREIGHT_TL_PKG;