DBA Data[Home] [Help]

APPS.EAM_ACTIVITY_PUB dependencies on INV_ITEM_GRP

Line 112: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,
111:
112: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
113: p_template_id IN NUMBER := NULL,
114: p_template_name IN VARCHAR2 := NULL,
115: p_activity_type_code IN VARCHAR2 := NULL,
116: p_activity_cause_code IN VARCHAR2 := NULL,

Line 130: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

126:
127: -- x_inventory_item_id OUT NUMBER, -- the inventory_item_it the system has created
128: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
129:
130: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
131: x_curr_item_return_status OUT NOCOPY VARCHAR2,
132: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
133: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
134: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 132: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

128: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
129:
130: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
131: x_curr_item_return_status OUT NOCOPY VARCHAR2,
132: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
133: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
134: x_master_item_return_status OUT NOCOPY VARCHAR2,
135: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
136:

Line 133: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

129:
130: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
131: x_curr_item_return_status OUT NOCOPY VARCHAR2,
132: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
133: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
134: x_master_item_return_status OUT NOCOPY VARCHAR2,
135: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
136:
137: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

Line 135: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

131: x_curr_item_return_status OUT NOCOPY VARCHAR2,
132: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
133: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
134: x_master_item_return_status OUT NOCOPY VARCHAR2,
135: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
136:
137: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
138: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
139: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 174: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

170: x_msg_count OUT NOCOPY NUMBER ,
171: x_msg_data OUT NOCOPY VARCHAR2 ,
172:
173: -- target activity, need to set org, item name, description
174: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
175:
176:
177: p_template_id IN NUMBER := NULL,
178: p_template_name IN VARCHAR2 := NULL,

Line 199: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

195: p_bom_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
196: p_routing_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
197: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
198:
199: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
200: x_curr_item_return_status OUT NOCOPY VARCHAR2,
201: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
202: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
203: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 201: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

197: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
198:
199: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
200: x_curr_item_return_status OUT NOCOPY VARCHAR2,
201: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
202: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
203: x_master_item_return_status OUT NOCOPY VARCHAR2,
204: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
205:

Line 202: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

198:
199: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
200: x_curr_item_return_status OUT NOCOPY VARCHAR2,
201: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
202: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
203: x_master_item_return_status OUT NOCOPY VARCHAR2,
204: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
205:
206: x_assoc_return_status OUT NOCOPY VARCHAR2,

Line 204: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

200: x_curr_item_return_status OUT NOCOPY VARCHAR2,
201: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
202: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
203: x_master_item_return_status OUT NOCOPY VARCHAR2,
204: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
205:
206: x_assoc_return_status OUT NOCOPY VARCHAR2,
207: x_assoc_msg_count OUT NOCOPY NUMBER,
208: x_assoc_msg_data OUT NOCOPY VARCHAR2,

Line 294: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

290: p_shutdown_type_code IN VARCHAR2 := NULL,
291: p_notification_req_flag IN VARCHAR2 := NULL,
292: p_activity_source_code IN VARCHAR2 := NULL,
293:
294: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
295: x_curr_item_return_status OUT NOCOPY VARCHAR2,
296: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
297: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
298: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 296: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

292: p_activity_source_code IN VARCHAR2 := NULL,
293:
294: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
295: x_curr_item_return_status OUT NOCOPY VARCHAR2,
296: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
297: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
298: x_master_item_return_status OUT NOCOPY VARCHAR2,
299: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
300: );

Line 297: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

293:
294: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
295: x_curr_item_return_status OUT NOCOPY VARCHAR2,
296: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
297: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
298: x_master_item_return_status OUT NOCOPY VARCHAR2,
299: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
300: );
301:

Line 299: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

295: x_curr_item_return_status OUT NOCOPY VARCHAR2,
296: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
297: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
298: x_master_item_return_status OUT NOCOPY VARCHAR2,
299: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
300: );
301:
302: -- From Saurabh
303: procedure create_bom_header(

Line 304: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

300: );
301:
302: -- From Saurabh
303: procedure create_bom_header(
304: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
305: --p_source_org_id IN NUMBER,
306: --p_source_activity_id IN NUMBER, -- inventory_item_id
307:
308: --p_material_copy_option IN NUMBER,

Line 321: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

317: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
318: );
319:
320: procedure create_bom_header_form(
321: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
322: p_inventory_item_name varchar2,
323: p_organization_code varchar2,
324: x_return_status OUT NOCOPY VARCHAR2
325: );

Line 369: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,

365: p_shutdown_type_code IN VARCHAR2 := NULL,
366: p_notification_req_flag IN VARCHAR2 := NULL,
367: p_activity_source_code IN VARCHAR2 := NULL
368:
369: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
370: --x_curr_item_return_status OUT VARCHAR2,
371: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
372: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
373: --x_master_item_return_status OUT VARCHAR2,

Line 371: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,

367: p_activity_source_code IN VARCHAR2 := NULL
368:
369: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
370: --x_curr_item_return_status OUT VARCHAR2,
371: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
372: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
373: --x_master_item_return_status OUT VARCHAR2,
374: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
375: );

Line 372: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,

368:
369: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
370: --x_curr_item_return_status OUT VARCHAR2,
371: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
372: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
373: --x_master_item_return_status OUT VARCHAR2,
374: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
375: );
376:

Line 374: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type

370: --x_curr_item_return_status OUT VARCHAR2,
371: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
372: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
373: --x_master_item_return_status OUT VARCHAR2,
374: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
375: );
376:
377: PROCEDURE Create_Routing_Header(
378: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

Line 378: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

374: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
375: );
376:
377: PROCEDURE Create_Routing_Header(
378: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
379:
380: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
381: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
382: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 392: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

388: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
389: );
390:
391: procedure create_routing_header_form(
392: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
393: p_inventory_item_name varchar2,
394: p_organization_code varchar2,
395: x_return_status OUT NOCOPY VARCHAR2
396: );