DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT_W dependencies on CSD_HV_WIP_JOB_PVT

Line 1: package body csd_hv_wip_job_pvt_w as

1: package body csd_hv_wip_job_pvt_w as
2: /* $Header: csdwhvjb.pls 120.14.12020000.4 2013/04/02 22:38:03 swai ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300

1: package body csd_hv_wip_job_pvt_w as
2: /* $Header: csdwhvjb.pls 120.14.12020000.4 2013/04/02 22:38:03 swai ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 34: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

30: end loop;
31: end if;
32: end if;
33: end rosetta_table_copy_in_p3;
34: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE

Line 88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE

84: end if;
85: end if;
86: end rosetta_table_copy_out_p3;
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_NUMBER_TABLE
91: , a3 JTF_NUMBER_TABLE
92: , a4 JTF_NUMBER_TABLE

Line 187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

183: end loop;
184: end if;
185: end if;
186: end rosetta_table_copy_in_p5;
187: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE

Line 411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE

407: end if;
408: end if;
409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_NUMBER_TABLE
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE

Line 502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

498: end loop;
499: end if;
500: end if;
501: end rosetta_table_copy_in_p7;
502: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_NUMBER_TABLE
505: , a3 out nocopy JTF_NUMBER_TABLE
506: , a4 out nocopy JTF_NUMBER_TABLE

Line 706: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE

702: end if;
703: end if;
704: end rosetta_table_copy_out_p7;
705:
706: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
707: , a1 JTF_NUMBER_TABLE
708: , a2 JTF_NUMBER_TABLE
709: , a3 JTF_NUMBER_TABLE
710: , a4 JTF_VARCHAR2_TABLE_300

Line 791: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

787: end loop;
788: end if;
789: end if;
790: end rosetta_table_copy_in_p9;
791: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_NUMBER_TABLE
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 980: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE

976: end if;
977: end if;
978: end rosetta_table_copy_out_p9;
979:
980: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
981: , a1 JTF_NUMBER_TABLE
982: , a2 JTF_NUMBER_TABLE
983: , a3 JTF_NUMBER_TABLE
984: ) as

Line 1005: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1001: end loop;
1002: end if;
1003: end if;
1004: end rosetta_table_copy_in_p11;
1005: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1006: , a1 out nocopy JTF_NUMBER_TABLE
1007: , a2 out nocopy JTF_NUMBER_TABLE
1008: , a3 out nocopy JTF_NUMBER_TABLE
1009: ) as

Line 1061: ddp_mv_txn_dtls_tbl csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type;

1057: , p7_a6 JTF_NUMBER_TABLE
1058: )
1059:
1060: as
1061: ddp_mv_txn_dtls_tbl csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type;
1062: ddindx binary_integer; indx binary_integer;
1063: begin
1064:
1065: -- copy data to the local IN or IN-OUT args, if any

Line 1073: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p3(ddp_mv_txn_dtls_tbl, p7_a0

1069:
1070:
1071:
1072:
1073: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p3(ddp_mv_txn_dtls_tbl, p7_a0
1074: , p7_a1
1075: , p7_a2
1076: , p7_a3
1077: , p7_a4

Line 1083: csd_hv_wip_job_pvt.process_oper_comp_txn(p_api_version_number,

1079: , p7_a6
1080: );
1081:
1082: -- here's the delegated call to the old PL/SQL routine
1083: csd_hv_wip_job_pvt.process_oper_comp_txn(p_api_version_number,
1084: p_init_msg_list,
1085: p_commit,
1086: p_validation_level,
1087: x_return_status,

Line 1123: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;

1119: , x_transaction_header_id out nocopy NUMBER
1120: )
1121:
1122: as
1123: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;
1124: ddindx binary_integer; indx binary_integer;
1125: begin
1126:
1127: -- copy data to the local IN or IN-OUT args, if any

Line 1148: csd_hv_wip_job_pvt.process_job_comp_txn(p_api_version_number,

1144: ddp_comp_job_dtls_rec.lot_control_code := p7_a9;
1145:
1146:
1147: -- here's the delegated call to the old PL/SQL routine
1148: csd_hv_wip_job_pvt.process_job_comp_txn(p_api_version_number,
1149: p_init_msg_list,
1150: p_commit,
1151: p_validation_level,
1152: x_return_status,

Line 1191: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;

1187: , x_transaction_header_id out nocopy NUMBER
1188: )
1189:
1190: as
1191: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;
1192: ddindx binary_integer; indx binary_integer;
1193: begin
1194:
1195: -- copy data to the local IN or IN-OUT args, if any

Line 1217: csd_hv_wip_job_pvt.insert_job_comp_txn(p_api_version_number,

1213:
1214:
1215:
1216: -- here's the delegated call to the old PL/SQL routine
1217: csd_hv_wip_job_pvt.insert_job_comp_txn(p_api_version_number,
1218: p_init_msg_list,
1219: p_commit,
1220: p_validation_level,
1221: x_return_status,

Line 1292: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1288: , x_transaction_header_id out nocopy NUMBER
1289: )
1290:
1291: as
1292: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1293: ddindx binary_integer; indx binary_integer;
1294: begin
1295:
1296: -- copy data to the local IN or IN-OUT args, if any

Line 1304: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1300:
1301:
1302:
1303:
1304: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1305: , p7_a1
1306: , p7_a2
1307: , p7_a3
1308: , p7_a4

Line 1349: csd_hv_wip_job_pvt.process_issue_mtl_txn(p_api_version_number,

1345: );
1346:
1347:
1348: -- here's the delegated call to the old PL/SQL routine
1349: csd_hv_wip_job_pvt.process_issue_mtl_txn(p_api_version_number,
1350: p_init_msg_list,
1351: p_commit,
1352: p_validation_level,
1353: x_return_status,

Line 1422: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1418: , p_transaction_header_id NUMBER
1419: )
1420:
1421: as
1422: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1423: ddindx binary_integer; indx binary_integer;
1424: begin
1425:
1426: -- copy data to the local IN or IN-OUT args, if any

Line 1434: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1430:
1431:
1432:
1433:
1434: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1435: , p7_a1
1436: , p7_a2
1437: , p7_a3
1438: , p7_a4

Line 1479: csd_hv_wip_job_pvt.process_issue_mtl_txns_lot_srl(p_api_version_number,

1475: );
1476:
1477:
1478: -- here's the delegated call to the old PL/SQL routine
1479: csd_hv_wip_job_pvt.process_issue_mtl_txns_lot_srl(p_api_version_number,
1480: p_init_msg_list,
1481: p_commit,
1482: p_validation_level,
1483: x_return_status,

Line 1552: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1548: , p_transaction_header_id NUMBER
1549: )
1550:
1551: as
1552: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1553: ddindx binary_integer; indx binary_integer;
1554: begin
1555:
1556: -- copy data to the local IN or IN-OUT args, if any

Line 1564: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1560:
1561:
1562:
1563:
1564: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1565: , p7_a1
1566: , p7_a2
1567: , p7_a3
1568: , p7_a4

Line 1609: csd_hv_wip_job_pvt.update_mtl_txns_lot_srl(p_api_version_number,

1605: );
1606:
1607:
1608: -- here's the delegated call to the old PL/SQL routine
1609: csd_hv_wip_job_pvt.update_mtl_txns_lot_srl(p_api_version_number,
1610: p_init_msg_list,
1611: p_commit,
1612: p_validation_level,
1613: x_return_status,

Line 1677: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;

1673: , p7_a36 JTF_VARCHAR2_TABLE_200
1674: )
1675:
1676: as
1677: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;
1678: ddindx binary_integer; indx binary_integer;
1679: begin
1680:
1681: -- copy data to the local IN or IN-OUT args, if any

Line 1689: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0

1685:
1686:
1687:
1688:
1689: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0
1690: , p7_a1
1691: , p7_a2
1692: , p7_a3
1693: , p7_a4

Line 1729: csd_hv_wip_job_pvt.process_transact_res_txn(p_api_version_number,

1725: , p7_a36
1726: );
1727:
1728: -- here's the delegated call to the old PL/SQL routine
1729: csd_hv_wip_job_pvt.process_transact_res_txn(p_api_version_number,
1730: p_init_msg_list,
1731: p_commit,
1732: p_validation_level,
1733: x_return_status,

Line 1800: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1796: , x_op_created out nocopy VARCHAR
1797: )
1798:
1799: as
1800: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1801: ddindx binary_integer; indx binary_integer;
1802: begin
1803:
1804: -- copy data to the local IN or IN-OUT args, if any

Line 1812: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1808:
1809:
1810:
1811:
1812: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1813: , p7_a1
1814: , p7_a2
1815: , p7_a3
1816: , p7_a4

Line 1857: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls(p_api_version_number,

1853: );
1854:
1855:
1856: -- here's the delegated call to the old PL/SQL routine
1857: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls(p_api_version_number,
1858: p_init_msg_list,
1859: p_commit,
1860: p_validation_level,
1861: x_return_status,

Line 1925: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;

1921: , p7_a36 JTF_VARCHAR2_TABLE_200
1922: )
1923:
1924: as
1925: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;
1926: ddindx binary_integer; indx binary_integer;
1927: begin
1928:
1929: -- copy data to the local IN or IN-OUT args, if any

Line 1937: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0

1933:
1934:
1935:
1936:
1937: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0
1938: , p7_a1
1939: , p7_a2
1940: , p7_a3
1941: , p7_a4

Line 1977: csd_hv_wip_job_pvt.process_save_res_txn_dtls(p_api_version_number,

1973: , p7_a36
1974: );
1975:
1976: -- here's the delegated call to the old PL/SQL routine
1977: csd_hv_wip_job_pvt.process_save_res_txn_dtls(p_api_version_number,
1978: p_init_msg_list,
1979: p_commit,
1980: p_validation_level,
1981: x_return_status,

Line 2040: ddp_op_dtls_tbl csd_hv_wip_job_pvt.op_dtls_tbl_type;

2036: , p7_a33 JTF_VARCHAR2_TABLE_200
2037: )
2038:
2039: as
2040: ddp_op_dtls_tbl csd_hv_wip_job_pvt.op_dtls_tbl_type;
2041: ddindx binary_integer; indx binary_integer;
2042: begin
2043:
2044: -- copy data to the local IN or IN-OUT args, if any

Line 2052: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p9(ddp_op_dtls_tbl, p7_a0

2048:
2049:
2050:
2051:
2052: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p9(ddp_op_dtls_tbl, p7_a0
2053: , p7_a1
2054: , p7_a2
2055: , p7_a3
2056: , p7_a4

Line 2089: csd_hv_wip_job_pvt.process_save_op_dtls(p_api_version_number,

2085: , p7_a33
2086: );
2087:
2088: -- here's the delegated call to the old PL/SQL routine
2089: csd_hv_wip_job_pvt.process_save_op_dtls(p_api_version_number,
2090: p_init_msg_list,
2091: p_commit,
2092: p_validation_level,
2093: x_return_status,

Line 2124: ddp_service_code_tbl csd_hv_wip_job_pvt.service_code_tbl_type;

2120: , p9_a3 JTF_NUMBER_TABLE
2121: )
2122:
2123: as
2124: ddp_service_code_tbl csd_hv_wip_job_pvt.service_code_tbl_type;
2125: ddindx binary_integer; indx binary_integer;
2126: begin
2127:
2128: -- copy data to the local IN or IN-OUT args, if any

Line 2138: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p11(ddp_service_code_tbl, p9_a0

2134:
2135:
2136:
2137:
2138: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p11(ddp_service_code_tbl, p9_a0
2139: , p9_a1
2140: , p9_a2
2141: , p9_a3
2142: );

Line 2145: csd_hv_wip_job_pvt.generate_wip_jobs_from_scs(p_api_version_number,

2141: , p9_a3
2142: );
2143:
2144: -- here's the delegated call to the old PL/SQL routine
2145: csd_hv_wip_job_pvt.generate_wip_jobs_from_scs(p_api_version_number,
2146: p_init_msg_list,
2147: p_commit,
2148: p_validation_level,
2149: x_return_status,

Line 2219: ddp_mtl_txn_dtls csd_hv_wip_job_pvt.mtl_txn_dtls_rec_type;

2215: , p7_a40 VARCHAR2
2216: )
2217:
2218: as
2219: ddp_mtl_txn_dtls csd_hv_wip_job_pvt.mtl_txn_dtls_rec_type;
2220: ddindx binary_integer; indx binary_integer;
2221: begin
2222:
2223: -- copy data to the local IN or IN-OUT args, if any

Line 2274: csd_hv_wip_job_pvt.process_delete_mtl_txn_dtl(p_api_version_number,

2270: ddp_mtl_txn_dtls.attribute15 := p7_a39;
2271: ddp_mtl_txn_dtls.create_ro_flag := p7_a40;
2272:
2273: -- here's the delegated call to the old PL/SQL routine
2274: csd_hv_wip_job_pvt.process_delete_mtl_txn_dtl(p_api_version_number,
2275: p_init_msg_list,
2276: p_commit,
2277: p_validation_level,
2278: x_return_status,

Line 2337: ddp_op_dtls csd_hv_wip_job_pvt.op_dtls_rec_type;

2333: , p7_a33 VARCHAR2
2334: )
2335:
2336: as
2337: ddp_op_dtls csd_hv_wip_job_pvt.op_dtls_rec_type;
2338: ddindx binary_integer; indx binary_integer;
2339: begin
2340:
2341: -- copy data to the local IN or IN-OUT args, if any

Line 2385: csd_hv_wip_job_pvt.process_delete_op_dtl(p_api_version_number,

2381: ddp_op_dtls.attribute14 := p7_a32;
2382: ddp_op_dtls.attribute15 := p7_a33;
2383:
2384: -- here's the delegated call to the old PL/SQL routine
2385: csd_hv_wip_job_pvt.process_delete_op_dtl(p_api_version_number,
2386: p_init_msg_list,
2387: p_commit,
2388: p_validation_level,
2389: x_return_status,

Line 2404: end csd_hv_wip_job_pvt_w;

2400:
2401:
2402: end;
2403:
2404: end csd_hv_wip_job_pvt_w;