DBA Data[Home] [Help]

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.4.12010000.2 2008/12/15 01:47:22 sracha ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_workorder_pvt.prd_workoper_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_workorder_pvt.prd_workoper_tbl, a0 JTF_NUMBER_TABLE

1: package body ahl_prd_workorder_pvt_w as
2: /* $Header: AHLWPRJB.pls 120.4.12010000.2 2008/12/15 01:47:22 sracha ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_workorder_pvt.prd_workoper_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_NUMBER_TABLE

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

130: end loop;
131: end if;
132: end if;
133: end rosetta_table_copy_in_p1;
134: procedure rosetta_table_copy_out_p1(t ahl_prd_workorder_pvt.prd_workoper_tbl, a0 out nocopy JTF_NUMBER_TABLE
135: , a1 out nocopy JTF_NUMBER_TABLE
136: , a2 out nocopy JTF_NUMBER_TABLE
137: , a3 out nocopy JTF_VARCHAR2_TABLE_500
138: , a4 out nocopy JTF_NUMBER_TABLE

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

434: end if;
435: end if;
436: end rosetta_table_copy_out_p1;
437:
438: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_workorder_pvt.prd_workorder_tbl, a0 JTF_NUMBER_TABLE
439: , a1 JTF_NUMBER_TABLE
440: , a2 JTF_NUMBER_TABLE
441: , a3 JTF_NUMBER_TABLE
442: , a4 JTF_NUMBER_TABLE

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

653: end loop;
654: end if;
655: end if;
656: end rosetta_table_copy_in_p3;
657: procedure rosetta_table_copy_out_p3(t ahl_prd_workorder_pvt.prd_workorder_tbl, a0 out nocopy JTF_NUMBER_TABLE
658: , a1 out nocopy JTF_NUMBER_TABLE
659: , a2 out nocopy JTF_NUMBER_TABLE
660: , a3 out nocopy JTF_NUMBER_TABLE
661: , a4 out nocopy JTF_NUMBER_TABLE

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

1177: end if;
1178: end if;
1179: end rosetta_table_copy_out_p3;
1180:
1181: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 JTF_NUMBER_TABLE
1182: , a1 JTF_NUMBER_TABLE
1183: , a2 JTF_NUMBER_TABLE
1184: , a3 JTF_NUMBER_TABLE
1185: , a4 JTF_NUMBER_TABLE

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

1210: end loop;
1211: end if;
1212: end if;
1213: end rosetta_table_copy_in_p5;
1214: procedure rosetta_table_copy_out_p5(t ahl_prd_workorder_pvt.prd_workorder_rel_tbl, a0 out nocopy JTF_NUMBER_TABLE
1215: , a1 out nocopy JTF_NUMBER_TABLE
1216: , a2 out nocopy JTF_NUMBER_TABLE
1217: , a3 out nocopy JTF_NUMBER_TABLE
1218: , a4 out nocopy JTF_NUMBER_TABLE

Line 1273: procedure rosetta_table_copy_in_p13(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE

1269: end if;
1270: end if;
1271: end rosetta_table_copy_out_p5;
1272:
1273: procedure rosetta_table_copy_in_p13(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
1274: , a1 JTF_NUMBER_TABLE
1275: , a2 JTF_VARCHAR2_TABLE_100
1276: , a3 JTF_VARCHAR2_TABLE_2000
1277: , a4 JTF_NUMBER_TABLE

Line 1306: procedure rosetta_table_copy_out_p13(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1302: end loop;
1303: end if;
1304: end if;
1305: end rosetta_table_copy_in_p13;
1306: procedure rosetta_table_copy_out_p13(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1307: , a1 out nocopy JTF_NUMBER_TABLE
1308: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
1310: , a4 out nocopy JTF_NUMBER_TABLE

Line 1486: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;

1482: , p10_a7 JTF_VARCHAR2_TABLE_100
1483: )
1484:
1485: as
1486: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;
1487: ddp_prd_workorder_rel_tbl ahl_prd_workorder_pvt.prd_workorder_rel_tbl;
1488: ddindx binary_integer; indx binary_integer;
1489: begin
1490:

Line 1487: ddp_prd_workorder_rel_tbl ahl_prd_workorder_pvt.prd_workorder_rel_tbl;

1483: )
1484:
1485: as
1486: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;
1487: ddp_prd_workorder_rel_tbl ahl_prd_workorder_pvt.prd_workorder_rel_tbl;
1488: ddindx binary_integer; indx binary_integer;
1489: begin
1490:
1491: -- copy data to the local IN or IN-OUT args, if any

Line 1501: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p3(ddp_x_prd_workorder_tbl, p9_a0

1497:
1498:
1499:
1500:
1501: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p3(ddp_x_prd_workorder_tbl, p9_a0
1502: , p9_a1
1503: , p9_a2
1504: , p9_a3
1505: , p9_a4

Line 1604: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p5(ddp_prd_workorder_rel_tbl, p10_a0

1600: , p9_a99
1601: , p9_a100
1602: );
1603:
1604: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p5(ddp_prd_workorder_rel_tbl, p10_a0
1605: , p10_a1
1606: , p10_a2
1607: , p10_a3
1608: , p10_a4

Line 1615: ahl_prd_workorder_pvt.process_jobs(p_api_version,

1611: , p10_a7
1612: );
1613:
1614: -- here's the delegated call to the old PL/SQL routine
1615: ahl_prd_workorder_pvt.process_jobs(p_api_version,
1616: p_init_msg_list,
1617: p_commit,
1618: p_validation_level,
1619: p_default,

Line 1637: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p3(ddp_x_prd_workorder_tbl, p9_a0

1633:
1634:
1635:
1636:
1637: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p3(ddp_x_prd_workorder_tbl, p9_a0
1638: , p9_a1
1639: , p9_a2
1640: , p9_a3
1641: , p9_a4

Line 1913: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;

1909: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
1910: )
1911:
1912: as
1913: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;
1914: ddp_x_prd_workoper_tbl ahl_prd_workorder_pvt.prd_workoper_tbl;
1915: ddindx binary_integer; indx binary_integer;
1916: begin
1917:

Line 1914: ddp_x_prd_workoper_tbl ahl_prd_workorder_pvt.prd_workoper_tbl;

1910: )
1911:
1912: as
1913: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;
1914: ddp_x_prd_workoper_tbl ahl_prd_workorder_pvt.prd_workoper_tbl;
1915: ddindx binary_integer; indx binary_integer;
1916: begin
1917:
1918: -- copy data to the local IN or IN-OUT args, if any

Line 2031: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p1(ddp_x_prd_workoper_tbl, p11_a0

2027: ddp_x_prd_workorder_rec.dml_operation := p10_a98;
2028: ddp_x_prd_workorder_rec.hold_reason_code := p10_a99;
2029: ddp_x_prd_workorder_rec.hold_reason := p10_a100;
2030:
2031: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p1(ddp_x_prd_workoper_tbl, p11_a0
2032: , p11_a1
2033: , p11_a2
2034: , p11_a3
2035: , p11_a4

Line 2091: ahl_prd_workorder_pvt.update_job(p_api_version,

2087: , p11_a56
2088: );
2089:
2090: -- here's the delegated call to the old PL/SQL routine
2091: ahl_prd_workorder_pvt.update_job(p_api_version,
2092: p_init_msg_list,
2093: p_commit,
2094: p_validation_level,
2095: p_default,

Line 2217: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p1(ddp_x_prd_workoper_tbl, p11_a0

2213: p10_a98 := ddp_x_prd_workorder_rec.dml_operation;
2214: p10_a99 := ddp_x_prd_workorder_rec.hold_reason_code;
2215: p10_a100 := ddp_x_prd_workorder_rec.hold_reason;
2216:
2217: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p1(ddp_x_prd_workoper_tbl, p11_a0
2218: , p11_a1
2219: , p11_a2
2220: , p11_a3
2221: , p11_a4

Line 2297: ddp_trunover_notes_tbl ahl_prd_workorder_pvt.turnover_notes_tbl_type;

2293: , p9_a7 in out nocopy JTF_NUMBER_TABLE
2294: )
2295:
2296: as
2297: ddp_trunover_notes_tbl ahl_prd_workorder_pvt.turnover_notes_tbl_type;
2298: ddindx binary_integer; indx binary_integer;
2299: begin
2300:
2301: -- copy data to the local IN or IN-OUT args, if any

Line 2311: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p13(ddp_trunover_notes_tbl, p9_a0

2307:
2308:
2309:
2310:
2311: ahl_prd_workorder_pvt_w.rosetta_table_copy_in_p13(ddp_trunover_notes_tbl, p9_a0
2312: , p9_a1
2313: , p9_a2
2314: , p9_a3
2315: , p9_a4

Line 2322: ahl_prd_workorder_pvt.insert_turnover_notes(p_api_version,

2318: , p9_a7
2319: );
2320:
2321: -- here's the delegated call to the old PL/SQL routine
2322: ahl_prd_workorder_pvt.insert_turnover_notes(p_api_version,
2323: p_init_msg_list,
2324: p_commit,
2325: p_validation_level,
2326: p_default,

Line 2343: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p13(ddp_trunover_notes_tbl, p9_a0

2339:
2340:
2341:
2342:
2343: ahl_prd_workorder_pvt_w.rosetta_table_copy_out_p13(ddp_trunover_notes_tbl, p9_a0
2344: , p9_a1
2345: , p9_a2
2346: , p9_a3
2347: , p9_a4

Line 2354: end ahl_prd_workorder_pvt_w;

2350: , p9_a7
2351: );
2352: end;
2353:
2354: end ahl_prd_workorder_pvt_w;