DBA Data[Home] [Help]

APPS.CN_PRD_QUOTA_PVT_W dependencies on CN_PRD_QUOTA_PVT

Line 1: package body cn_prd_quota_pvt_w as

1: package body cn_prd_quota_pvt_w as
2: /* $Header: cnwpedqb.pls 120.3 2005/09/14 04:28 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_prd_quota_pvt.prd_quota_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_prd_quota_pvt.prd_quota_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_prd_quota_pvt_w as
2: /* $Header: cnwpedqb.pls 120.3 2005/09/14 04:28 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_prd_quota_pvt.prd_quota_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 70: procedure rosetta_table_copy_out_p1(t cn_prd_quota_pvt.prd_quota_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_prd_quota_pvt.prd_quota_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_NUMBER_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE

Line 214: procedure rosetta_table_copy_in_p3(t out nocopy cn_prd_quota_pvt.prd_quota_q_tbl_type, a0 JTF_NUMBER_TABLE

210: end if;
211: end if;
212: end rosetta_table_copy_out_p1;
213:
214: procedure rosetta_table_copy_in_p3(t out nocopy cn_prd_quota_pvt.prd_quota_q_tbl_type, a0 JTF_NUMBER_TABLE
215: , a1 JTF_NUMBER_TABLE
216: , a2 JTF_NUMBER_TABLE
217: , a3 JTF_NUMBER_TABLE
218: , a4 JTF_NUMBER_TABLE

Line 255: procedure rosetta_table_copy_out_p3(t cn_prd_quota_pvt.prd_quota_q_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

251: end loop;
252: end if;
253: end if;
254: end rosetta_table_copy_in_p3;
255: procedure rosetta_table_copy_out_p3(t cn_prd_quota_pvt.prd_quota_q_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
256: , a1 out nocopy JTF_NUMBER_TABLE
257: , a2 out nocopy JTF_NUMBER_TABLE
258: , a3 out nocopy JTF_NUMBER_TABLE
259: , a4 out nocopy JTF_NUMBER_TABLE

Line 334: procedure rosetta_table_copy_in_p5(t out nocopy cn_prd_quota_pvt.prd_quota_year_tbl_type, a0 JTF_NUMBER_TABLE

330: end if;
331: end if;
332: end rosetta_table_copy_out_p3;
333:
334: procedure rosetta_table_copy_in_p5(t out nocopy cn_prd_quota_pvt.prd_quota_year_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE

Line 373: procedure rosetta_table_copy_out_p5(t cn_prd_quota_pvt.prd_quota_year_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

369: end loop;
370: end if;
371: end if;
372: end rosetta_table_copy_in_p5;
373: procedure rosetta_table_copy_out_p5(t cn_prd_quota_pvt.prd_quota_year_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
374: , a1 out nocopy JTF_NUMBER_TABLE
375: , a2 out nocopy JTF_NUMBER_TABLE
376: , a3 out nocopy JTF_NUMBER_TABLE
377: , a4 out nocopy JTF_NUMBER_TABLE

Line 482: ddp_prd_quota cn_prd_quota_pvt.prd_quota_rec_type;

478: , x_msg_data out nocopy VARCHAR2
479: )
480:
481: as
482: ddp_prd_quota cn_prd_quota_pvt.prd_quota_rec_type;
483: ddindx binary_integer; indx binary_integer;
484: begin
485:
486: -- copy data to the local IN or IN-OUT args, if any

Line 521: cn_prd_quota_pvt.update_period_quota(p_api_version,

517:
518:
519:
520: -- here's the delegated call to the old PL/SQL routine
521: cn_prd_quota_pvt.update_period_quota(p_api_version,
522: p_init_msg_list,
523: p_commit,
524: p_validation_level,
525: ddp_prd_quota,

Line 565: end cn_prd_quota_pvt_w;

561:
562:
563: end;
564:
565: end cn_prd_quota_pvt_w;