[Home] [Help]
PACKAGE: APPS.AHL_LTP_MTL_REQ_PVT_W
Source
1 package ahl_ltp_mtl_req_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWLMRS.pls 120.0.12020000.2 2012/12/14 09:50:33 shnatu noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_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
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 );
16 procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17 , a1 out nocopy JTF_NUMBER_TABLE
18 , a2 out nocopy JTF_NUMBER_TABLE
19 , a3 out nocopy JTF_NUMBER_TABLE
20 , a4 out nocopy JTF_NUMBER_TABLE
21 , a5 out nocopy JTF_VARCHAR2_TABLE_100
22 , a6 out nocopy JTF_NUMBER_TABLE
23 , a7 out nocopy JTF_NUMBER_TABLE
24 , a8 out nocopy JTF_NUMBER_TABLE
25 , a9 out nocopy JTF_NUMBER_TABLE
26 , a10 out nocopy JTF_NUMBER_TABLE
27 , a11 out nocopy JTF_NUMBER_TABLE
28 );
29
30 procedure rosetta_table_copy_in_p2(t out nocopy ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 JTF_NUMBER_TABLE);
31 procedure rosetta_table_copy_out_p2(t ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
32
33 procedure get_route_mtl_req(p_api_version NUMBER
34 , p_init_msg_list VARCHAR2
35 , p_validation_level NUMBER
36 , x_return_status out nocopy VARCHAR2
37 , x_msg_count out nocopy NUMBER
38 , x_msg_data out nocopy VARCHAR2
39 , p_route_id NUMBER
40 , p_mr_route_id NUMBER
41 , p_item_instance_id NUMBER
42 , p_visit_id NUMBER
43 , p_requirement_date DATE
44 , p_request_type VARCHAR2
45 , p12_a0 out nocopy JTF_NUMBER_TABLE
46 , p12_a1 out nocopy JTF_NUMBER_TABLE
47 , p12_a2 out nocopy JTF_NUMBER_TABLE
48 , p12_a3 out nocopy JTF_NUMBER_TABLE
49 , p12_a4 out nocopy JTF_NUMBER_TABLE
50 , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
51 , p12_a6 out nocopy JTF_NUMBER_TABLE
52 , p12_a7 out nocopy JTF_NUMBER_TABLE
53 , p12_a8 out nocopy JTF_NUMBER_TABLE
54 , p12_a9 out nocopy JTF_NUMBER_TABLE
55 , p12_a10 out nocopy JTF_NUMBER_TABLE
56 , p12_a11 out nocopy JTF_NUMBER_TABLE
57 );
58 procedure get_material_req_for_pos(p_api_version NUMBER
59 , p_init_msg_list VARCHAR2
60 , p_validation_level NUMBER
61 , x_return_status out nocopy VARCHAR2
62 , x_msg_count out nocopy NUMBER
63 , x_msg_data out nocopy VARCHAR2
64 , p_uc_header_id NUMBER
65 , p_visit_id NUMBER
66 , p_quantity NUMBER
67 , p_uom_code VARCHAR2
68 , p_x_index in out nocopy NUMBER
69 , p11_a0 in out nocopy JTF_NUMBER_TABLE
70 , p11_a1 in out nocopy JTF_NUMBER_TABLE
71 , p11_a2 in out nocopy JTF_NUMBER_TABLE
72 , p11_a3 in out nocopy JTF_NUMBER_TABLE
73 , p11_a4 in out nocopy JTF_NUMBER_TABLE
74 , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
75 , p11_a6 in out nocopy JTF_NUMBER_TABLE
76 , p11_a7 in out nocopy JTF_NUMBER_TABLE
77 , p11_a8 in out nocopy JTF_NUMBER_TABLE
78 , p11_a9 in out nocopy JTF_NUMBER_TABLE
79 , p11_a10 in out nocopy JTF_NUMBER_TABLE
80 , p11_a11 in out nocopy JTF_NUMBER_TABLE
81 );
82 procedure get_alternate_items(p_api_version NUMBER
83 , p_init_msg_list VARCHAR2
84 , p_validation_level NUMBER
85 , p_schedule_material_id NUMBER
86 , p_curr_item_flag VARCHAR2
87 , x_alt_items out nocopy JTF_NUMBER_TABLE
88 , x_return_status out nocopy VARCHAR2
89 , x_msg_count out nocopy NUMBER
90 , x_msg_data out nocopy VARCHAR2
91 );
92 end ahl_ltp_mtl_req_pvt_w;