DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT_W dependencies on AHL_PRD_NONROUTINE_PVT

Line 1: package body ahl_prd_nonroutine_pvt_w as

1: package body ahl_prd_nonroutine_pvt_w as
2: /* $Header: AHLWPNRB.pls 120.3 2008/01/31 15:13:38 amsriniv 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 JTF_DATE_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 JTF_DATE_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100

Line 127: procedure rosetta_table_copy_out_p2(t ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 out nocopy JTF_DATE_TABLE

123: end loop;
124: end if;
125: end if;
126: end rosetta_table_copy_in_p2;
127: procedure rosetta_table_copy_out_p2(t ahl_prd_nonroutine_pvt.sr_task_tbl_type, a0 out nocopy JTF_DATE_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_VARCHAR2_TABLE_100
130: , a3 out nocopy JTF_NUMBER_TABLE
131: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 381: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 JTF_NUMBER_TABLE

377: end if;
378: end if;
379: end rosetta_table_copy_out_p2;
380:
381: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 JTF_NUMBER_TABLE
382: , a1 JTF_VARCHAR2_TABLE_100
383: , a2 JTF_NUMBER_TABLE
384: , a3 JTF_NUMBER_TABLE
385: , a4 JTF_NUMBER_TABLE

Line 418: procedure rosetta_table_copy_out_p4(t ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

414: end loop;
415: end if;
416: end if;
417: end rosetta_table_copy_in_p4;
418: procedure rosetta_table_copy_out_p4(t ahl_prd_nonroutine_pvt.mr_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
419: , a1 out nocopy JTF_VARCHAR2_TABLE_100
420: , a2 out nocopy JTF_NUMBER_TABLE
421: , a3 out nocopy JTF_NUMBER_TABLE
422: , a4 out nocopy JTF_NUMBER_TABLE

Line 555: ddp_x_sr_task_tbl ahl_prd_nonroutine_pvt.sr_task_tbl_type;

551: , p9_a9 in out nocopy JTF_NUMBER_TABLE
552: )
553:
554: as
555: ddp_x_sr_task_tbl ahl_prd_nonroutine_pvt.sr_task_tbl_type;
556: ddp_x_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;
557: ddindx binary_integer; indx binary_integer;
558: begin
559:

Line 556: ddp_x_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;

552: )
553:
554: as
555: ddp_x_sr_task_tbl ahl_prd_nonroutine_pvt.sr_task_tbl_type;
556: ddp_x_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;
557: ddindx binary_integer; indx binary_integer;
558: begin
559:
560: -- copy data to the local IN or IN-OUT args, if any

Line 569: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p2(ddp_x_sr_task_tbl, p8_a0

565:
566:
567:
568:
569: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p2(ddp_x_sr_task_tbl, p8_a0
570: , p8_a1
571: , p8_a2
572: , p8_a3
573: , p8_a4

Line 618: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p4(ddp_x_mr_asso_tbl, p9_a0

614: , p8_a45
615: , p8_a46
616: );
617:
618: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_in_p4(ddp_x_mr_asso_tbl, p9_a0
619: , p9_a1
620: , p9_a2
621: , p9_a3
622: , p9_a4

Line 631: ahl_prd_nonroutine_pvt.process_nonroutine_job(p_api_version,

627: , p9_a9
628: );
629:
630: -- here's the delegated call to the old PL/SQL routine
631: ahl_prd_nonroutine_pvt.process_nonroutine_job(p_api_version,
632: p_init_msg_list,
633: p_commit,
634: p_validation_level,
635: p_module_type,

Line 651: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p2(ddp_x_sr_task_tbl, p8_a0

647:
648:
649:
650:
651: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p2(ddp_x_sr_task_tbl, p8_a0
652: , p8_a1
653: , p8_a2
654: , p8_a3
655: , p8_a4

Line 700: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p4(ddp_x_mr_asso_tbl, p9_a0

696: , p8_a45
697: , p8_a46
698: );
699:
700: ahl_prd_nonroutine_pvt_w.rosetta_table_copy_out_p4(ddp_x_mr_asso_tbl, p9_a0
701: , p9_a1
702: , p9_a2
703: , p9_a3
704: , p9_a4

Line 713: end ahl_prd_nonroutine_pvt_w;

709: , p9_a9
710: );
711: end;
712:
713: end ahl_prd_nonroutine_pvt_w;