DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT_W dependencies on AHL_PRD_BLK_PARTS_CHANGE_PVT

Line 1: package body ahl_prd_blk_parts_change_pvt_w as

1: package body ahl_prd_blk_parts_change_pvt_w as
2: /* $Header: AHLWBPCB.pls 120.0.12020000.2 2012/12/11 05:51:38 prakkum noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_prd_blk_parts_change_pvt_w as
2: /* $Header: AHLWBPCB.pls 120.0.12020000.2 2012/12/11 05:51:38 prakkum noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 164: procedure rosetta_table_copy_out_p5(t ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p5;
164: procedure rosetta_table_copy_out_p5(t ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_NUMBER_TABLE
168: , a4 out nocopy JTF_NUMBER_TABLE

Line 543: procedure rosetta_table_copy_in_p8(t out nocopy ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 JTF_VARCHAR2_TABLE_100

539: end if;
540: end if;
541: end rosetta_table_copy_out_p5;
542:
543: procedure rosetta_table_copy_in_p8(t out nocopy ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 JTF_VARCHAR2_TABLE_100
544: , a1 JTF_VARCHAR2_TABLE_300
545: ) as
546: ddindx binary_integer; indx binary_integer;
547: begin

Line 564: procedure rosetta_table_copy_out_p8(t ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

560: end loop;
561: end if;
562: end if;
563: end rosetta_table_copy_in_p8;
564: procedure rosetta_table_copy_out_p8(t ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
565: , a1 out nocopy JTF_VARCHAR2_TABLE_300
566: ) as
567: ddindx binary_integer; indx binary_integer;
568: begin

Line 593: procedure rosetta_table_copy_in_p12(t out nocopy ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 JTF_NUMBER_TABLE

589: end if;
590: end if;
591: end rosetta_table_copy_out_p8;
592:
593: procedure rosetta_table_copy_in_p12(t out nocopy ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 JTF_NUMBER_TABLE
594: , a1 JTF_NUMBER_TABLE
595: , a2 JTF_NUMBER_TABLE
596: , a3 JTF_VARCHAR2_TABLE_100
597: , a4 JTF_NUMBER_TABLE

Line 708: procedure rosetta_table_copy_out_p12(t ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

704: end loop;
705: end if;
706: end if;
707: end rosetta_table_copy_in_p12;
708: procedure rosetta_table_copy_out_p12(t ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
709: , a1 out nocopy JTF_NUMBER_TABLE
710: , a2 out nocopy JTF_NUMBER_TABLE
711: , a3 out nocopy JTF_VARCHAR2_TABLE_100
712: , a4 out nocopy JTF_NUMBER_TABLE

Line 972: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

968: end if;
969: end if;
970: end rosetta_table_copy_out_p12;
971:
972: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
973: , a1 JTF_VARCHAR2_TABLE_4000
974: ) as
975: ddindx binary_integer; indx binary_integer;
976: begin

Line 993: procedure rosetta_table_copy_out_p14(t ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

989: end loop;
990: end if;
991: end if;
992: end rosetta_table_copy_in_p14;
993: procedure rosetta_table_copy_out_p14(t ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
994: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
995: ) as
996: ddindx binary_integer; indx binary_integer;
997: begin

Line 1108: ddx_uc_details_tbl ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type;

1104: , x_msg_data out nocopy VARCHAR2
1105: )
1106:
1107: as
1108: ddx_uc_details_tbl ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type;
1109: ddindx binary_integer; indx binary_integer;
1110: begin
1111:
1112: -- copy data to the local IN or IN-OUT args, if any

Line 1126: ahl_prd_blk_parts_change_pvt.get_bulk_part_chg_details(p_api_version,

1122:
1123:
1124:
1125: -- here's the delegated call to the old PL/SQL routine
1126: ahl_prd_blk_parts_change_pvt.get_bulk_part_chg_details(p_api_version,
1127: p_init_msg_list,
1128: p_commit,
1129: p_validation_level,
1130: p_default,

Line 1148: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_out_p5(ddx_uc_details_tbl, p8_a0

1144:
1145:
1146:
1147:
1148: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_out_p5(ddx_uc_details_tbl, p8_a0
1149: , p8_a1
1150: , p8_a2
1151: , p8_a3
1152: , p8_a4

Line 1241: ddp_filter_records_tbl ahl_prd_blk_parts_change_pvt.filter_records_tbl_type;

1237: , x_msg_data out nocopy VARCHAR2
1238: )
1239:
1240: as
1241: ddp_filter_records_tbl ahl_prd_blk_parts_change_pvt.filter_records_tbl_type;
1242: ddindx binary_integer; indx binary_integer;
1243: begin
1244:
1245: -- copy data to the local IN or IN-OUT args, if any

Line 1252: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_in_p8(ddp_filter_records_tbl, p6_a0

1248:
1249:
1250:
1251:
1252: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_in_p8(ddp_filter_records_tbl, p6_a0
1253: , p6_a1
1254: );
1255:
1256:

Line 1261: ahl_prd_blk_parts_change_pvt.filter_records_uc_details(p_api_version,

1257:
1258:
1259:
1260: -- here's the delegated call to the old PL/SQL routine
1261: ahl_prd_blk_parts_change_pvt.filter_records_uc_details(p_api_version,
1262: p_init_msg_list,
1263: p_commit,
1264: p_validation_level,
1265: p_default,

Line 1361: ddp_x_uc_details_rec ahl_prd_blk_parts_change_pvt.uc_details_hgrid_rec_type;

1357: , p0_a71 in out nocopy VARCHAR2
1358: )
1359:
1360: as
1361: ddp_x_uc_details_rec ahl_prd_blk_parts_change_pvt.uc_details_hgrid_rec_type;
1362: ddindx binary_integer; indx binary_integer;
1363: begin
1364:
1365: -- copy data to the local IN or IN-OUT args, if any

Line 1440: ahl_prd_blk_parts_change_pvt.calc_qty_on_inst_selection(ddp_x_uc_details_rec);

1436: ddp_x_uc_details_rec.mrb_quality_typ := p0_a70;
1437: ddp_x_uc_details_rec.bulk_process_flag := p0_a71;
1438:
1439: -- here's the delegated call to the old PL/SQL routine
1440: ahl_prd_blk_parts_change_pvt.calc_qty_on_inst_selection(ddp_x_uc_details_rec);
1441:
1442: -- copy data back from the local variables to OUT or IN-OUT args, if any
1443: p0_a0 := ddp_x_uc_details_rec.unit_node_id;
1444: p0_a1 := ddp_x_uc_details_rec.root_instance_id;

Line 1590: ddp_x_parts_rec_tbl ahl_prd_blk_parts_change_pvt.part_change_tbl_type;

1586: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_4000
1587: )
1588:
1589: as
1590: ddp_x_parts_rec_tbl ahl_prd_blk_parts_change_pvt.part_change_tbl_type;
1591: ddp_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;
1592: ddx_error_msg_tbl ahl_prd_blk_parts_change_pvt.error_msg_tbl_type;
1593: ddindx binary_integer; indx binary_integer;
1594: begin

Line 1592: ddx_error_msg_tbl ahl_prd_blk_parts_change_pvt.error_msg_tbl_type;

1588:
1589: as
1590: ddp_x_parts_rec_tbl ahl_prd_blk_parts_change_pvt.part_change_tbl_type;
1591: ddp_mr_asso_tbl ahl_prd_nonroutine_pvt.mr_association_tbl_type;
1592: ddx_error_msg_tbl ahl_prd_blk_parts_change_pvt.error_msg_tbl_type;
1593: ddindx binary_integer; indx binary_integer;
1594: begin
1595:
1596: -- copy data to the local IN or IN-OUT args, if any

Line 1603: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_in_p12(ddp_x_parts_rec_tbl, p6_a0

1599:
1600:
1601:
1602:
1603: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_in_p12(ddp_x_parts_rec_tbl, p6_a0
1604: , p6_a1
1605: , p6_a2
1606: , p6_a3
1607: , p6_a4

Line 1671: ahl_prd_blk_parts_change_pvt.process_part_changes(p_api_version,

1667:
1668:
1669:
1670: -- here's the delegated call to the old PL/SQL routine
1671: ahl_prd_blk_parts_change_pvt.process_part_changes(p_api_version,
1672: p_init_msg_list,
1673: p_commit,
1674: p_validation_level,
1675: p_module_type,

Line 1691: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_out_p12(ddp_x_parts_rec_tbl, p6_a0

1687:
1688:
1689:
1690:
1691: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_out_p12(ddp_x_parts_rec_tbl, p6_a0
1692: , p6_a1
1693: , p6_a2
1694: , p6_a3
1695: , p6_a4

Line 1746: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_out_p14(ddx_error_msg_tbl, p11_a0

1742:
1743:
1744:
1745:
1746: ahl_prd_blk_parts_change_pvt_w.rosetta_table_copy_out_p14(ddx_error_msg_tbl, p11_a0
1747: , p11_a1
1748: );
1749: end;
1750:

Line 1751: end ahl_prd_blk_parts_change_pvt_w;

1747: , p11_a1
1748: );
1749: end;
1750:
1751: end ahl_prd_blk_parts_change_pvt_w;