eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.2.12010000.4 2008/11/20 11:47:49 sathapli 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_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

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

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p3;
43: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_NUMBER_TABLE
46: , a3 out nocopy JTF_VARCHAR2_TABLE_100
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

83: end if;
84: end if;
85: end rosetta_table_copy_out_p3;
86:
87: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_NUMBER_TABLE
90: , a3 JTF_NUMBER_TABLE
91: , a4 JTF_NUMBER_TABLE

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

114: end loop;
115: end if;
116: end if;
117: end rosetta_table_copy_in_p5;
118: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_NUMBER_TABLE

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

168: end if;
169: end if;
170: end rosetta_table_copy_out_p5;
171:
172: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100

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

263: end loop;
264: end if;
265: end if;
266: end rosetta_table_copy_in_p7;
267: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
268: , a1 out nocopy JTF_NUMBER_TABLE
269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 541: ddp_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;

537: , p_prod_user_flag VARCHAR2
538: )
539:
540: as
541: ddp_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
542: ddindx binary_integer; indx binary_integer;
543: begin
544:
545: -- copy data to the local IN or IN-OUT args, if any

Line 605: ahl_uc_instance_pvt.update_instance_attr(p_api_version,

601: ddp_uc_instance_rec.attribute30 := p8_a47;
602:
603:
604: -- here's the delegated call to the old PL/SQL routine
605: ahl_uc_instance_pvt.update_instance_attr(p_api_version,
606: p_init_msg_list,
607: p_commit,
608: p_validation_level,
609: x_return_status,

Line 719: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;

715: , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
716: )
717:
718: as
719: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
720: ddp_x_sub_uc_rec ahl_uc_instance_pvt.uc_header_rec_type;
721: ddx_warning_msg_tbl ahl_uc_validation_pub.error_tbl_type;
722: ddindx binary_integer; indx binary_integer;
723: begin

Line 720: ddp_x_sub_uc_rec ahl_uc_instance_pvt.uc_header_rec_type;

716: )
717:
718: as
719: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
720: ddp_x_sub_uc_rec ahl_uc_instance_pvt.uc_header_rec_type;
721: ddx_warning_msg_tbl ahl_uc_validation_pub.error_tbl_type;
722: ddindx binary_integer; indx binary_integer;
723: begin
724:

Line 817: ahl_uc_instance_pvt.install_new_instance(p_api_version,

813: ddp_x_sub_uc_rec.attribute15 := p11_a28;
814:
815:
816: -- here's the delegated call to the old PL/SQL routine
817: ahl_uc_instance_pvt.install_new_instance(p_api_version,
818: p_init_msg_list,
819: p_commit,
820: p_validation_level,
821: x_return_status,

Line 963: ahl_uc_instance_pvt.install_existing_instance(p_api_version,

959:
960:
961:
962: -- here's the delegated call to the old PL/SQL routine
963: ahl_uc_instance_pvt.install_existing_instance(p_api_version,
964: p_init_msg_list,
965: p_commit,
966: p_validation_level,
967: x_return_status,

Line 1038: ahl_uc_instance_pvt.swap_instance(p_api_version,

1034:
1035:
1036:
1037: -- here's the delegated call to the old PL/SQL routine
1038: ahl_uc_instance_pvt.swap_instance(p_api_version,
1039: p_init_msg_list,
1040: p_commit,
1041: p_validation_level,
1042: x_return_status,

Line 1131: ddx_available_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;

1127: , x_tbl_count out nocopy NUMBER
1128: )
1129:
1130: as
1131: ddx_available_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;
1132: ddindx binary_integer; indx binary_integer;
1133: begin
1134:
1135: -- copy data to the local IN or IN-OUT args, if any

Line 1153: ahl_uc_instance_pvt.get_available_instances(p_api_version,

1149:
1150:
1151:
1152: -- here's the delegated call to the old PL/SQL routine
1153: ahl_uc_instance_pvt.get_available_instances(p_api_version,
1154: p_init_msg_list,
1155: p_validation_level,
1156: x_return_status,
1157: x_msg_count,

Line 1185: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_available_instance_tbl, p14_a0

1181:
1182:
1183:
1184:
1185: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_available_instance_tbl, p14_a0
1186: , p14_a1
1187: , p14_a2
1188: , p14_a3
1189: , p14_a4

Line 1283: ddx_avail_subinv_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;

1279: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1280: )
1281:
1282: as
1283: ddx_avail_subinv_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;
1284: ddindx binary_integer; indx binary_integer;
1285: begin
1286:
1287: -- copy data to the local IN or IN-OUT args, if any

Line 1303: ahl_uc_instance_pvt.get_avail_subinv_instances(p_api_version,

1299:
1300:
1301:
1302: -- here's the delegated call to the old PL/SQL routine
1303: ahl_uc_instance_pvt.get_avail_subinv_instances(p_api_version,
1304: p_init_msg_list,
1305: p_validation_level,
1306: x_return_status,
1307: x_msg_count,

Line 1332: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_avail_subinv_instance_tbl, p13_a0

1328:
1329:
1330:
1331:
1332: ahl_uc_instance_pvt_w.rosetta_table_copy_out_p7(ddx_avail_subinv_instance_tbl, p13_a0
1333: , p13_a1
1334: , p13_a2
1335: , p13_a3
1336: , p13_a4

Line 1433: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;

1429: , p8_a47 in out nocopy VARCHAR2
1430: )
1431:
1432: as
1433: ddp_x_uc_instance_rec ahl_uc_instance_pvt.uc_instance_rec_type;
1434: ddindx binary_integer; indx binary_integer;
1435: begin
1436:
1437: -- copy data to the local IN or IN-OUT args, if any

Line 1496: ahl_uc_instance_pvt.create_unassigned_instance(p_api_version,

1492: ddp_x_uc_instance_rec.attribute29 := p8_a46;
1493: ddp_x_uc_instance_rec.attribute30 := p8_a47;
1494:
1495: -- here's the delegated call to the old PL/SQL routine
1496: ahl_uc_instance_pvt.create_unassigned_instance(p_api_version,
1497: p_init_msg_list,
1498: p_commit,
1499: p_validation_level,
1500: x_return_status,

Line 1565: end ahl_uc_instance_pvt_w;

1561: p8_a46 := ddp_x_uc_instance_rec.attribute29;
1562: p8_a47 := ddp_x_uc_instance_rec.attribute30;
1563: end;
1564:
1565: end ahl_uc_instance_pvt_w;