DBA Data[Home] [Help]

APPS.CN_ROLE_PLANS_PUB_W dependencies on CN_ROLE_PLANS_PUB

Line 1: package body cn_role_plans_pub_w as

1: package body cn_role_plans_pub_w as
2: /* $Header: cnwrlplb.pls 120.2 2005/09/14 03:41 vensrini ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body cn_role_plans_pub_w as
2: /* $Header: cnwrlplb.pls 120.2 2005/09/14 03:41 vensrini ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 68: procedure rosetta_table_copy_out_p1(t cn_role_plans_pub.role_plan_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

64: end loop;
65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t cn_role_plans_pub.role_plan_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_DATE_TABLE

Line 244: ddp_role_plan_rec cn_role_plans_pub.role_plan_rec_type;

240: , x_obj_ver_num out nocopy NUMBER
241: )
242:
243: as
244: ddp_role_plan_rec cn_role_plans_pub.role_plan_rec_type;
245: ddindx binary_integer; indx binary_integer;
246: begin
247:
248: -- copy data to the local IN or IN-OUT args, if any

Line 285: cn_role_plans_pub.create_role_plan(p_api_version,

281:
282:
283:
284: -- here's the delegated call to the old PL/SQL routine
285: cn_role_plans_pub.create_role_plan(p_api_version,
286: p_init_msg_list,
287: p_commit,
288: p_validation_level,
289: x_return_status,

Line 371: ddp_role_plan_rec_old cn_role_plans_pub.role_plan_rec_type;

367: , p_role_plan_id NUMBER
368: )
369:
370: as
371: ddp_role_plan_rec_old cn_role_plans_pub.role_plan_rec_type;
372: ddp_role_plan_rec_new cn_role_plans_pub.role_plan_rec_type;
373: ddindx binary_integer; indx binary_integer;
374: begin
375:

Line 372: ddp_role_plan_rec_new cn_role_plans_pub.role_plan_rec_type;

368: )
369:
370: as
371: ddp_role_plan_rec_old cn_role_plans_pub.role_plan_rec_type;
372: ddp_role_plan_rec_new cn_role_plans_pub.role_plan_rec_type;
373: ddindx binary_integer; indx binary_integer;
374: begin
375:
376: -- copy data to the local IN or IN-OUT args, if any

Line 438: cn_role_plans_pub.update_role_plan(p_api_version,

434: ddp_role_plan_rec_new.org_id := p10_a23;
435:
436:
437: -- here's the delegated call to the old PL/SQL routine
438: cn_role_plans_pub.update_role_plan(p_api_version,
439: p_init_msg_list,
440: p_commit,
441: p_validation_level,
442: x_return_status,

Line 500: ddp_role_plan_rec cn_role_plans_pub.role_plan_rec_type;

496: , p8_a23 NUMBER
497: )
498:
499: as
500: ddp_role_plan_rec cn_role_plans_pub.role_plan_rec_type;
501: ddindx binary_integer; indx binary_integer;
502: begin
503:
504: -- copy data to the local IN or IN-OUT args, if any

Line 539: cn_role_plans_pub.delete_role_plan(p_api_version,

535: ddp_role_plan_rec.object_version_number := p8_a22;
536: ddp_role_plan_rec.org_id := p8_a23;
537:
538: -- here's the delegated call to the old PL/SQL routine
539: cn_role_plans_pub.delete_role_plan(p_api_version,
540: p_init_msg_list,
541: p_commit,
542: p_validation_level,
543: x_return_status,

Line 560: end cn_role_plans_pub_w;

556:
557:
558: end;
559:
560: end cn_role_plans_pub_w;