DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT_W dependencies on AHL_PRD_BLK_PARTS_CHANGE_PVT

Line 1: package ahl_prd_blk_parts_change_pvt_w AUTHID CURRENT_USER as

1: package ahl_prd_blk_parts_change_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWBPCS.pls 120.0.12020000.2 2012/12/11 05:52:21 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 ahl_prd_blk_parts_change_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWBPCS.pls 120.0.12020000.2 2012/12/11 05:52:21 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 76: procedure rosetta_table_copy_out_p5(t ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

72: , a69 JTF_VARCHAR2_TABLE_100
73: , a70 JTF_VARCHAR2_TABLE_100
74: , a71 JTF_VARCHAR2_TABLE_100
75: );
76: procedure rosetta_table_copy_out_p5(t ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_NUMBER_TABLE
79: , a3 out nocopy JTF_NUMBER_TABLE
80: , a4 out nocopy JTF_NUMBER_TABLE

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

146: , a70 out nocopy JTF_VARCHAR2_TABLE_100
147: , a71 out nocopy JTF_VARCHAR2_TABLE_100
148: );
149:
150: procedure rosetta_table_copy_in_p8(t out nocopy ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 JTF_VARCHAR2_TABLE_100
151: , a1 JTF_VARCHAR2_TABLE_300
152: );
153: procedure rosetta_table_copy_out_p8(t ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
154: , a1 out nocopy JTF_VARCHAR2_TABLE_300

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

149:
150: procedure rosetta_table_copy_in_p8(t out nocopy ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 JTF_VARCHAR2_TABLE_100
151: , a1 JTF_VARCHAR2_TABLE_300
152: );
153: procedure rosetta_table_copy_out_p8(t ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
154: , a1 out nocopy JTF_VARCHAR2_TABLE_300
155: );
156:
157: procedure rosetta_table_copy_in_p12(t out nocopy ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 JTF_NUMBER_TABLE

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

153: procedure rosetta_table_copy_out_p8(t ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
154: , a1 out nocopy JTF_VARCHAR2_TABLE_300
155: );
156:
157: procedure rosetta_table_copy_in_p12(t out nocopy ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 JTF_NUMBER_TABLE
158: , a1 JTF_NUMBER_TABLE
159: , a2 JTF_NUMBER_TABLE
160: , a3 JTF_VARCHAR2_TABLE_100
161: , a4 JTF_NUMBER_TABLE

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

203: , a46 JTF_NUMBER_TABLE
204: , a47 JTF_NUMBER_TABLE
205: , a48 JTF_NUMBER_TABLE
206: );
207: procedure rosetta_table_copy_out_p12(t ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
208: , a1 out nocopy JTF_NUMBER_TABLE
209: , a2 out nocopy JTF_NUMBER_TABLE
210: , a3 out nocopy JTF_VARCHAR2_TABLE_100
211: , a4 out nocopy JTF_NUMBER_TABLE

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

254: , a47 out nocopy JTF_NUMBER_TABLE
255: , a48 out nocopy JTF_NUMBER_TABLE
256: );
257:
258: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
259: , a1 JTF_VARCHAR2_TABLE_4000
260: );
261: procedure rosetta_table_copy_out_p14(t ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
262: , a1 out nocopy JTF_VARCHAR2_TABLE_4000

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

257:
258: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
259: , a1 JTF_VARCHAR2_TABLE_4000
260: );
261: procedure rosetta_table_copy_out_p14(t ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
262: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
263: );
264:
265: procedure get_bulk_part_chg_details(p_api_version NUMBER

Line 506: end ahl_prd_blk_parts_change_pvt_w;

502: , x_msg_data out nocopy VARCHAR2
503: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_100
504: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_4000
505: );
506: end ahl_prd_blk_parts_change_pvt_w;