APPS.CN_REASONS_PUB_W dependencies on CN_REASONS_PUB

Line 1: package body cn_reasons_pub_w as

1: package body cn_reasons_pub_w as
2: /* $Header: cnwresnb.pls 115.3 2003/07/04 01:44:16 jjhuang 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_p2(t out nocopy cn_reasons_pub.notes_tbl, 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_p2(t out nocopy cn_reasons_pub.notes_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_4000

Line 90: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE

86: end loop;
87: end if;
88: end if;
89: end rosetta_table_copy_in_p2;
90: procedure rosetta_table_copy_out_p2(t cn_reasons_pub.notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_VARCHAR2_TABLE_100
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_VARCHAR2_TABLE_4000

Line 320: ddx_worksheet_rec cn_reasons_pub.worksheet_rec;

316: , x_notes_count out nocopy NUMBER
317: )
318:
319: as
320: ddx_worksheet_rec cn_reasons_pub.worksheet_rec;
321: ddx_notes_tbl cn_reasons_pub.notes_tbl;
322: ddindx binary_integer; indx binary_integer;
323: begin
324:

Line 321: ddx_notes_tbl cn_reasons_pub.notes_tbl;

317: )
318:
319: as
320: ddx_worksheet_rec cn_reasons_pub.worksheet_rec;
321: ddx_notes_tbl cn_reasons_pub.notes_tbl;
322: ddindx binary_integer; indx binary_integer;
323: begin
324:
325: -- copy data to the local IN or IN-OUT args, if any

Line 343: cn_reasons_pub.show_analyst_notes(p_api_version,

339:
340:
341:
342: -- here's the delegated call to the old PL/SQL routine
343: cn_reasons_pub.show_analyst_notes(p_api_version,
344: p_init_msg_list,
345: p_validation_level,
346: p_commit,
347: p_first,

Line 389: cn_reasons_pub_w.rosetta_table_copy_out_p2(ddx_notes_tbl, p14_a0

385: p13_a11 := ddx_worksheet_rec.employee_number;
386: p13_a12 := ddx_worksheet_rec.pay_group_id;
387: p13_a13 := ddx_worksheet_rec.pay_group_name;
388:
389: cn_reasons_pub_w.rosetta_table_copy_out_p2(ddx_notes_tbl, p14_a0
390: , p14_a1
391: , p14_a2
392: , p14_a3
393: , p14_a4

Line 464: ddp_notes_tbl cn_reasons_pub.notes_tbl;

460: , x_loading_status out nocopy VARCHAR2
461: )
462:
463: as
464: ddp_notes_tbl cn_reasons_pub.notes_tbl;
465: ddindx binary_integer; indx binary_integer;
466: begin
467:
468: -- copy data to the local IN or IN-OUT args, if any

Line 473: cn_reasons_pub_w.rosetta_table_copy_in_p2(ddp_notes_tbl, p4_a0

469:
470:
471:
472:
473: cn_reasons_pub_w.rosetta_table_copy_in_p2(ddp_notes_tbl, p4_a0
474: , p4_a1
475: , p4_a2
476: , p4_a3
477: , p4_a4

Line 510: cn_reasons_pub.manage_analyst_notes(p_api_version,

506:
507:
508:
509: -- here's the delegated call to the old PL/SQL routine
510: cn_reasons_pub.manage_analyst_notes(p_api_version,
511: p_init_msg_list,
512: p_validation_level,
513: p_commit,
514: ddp_notes_tbl,

Line 576: ddx_notes_tbl cn_reasons_pub.notes_tbl;

572: , x_notes_count out nocopy NUMBER
573: )
574:
575: as
576: ddx_notes_tbl cn_reasons_pub.notes_tbl;
577: ddindx binary_integer; indx binary_integer;
578: begin
579:
580: -- copy data to the local IN or IN-OUT args, if any

Line 595: cn_reasons_pub.show_last_analyst_note(p_api_version,

591:
592:
593:
594: -- here's the delegated call to the old PL/SQL routine
595: cn_reasons_pub.show_last_analyst_note(p_api_version,
596: p_init_msg_list,
597: p_validation_level,
598: p_commit,
599: p_payment_worksheet_id,

Line 621: cn_reasons_pub_w.rosetta_table_copy_out_p2(ddx_notes_tbl, p11_a0

617:
618:
619:
620:
621: cn_reasons_pub_w.rosetta_table_copy_out_p2(ddx_notes_tbl, p11_a0
622: , p11_a1
623: , p11_a2
624: , p11_a3
625: , p11_a4

Line 655: end cn_reasons_pub_w;

651: );
652:
653: end;
654:
655: end cn_reasons_pub_w;