APPS.CN_ATTAIN_TIER_PVT_W dependencies on CN_ATTAIN_TIER_PVT

Line 1: package body cn_attain_tier_pvt_w as

1: package body cn_attain_tier_pvt_w as
2: /* $Header: cnwattrb.pls 115.3 2002/11/25 22:22:46 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_attain_tier_pvt.attain_tier_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_attain_tier_pvt.attain_tier_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_200

Line 70: procedure rosetta_table_copy_out_p1(t cn_attain_tier_pvt.attain_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

66: end loop;
67: end if;
68: end if;
69: end rosetta_table_copy_in_p1;
70: procedure rosetta_table_copy_out_p1(t cn_attain_tier_pvt.attain_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 219: ddp_attain_tier cn_attain_tier_pvt.attain_tier_rec_type;

215: , x_msg_data out nocopy VARCHAR2
216: )
217:
218: as
219: ddp_attain_tier cn_attain_tier_pvt.attain_tier_rec_type;
220: ddindx binary_integer; indx binary_integer;
221: begin
222:
223: -- copy data to the local IN or IN-OUT args, if any

Line 253: cn_attain_tier_pvt.create_attain_tier(p_api_version,

249:
250:
251:
252: -- here's the delegated call to the old PL/SQL routine
253: cn_attain_tier_pvt.create_attain_tier(p_api_version,
254: p_init_msg_list,
255: p_commit,
256: p_validation_level,
257: ddp_attain_tier,

Line 302: ddp_attain_tier cn_attain_tier_pvt.attain_tier_rec_type;

298: , x_msg_data out nocopy VARCHAR2
299: )
300:
301: as
302: ddp_attain_tier cn_attain_tier_pvt.attain_tier_rec_type;
303: ddindx binary_integer; indx binary_integer;
304: begin
305:
306: -- copy data to the local IN or IN-OUT args, if any

Line 336: cn_attain_tier_pvt.update_attain_tier(p_api_version,

332:
333:
334:
335: -- here's the delegated call to the old PL/SQL routine
336: cn_attain_tier_pvt.update_attain_tier(p_api_version,
337: p_init_msg_list,
338: p_commit,
339: p_validation_level,
340: ddp_attain_tier,

Line 385: ddp_attain_tier cn_attain_tier_pvt.attain_tier_rec_type;

381: , x_msg_data out nocopy VARCHAR2
382: )
383:
384: as
385: ddp_attain_tier cn_attain_tier_pvt.attain_tier_rec_type;
386: ddindx binary_integer; indx binary_integer;
387: begin
388:
389: -- copy data to the local IN or IN-OUT args, if any

Line 419: cn_attain_tier_pvt.delete_attain_tier(p_api_version,

415:
416:
417:
418: -- here's the delegated call to the old PL/SQL routine
419: cn_attain_tier_pvt.delete_attain_tier(p_api_version,
420: p_init_msg_list,
421: p_commit,
422: p_validation_level,
423: ddp_attain_tier,

Line 469: ddx_attain_tier cn_attain_tier_pvt.attain_tier_tbl_type;

465: , x_msg_data out nocopy VARCHAR2
466: )
467:
468: as
469: ddx_attain_tier cn_attain_tier_pvt.attain_tier_tbl_type;
470: ddindx binary_integer; indx binary_integer;
471: begin
472:
473: -- copy data to the local IN or IN-OUT args, if any

Line 484: cn_attain_tier_pvt.get_attain_tier(p_api_version,

480:
481:
482:
483: -- here's the delegated call to the old PL/SQL routine
484: cn_attain_tier_pvt.get_attain_tier(p_api_version,
485: p_init_msg_list,
486: p_commit,
487: p_validation_level,
488: p_attain_schedule_id,

Line 500: cn_attain_tier_pvt_w.rosetta_table_copy_out_p1(ddx_attain_tier, p5_a0

496:
497:
498:
499:
500: cn_attain_tier_pvt_w.rosetta_table_copy_out_p1(ddx_attain_tier, p5_a0
501: , p5_a1
502: , p5_a2
503: , p5_a3
504: , p5_a4

Line 526: end cn_attain_tier_pvt_w;

522:
523:
524: end;
525:
526: end cn_attain_tier_pvt_w;