DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT_W dependencies on AHL_UC_INSTANCE_PVT

Line 1: package body ahl_uc_instance_pvt_w as

1: package body ahl_uc_instance_pvt_w as
2: /* $Header: AHLWUCIB.pls 120.5.12020000.2 2012/12/14 06:59:28 shnatu ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ahl_uc_instance_pvt_w as
2: /* $Header: AHLWUCIB.pls 120.5.12020000.2 2012/12/14 06:59:28 shnatu ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 30: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

26: end loop;
27: end if;
28: end if;
29: end rosetta_table_copy_in_p3;
30: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100

70: end if;
71: end if;
72: end rosetta_table_copy_out_p3;
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_NUMBER_TABLE

Line 105: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

101: end loop;
102: end if;
103: end if;
104: end rosetta_table_copy_in_p5;
105: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_NUMBER_TABLE

Line 159: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE

155: end if;
156: end if;
157: end rosetta_table_copy_out_p5;
158:
159: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100

Line 254: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

250: end loop;
251: end if;
252: end if;
253: end rosetta_table_copy_in_p7;
254: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
255: , a1 out nocopy JTF_NUMBER_TABLE
256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 528: ddp_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;

524: , p_prod_user_flag VARCHAR2
525: )
526:
527: as
528: ddp_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
529: ddindx binary_integer; indx binary_integer;
530: begin
531:
532: -- copy data to the local IN or IN-OUT args, if any

Line 592: ahl_uc_instance_pvt.update_instance_attr(p_api_version,

588: ddp_uc_instance_rec.attribute30 := p8_a47;
589:
590:
591: -- here's the delegated call to the old PL/SQL routine
592: ahl_uc_instance_pvt.update_instance_attr(p_api_version,
593: p_init_msg_list,
594: p_commit,
595: p_validation_level,
596: x_return_status,

Line 706: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;

702: , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
703: )
704:
705: as
706: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
707: ddp_x_sub_uc_rec ahl_uc_instance_pvt.uc_header_rec_type;
708: ddx_warning_msg_tbl ahl_uc_validation_pub.error_tbl_type;
709: ddindx binary_integer; indx binary_integer;
710: begin

Line 707: ddp_x_sub_uc_rec ahl_uc_instance_pvt.uc_header_rec_type;

703: )
704:
705: as
706: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
707: ddp_x_sub_uc_rec ahl_uc_instance_pvt.uc_header_rec_type;
708: ddx_warning_msg_tbl ahl_uc_validation_pub.error_tbl_type;
709: ddindx binary_integer; indx binary_integer;
710: begin
711:

Line 804: ahl_uc_instance_pvt.install_new_instance(p_api_version,

800: ddp_x_sub_uc_rec.attribute15 := p11_a28;
801:
802:
803: -- here's the delegated call to the old PL/SQL routine
804: ahl_uc_instance_pvt.install_new_instance(p_api_version,
805: p_init_msg_list,
806: p_commit,
807: p_validation_level,
808: x_return_status,

Line 952: ahl_uc_instance_pvt.install_existing_instance(p_api_version,

948:
949:
950:
951: -- here's the delegated call to the old PL/SQL routine
952: ahl_uc_instance_pvt.install_existing_instance(p_api_version,
953: p_init_msg_list,
954: p_commit,
955: p_validation_level,
956: x_return_status,

Line 1029: ahl_uc_instance_pvt.swap_instance(p_api_version,

1025:
1026:
1027:
1028: -- here's the delegated call to the old PL/SQL routine
1029: ahl_uc_instance_pvt.swap_instance(p_api_version,
1030: p_init_msg_list,
1031: p_commit,
1032: p_validation_level,
1033: x_return_status,

Line 1122: ddx_available_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;

1118: , x_tbl_count out nocopy NUMBER
1119: )
1120:
1121: as
1122: ddx_available_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:
1126: -- copy data to the local IN or IN-OUT args, if any

Line 1144: ahl_uc_instance_pvt.get_available_instances(p_api_version,

1140:
1141:
1142:
1143: -- here's the delegated call to the old PL/SQL routine
1144: ahl_uc_instance_pvt.get_available_instances(p_api_version,
1145: p_init_msg_list,
1146: p_validation_level,
1147: x_return_status,
1148: x_msg_count,

Line 1176: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_available_instance_tbl, p14_a0

1172:
1173:
1174:
1175:
1176: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_available_instance_tbl, p14_a0
1177: , p14_a1
1178: , p14_a2
1179: , p14_a3
1180: , p14_a4

Line 1274: ddx_avail_subinv_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;

1270: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1271: )
1272:
1273: as
1274: ddx_avail_subinv_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;
1275: ddindx binary_integer; indx binary_integer;
1276: begin
1277:
1278: -- copy data to the local IN or IN-OUT args, if any

Line 1294: ahl_uc_instance_pvt.get_avail_subinv_instances(p_api_version,

1290:
1291:
1292:
1293: -- here's the delegated call to the old PL/SQL routine
1294: ahl_uc_instance_pvt.get_avail_subinv_instances(p_api_version,
1295: p_init_msg_list,
1296: p_validation_level,
1297: x_return_status,
1298: x_msg_count,

Line 1323: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_avail_subinv_instance_tbl, p13_a0

1319:
1320:
1321:
1322:
1323: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_avail_subinv_instance_tbl, p13_a0
1324: , p13_a1
1325: , p13_a2
1326: , p13_a3
1327: , p13_a4

Line 1424: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;

1420: , p8_a47 in out nocopy VARCHAR2
1421: )
1422:
1423: as
1424: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
1425: ddindx binary_integer; indx binary_integer;
1426: begin
1427:
1428: -- copy data to the local IN or IN-OUT args, if any

Line 1487: ahl_uc_instance_pvt.create_unassigned_instance(p_api_version,

1483: ddp_x_uc_instance_rec.attribute29 := p8_a46;
1484: ddp_x_uc_instance_rec.attribute30 := p8_a47;
1485:
1486: -- here's the delegated call to the old PL/SQL routine
1487: ahl_uc_instance_pvt.create_unassigned_instance(p_api_version,
1488: p_init_msg_list,
1489: p_commit,
1490: p_validation_level,
1491: x_return_status,

Line 1556: end ahl_uc_instance_pvt_w;

1552: p8_a46 := ddp_x_uc_instance_rec.attribute29;
1553: p8_a47 := ddp_x_uc_instance_rec.attribute30;
1554: end;
1555:
1556: end ahl_uc_instance_pvt_w;