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:
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:
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
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
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
651: );
652:
653: end;
654:
655: end cn_reasons_pub_w;