APPS.CN_QUOTA_CATEGORIES_PUB_W dependencies on CN_QUOTA_CATEGORIES_PUB

Line 1: package body cn_quota_categories_pub_w as

1: package body cn_quota_categories_pub_w as
2: /* $Header: cnwqcatb.pls 115.8 2002/11/25 22:26:17 nkodkani ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 50: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

46: end loop;
47: end if;
48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_VARCHAR2_TABLE_100
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: ddp_rec cn_quota_categories_pub.quota_category_rec_type;

136: , x_quota_category_id out nocopy NUMBER
137: )
138:
139: as
140: ddp_rec cn_quota_categories_pub.quota_category_rec_type;
141: ddindx binary_integer; indx binary_integer;
142: begin
143:
144: -- copy data to the local IN or IN-OUT args, if any

Line 165: cn_quota_categories_pub.create_quota_category(p_api_version,

161:
162:
163:
164: -- here's the delegated call to the old PL/SQL routine
165: cn_quota_categories_pub.create_quota_category(p_api_version,
166: p_init_msg_list,
167: p_commit,
168: p_validation_level,
169: ddp_rec,

Line 206: ddp_rec cn_quota_categories_pub.quota_category_rec_type;

202: , x_msg_data out nocopy VARCHAR2
203: )
204:
205: as
206: ddp_rec cn_quota_categories_pub.quota_category_rec_type;
207: ddindx binary_integer; indx binary_integer;
208: begin
209:
210: -- copy data to the local IN or IN-OUT args, if any

Line 230: cn_quota_categories_pub.update_quota_category(p_api_version,

226:
227:
228:
229: -- here's the delegated call to the old PL/SQL routine
230: cn_quota_categories_pub.update_quota_category(p_api_version,
231: p_init_msg_list,
232: p_commit,
233: p_validation_level,
234: ddp_rec,

Line 274: ddx_quota_categories_tbl cn_quota_categories_pub.quota_categories_tbl_type;

270: , x_total_records out nocopy NUMBER
271: )
272:
273: as
274: ddx_quota_categories_tbl cn_quota_categories_pub.quota_categories_tbl_type;
275: ddindx binary_integer; indx binary_integer;
276: begin
277:
278: -- copy data to the local IN or IN-OUT args, if any

Line 293: cn_quota_categories_pub.get_quota_category_details(p_api_version,

289:
290:
291:
292: -- here's the delegated call to the old PL/SQL routine
293: cn_quota_categories_pub.get_quota_category_details(p_api_version,
294: p_init_msg_list,
295: p_validation_level,
296: x_return_status,
297: x_msg_count,

Line 319: cn_quota_categories_pub_w.rosetta_table_copy_out_p1(ddx_quota_categories_tbl, p11_a0

315:
316:
317:
318:
319: cn_quota_categories_pub_w.rosetta_table_copy_out_p1(ddx_quota_categories_tbl, p11_a0
320: , p11_a1
321: , p11_a2
322: , p11_a3
323: , p11_a4

Line 333: end cn_quota_categories_pub_w;

329: );
330:
331: end;
332:
333: end cn_quota_categories_pub_w;