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_COMPLETIONS_PVT_W dependencies on AHL_COMPLETIONS_PVT

Line 1: package body ahl_completions_pvt_w as

1: package body ahl_completions_pvt_w as
2: /* $Header: AHLWPRCB.pls 120.5.12020000.2 2012/12/14 03:38:46 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_completions_pvt.workorder_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_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE

Line 220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE

216: end if;
217: end if;
218: end rosetta_table_copy_out_p1;
219:
220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE

Line 269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

265: end loop;
266: end if;
267: end if;
268: end rosetta_table_copy_in_p3;
269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE

Line 368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE

364: end if;
365: end if;
366: end rosetta_table_copy_out_p3;
367:
368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE

Line 409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

405: end loop;
406: end if;
407: end if;
408: end rosetta_table_copy_in_p7;
409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE

Line 488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE

484: end if;
485: end if;
486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE

Line 521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

517: end loop;
518: end if;
519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE

Line 580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as

576: end if;
577: end if;
578: end rosetta_table_copy_out_p9;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as
581: ddindx binary_integer; indx binary_integer;
582: begin
583: if a0 is not null and a0.count > 0 then
584: if a0.count > 0 then

Line 598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

594: end loop;
595: end if;
596: end if;
597: end rosetta_table_copy_in_p10;
598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
599: ddindx binary_integer; indx binary_integer;
600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();

Line 621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE

617: end if;
618: end if;
619: end rosetta_table_copy_out_p10;
620:
621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE

Line 666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

662: end loop;
663: end if;
664: end if;
665: end rosetta_table_copy_in_p18;
666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE

Line 779: ddp_x_mr_rec ahl_completions_pvt.mr_rec_type;

775: , p9_a11 in out nocopy DATE
776: )
777:
778: as
779: ddp_x_mr_rec ahl_completions_pvt.mr_rec_type;
780: ddindx binary_integer; indx binary_integer;
781: begin
782:
783: -- copy data to the local IN or IN-OUT args, if any

Line 807: ahl_completions_pvt.complete_mr_instance(p_api_version,

803: ddp_x_mr_rec.item_instance_id := p9_a10;
804: ddp_x_mr_rec.actual_end_date := rosetta_g_miss_date_in_map(p9_a11);
805:
806: -- here's the delegated call to the old PL/SQL routine
807: ahl_completions_pvt.complete_mr_instance(p_api_version,
808: p_init_msg_list,
809: p_commit,
810: p_validation_level,
811: p_default,

Line 866: ddp_signoff_mr_rec ahl_completions_pvt.signoff_mr_rec_type;

862: , p9_a11 VARCHAR2
863: )
864:
865: as
866: ddp_signoff_mr_rec ahl_completions_pvt.signoff_mr_rec_type;
867: ddindx binary_integer; indx binary_integer;
868: begin
869:
870: -- copy data to the local IN or IN-OUT args, if any

Line 894: ahl_completions_pvt.signoff_mr_instance(p_api_version,

890: ddp_signoff_mr_rec.employee_number := p9_a10;
891: ddp_signoff_mr_rec.serial_number := p9_a11;
892:
893: -- here's the delegated call to the old PL/SQL routine
894: ahl_completions_pvt.signoff_mr_instance(p_api_version,
895: p_init_msg_list,
896: p_commit,
897: p_validation_level,
898: p_default,

Line 942: ddp_close_visit_rec ahl_completions_pvt.close_visit_rec_type;

938: , p9_a12 VARCHAR2
939: )
940:
941: as
942: ddp_close_visit_rec ahl_completions_pvt.close_visit_rec_type;
943: ddindx binary_integer; indx binary_integer;
944: begin
945:
946: -- copy data to the local IN or IN-OUT args, if any

Line 971: ahl_completions_pvt.close_visit(p_api_version,

967: ddp_close_visit_rec.serial_number := p9_a11;
968: ddp_close_visit_rec.check_unit_complete_flag := p9_a12;
969:
970: -- here's the delegated call to the old PL/SQL routine
971: ahl_completions_pvt.close_visit(p_api_version,
972: p_init_msg_list,
973: p_commit,
974: p_validation_level,
975: p_default,

Line 1016: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;

1012: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1013: )
1014:
1015: as
1016: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1019:
1020: -- copy data to the local IN or IN-OUT args, if any

Line 1024: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p3_a0

1020: -- copy data to the local IN or IN-OUT args, if any
1021:
1022:
1023:
1024: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p3_a0
1025: , p3_a1
1026: , p3_a2
1027: , p3_a3
1028: , p3_a4

Line 1043: ahl_completions_pvt.get_default_op_actual_dates(x_return_status,

1039: , p3_a15
1040: );
1041:
1042: -- here's the delegated call to the old PL/SQL routine
1043: ahl_completions_pvt.get_default_op_actual_dates(x_return_status,
1044: x_msg_count,
1045: x_msg_data,
1046: ddp_x_operation_tbl);
1047:

Line 1052: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p3_a0

1048: -- copy data back from the local variables to OUT or IN-OUT args, if any
1049:
1050:
1051:
1052: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p3_a0
1053: , p3_a1
1054: , p3_a2
1055: , p3_a3
1056: , p3_a4

Line 1091: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;

1087: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1088: )
1089:
1090: as
1091: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;
1092: ddindx binary_integer; indx binary_integer;
1093: begin
1094:
1095: -- copy data to the local IN or IN-OUT args, if any

Line 1097: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p1_a0

1093: begin
1094:
1095: -- copy data to the local IN or IN-OUT args, if any
1096:
1097: ahl_completions_pvt_w.rosetta_table_copy_in_p3(ddp_x_operation_tbl, p1_a0
1098: , p1_a1
1099: , p1_a2
1100: , p1_a3
1101: , p1_a4

Line 1116: ahl_completions_pvt.get_op_actual_dates(x_return_status,

1112: , p1_a15
1113: );
1114:
1115: -- here's the delegated call to the old PL/SQL routine
1116: ahl_completions_pvt.get_op_actual_dates(x_return_status,
1117: ddp_x_operation_tbl);
1118:
1119: -- copy data back from the local variables to OUT or IN-OUT args, if any
1120:

Line 1121: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p1_a0

1117: ddp_x_operation_tbl);
1118:
1119: -- copy data back from the local variables to OUT or IN-OUT args, if any
1120:
1121: ahl_completions_pvt_w.rosetta_table_copy_out_p3(ddp_x_operation_tbl, p1_a0
1122: , p1_a1
1123: , p1_a2
1124: , p1_a3
1125: , p1_a4

Line 1161: ddrosetta_retval := ahl_completions_pvt.is_signoff_date_overlapping(ddp_actual_start_date,

1157:
1158:
1159:
1160: -- here's the delegated call to the old PL/SQL routine
1161: ddrosetta_retval := ahl_completions_pvt.is_signoff_date_overlapping(ddp_actual_start_date,
1162: ddp_actual_end_date,
1163: p_unit_effectivity_id,
1164: p_visit_id);
1165:

Line 1189: ddx_counter_tbl ahl_completions_pvt.counter_tbl_type;

1185: ) return varchar2
1186:
1187: as
1188: ddp_actual_date date;
1189: ddx_counter_tbl ahl_completions_pvt.counter_tbl_type;
1190: ddindx binary_integer; indx binary_integer;
1191: ddrosetta_retval varchar2(4000);
1192: begin
1193:

Line 1201: ddrosetta_retval := ahl_completions_pvt.get_reset_counters(p_mr_header_id,

1197: ddp_actual_date := rosetta_g_miss_date_in_map(p_actual_date);
1198:
1199:
1200: -- here's the delegated call to the old PL/SQL routine
1201: ddrosetta_retval := ahl_completions_pvt.get_reset_counters(p_mr_header_id,
1202: p_item_instance_id,
1203: ddp_actual_date,
1204: ddx_counter_tbl);
1205:

Line 1210: ahl_completions_pvt_w.rosetta_table_copy_out_p9(ddx_counter_tbl, p3_a0

1206: -- copy data back from the local variables to OUT or IN-OUT args, if any
1207:
1208:
1209:
1210: ahl_completions_pvt_w.rosetta_table_copy_out_p9(ddx_counter_tbl, p3_a0
1211: , p3_a1
1212: , p3_a2
1213: , p3_a3
1214: , p3_a4

Line 1249: ddp_mr_rec ahl_completions_pvt.mr_rec_type;

1245: , x_msg_data out nocopy VARCHAR2
1246: ) return varchar2
1247:
1248: as
1249: ddp_mr_rec ahl_completions_pvt.mr_rec_type;
1250: ddp_x_counter_tbl ahl_completions_pvt.counter_tbl_type;
1251: ddp_actual_end_date date;
1252: ddindx binary_integer; indx binary_integer;
1253: ddrosetta_retval varchar2(4000);

Line 1250: ddp_x_counter_tbl ahl_completions_pvt.counter_tbl_type;

1246: ) return varchar2
1247:
1248: as
1249: ddp_mr_rec ahl_completions_pvt.mr_rec_type;
1250: ddp_x_counter_tbl ahl_completions_pvt.counter_tbl_type;
1251: ddp_actual_end_date date;
1252: ddindx binary_integer; indx binary_integer;
1253: ddrosetta_retval varchar2(4000);
1254: begin

Line 1270: ahl_completions_pvt_w.rosetta_table_copy_in_p9(ddp_x_counter_tbl, p1_a0

1266: ddp_mr_rec.qa_collection_id := p0_a9;
1267: ddp_mr_rec.item_instance_id := p0_a10;
1268: ddp_mr_rec.actual_end_date := rosetta_g_miss_date_in_map(p0_a11);
1269:
1270: ahl_completions_pvt_w.rosetta_table_copy_in_p9(ddp_x_counter_tbl, p1_a0
1271: , p1_a1
1272: , p1_a2
1273: , p1_a3
1274: , p1_a4

Line 1285: ddrosetta_retval := ahl_completions_pvt.reset_counters(ddp_mr_rec,

1281:
1282:
1283:
1284: -- here's the delegated call to the old PL/SQL routine
1285: ddrosetta_retval := ahl_completions_pvt.reset_counters(ddp_mr_rec,
1286: ddp_x_counter_tbl,
1287: ddp_actual_end_date,
1288: x_msg_count,
1289: x_msg_data);

Line 1293: ahl_completions_pvt_w.rosetta_table_copy_out_p9(ddp_x_counter_tbl, p1_a0

1289: x_msg_data);
1290:
1291: -- copy data back from the local variables to OUT or IN-OUT args, if any
1292:
1293: ahl_completions_pvt_w.rosetta_table_copy_out_p9(ddp_x_counter_tbl, p1_a0
1294: , p1_a1
1295: , p1_a2
1296: , p1_a3
1297: , p1_a4

Line 1324: ddx_counter_tbl ahl_completions_pvt.counter_tbl_type;

1320: ) return varchar2
1321:
1322: as
1323: ddp_actual_date date;
1324: ddx_counter_tbl ahl_completions_pvt.counter_tbl_type;
1325: ddindx binary_integer; indx binary_integer;
1326: ddrosetta_retval varchar2(4000);
1327: begin
1328:

Line 1336: ddrosetta_retval := ahl_completions_pvt.get_cp_counters(p_item_instance_id,

1332: ddp_actual_date := rosetta_g_miss_date_in_map(p_actual_date);
1333:
1334:
1335: -- here's the delegated call to the old PL/SQL routine
1336: ddrosetta_retval := ahl_completions_pvt.get_cp_counters(p_item_instance_id,
1337: p_wip_entity_id,
1338: ddp_actual_date,
1339: ddx_counter_tbl);
1340:

Line 1345: ahl_completions_pvt_w.rosetta_table_copy_out_p9(ddx_counter_tbl, p3_a0

1341: -- copy data back from the local variables to OUT or IN-OUT args, if any
1342:
1343:
1344:
1345: ahl_completions_pvt_w.rosetta_table_copy_out_p9(ddx_counter_tbl, p3_a0
1346: , p3_a1
1347: , p3_a2
1348: , p3_a3
1349: , p3_a4

Line 1376: ddp_counter_tbl ahl_completions_pvt.counter_tbl_type;

1372: ) return varchar2
1373:
1374: as
1375: ddp_actual_end_date date;
1376: ddp_counter_tbl ahl_completions_pvt.counter_tbl_type;
1377: ddindx binary_integer; indx binary_integer;
1378: ddrosetta_retval varchar2(4000);
1379: begin
1380:

Line 1386: ahl_completions_pvt_w.rosetta_table_copy_in_p9(ddp_counter_tbl, p3_a0

1382:
1383:
1384: ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1385:
1386: ahl_completions_pvt_w.rosetta_table_copy_in_p9(ddp_counter_tbl, p3_a0
1387: , p3_a1
1388: , p3_a2
1389: , p3_a3
1390: , p3_a4

Line 1400: ddrosetta_retval := ahl_completions_pvt.update_ump(p_unit_effectivity_id,

1396:
1397:
1398:
1399: -- here's the delegated call to the old PL/SQL routine
1400: ddrosetta_retval := ahl_completions_pvt.update_ump(p_unit_effectivity_id,
1401: p_ue_object_version,
1402: ddp_actual_end_date,
1403: ddp_counter_tbl,
1404: p_dml_flag,

Line 1419: end ahl_completions_pvt_w;

1415:
1416: return ddrosetta_retval;
1417: end;
1418:
1419: end ahl_completions_pvt_w;