DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT_W dependencies on AHL_PRD_MRSHL_PVT

Line 1: package body ahl_prd_mrshl_pvt_w as

1: package body ahl_prd_mrshl_pvt_w as
2: /* $Header: AHLWPMLB.pls 120.1 2008/02/20 05:05:17 sikumar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_prd_mrshl_pvt_w as
2: /* $Header: AHLWPMLB.pls 120.1 2008/02/20 05:05:17 sikumar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE

Line 92: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_VARCHAR2_TABLE_300
95: , a3 out nocopy JTF_VARCHAR2_TABLE_300
96: , a4 out nocopy JTF_NUMBER_TABLE

Line 291: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE

287: end if;
288: end if;
289: end rosetta_table_copy_out_p2;
290:
291: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
292: , a1 JTF_NUMBER_TABLE
293: , a2 JTF_VARCHAR2_TABLE_300
294: , a3 JTF_VARCHAR2_TABLE_300
295: , a4 JTF_NUMBER_TABLE

Line 388: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

384: end loop;
385: end if;
386: end if;
387: end rosetta_table_copy_in_p4;
388: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
389: , a1 out nocopy JTF_NUMBER_TABLE
390: , a2 out nocopy JTF_VARCHAR2_TABLE_300
391: , a3 out nocopy JTF_VARCHAR2_TABLE_300
392: , a4 out nocopy JTF_NUMBER_TABLE

Line 607: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE

603: end if;
604: end if;
605: end rosetta_table_copy_out_p4;
606:
607: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
608: , a1 JTF_VARCHAR2_TABLE_100
609: , a2 JTF_NUMBER_TABLE
610: , a3 JTF_NUMBER_TABLE
611: , a4 JTF_NUMBER_TABLE

Line 676: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

672: end loop;
673: end if;
674: end if;
675: end rosetta_table_copy_in_p6;
676: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
677: , a1 out nocopy JTF_VARCHAR2_TABLE_100
678: , a2 out nocopy JTF_NUMBER_TABLE
679: , a3 out nocopy JTF_NUMBER_TABLE
680: , a4 out nocopy JTF_NUMBER_TABLE

Line 880: ddp_mrshl_search_rec ahl_prd_mrshl_pvt.mrshl_search_rec_type;

876: , x_msg_data out nocopy VARCHAR2
877: )
878:
879: as
880: ddp_mrshl_search_rec ahl_prd_mrshl_pvt.mrshl_search_rec_type;
881: ddx_unavailable_items_tbl ahl_prd_mrshl_pvt.unavailable_items_tbl_type;
882: ddindx binary_integer; indx binary_integer;
883: begin
884:

Line 881: ddx_unavailable_items_tbl ahl_prd_mrshl_pvt.unavailable_items_tbl_type;

877: )
878:
879: as
880: ddp_mrshl_search_rec ahl_prd_mrshl_pvt.mrshl_search_rec_type;
881: ddx_unavailable_items_tbl ahl_prd_mrshl_pvt.unavailable_items_tbl_type;
882: ddindx binary_integer; indx binary_integer;
883: begin
884:
885: -- copy data to the local IN or IN-OUT args, if any

Line 905: ahl_prd_mrshl_pvt.get_unavailable_items(p_api_version,

901:
902:
903:
904: -- here's the delegated call to the old PL/SQL routine
905: ahl_prd_mrshl_pvt.get_unavailable_items(p_api_version,
906: p_init_msg_list,
907: p_commit,
908: p_validation_level,
909: p_default,

Line 925: ahl_prd_mrshl_pvt_w.rosetta_table_copy_out_p2(ddx_unavailable_items_tbl, p7_a0

921:
922:
923:
924:
925: ahl_prd_mrshl_pvt_w.rosetta_table_copy_out_p2(ddx_unavailable_items_tbl, p7_a0
926: , p7_a1
927: , p7_a2
928: , p7_a3
929: , p7_a4

Line 1026: ddp_mrshl_search_rec ahl_prd_mrshl_pvt.mrshl_search_rec_type;

1022: , x_msg_data out nocopy VARCHAR2
1023: )
1024:
1025: as
1026: ddp_mrshl_search_rec ahl_prd_mrshl_pvt.mrshl_search_rec_type;
1027: ddx_available_items_tbl ahl_prd_mrshl_pvt.available_items_tbl_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin
1030:

Line 1027: ddx_available_items_tbl ahl_prd_mrshl_pvt.available_items_tbl_type;

1023: )
1024:
1025: as
1026: ddp_mrshl_search_rec ahl_prd_mrshl_pvt.mrshl_search_rec_type;
1027: ddx_available_items_tbl ahl_prd_mrshl_pvt.available_items_tbl_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin
1030:
1031: -- copy data to the local IN or IN-OUT args, if any

Line 1051: ahl_prd_mrshl_pvt.get_available_items(p_api_version,

1047:
1048:
1049:
1050: -- here's the delegated call to the old PL/SQL routine
1051: ahl_prd_mrshl_pvt.get_available_items(p_api_version,
1052: p_init_msg_list,
1053: p_commit,
1054: p_validation_level,
1055: p_default,

Line 1071: ahl_prd_mrshl_pvt_w.rosetta_table_copy_out_p4(ddx_available_items_tbl, p7_a0

1067:
1068:
1069:
1070:
1071: ahl_prd_mrshl_pvt_w.rosetta_table_copy_out_p4(ddx_available_items_tbl, p7_a0
1072: , p7_a1
1073: , p7_a2
1074: , p7_a3
1075: , p7_a4

Line 1158: ddx_mrshl_details_tbl ahl_prd_mrshl_pvt.mrshl_details_tbl_type;

1154: , x_msg_data out nocopy VARCHAR2
1155: )
1156:
1157: as
1158: ddx_mrshl_details_tbl ahl_prd_mrshl_pvt.mrshl_details_tbl_type;
1159: ddindx binary_integer; indx binary_integer;
1160: begin
1161:
1162: -- copy data to the local IN or IN-OUT args, if any

Line 1177: ahl_prd_mrshl_pvt.get_mrshl_details(p_api_version,

1173:
1174:
1175:
1176: -- here's the delegated call to the old PL/SQL routine
1177: ahl_prd_mrshl_pvt.get_mrshl_details(p_api_version,
1178: p_init_msg_list,
1179: p_commit,
1180: p_validation_level,
1181: p_default,

Line 1201: ahl_prd_mrshl_pvt_w.rosetta_table_copy_out_p6(ddx_mrshl_details_tbl, p9_a0

1197:
1198:
1199:
1200:
1201: ahl_prd_mrshl_pvt_w.rosetta_table_copy_out_p6(ddx_mrshl_details_tbl, p9_a0
1202: , p9_a1
1203: , p9_a2
1204: , p9_a3
1205: , p9_a4

Line 1233: end ahl_prd_mrshl_pvt_w;

1229:
1230:
1231: end;
1232:
1233: end ahl_prd_mrshl_pvt_w;