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_PRD_WORKORDER_PVT_W dependencies on AHL_PRD_WORKORDER_PVT

Line 1: package body ahl_prd_workorder_pvt_w as

1: package body ahl_prd_workorder_pvt_w as
2: /* $Header: AHLWPRJB.pls 120.8.12020000.2 2012/12/14 05:53:26 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_prd_workorder_pvt.prd_workoper_tbl, 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_prd_workorder_pvt.prd_workoper_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_500
20: , a4 JTF_NUMBER_TABLE

Line 147: procedure rosetta_table_copy_out_p1(t ahl_prd_workorder_pvt.prd_workoper_tbl, a0 out nocopy JTF_NUMBER_TABLE

143: end loop;
144: end if;
145: end if;
146: end rosetta_table_copy_in_p1;
147: procedure rosetta_table_copy_out_p1(t ahl_prd_workorder_pvt.prd_workoper_tbl, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_VARCHAR2_TABLE_500
151: , a4 out nocopy JTF_NUMBER_TABLE

Line 451: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_workorder_pvt.prd_workorder_tbl, a0 JTF_NUMBER_TABLE

447: end if;
448: end if;
449: end rosetta_table_copy_out_p1;
450:
451: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_workorder_pvt.prd_workorder_tbl, a0 JTF_NUMBER_TABLE
452: , a1 JTF_NUMBER_TABLE
453: , a2 JTF_NUMBER_TABLE
454: , a3 JTF_NUMBER_TABLE
455: , a4 JTF_NUMBER_TABLE

Line 678: procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE

674: end loop;
675: end if;
676: end if;
677: end rosetta_table_copy_in_p3;
678: procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
679: , a1 out nocopy JTF_NUMBER_TABLE
680: , a2 out nocopy JTF_NUMBER_TABLE
681: , a3 out nocopy JTF_NUMBER_TABLE
682: , a4 out nocopy JTF_NUMBER_TABLE

Line 1222: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE

1218: end if;
1219: end if;
1220: end rosetta_table_copy_out_p3;
1221:
1222: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE
1223: , a1 JTF_NUMBER_TABLE
1224: , a2 JTF_NUMBER_TABLE
1225: , a3 JTF_NUMBER_TABLE
1226: , a4 JTF_NUMBER_TABLE

Line 1255: procedure rosetta_table_copy_out_p5(t ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 out nocopy JTF_NUMBER_TABLE

1251: end loop;
1252: end if;
1253: end if;
1254: end rosetta_table_copy_in_p5;
1255: procedure rosetta_table_copy_out_p5(t ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 out nocopy JTF_NUMBER_TABLE
1256: , a1 out nocopy JTF_NUMBER_TABLE
1257: , a2 out nocopy JTF_NUMBER_TABLE
1258: , a3 out nocopy JTF_NUMBER_TABLE
1259: , a4 out nocopy JTF_NUMBER_TABLE

Line 1314: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE

1310: end if;
1311: end if;
1312: end rosetta_table_copy_out_p5;
1313:
1314: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
1315: , a1 JTF_NUMBER_TABLE
1316: , a2 JTF_VARCHAR2_TABLE_100
1317: , a3 JTF_VARCHAR2_TABLE_2000
1318: , a4 JTF_NUMBER_TABLE

Line 1347: procedure rosetta_table_copy_out_p14(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1343: end loop;
1344: end if;
1345: end if;
1346: end rosetta_table_copy_in_p14;
1347: procedure rosetta_table_copy_out_p14(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1348: , a1 out nocopy JTF_NUMBER_TABLE
1349: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1350: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
1351: , a4 out nocopy JTF_NUMBER_TABLE

Line 1406: procedure rosetta_table_copy_in_p23(t out nocopy ahl_prd_workorder_pvt.workorder_id_tbl_type, a0 JTF_NUMBER_TABLE

1402: end if;
1403: end if;
1404: end rosetta_table_copy_out_p14;
1405:
1406: procedure rosetta_table_copy_in_p23(t out nocopy ahl_prd_workorder_pvt.workorder_id_tbl_type, a0 JTF_NUMBER_TABLE
1407: , a1 JTF_NUMBER_TABLE
1408: ) as
1409: ddindx binary_integer; indx binary_integer;
1410: begin

Line 1427: procedure rosetta_table_copy_out_p23(t ahl_prd_workorder_pvt.workorder_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1423: end loop;
1424: end if;
1425: end if;
1426: end rosetta_table_copy_in_p23;
1427: procedure rosetta_table_copy_out_p23(t ahl_prd_workorder_pvt.workorder_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1428: , a1 out nocopy JTF_NUMBER_TABLE
1429: ) as
1430: ddindx binary_integer; indx binary_integer;
1431: begin

Line 1581: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;

1577: , p10_a7 JTF_VARCHAR2_TABLE_100
1578: )
1579:
1580: as
1581: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;
1582: ddp_prd_workorder_rel_tbl ahl_prd_workorder_pvt.prd_workorder_rel_tbl;
1583: ddindx binary_integer; indx binary_integer;
1584: begin
1585:

Line 1582: ddp_prd_workorder_rel_tbl ahl_prd_workorder_pvt.prd_workorder_rel_tbl;

1578: )
1579:
1580: as
1581: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;
1582: ddp_prd_workorder_rel_tbl ahl_prd_workorder_pvt.prd_workorder_rel_tbl;
1583: ddindx binary_integer; indx binary_integer;
1584: begin
1585:
1586: -- copy data to the local IN or IN-OUT args, if any

Line 1596: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p3(ddp_x_prd_workorder_tbl, p9_a0

1592:
1593:
1594:
1595:
1596: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p3(ddp_x_prd_workorder_tbl, p9_a0
1597: , p9_a1
1598: , p9_a2
1599: , p9_a3
1600: , p9_a4

Line 1703: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p5(ddp_prd_workorder_rel_tbl, p10_a0

1699: , p9_a103
1700: , p9_a104
1701: );
1702:
1703: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p5(ddp_prd_workorder_rel_tbl, p10_a0
1704: , p10_a1
1705: , p10_a2
1706: , p10_a3
1707: , p10_a4

Line 1714: ahl_prd_workorder_pvt.process_jobs(p_api_version,

1710: , p10_a7
1711: );
1712:
1713: -- here's the delegated call to the old PL/SQL routine
1714: ahl_prd_workorder_pvt.process_jobs(p_api_version,
1715: p_init_msg_list,
1716: p_commit,
1717: p_validation_level,
1718: p_default,

Line 1736: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p3(ddp_x_prd_workorder_tbl, p9_a0

1732:
1733:
1734:
1735:
1736: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p3(ddp_x_prd_workorder_tbl, p9_a0
1737: , p9_a1
1738: , p9_a2
1739: , p9_a3
1740: , p9_a4

Line 2020: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;

2016: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
2017: )
2018:
2019: as
2020: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;
2021: ddp_x_prd_workoper_tbl ahl_prd_workorder_pvt.prd_workoper_tbl;
2022: ddindx binary_integer; indx binary_integer;
2023: begin
2024:

Line 2021: ddp_x_prd_workoper_tbl ahl_prd_workorder_pvt.prd_workoper_tbl;

2017: )
2018:
2019: as
2020: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;
2021: ddp_x_prd_workoper_tbl ahl_prd_workorder_pvt.prd_workoper_tbl;
2022: ddindx binary_integer; indx binary_integer;
2023: begin
2024:
2025: -- copy data to the local IN or IN-OUT args, if any

Line 2142: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p1(ddp_x_prd_workoper_tbl, p11_a0

2138: ddp_x_prd_workorder_rec.warranty_status_code := p10_a102;
2139: ddp_x_prd_workorder_rec.aog_flag := p10_a103;
2140: ddp_x_prd_workorder_rec.set_mr_priority := p10_a104;
2141:
2142: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p1(ddp_x_prd_workoper_tbl, p11_a0
2143: , p11_a1
2144: , p11_a2
2145: , p11_a3
2146: , p11_a4

Line 2202: ahl_prd_workorder_pvt.update_job(p_api_version,

2198: , p11_a56
2199: );
2200:
2201: -- here's the delegated call to the old PL/SQL routine
2202: ahl_prd_workorder_pvt.update_job(p_api_version,
2203: p_init_msg_list,
2204: p_commit,
2205: p_validation_level,
2206: p_default,

Line 2332: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p1(ddp_x_prd_workoper_tbl, p11_a0

2328: p10_a102 := ddp_x_prd_workorder_rec.warranty_status_code;
2329: p10_a103 := ddp_x_prd_workorder_rec.aog_flag;
2330: p10_a104 := ddp_x_prd_workorder_rec.set_mr_priority;
2331:
2332: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p1(ddp_x_prd_workoper_tbl, p11_a0
2333: , p11_a1
2334: , p11_a2
2335: , p11_a3
2336: , p11_a4

Line 2508: ddp_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;

2504: , x_msg_data out nocopy VARCHAR2
2505: )
2506:
2507: as
2508: ddp_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;
2509: ddindx binary_integer; indx binary_integer;
2510: begin
2511:
2512: -- copy data to the local IN or IN-OUT args, if any

Line 2518: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p3(ddp_workorder_tbl, p5_a0

2514:
2515:
2516:
2517:
2518: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p3(ddp_workorder_tbl, p5_a0
2519: , p5_a1
2520: , p5_a2
2521: , p5_a3
2522: , p5_a4

Line 2629: ahl_prd_workorder_pvt.process_stage_jobs(p_api_version,

2625:
2626:
2627:
2628: -- here's the delegated call to the old PL/SQL routine
2629: ahl_prd_workorder_pvt.process_stage_jobs(p_api_version,
2630: p_init_msg_list,
2631: p_commit,
2632: p_validation_level,
2633: p_module_type,

Line 2686: ahl_prd_workorder_pvt.reschedule_visit_jobs(p_api_version,

2682:
2683: ddp_x_scheduled_end_date := rosetta_g_miss_date_in_map(p_x_scheduled_end_date);
2684:
2685: -- here's the delegated call to the old PL/SQL routine
2686: ahl_prd_workorder_pvt.reschedule_visit_jobs(p_api_version,
2687: p_init_msg_list,
2688: p_commit,
2689: p_validation_level,
2690: p_default,

Line 2735: ddp_trunover_notes_tbl ahl_prd_workorder_pvt.turnover_notes_tbl_type;

2731: , p9_a7 in out nocopy JTF_NUMBER_TABLE
2732: )
2733:
2734: as
2735: ddp_trunover_notes_tbl ahl_prd_workorder_pvt.turnover_notes_tbl_type;
2736: ddindx binary_integer; indx binary_integer;
2737: begin
2738:
2739: -- copy data to the local IN or IN-OUT args, if any

Line 2749: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p14(ddp_trunover_notes_tbl, p9_a0

2745:
2746:
2747:
2748:
2749: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p14(ddp_trunover_notes_tbl, p9_a0
2750: , p9_a1
2751: , p9_a2
2752: , p9_a3
2753: , p9_a4

Line 2760: ahl_prd_workorder_pvt.insert_turnover_notes(p_api_version,

2756: , p9_a7
2757: );
2758:
2759: -- here's the delegated call to the old PL/SQL routine
2760: ahl_prd_workorder_pvt.insert_turnover_notes(p_api_version,
2761: p_init_msg_list,
2762: p_commit,
2763: p_validation_level,
2764: p_default,

Line 2781: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p14(ddp_trunover_notes_tbl, p9_a0

2777:
2778:
2779:
2780:
2781: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p14(ddp_trunover_notes_tbl, p9_a0
2782: , p9_a1
2783: , p9_a2
2784: , p9_a3
2785: , p9_a4

Line 2909: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;

2905: , p9_a104 in out nocopy VARCHAR2
2906: )
2907:
2908: as
2909: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;
2910: ddindx binary_integer; indx binary_integer;
2911: begin
2912:
2913: -- copy data to the local IN or IN-OUT args, if any

Line 3030: ahl_prd_workorder_pvt.unclose_workorder(p_api_version,

3026: ddp_x_prd_workorder_rec.aog_flag := p9_a103;
3027: ddp_x_prd_workorder_rec.set_mr_priority := p9_a104;
3028:
3029: -- here's the delegated call to the old PL/SQL routine
3030: ahl_prd_workorder_pvt.unclose_workorder(p_api_version,
3031: p_init_msg_list,
3032: p_commit,
3033: p_validation_level,
3034: p_default,

Line 3258: ahl_prd_workorder_pvt.populate_entitlements(p_api_version,

3254:
3255:
3256:
3257: -- here's the delegated call to the old PL/SQL routine
3258: ahl_prd_workorder_pvt.populate_entitlements(p_api_version,
3259: p_init_msg_list,
3260: p_commit,
3261: p_validation_level,
3262: p_contract_number,

Line 3328: ddp_workorder_id_tbl ahl_prd_workorder_pvt.workorder_id_tbl_type;

3324: , x_msg_data out nocopy VARCHAR2
3325: )
3326:
3327: as
3328: ddp_workorder_id_tbl ahl_prd_workorder_pvt.workorder_id_tbl_type;
3329: ddindx binary_integer; indx binary_integer;
3330: begin
3331:
3332: -- copy data to the local IN or IN-OUT args, if any

Line 3336: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p23(ddp_workorder_id_tbl, p3_a0

3332: -- copy data to the local IN or IN-OUT args, if any
3333:
3334:
3335:
3336: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p23(ddp_workorder_id_tbl, p3_a0
3337: , p3_a1
3338: );
3339:
3340:

Line 3344: ahl_prd_workorder_pvt.update_wo_aog_status(p_api_version,

3340:
3341:
3342:
3343: -- here's the delegated call to the old PL/SQL routine
3344: ahl_prd_workorder_pvt.update_wo_aog_status(p_api_version,
3345: p_init_msg_list,
3346: p_commit,
3347: ddp_workorder_id_tbl,
3348: x_return_status,

Line 3361: end ahl_prd_workorder_pvt_w;

3357:
3358:
3359: end;
3360:
3361: end ahl_prd_workorder_pvt_w;