APPS.CN_USER_ACCESS_PVT_W dependencies on CN_USER_ACCESS_PVT

Line 1: package body cn_user_access_pvt_w as

1: package body cn_user_access_pvt_w as
2: /* $Header: cnwurasb.pls 115.4 2002/11/25 22:32:50 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_user_access_pvt.user_access_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_user_access_pvt.user_access_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_100

Line 74: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

70: end loop;
71: end if;
72: end if;
73: end rosetta_table_copy_in_p1;
74: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_NUMBER_TABLE
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE

199: end if;
200: end if;
201: end rosetta_table_copy_out_p1;
202:
203: procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE
204: , a1 JTF_VARCHAR2_TABLE_300
205: , a2 JTF_VARCHAR2_TABLE_100
206: ) as
207: ddindx binary_integer; indx binary_integer;

Line 226: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

222: end loop;
223: end if;
224: end if;
225: end rosetta_table_copy_in_p3;
226: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
227: , a1 out nocopy JTF_VARCHAR2_TABLE_300
228: , a2 out nocopy JTF_VARCHAR2_TABLE_100
229: ) as
230: ddindx binary_integer; indx binary_integer;

Line 293: ddp_rec cn_user_access_pvt.user_access_rec_type;

289: , x_user_access_id out nocopy NUMBER
290: )
291:
292: as
293: ddp_rec cn_user_access_pvt.user_access_rec_type;
294: ddindx binary_integer; indx binary_integer;
295: begin
296:
297: -- copy data to the local IN or IN-OUT args, if any

Line 330: cn_user_access_pvt.create_user_access(p_api_version,

326:
327:
328:
329: -- here's the delegated call to the old PL/SQL routine
330: cn_user_access_pvt.create_user_access(p_api_version,
331: p_init_msg_list,
332: p_commit,
333: p_validation_level,
334: ddp_rec,

Line 383: ddp_rec cn_user_access_pvt.user_access_rec_type;

379: , x_msg_data out nocopy VARCHAR2
380: )
381:
382: as
383: ddp_rec cn_user_access_pvt.user_access_rec_type;
384: ddindx binary_integer; indx binary_integer;
385: begin
386:
387: -- copy data to the local IN or IN-OUT args, if any

Line 419: cn_user_access_pvt.update_user_access(p_api_version,

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

Line 447: ddx_result_tbl cn_user_access_pvt.user_access_sum_tbl_type;

443: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
444: )
445:
446: as
447: ddx_result_tbl cn_user_access_pvt.user_access_sum_tbl_type;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:
451: -- copy data to the local IN or IN-OUT args, if any

Line 457: cn_user_access_pvt.get_accesses(p_range_low,

453:
454:
455:
456: -- here's the delegated call to the old PL/SQL routine
457: cn_user_access_pvt.get_accesses(p_range_low,
458: p_range_high,
459: x_total_rows,
460: ddx_result_tbl);
461:

Line 466: cn_user_access_pvt_w.rosetta_table_copy_out_p3(ddx_result_tbl, p3_a0

462: -- copy data back from the local variables to OUT or IN-OUT args, if any
463:
464:
465:
466: cn_user_access_pvt_w.rosetta_table_copy_out_p3(ddx_result_tbl, p3_a0
467: , p3_a1
468: , p3_a2
469: );
470: end;

Line 498: ddx_result_tbl cn_user_access_pvt.user_access_tbl_type;

494: , p1_a21 out nocopy JTF_NUMBER_TABLE
495: )
496:
497: as
498: ddx_result_tbl cn_user_access_pvt.user_access_tbl_type;
499: ddindx binary_integer; indx binary_integer;
500: begin
501:
502: -- copy data to the local IN or IN-OUT args, if any

Line 506: cn_user_access_pvt.get_access_details(p_user_id,

502: -- copy data to the local IN or IN-OUT args, if any
503:
504:
505: -- here's the delegated call to the old PL/SQL routine
506: cn_user_access_pvt.get_access_details(p_user_id,
507: ddx_result_tbl);
508:
509: -- copy data back from the local variables to OUT or IN-OUT args, if any
510:

Line 511: cn_user_access_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p1_a0

507: ddx_result_tbl);
508:
509: -- copy data back from the local variables to OUT or IN-OUT args, if any
510:
511: cn_user_access_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p1_a0
512: , p1_a1
513: , p1_a2
514: , p1_a3
515: , p1_a4

Line 536: end cn_user_access_pvt_w;

532: , p1_a21
533: );
534: end;
535:
536: end cn_user_access_pvt_w;