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.9 2008/03/25 01:18:11 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.9 2008/03/25 01:18:11 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 153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

149: end loop;
150: end if;
151: end if;
152: end rosetta_table_copy_in_p5;
153: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE

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

288: end if;
289: end if;
290: end rosetta_table_copy_out_p5;
291:
292: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE
293: , a1 JTF_NUMBER_TABLE
294: , a2 JTF_NUMBER_TABLE
295: , a3 JTF_NUMBER_TABLE
296: , a4 JTF_NUMBER_TABLE

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

347: end loop;
348: end if;
349: end if;
350: end rosetta_table_copy_in_p7;
351: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_NUMBER_TABLE
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE

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

471: end if;
472: end if;
473: end rosetta_table_copy_out_p7;
474:
475: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
476: , a1 JTF_NUMBER_TABLE
477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_VARCHAR2_TABLE_300

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

524: end loop;
525: end if;
526: end if;
527: end rosetta_table_copy_in_p9;
528: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
529: , a1 out nocopy JTF_NUMBER_TABLE
530: , a2 out nocopy JTF_NUMBER_TABLE
531: , a3 out nocopy JTF_NUMBER_TABLE
532: , a4 out nocopy JTF_VARCHAR2_TABLE_300

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

633: end if;
634: end if;
635: end rosetta_table_copy_out_p9;
636:
637: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
638: , a1 JTF_NUMBER_TABLE
639: , a2 JTF_NUMBER_TABLE
640: , a3 JTF_NUMBER_TABLE
641: ) as

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

658: end loop;
659: end if;
660: end if;
661: end rosetta_table_copy_in_p11;
662: procedure rosetta_table_copy_out_p11(t csd_hv_wip_job_pvt.service_code_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
663: , a1 out nocopy JTF_NUMBER_TABLE
664: , a2 out nocopy JTF_NUMBER_TABLE
665: , a3 out nocopy JTF_NUMBER_TABLE
666: ) as

Line 718: ddp_mv_txn_dtls_tbl csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type;

714: , p7_a6 JTF_NUMBER_TABLE
715: )
716:
717: as
718: ddp_mv_txn_dtls_tbl csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type;
719: ddindx binary_integer; indx binary_integer;
720: begin
721:
722: -- copy data to the local IN or IN-OUT args, if any

Line 730: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p3(ddp_mv_txn_dtls_tbl, p7_a0

726:
727:
728:
729:
730: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p3(ddp_mv_txn_dtls_tbl, p7_a0
731: , p7_a1
732: , p7_a2
733: , p7_a3
734: , p7_a4

Line 740: csd_hv_wip_job_pvt.process_oper_comp_txn(p_api_version_number,

736: , p7_a6
737: );
738:
739: -- here's the delegated call to the old PL/SQL routine
740: csd_hv_wip_job_pvt.process_oper_comp_txn(p_api_version_number,
741: p_init_msg_list,
742: p_commit,
743: p_validation_level,
744: x_return_status,

Line 780: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;

776: , x_transaction_header_id out nocopy NUMBER
777: )
778:
779: as
780: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;
781: ddindx binary_integer; indx binary_integer;
782: begin
783:
784: -- copy data to the local IN or IN-OUT args, if any

Line 805: csd_hv_wip_job_pvt.process_job_comp_txn(p_api_version_number,

801: ddp_comp_job_dtls_rec.lot_control_code := p7_a9;
802:
803:
804: -- here's the delegated call to the old PL/SQL routine
805: csd_hv_wip_job_pvt.process_job_comp_txn(p_api_version_number,
806: p_init_msg_list,
807: p_commit,
808: p_validation_level,
809: x_return_status,

Line 848: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;

844: , x_transaction_header_id out nocopy NUMBER
845: )
846:
847: as
848: ddp_comp_job_dtls_rec csd_hv_wip_job_pvt.job_dtls_rec_type;
849: ddindx binary_integer; indx binary_integer;
850: begin
851:
852: -- copy data to the local IN or IN-OUT args, if any

Line 874: csd_hv_wip_job_pvt.insert_job_comp_txn(p_api_version_number,

870:
871:
872:
873: -- here's the delegated call to the old PL/SQL routine
874: csd_hv_wip_job_pvt.insert_job_comp_txn(p_api_version_number,
875: p_init_msg_list,
876: p_commit,
877: p_validation_level,
878: x_return_status,

Line 932: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

928: , x_transaction_header_id out nocopy NUMBER
929: )
930:
931: as
932: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
933: ddindx binary_integer; indx binary_integer;
934: begin
935:
936: -- copy data to the local IN or IN-OUT args, if any

Line 944: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

940:
941:
942:
943:
944: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
945: , p7_a1
946: , p7_a2
947: , p7_a3
948: , p7_a4

Line 972: csd_hv_wip_job_pvt.process_issue_mtl_txn(p_api_version_number,

968: );
969:
970:
971: -- here's the delegated call to the old PL/SQL routine
972: csd_hv_wip_job_pvt.process_issue_mtl_txn(p_api_version_number,
973: p_init_msg_list,
974: p_commit,
975: p_validation_level,
976: x_return_status,

Line 1028: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1024: , p_transaction_header_id NUMBER
1025: )
1026:
1027: as
1028: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1029: ddindx binary_integer; indx binary_integer;
1030: begin
1031:
1032: -- copy data to the local IN or IN-OUT args, if any

Line 1040: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1036:
1037:
1038:
1039:
1040: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1041: , p7_a1
1042: , p7_a2
1043: , p7_a3
1044: , p7_a4

Line 1068: csd_hv_wip_job_pvt.process_issue_mtl_txns_lot_srl(p_api_version_number,

1064: );
1065:
1066:
1067: -- here's the delegated call to the old PL/SQL routine
1068: csd_hv_wip_job_pvt.process_issue_mtl_txns_lot_srl(p_api_version_number,
1069: p_init_msg_list,
1070: p_commit,
1071: p_validation_level,
1072: x_return_status,

Line 1124: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1120: , p_transaction_header_id NUMBER
1121: )
1122:
1123: as
1124: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1125: ddindx binary_integer; indx binary_integer;
1126: begin
1127:
1128: -- copy data to the local IN or IN-OUT args, if any

Line 1136: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1132:
1133:
1134:
1135:
1136: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1137: , p7_a1
1138: , p7_a2
1139: , p7_a3
1140: , p7_a4

Line 1164: csd_hv_wip_job_pvt.update_mtl_txns_lot_srl(p_api_version_number,

1160: );
1161:
1162:
1163: -- here's the delegated call to the old PL/SQL routine
1164: csd_hv_wip_job_pvt.update_mtl_txns_lot_srl(p_api_version_number,
1165: p_init_msg_list,
1166: p_commit,
1167: p_validation_level,
1168: x_return_status,

Line 1216: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;

1212: , p7_a20 JTF_VARCHAR2_TABLE_100
1213: )
1214:
1215: as
1216: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;
1217: ddindx binary_integer; indx binary_integer;
1218: begin
1219:
1220: -- copy data to the local IN or IN-OUT args, if any

Line 1228: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0

1224:
1225:
1226:
1227:
1228: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0
1229: , p7_a1
1230: , p7_a2
1231: , p7_a3
1232: , p7_a4

Line 1252: csd_hv_wip_job_pvt.process_transact_res_txn(p_api_version_number,

1248: , p7_a20
1249: );
1250:
1251: -- here's the delegated call to the old PL/SQL routine
1252: csd_hv_wip_job_pvt.process_transact_res_txn(p_api_version_number,
1253: p_init_msg_list,
1254: p_commit,
1255: p_validation_level,
1256: x_return_status,

Line 1306: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;

1302: , x_op_created out nocopy VARCHAR
1303: )
1304:
1305: as
1306: ddp_mtl_txn_dtls_tbl csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type;
1307: ddindx binary_integer; indx binary_integer;
1308: begin
1309:
1310: -- copy data to the local IN or IN-OUT args, if any

Line 1318: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0

1314:
1315:
1316:
1317:
1318: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p5(ddp_mtl_txn_dtls_tbl, p7_a0
1319: , p7_a1
1320: , p7_a2
1321: , p7_a3
1322: , p7_a4

Line 1346: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls(p_api_version_number,

1342: );
1343:
1344:
1345: -- here's the delegated call to the old PL/SQL routine
1346: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls(p_api_version_number,
1347: p_init_msg_list,
1348: p_commit,
1349: p_validation_level,
1350: x_return_status,

Line 1398: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;

1394: , p7_a20 JTF_VARCHAR2_TABLE_100
1395: )
1396:
1397: as
1398: ddp_res_txn_dtls_tbl csd_hv_wip_job_pvt.res_txn_dtls_tbl_type;
1399: ddindx binary_integer; indx binary_integer;
1400: begin
1401:
1402: -- copy data to the local IN or IN-OUT args, if any

Line 1410: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0

1406:
1407:
1408:
1409:
1410: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p7(ddp_res_txn_dtls_tbl, p7_a0
1411: , p7_a1
1412: , p7_a2
1413: , p7_a3
1414: , p7_a4

Line 1434: csd_hv_wip_job_pvt.process_save_res_txn_dtls(p_api_version_number,

1430: , p7_a20
1431: );
1432:
1433: -- here's the delegated call to the old PL/SQL routine
1434: csd_hv_wip_job_pvt.process_save_res_txn_dtls(p_api_version_number,
1435: p_init_msg_list,
1436: p_commit,
1437: p_validation_level,
1438: x_return_status,

Line 1481: ddp_op_dtls_tbl csd_hv_wip_job_pvt.op_dtls_tbl_type;

1477: , p7_a17 JTF_VARCHAR2_TABLE_100
1478: )
1479:
1480: as
1481: ddp_op_dtls_tbl csd_hv_wip_job_pvt.op_dtls_tbl_type;
1482: ddindx binary_integer; indx binary_integer;
1483: begin
1484:
1485: -- copy data to the local IN or IN-OUT args, if any

Line 1493: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p9(ddp_op_dtls_tbl, p7_a0

1489:
1490:
1491:
1492:
1493: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p9(ddp_op_dtls_tbl, p7_a0
1494: , p7_a1
1495: , p7_a2
1496: , p7_a3
1497: , p7_a4

Line 1514: csd_hv_wip_job_pvt.process_save_op_dtls(p_api_version_number,

1510: , p7_a17
1511: );
1512:
1513: -- here's the delegated call to the old PL/SQL routine
1514: csd_hv_wip_job_pvt.process_save_op_dtls(p_api_version_number,
1515: p_init_msg_list,
1516: p_commit,
1517: p_validation_level,
1518: x_return_status,

Line 1549: ddp_service_code_tbl csd_hv_wip_job_pvt.service_code_tbl_type;

1545: , p9_a3 JTF_NUMBER_TABLE
1546: )
1547:
1548: as
1549: ddp_service_code_tbl csd_hv_wip_job_pvt.service_code_tbl_type;
1550: ddindx binary_integer; indx binary_integer;
1551: begin
1552:
1553: -- copy data to the local IN or IN-OUT args, if any

Line 1563: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p11(ddp_service_code_tbl, p9_a0

1559:
1560:
1561:
1562:
1563: csd_hv_wip_job_pvt_w.rosetta_table_copy_in_p11(ddp_service_code_tbl, p9_a0
1564: , p9_a1
1565: , p9_a2
1566: , p9_a3
1567: );

Line 1570: csd_hv_wip_job_pvt.generate_wip_jobs_from_scs(p_api_version_number,

1566: , p9_a3
1567: );
1568:
1569: -- here's the delegated call to the old PL/SQL routine
1570: csd_hv_wip_job_pvt.generate_wip_jobs_from_scs(p_api_version_number,
1571: p_init_msg_list,
1572: p_commit,
1573: p_validation_level,
1574: x_return_status,

Line 1593: end csd_hv_wip_job_pvt_w;

1589:
1590:
1591: end;
1592:
1593: end csd_hv_wip_job_pvt_w;