1 PACKAGE AHL_LTP_MATRL_AVAL_PVT AS
2 /* $Header: AHLVMTAS.pls 120.1 2008/02/25 11:32:42 rnahata ship $*/
3 --
4 --
5 -- Start of Comments --
6 -- Procedure name : Check_Availability
7 -- Type : Private
8 -- Function : This procedure calls ATP to check inventory item is available
9 -- for Routine jobs derived requested quantity and task start date
10 -- Pre-reqs :
11 -- Parameters :
12 --
13 -- Standard OUT Parameters :
14 -- x_return_status OUT VARCHAR2 Required
15 --
16 -- Check_Material_Aval Parameters :
17 -- p_calling_module IN NUMBER default null
18 -- p_inventory_item_id IN NUMBER , Required
19 -- p_quantity_required IN NUMBER, Required
20 -- p_organization_id IN NUMBER, Required
21 -- p_uom IN VARCHAR2, Required
22 -- p_requested_date IN VARCHAR2, Required
23 --
24 PROCEDURE Check_Availability (
25 p_calling_module IN NUMBER ,
26 p_inventory_item_id IN NUMBER ,
27 p_item_description IN VARCHAR2 ,
28 p_quantity_required IN NUMBER,
29 p_organization_id IN NUMBER,
30 p_uom IN VARCHAR2,
31 p_requested_date IN DATE, --Modified by rnahata for Issue 105
32 p_schedule_material_id IN NUMBER,
33 x_available_qty OUT NOCOPY NUMBER,
34 x_available_date OUT NOCOPY DATE,
35 x_error_code OUT NOCOPY NUMBER,
36 x_error_message OUT NOCOPY VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2
38 );
39
40 -- Start of Comments --
41 -- Procedure name : Check_Material_Aval
42 -- Type : Private
43 -- Function : This procedure calls ATP to check inventory item is available
44 -- for Routine jobs derived requested quantity and task start date
45 -- Pre-reqs :
46 -- Parameters :
47 --
48 -- Standard IN Parameters :
49 -- p_api_version IN NUMBER Required
50 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
51 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
52 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
53 -- Based on this flag, the API will set the default attributes.
54 -- p_module_type In VARCHAR2 Default NULL
55 -- This will be null.
56 -- Standard OUT Parameters :
57 -- x_return_status OUT VARCHAR2 Required
58 -- x_msg_count OUT NUMBER Required
59 -- x_msg_data OUT VARCHAR2 Required
60 --
61 -- Check_Material_Aval Parameters :
62 -- p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,Required
63 -- List of item attributes associated to visit task
64 --
65
66 PROCEDURE Check_Material_Aval (
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
69 p_commit IN VARCHAR2 := FND_API.g_false,
70 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
71 p_module_type IN VARCHAR2 := 'JSP',
72 p_x_material_avl_tbl IN OUT NOCOPY ahl_ltp_matrl_aval_pub.Material_Availability_Tbl,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78 -- Start of Comments --
79 -- Procedure name : Get_Visit_Task_Materials
80 -- Type : Private
81 -- Function : This procedure derives material information associated to scheduled
82 -- visit, which are defined at Route Operation level
83 -- Pre-reqs :
84 -- Parameters :
85 --
86 -- Standard IN Parameters :
87 -- p_api_version IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
89 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
90 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
91 -- Based on this flag, the API will set the default attributes.
92 -- p_module_type In VARCHAR2 Default NULL
93 -- This will be null.
94 -- Standard OUT Parameters :
95 -- x_return_status OUT VARCHAR2 Required
96 -- x_msg_count OUT NUMBER Required
97 -- x_msg_data OUT VARCHAR2 Required
98 --
99 -- Get_Visit_Task_Materials :
100 -- p_visit_id IN NUMBER,Required
101 -- x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,
102 --
103
104 PROCEDURE Get_Visit_Task_Materials (
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
107 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
108 p_visit_id IN NUMBER,
109 x_task_req_matrl_tbl OUT NOCOPY ahl_ltp_matrl_aval_pub.task_req_matrl_tbl,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113
114 );
115
116 -- Start of Comments --
117 -- Procedure name : Schedule_Planned_Mtrls
118 -- Type : Public
119 -- Function : This procedure calls ATP to schedule planned materials
120 -- for Routine jobs derived requested quantity and task start date
121 -- Pre-reqs :
122 -- Parameters :
123 --
124 -- Standard IN Parameters :
125 -- p_api_version IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
127 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
128 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
129 -- Based on this flag, the API will set the default attributes.
130 -- p_module_type In VARCHAR2 Default NULL
131 -- This will be null.
132 -- Standard OUT Parameters :
133 -- x_return_status OUT VARCHAR2 Required
134 -- x_msg_count OUT NUMBER Required
135 -- x_msg_data OUT VARCHAR2 Required
136 --
137 -- Schedule_Planned_Matrls Parameters :
138 -- p_x_planned_matrls_tbl IN OUT NOCOPY Planned_Matrls_Tbl,Required
139 -- List of item attributes associated to visit task
140 --
141 PROCEDURE Schedule_Planned_Matrls (
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144 p_commit IN VARCHAR2 := FND_API.g_false,
145 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
146 p_x_planned_matrl_tbl IN OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2
150 );
151
152 -- Start of Comments --
153 -- Procedure name : Schedule_All_Materials
154 -- Type : Public
155 -- Function : This procedure calls ATP to schedule planned materials for a visit
156 -- for Routine jobs derived requested quantity and task start date
157 -- Pre-reqs :
158 -- Parameters :
159 --
160 -- Standard IN Parameters :
161 -- p_api_version IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
163 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
164 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165 -- Based on this flag, the API will set the default attributes.
166 -- p_module_type In VARCHAR2 Default NULL
167 -- This will be null.
168 -- Standard OUT Parameters :
169 -- x_return_status OUT VARCHAR2 Required
170 -- x_msg_count OUT NUMBER Required
171 -- x_msg_data OUT VARCHAR2 Required
172 --
173 -- Schedule_All_Materials Parameters :
174 -- p_visit_id IN Number,Required
175 -- List of item attributes associated to visit task
176 --
177 PROCEDURE Schedule_All_Materials (
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
180 p_commit IN VARCHAR2 := FND_API.g_false,
181 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
182 p_visit_id IN NUMBER,
183 x_planned_matrl_tbl OUT NOCOPY AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 END AHL_LTP_MATRL_AVAL_PVT;