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_WIP_JOB_PVT_W dependencies on AHL_WIP_JOB_PVT

Line 1: package body ahl_wip_job_pvt_w as

1: package body ahl_wip_job_pvt_w as
2: /* $Header: AHLWWIPB.pls 120.1 2006/05/03 00:45 bachandr noship $ */
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_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_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_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE

Line 53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

49: end loop;
50: end if;
51: end if;
52: end rosetta_table_copy_in_p2;
53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE

Line 122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE

118: end if;
119: end if;
120: end rosetta_table_copy_out_p2;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_NUMBER_TABLE
125: , a3 JTF_NUMBER_TABLE
126: , a4 JTF_NUMBER_TABLE

Line 183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

179: end loop;
180: end if;
181: end if;
182: end rosetta_table_copy_in_p4;
183: procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE

Line 312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE

308: end if;
309: end if;
310: end rosetta_table_copy_out_p4;
311:
312: procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_NUMBER_TABLE
315: , a3 JTF_NUMBER_TABLE
316: , a4 JTF_NUMBER_TABLE

Line 353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

349: end loop;
350: end if;
351: end if;
352: end rosetta_table_copy_in_p6;
353: procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
354: , a1 out nocopy JTF_NUMBER_TABLE
355: , a2 out nocopy JTF_NUMBER_TABLE
356: , a3 out nocopy JTF_NUMBER_TABLE
357: , a4 out nocopy JTF_NUMBER_TABLE

Line 432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE

428: end if;
429: end if;
430: end rosetta_table_copy_out_p6;
431:
432: procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_NUMBER_TABLE
434: , a2 JTF_NUMBER_TABLE
435: , a3 JTF_NUMBER_TABLE
436: , a4 JTF_NUMBER_TABLE

Line 481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

477: end loop;
478: end if;
479: end if;
480: end rosetta_table_copy_in_p8;
481: procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_NUMBER_TABLE
484: , a3 out nocopy JTF_NUMBER_TABLE
485: , a4 out nocopy JTF_NUMBER_TABLE

Line 580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 JTF_NUMBER_TABLE

576: end if;
577: end if;
578: end rosetta_table_copy_out_p8;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 JTF_NUMBER_TABLE
581: , a1 JTF_VARCHAR2_TABLE_300
582: , a2 JTF_NUMBER_TABLE
583: , a3 JTF_VARCHAR2_TABLE_32767
584: ) as

Line 605: procedure rosetta_table_copy_out_p10(t ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

601: end loop;
602: end if;
603: end if;
604: end rosetta_table_copy_in_p10;
605: procedure rosetta_table_copy_out_p10(t ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
606: , a1 out nocopy JTF_VARCHAR2_TABLE_300
607: , a2 out nocopy JTF_NUMBER_TABLE
608: , a3 out nocopy JTF_VARCHAR2_TABLE_32767
609: ) as

Line 722: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;

718: , x_wip_entity_id out nocopy NUMBER
719: )
720:
721: as
722: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
723: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
724: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
725: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
726: ddindx binary_integer; indx binary_integer;

Line 723: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;

719: )
720:
721: as
722: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
723: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
724: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
725: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
726: ddindx binary_integer; indx binary_integer;
727: begin

Line 724: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;

720:
721: as
722: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
723: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
724: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
725: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
726: ddindx binary_integer; indx binary_integer;
727: begin
728:

Line 725: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;

721: as
722: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
723: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
724: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
725: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
726: ddindx binary_integer; indx binary_integer;
727: begin
728:
729: -- copy data to the local IN or IN-OUT args, if any

Line 761: ahl_wip_job_pvt_w.rosetta_table_copy_in_p2(ddp_ahl_wo_op_tbl, p7_a0

757: ddp_ahl_wo_rec.scheduling_method := p6_a21;
758: ddp_ahl_wo_rec.description := p6_a22;
759: ddp_ahl_wo_rec.dml_type := p6_a23;
760:
761: ahl_wip_job_pvt_w.rosetta_table_copy_in_p2(ddp_ahl_wo_op_tbl, p7_a0
762: , p7_a1
763: , p7_a2
764: , p7_a3
765: , p7_a4

Line 773: ahl_wip_job_pvt_w.rosetta_table_copy_in_p4(ddp_ahl_wo_res_tbl, p8_a0

769: , p7_a8
770: , p7_a9
771: );
772:
773: ahl_wip_job_pvt_w.rosetta_table_copy_in_p4(ddp_ahl_wo_res_tbl, p8_a0
774: , p8_a1
775: , p8_a2
776: , p8_a3
777: , p8_a4

Line 797: ahl_wip_job_pvt_w.rosetta_table_copy_in_p6(ddp_ahl_wo_mtl_tbl, p9_a0

793: , p8_a20
794: , p8_a21
795: );
796:
797: ahl_wip_job_pvt_w.rosetta_table_copy_in_p6(ddp_ahl_wo_mtl_tbl, p9_a0
798: , p9_a1
799: , p9_a2
800: , p9_a3
801: , p9_a4

Line 813: ahl_wip_job_pvt.load_wip_job(p_api_version,

809: );
810:
811:
812: -- here's the delegated call to the old PL/SQL routine
813: ahl_wip_job_pvt.load_wip_job(p_api_version,
814: p_init_msg_list,
815: p_validation_level,
816: x_return_status,
817: x_msg_count,

Line 864: ddp_ahl_res_txn_tbl ahl_wip_job_pvt.ahl_res_txn_tbl_type;

860: , p7_a15 JTF_VARCHAR2_TABLE_300
861: )
862:
863: as
864: ddp_ahl_res_txn_tbl ahl_wip_job_pvt.ahl_res_txn_tbl_type;
865: ddindx binary_integer; indx binary_integer;
866: begin
867:
868: -- copy data to the local IN or IN-OUT args, if any

Line 876: ahl_wip_job_pvt_w.rosetta_table_copy_in_p8(ddp_ahl_res_txn_tbl, p7_a0

872:
873:
874:
875:
876: ahl_wip_job_pvt_w.rosetta_table_copy_in_p8(ddp_ahl_res_txn_tbl, p7_a0
877: , p7_a1
878: , p7_a2
879: , p7_a3
880: , p7_a4

Line 895: ahl_wip_job_pvt.insert_resource_txn(p_api_version,

891: , p7_a15
892: );
893:
894: -- here's the delegated call to the old PL/SQL routine
895: ahl_wip_job_pvt.insert_resource_txn(p_api_version,
896: p_init_msg_list,
897: p_commit,
898: p_validation_level,
899: x_return_status,

Line 926: ddrosetta_retval := ahl_wip_job_pvt.wip_massload_pending(p_wip_entity_id);

922:
923: -- copy data to the local IN or IN-OUT args, if any
924:
925: -- here's the delegated call to the old PL/SQL routine
926: ddrosetta_retval := ahl_wip_job_pvt.wip_massload_pending(p_wip_entity_id);
927:
928: -- copy data back from the local variables to OUT or IN-OUT args, if any
929: if ddrosetta_retval is null
930: then ddrosetta_retval_bool := null;

Line 1023: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;

1019: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_32767
1020: )
1021:
1022: as
1023: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
1024: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
1025: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
1026: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
1027: ddx_ahl_wip_job_tbl ahl_wip_job_pvt.ahl_wip_job_tbl_type;

Line 1024: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;

1020: )
1021:
1022: as
1023: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
1024: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
1025: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
1026: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
1027: ddx_ahl_wip_job_tbl ahl_wip_job_pvt.ahl_wip_job_tbl_type;
1028: ddindx binary_integer; indx binary_integer;

Line 1025: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;

1021:
1022: as
1023: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
1024: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
1025: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
1026: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
1027: ddx_ahl_wip_job_tbl ahl_wip_job_pvt.ahl_wip_job_tbl_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin

Line 1026: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;

1022: as
1023: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
1024: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
1025: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
1026: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
1027: ddx_ahl_wip_job_tbl ahl_wip_job_pvt.ahl_wip_job_tbl_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin
1030:

Line 1027: ddx_ahl_wip_job_tbl ahl_wip_job_pvt.ahl_wip_job_tbl_type;

1023: ddp_ahl_wo_rec ahl_wip_job_pvt.ahl_wo_rec_type;
1024: ddp_ahl_wo_op_tbl ahl_wip_job_pvt.ahl_wo_op_tbl_type;
1025: ddp_ahl_wo_res_tbl ahl_wip_job_pvt.ahl_wo_res_tbl_type;
1026: ddp_ahl_wo_mtl_tbl ahl_wip_job_pvt.ahl_wo_mtl_tbl_type;
1027: ddx_ahl_wip_job_tbl ahl_wip_job_pvt.ahl_wip_job_tbl_type;
1028: ddindx binary_integer; indx binary_integer;
1029: begin
1030:
1031: -- copy data to the local IN or IN-OUT args, if any

Line 1066: ahl_wip_job_pvt_w.rosetta_table_copy_in_p2(ddp_ahl_wo_op_tbl, p10_a0

1062: ddp_ahl_wo_rec.scheduling_method := p9_a21;
1063: ddp_ahl_wo_rec.description := p9_a22;
1064: ddp_ahl_wo_rec.dml_type := p9_a23;
1065:
1066: ahl_wip_job_pvt_w.rosetta_table_copy_in_p2(ddp_ahl_wo_op_tbl, p10_a0
1067: , p10_a1
1068: , p10_a2
1069: , p10_a3
1070: , p10_a4

Line 1078: ahl_wip_job_pvt_w.rosetta_table_copy_in_p4(ddp_ahl_wo_res_tbl, p11_a0

1074: , p10_a8
1075: , p10_a9
1076: );
1077:
1078: ahl_wip_job_pvt_w.rosetta_table_copy_in_p4(ddp_ahl_wo_res_tbl, p11_a0
1079: , p11_a1
1080: , p11_a2
1081: , p11_a3
1082: , p11_a4

Line 1102: ahl_wip_job_pvt_w.rosetta_table_copy_in_p6(ddp_ahl_wo_mtl_tbl, p12_a0

1098: , p11_a20
1099: , p11_a21
1100: );
1101:
1102: ahl_wip_job_pvt_w.rosetta_table_copy_in_p6(ddp_ahl_wo_mtl_tbl, p12_a0
1103: , p12_a1
1104: , p12_a2
1105: , p12_a3
1106: , p12_a4

Line 1120: ahl_wip_job_pvt.load_wip_batch_jobs(p_api_version,

1116:
1117:
1118:
1119: -- here's the delegated call to the old PL/SQL routine
1120: ahl_wip_job_pvt.load_wip_batch_jobs(p_api_version,
1121: p_init_msg_list,
1122: p_validation_level,
1123: x_return_status,
1124: x_msg_count,

Line 1153: ahl_wip_job_pvt_w.rosetta_table_copy_out_p10(ddx_ahl_wip_job_tbl, p15_a0

1149:
1150:
1151:
1152:
1153: ahl_wip_job_pvt_w.rosetta_table_copy_out_p10(ddx_ahl_wip_job_tbl, p15_a0
1154: , p15_a1
1155: , p15_a2
1156: , p15_a3
1157: );

Line 1160: end ahl_wip_job_pvt_w;

1156: , p15_a3
1157: );
1158: end;
1159:
1160: end ahl_wip_job_pvt_w;