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_VWP_RULES_PVT_W dependencies on AHL_VWP_RULES_PVT

Line 1: package body ahl_vwp_rules_pvt_w as

1: package body ahl_vwp_rules_pvt_w as
2: /* $Header: AHLWRULB.pls 120.6.12020000.2 2012/12/14 06:11:57 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_p3(t out nocopy ahl_vwp_rules_pvt.mr_serial_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_p3(t out nocopy ahl_vwp_rules_pvt.mr_serial_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: ) as
20: ddindx binary_integer; indx binary_integer;

Line 39: procedure rosetta_table_copy_out_p3(t ahl_vwp_rules_pvt.mr_serial_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

35: end loop;
36: end if;
37: end if;
38: end rosetta_table_copy_in_p3;
39: procedure rosetta_table_copy_out_p3(t ahl_vwp_rules_pvt.mr_serial_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;

Line 73: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_rules_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE

69: end if;
70: end if;
71: end rosetta_table_copy_out_p3;
72:
73: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_rules_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_NUMBER_TABLE
75: , a2 JTF_NUMBER_TABLE
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_DATE_TABLE

Line 102: procedure rosetta_table_copy_out_p4(t ahl_vwp_rules_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

98: end loop;
99: end if;
100: end if;
101: end rosetta_table_copy_in_p4;
102: procedure rosetta_table_copy_out_p4(t ahl_vwp_rules_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_DATE_TABLE

Line 151: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_rules_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE

147: end if;
148: end if;
149: end rosetta_table_copy_out_p4;
150:
151: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_rules_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE
152: , a1 JTF_NUMBER_TABLE
153: , a2 JTF_NUMBER_TABLE
154: , a3 JTF_VARCHAR2_TABLE_100
155: , a4 JTF_NUMBER_TABLE

Line 358: procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

354: end loop;
355: end if;
356: end if;
357: end rosetta_table_copy_in_p5;
358: procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
359: , a1 out nocopy JTF_NUMBER_TABLE
360: , a2 out nocopy JTF_NUMBER_TABLE
361: , a3 out nocopy JTF_VARCHAR2_TABLE_100
362: , a4 out nocopy JTF_NUMBER_TABLE

Line 908: ahl_vwp_rules_pvt.insert_tasks(p_visit_id,

904:
905:
906:
907: -- here's the delegated call to the old PL/SQL routine
908: ahl_vwp_rules_pvt.insert_tasks(p_visit_id,
909: p_unit_id,
910: p_serial_id,
911: p_service_id,
912: p_dept_id,

Line 962: ddp_mr_serial_tbl ahl_vwp_rules_pvt.mr_serial_tbl_type;

958: , x_return_status out nocopy VARCHAR2
959: )
960:
961: as
962: ddp_mr_serial_tbl ahl_vwp_rules_pvt.mr_serial_tbl_type;
963: ddindx binary_integer; indx binary_integer;
964: begin
965:
966: -- copy data to the local IN or IN-OUT args, if any

Line 969: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p3(ddp_mr_serial_tbl, p2_a0

965:
966: -- copy data to the local IN or IN-OUT args, if any
967:
968:
969: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p3(ddp_mr_serial_tbl, p2_a0
970: , p2_a1
971: , p2_a2
972: );
973:

Line 976: ahl_vwp_rules_pvt.tech_dependency(p_visit_id,

972: );
973:
974:
975: -- here's the delegated call to the old PL/SQL routine
976: ahl_vwp_rules_pvt.tech_dependency(p_visit_id,
977: p_task_type,
978: ddp_mr_serial_tbl,
979: x_return_status);
980:

Line 1031: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id,

1027:
1028:
1029:
1030: -- here's the delegated call to the old PL/SQL routine
1031: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id,
1032: p_unit_id,
1033: p_item_id,
1034: p_org_id,
1035: p_serial_id,

Line 1085: ddp_item_tbl1 ahl_vwp_rules_pvt.item_tbl_type;

1081: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
1082: )
1083:
1084: as
1085: ddp_item_tbl1 ahl_vwp_rules_pvt.item_tbl_type;
1086: ddp_item_tbl2 ahl_vwp_rules_pvt.item_tbl_type;
1087: ddx_item_tbl ahl_vwp_rules_pvt.item_tbl_type;
1088: ddindx binary_integer; indx binary_integer;
1089: begin

Line 1086: ddp_item_tbl2 ahl_vwp_rules_pvt.item_tbl_type;

1082: )
1083:
1084: as
1085: ddp_item_tbl1 ahl_vwp_rules_pvt.item_tbl_type;
1086: ddp_item_tbl2 ahl_vwp_rules_pvt.item_tbl_type;
1087: ddx_item_tbl ahl_vwp_rules_pvt.item_tbl_type;
1088: ddindx binary_integer; indx binary_integer;
1089: begin
1090:

Line 1087: ddx_item_tbl ahl_vwp_rules_pvt.item_tbl_type;

1083:
1084: as
1085: ddp_item_tbl1 ahl_vwp_rules_pvt.item_tbl_type;
1086: ddp_item_tbl2 ahl_vwp_rules_pvt.item_tbl_type;
1087: ddx_item_tbl ahl_vwp_rules_pvt.item_tbl_type;
1088: ddindx binary_integer; indx binary_integer;
1089: begin
1090:
1091: -- copy data to the local IN or IN-OUT args, if any

Line 1092: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p4(ddp_item_tbl1, p0_a0

1088: ddindx binary_integer; indx binary_integer;
1089: begin
1090:
1091: -- copy data to the local IN or IN-OUT args, if any
1092: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p4(ddp_item_tbl1, p0_a0
1093: , p0_a1
1094: , p0_a2
1095: , p0_a3
1096: , p0_a4

Line 1100: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p4(ddp_item_tbl2, p1_a0

1096: , p0_a4
1097: , p0_a5
1098: );
1099:
1100: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p4(ddp_item_tbl2, p1_a0
1101: , p1_a1
1102: , p1_a2
1103: , p1_a3
1104: , p1_a4

Line 1110: ahl_vwp_rules_pvt.merge_for_unique_items(ddp_item_tbl1,

1106: );
1107:
1108:
1109: -- here's the delegated call to the old PL/SQL routine
1110: ahl_vwp_rules_pvt.merge_for_unique_items(ddp_item_tbl1,
1111: ddp_item_tbl2,
1112: ddx_item_tbl);
1113:
1114: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1117: ahl_vwp_rules_pvt_w.rosetta_table_copy_out_p4(ddx_item_tbl, p2_a0

1113:
1114: -- copy data back from the local variables to OUT or IN-OUT args, if any
1115:
1116:
1117: ahl_vwp_rules_pvt_w.rosetta_table_copy_out_p4(ddx_item_tbl, p2_a0
1118: , p2_a1
1119: , p2_a2
1120: , p2_a3
1121: , p2_a4

Line 1225: ddp_task_rec ahl_vwp_rules_pvt.task_rec_type;

1221: , x_return_status out nocopy VARCHAR2
1222: )
1223:
1224: as
1225: ddp_task_rec ahl_vwp_rules_pvt.task_rec_type;
1226: ddindx binary_integer; indx binary_integer;
1227: begin
1228:
1229: -- copy data to the local IN or IN-OUT args, if any

Line 1328: ahl_vwp_rules_pvt.validate_past_task_dates(ddp_task_rec,

1324: ddp_task_rec.repair_batch_name := p0_a94;
1325:
1326:
1327: -- here's the delegated call to the old PL/SQL routine
1328: ahl_vwp_rules_pvt.validate_past_task_dates(ddp_task_rec,
1329: x_return_status);
1330:
1331: -- copy data back from the local variables to OUT or IN-OUT args, if any
1332: p0_a0 := ddp_task_rec.visit_task_id;

Line 1482: ahl_vwp_rules_pvt.get_warranty_rec_for_create(p_task_id,

1478:
1479:
1480:
1481: -- here's the delegated call to the old PL/SQL routine
1482: ahl_vwp_rules_pvt.get_warranty_rec_for_create(p_task_id,
1483: p_instance_id,
1484: p_service_req_id,
1485: ddx_warranty_entl_tbl);
1486:

Line 1664: ddp_task_rec ahl_vwp_rules_pvt.task_rec_type;

1660: , p1_a35 out nocopy JTF_VARCHAR2_TABLE_200
1661: )
1662:
1663: as
1664: ddp_task_rec ahl_vwp_rules_pvt.task_rec_type;
1665: ddx_warranty_entl_tbl ahl_warranty_entl_pvt.warranty_entl_tbl_type;
1666: ddindx binary_integer; indx binary_integer;
1667: begin
1668:

Line 1768: ahl_vwp_rules_pvt.get_warranty_rec_for_update(ddp_task_rec,

1764: ddp_task_rec.repair_batch_name := p0_a94;
1765:
1766:
1767: -- here's the delegated call to the old PL/SQL routine
1768: ahl_vwp_rules_pvt.get_warranty_rec_for_update(ddp_task_rec,
1769: ddx_warranty_entl_tbl);
1770:
1771: -- copy data back from the local variables to OUT or IN-OUT args, if any
1772:

Line 1918: ddp_task_tbl ahl_vwp_rules_pvt.task_tbl_type;

1914: , x_msg_data out nocopy VARCHAR2
1915: )
1916:
1917: as
1918: ddp_task_tbl ahl_vwp_rules_pvt.task_tbl_type;
1919: ddindx binary_integer; indx binary_integer;
1920: begin
1921:
1922: -- copy data to the local IN or IN-OUT args, if any

Line 1928: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl, p5_a0

1924:
1925:
1926:
1927:
1928: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl, p5_a0
1929: , p5_a1
1930: , p5_a2
1931: , p5_a3
1932: , p5_a4

Line 2029: ahl_vwp_rules_pvt.handle_task_dependency(p_api_version,

2025:
2026:
2027:
2028: -- here's the delegated call to the old PL/SQL routine
2029: ahl_vwp_rules_pvt.handle_task_dependency(p_api_version,
2030: p_init_msg_list,
2031: p_commit,
2032: p_validation_level,
2033: p_visit_id,

Line 2155: ddp_task_tbl ahl_vwp_rules_pvt.task_tbl_type;

2151: , x_msg_data out nocopy VARCHAR2
2152: )
2153:
2154: as
2155: ddp_task_tbl ahl_vwp_rules_pvt.task_tbl_type;
2156: ddindx binary_integer; indx binary_integer;
2157: begin
2158:
2159: -- copy data to the local IN or IN-OUT args, if any

Line 2164: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl, p4_a0

2160:
2161:
2162:
2163:
2164: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl, p4_a0
2165: , p4_a1
2166: , p4_a2
2167: , p4_a3
2168: , p4_a4

Line 2265: ahl_vwp_rules_pvt.warranty_not_applicable(p_api_version,

2261:
2262:
2263:
2264: -- here's the delegated call to the old PL/SQL routine
2265: ahl_vwp_rules_pvt.warranty_not_applicable(p_api_version,
2266: p_init_msg_list,
2267: p_commit,
2268: p_validation_level,
2269: ddp_task_tbl,

Line 2389: ddp_task_tbl_type ahl_vwp_rules_pvt.task_tbl_type;

2385: , x_msg_data out nocopy VARCHAR2
2386: )
2387:
2388: as
2389: ddp_task_tbl_type ahl_vwp_rules_pvt.task_tbl_type;
2390: ddindx binary_integer; indx binary_integer;
2391: begin
2392:
2393: -- copy data to the local IN or IN-OUT args, if any

Line 2398: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl_type, p4_a0

2394:
2395:
2396:
2397:
2398: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl_type, p4_a0
2399: , p4_a1
2400: , p4_a2
2401: , p4_a3
2402: , p4_a4

Line 2499: ahl_vwp_rules_pvt.add_return_to_supply(p_api_version,

2495:
2496:
2497:
2498: -- here's the delegated call to the old PL/SQL routine
2499: ahl_vwp_rules_pvt.add_return_to_supply(p_api_version,
2500: p_init_msg_list,
2501: p_commit,
2502: p_validation_level,
2503: ddp_task_tbl_type,

Line 2623: ddp_task_tbl_type ahl_vwp_rules_pvt.task_tbl_type;

2619: , x_msg_data out nocopy VARCHAR2
2620: )
2621:
2622: as
2623: ddp_task_tbl_type ahl_vwp_rules_pvt.task_tbl_type;
2624: ddindx binary_integer; indx binary_integer;
2625: begin
2626:
2627: -- copy data to the local IN or IN-OUT args, if any

Line 2632: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl_type, p4_a0

2628:
2629:
2630:
2631:
2632: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_tbl_type, p4_a0
2633: , p4_a1
2634: , p4_a2
2635: , p4_a3
2636: , p4_a4

Line 2733: ahl_vwp_rules_pvt.remove_return_to_supply(p_api_version,

2729:
2730:
2731:
2732: -- here's the delegated call to the old PL/SQL routine
2733: ahl_vwp_rules_pvt.remove_return_to_supply(p_api_version,
2734: p_init_msg_list,
2735: p_commit,
2736: p_validation_level,
2737: ddp_task_tbl_type,

Line 2859: ddp_tasks_tbl ahl_vwp_rules_pvt.task_tbl_type;

2855: , x_msg_data out nocopy VARCHAR2
2856: )
2857:
2858: as
2859: ddp_tasks_tbl ahl_vwp_rules_pvt.task_tbl_type;
2860: ddindx binary_integer; indx binary_integer;
2861: begin
2862:
2863: -- copy data to the local IN or IN-OUT args, if any

Line 2870: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_tasks_tbl, p6_a0

2866:
2867:
2868:
2869:
2870: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_tasks_tbl, p6_a0
2871: , p6_a1
2872: , p6_a2
2873: , p6_a3
2874: , p6_a4

Line 2971: ahl_vwp_rules_pvt.validate_return_to_supply(p_api_version,

2967:
2968:
2969:
2970: -- here's the delegated call to the old PL/SQL routine
2971: ahl_vwp_rules_pvt.validate_return_to_supply(p_api_version,
2972: p_init_msg_list,
2973: p_commit,
2974: p_validation_level,
2975: p_module_type,

Line 3100: ddp_task_rec_tbl ahl_vwp_rules_pvt.task_tbl_type;

3096: , x_msg_data out nocopy VARCHAR2
3097: )
3098:
3099: as
3100: ddp_task_rec_tbl ahl_vwp_rules_pvt.task_tbl_type;
3101: ddindx binary_integer; indx binary_integer;
3102: begin
3103:
3104: -- copy data to the local IN or IN-OUT args, if any

Line 3110: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_rec_tbl, p5_a0

3106:
3107:
3108:
3109:
3110: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_rec_tbl, p5_a0
3111: , p5_a1
3112: , p5_a2
3113: , p5_a3
3114: , p5_a4

Line 3211: ahl_vwp_rules_pvt.flag_duplicate_task(p_api_version,

3207:
3208:
3209:
3210: -- here's the delegated call to the old PL/SQL routine
3211: ahl_vwp_rules_pvt.flag_duplicate_task(p_api_version,
3212: p_init_msg_list,
3213: p_commit,
3214: p_validation_level,
3215: p_module_type,

Line 3338: ddp_task_rec_tbl ahl_vwp_rules_pvt.task_tbl_type;

3334: , x_msg_data out nocopy VARCHAR2
3335: )
3336:
3337: as
3338: ddp_task_rec_tbl ahl_vwp_rules_pvt.task_tbl_type;
3339: ddindx binary_integer; indx binary_integer;
3340: begin
3341:
3342: -- copy data to the local IN or IN-OUT args, if any

Line 3348: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_rec_tbl, p5_a0

3344:
3345:
3346:
3347:
3348: ahl_vwp_rules_pvt_w.rosetta_table_copy_in_p5(ddp_task_rec_tbl, p5_a0
3349: , p5_a1
3350: , p5_a2
3351: , p5_a3
3352: , p5_a4

Line 3449: ahl_vwp_rules_pvt.remove_duplicate_task_flag(p_api_version,

3445:
3446:
3447:
3448: -- here's the delegated call to the old PL/SQL routine
3449: ahl_vwp_rules_pvt.remove_duplicate_task_flag(p_api_version,
3450: p_init_msg_list,
3451: p_commit,
3452: p_validation_level,
3453: p_module_type,

Line 3470: end ahl_vwp_rules_pvt_w;

3466:
3467:
3468: end;
3469:
3470: end ahl_vwp_rules_pvt_w;