DBA Data[Home] [Help]

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.8.12020000.2 2012/12/14 05:49:44 shnatu 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_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 273: procedure rosetta_table_copy_out_p2(t ahl_vwp_proj_prod_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

269: end loop;
270: end if;
271: end if;
272: end rosetta_table_copy_in_p2;
273: procedure rosetta_table_copy_out_p2(t ahl_vwp_proj_prod_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
274: , a1 out nocopy JTF_NUMBER_TABLE
275: , a2 out nocopy JTF_NUMBER_TABLE
276: , a3 out nocopy JTF_VARCHAR2_TABLE_100
277: , a4 out nocopy JTF_NUMBER_TABLE

Line 781: ddx_error_tbl ahl_vwp_proj_prod_pvt.error_tbl_type;

777: , x_msg_data out nocopy VARCHAR2
778: )
779:
780: as
781: ddx_error_tbl ahl_vwp_proj_prod_pvt.error_tbl_type;
782: ddindx binary_integer; indx binary_integer;
783: begin
784:
785: -- copy data to the local IN or IN-OUT args, if any

Line 797: ahl_vwp_proj_prod_pvt.validate_before_production(p_api_version,

793:
794:
795:
796: -- here's the delegated call to the old PL/SQL routine
797: ahl_vwp_proj_prod_pvt.validate_before_production(p_api_version,
798: p_init_msg_list,
799: p_commit,
800: p_validation_level,
801: p_module_type,

Line 815: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p1(ddx_error_tbl, p6_a0

811:
812:
813:
814:
815: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p1(ddx_error_tbl, p6_a0
816: , p6_a1
817: );
818:
819:

Line 929: ddp_x_task_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;

925: , x_msg_data out nocopy VARCHAR2
926: )
927:
928: as
929: ddp_x_task_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;
930: ddindx binary_integer; indx binary_integer;
931: begin
932:
933: -- copy data to the local IN or IN-OUT args, if any

Line 939: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_x_task_tbl, p5_a0

935:
936:
937:
938:
939: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_x_task_tbl, p5_a0
940: , p5_a1
941: , p5_a2
942: , p5_a3
943: , p5_a4

Line 1040: ahl_vwp_proj_prod_pvt.create_job_tasks(p_api_version,

1036:
1037:
1038:
1039: -- here's the delegated call to the old PL/SQL routine
1040: ahl_vwp_proj_prod_pvt.create_job_tasks(p_api_version,
1041: p_init_msg_list,
1042: p_commit,
1043: p_validation_level,
1044: p_module_type,

Line 1056: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p2(ddp_x_task_tbl, p5_a0

1052:
1053:
1054:
1055:
1056: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_out_p2(ddp_x_task_tbl, p5_a0
1057: , p5_a1
1058: , p5_a2
1059: , p5_a3
1060: , p5_a4

Line 1265: ddp_tasks_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;

1261: , x_msg_data out nocopy VARCHAR2
1262: )
1263:
1264: as
1265: ddp_tasks_tbl ahl_vwp_proj_prod_pvt.task_tbl_type;
1266: ddindx binary_integer; indx binary_integer;
1267: begin
1268:
1269: -- copy data to the local IN or IN-OUT args, if any

Line 1276: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_tasks_tbl, p6_a0

1272:
1273:
1274:
1275:
1276: ahl_vwp_proj_prod_pvt_w.rosetta_table_copy_in_p2(ddp_tasks_tbl, p6_a0
1277: , p6_a1
1278: , p6_a2
1279: , p6_a3
1280: , p6_a4

Line 1378: ahl_vwp_proj_prod_pvt.release_tasks(p_api_version,

1374:
1375:
1376:
1377: -- here's the delegated call to the old PL/SQL routine
1378: ahl_vwp_proj_prod_pvt.release_tasks(p_api_version,
1379: p_init_msg_list,
1380: p_commit,
1381: p_validation_level,
1382: p_module_type,

Line 1632: ahl_vwp_proj_prod_pvt.update_project_task_times(ddp_prd_workorder_tbl,

1628:
1629:
1630:
1631: -- here's the delegated call to the old PL/SQL routine
1632: ahl_vwp_proj_prod_pvt.update_project_task_times(ddp_prd_workorder_tbl,
1633: p_commit,
1634: x_return_status,
1635: x_msg_count,
1636: x_msg_data);

Line 1730: ahl_vwp_proj_prod_pvt.push_stages_to_production(p_api_version,

1726:
1727:
1728:
1729: -- here's the delegated call to the old PL/SQL routine
1730: ahl_vwp_proj_prod_pvt.push_stages_to_production(p_api_version,
1731: p_init_msg_list,
1732: p_commit,
1733: p_validation_level,
1734: p_module_type,

Line 1755: end ahl_vwp_proj_prod_pvt_w;

1751:
1752:
1753: end;
1754:
1755: end ahl_vwp_proj_prod_pvt_w;