[Home] [Help]
PACKAGE BODY: APPS.OZF_PROCESS_SETUP_PKG
Source
1 PACKAGE BODY OZF_Process_Setup_PKG as
2 /* $Header: ozftpseb.pls 120.0 2007/12/21 07:19:06 gdeepika noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Process_Setup_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19
20 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Process_Setup_PKG';
21 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftpseb.pls';
22
23 PROCEDURE Update_Row(
24 p_process_setup_id NUMBER,
25 p_object_version_number IN NUMBER,
26 p_last_update_date DATE,
27 p_last_updated_by NUMBER,
28 p_last_update_login NUMBER,
29 p_org_id NUMBER,
30 p_supp_trade_profile_id NUMBER,
31 p_process_code VARCHAR2,
32 p_enabled_flag VARCHAR2,
33 p_automatic_flag VARCHAR2,
34 p_attribute_category VARCHAR2,
35 p_attribute1 VARCHAR2,
36 p_attribute2 VARCHAR2,
37 p_attribute3 VARCHAR2,
38 p_attribute4 VARCHAR2,
39 p_attribute5 VARCHAR2,
40 p_attribute6 VARCHAR2,
41 p_attribute7 VARCHAR2,
42 p_attribute8 VARCHAR2,
43 p_attribute9 VARCHAR2,
44 p_attribute10 VARCHAR2,
45 p_attribute11 VARCHAR2,
46 p_attribute12 VARCHAR2,
47 p_attribute13 VARCHAR2,
48 p_attribute14 VARCHAR2,
49 p_attribute15 VARCHAR2)
50
51 IS
52 BEGIN
53 Update ozf_process_setup_all
54 SET
55 process_setup_id = DECODE( p_process_setup_id, null, process_setup_id, FND_API.G_MISS_NUM, null, p_process_setup_id),
56 object_version_number = nvl(p_object_version_number,0) + 1 ,
57 last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
58 last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
59 last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
60 org_id = DECODE( p_org_id, null, org_id, FND_API.G_MISS_NUM, null, p_org_id),
61 supp_trade_profile_id = DECODE( p_supp_trade_profile_id, null, supp_trade_profile_id, FND_API.G_MISS_NUM, null, p_supp_trade_profile_id),
62 process_code = DECODE( p_process_code, null, process_code, FND_API.g_miss_char, null, p_process_code),
63 enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
64 automatic_flag = DECODE( p_automatic_flag, null, automatic_flag, FND_API.g_miss_char, null, p_automatic_flag),
65 attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
66 attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
67 attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
68 attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
69 attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
70 attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
71 attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
72 attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
73 attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
74 attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
75 attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
76 attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
77 attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
78 attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
79 attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
80 attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
81 WHERE process_setup_id = p_process_setup_id
82 AND object_version_number = p_object_version_number;
83
84
85 IF (SQL%NOTFOUND) THEN
86 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87 END IF;
88
89
90 END Update_Row;
91
92
93
94
95 PROCEDURE Insert_Row(
96 px_process_setup_id IN OUT NOCOPY NUMBER,
97 px_object_version_number IN OUT NOCOPY NUMBER,
98 p_last_update_date DATE,
99 p_last_updated_by NUMBER,
100 p_creation_date DATE,
101 p_created_by NUMBER,
102 p_last_update_login NUMBER,
103 px_org_id IN OUT NOCOPY NUMBER,
104 p_supp_trade_profile_id NUMBER,
105 p_process_code VARCHAR2,
106 p_enabled_flag VARCHAR2,
107 p_automatic_flag VARCHAR2,
108 p_attribute_category VARCHAR2,
109 p_attribute1 VARCHAR2,
110 p_attribute2 VARCHAR2,
111 p_attribute3 VARCHAR2,
112 p_attribute4 VARCHAR2,
113 p_attribute5 VARCHAR2,
114 p_attribute6 VARCHAR2,
115 p_attribute7 VARCHAR2,
116 p_attribute8 VARCHAR2,
117 p_attribute9 VARCHAR2,
118 p_attribute10 VARCHAR2,
119 p_attribute11 VARCHAR2,
120 p_attribute12 VARCHAR2,
121 p_attribute13 VARCHAR2,
122 p_attribute14 VARCHAR2,
123 p_attribute15 VARCHAR2)
124
125 IS
126 x_rowid VARCHAR2(30);
127
128
129 BEGIN
130
131 -- R12 Enhancements
132 /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
133 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
134 INTO px_org_id
135 FROM DUAL;
136 END IF;
137 */
138
139 px_object_version_number := nvl(px_object_version_number, 1);
140
141
142 INSERT INTO ozf_process_setup_all(
143 process_setup_id,
144 object_version_number,
145 last_update_date,
146 last_updated_by,
147 creation_date,
148 created_by,
149 last_update_login,
150 org_id,
151 supp_trade_profile_id,
152 process_code,
153 enabled_flag,
154 automatic_flag,
155 attribute_category,
156 attribute1,
157 attribute2,
158 attribute3,
159 attribute4,
160 attribute5,
161 attribute6,
162 attribute7,
163 attribute8,
164 attribute9,
165 attribute10,
166 attribute11,
167 attribute12,
168 attribute13,
169 attribute14,
170 attribute15
171 ) VALUES (
172 DECODE( px_process_setup_id, FND_API.G_MISS_NUM, NULL, px_process_setup_id),
173 DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
174 DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
175 DECODE( p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
176 DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
177 DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
178 DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
179 DECODE( px_org_id, FND_API.G_MISS_NUM, NULL, px_org_id),
180 DECODE( p_supp_trade_profile_id, FND_API.G_MISS_NUM, NULL, p_supp_trade_profile_id),
181 DECODE( p_process_code, FND_API.g_miss_char, NULL, p_process_code),
182 DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
183 DECODE( p_automatic_flag, FND_API.g_miss_char, NULL, p_automatic_flag),
184 DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
185 DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
186 DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
187 DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
188 DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
189 DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
190 DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
191 DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
192 DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
193 DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
194 DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
195 DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
196 DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
197 DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
198 DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
199 DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
200
201 END Insert_Row;
202
203
204 END OZF_Process_Setup_PKG;