APPS.AHL_VWP_PROJ_PROD_PVT_W dependencies on AHL_VWP_PROJ_PROD_PVT

Line 1: package body ahl_vwp_proj_prod_pvt_w as

1: package body ahl_vwp_proj_prod_pvt_w as
2: /* $Header: AHLWPRDB.pls 120.2 2008/01/16 06:04:43 rnahata noship $ */
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_p1(t out nocopy ahl_vwp_proj_prod_pvt.error_tbl_type, a0 JTF_NUMBER_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_p1(t out nocopy ahl_vwp_proj_prod_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_2000
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin

Line 37: procedure rosetta_table_copy_out_p1(t ahl_vwp_proj_prod_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

33: end loop;
34: end if;
35: end if;
36: end rosetta_table_copy_in_p1;
37: procedure rosetta_table_copy_out_p1(t ahl_vwp_proj_prod_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin

Line 66: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_proj_prod_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE

62: end if;
63: end if;
64: end rosetta_table_copy_out_p1;
65:
66: procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_proj_prod_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE

Line 235: procedure rosetta_table_copy_out_p2(t ahl_vwp_proj_prod_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

231: end loop;
232: end if;
233: end if;
234: end rosetta_table_copy_in_p2;
235: procedure rosetta_table_copy_out_p2(t ahl_vwp_proj_prod_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
236: , a1 out nocopy JTF_NUMBER_TABLE
237: , a2 out nocopy JTF_NUMBER_TABLE
238: , a3 out nocopy JTF_VARCHAR2_TABLE_100
239: , a4 out nocopy JTF_NUMBER_TABLE

Line 648: ddx_error_tbl ahl_vwp_proj_prod_pvt.error_tbl_type;

644: , x_msg_data out nocopy VARCHAR2
645: )
646:
647: as
648: ddx_error_tbl ahl_vwp_proj_prod_pvt.error_tbl_type;
649: ddindx binary_integer; indx binary_integer;
650: begin
651:
652: -- copy data to the local IN or IN-OUT args, if any

Line 664: ahl_vwp_proj_prod_pvt.validate_before_production(p_api_version,

660:
661:
662:
663: -- here's the delegated call to the old PL/SQL routine
664: ahl_vwp_proj_prod_pvt.validate_before_production(p_api_version,
665: p_init_msg_list,
666: p_commit,
667: p_validation_level,
668: p_module_type,

Line 682: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p1(ddx_error_tbl, p6_a0

678:
679:
680:
681:
682: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p1(ddx_error_tbl, p6_a0
683: , p6_a1
684: );
685:
686:

Line 777: ddp_x_task_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;

773: , x_msg_data out nocopy VARCHAR2
774: )
775:
776: as
777: ddp_x_task_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;
778: ddindx binary_integer; indx binary_integer;
779: begin
780:
781: -- copy data to the local IN or IN-OUT args, if any

Line 787: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_x_task_tbl, p5_a0

783:
784:
785:
786:
787: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_x_task_tbl, p5_a0
788: , p5_a1
789: , p5_a2
790: , p5_a3
791: , p5_a4

Line 869: ahl_vwp_proj_prod_pvt.create_job_tasks(p_api_version,

865:
866:
867:
868: -- here's the delegated call to the old PL/SQL routine
869: ahl_vwp_proj_prod_pvt.create_job_tasks(p_api_version,
870: p_init_msg_list,
871: p_commit,
872: p_validation_level,
873: p_module_type,

Line 885: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p2(ddp_x_task_tbl, p5_a0

881:
882:
883:
884:
885: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p2(ddp_x_task_tbl, p5_a0
886: , p5_a1
887: , p5_a2
888: , p5_a3
889: , p5_a4

Line 1056: ddp_tasks_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;

1052: , x_msg_data out nocopy VARCHAR2
1053: )
1054:
1055: as
1056: ddp_tasks_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;
1057: ddindx binary_integer; indx binary_integer;
1058: begin
1059:
1060: -- copy data to the local IN or IN-OUT args, if any

Line 1067: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_tasks_tbl, p6_a0

1063:
1064:
1065:
1066:
1067: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_tasks_tbl, p6_a0
1068: , p6_a1
1069: , p6_a2
1070: , p6_a3
1071: , p6_a4

Line 1150: ahl_vwp_proj_prod_pvt.release_tasks(p_api_version,

1146:
1147:
1148:
1149: -- here's the delegated call to the old PL/SQL routine
1150: ahl_vwp_proj_prod_pvt.release_tasks(p_api_version,
1151: p_init_msg_list,
1152: p_commit,
1153: p_validation_level,
1154: p_module_type,

Line 1175: end ahl_vwp_proj_prod_pvt_w;

1171:
1172:
1173: end;
1174:
1175: end ahl_vwp_proj_prod_pvt_w;