DBA Data[Home] [Help]

APPS.EAM_ACTIVITY_PUB dependencies on INV_ITEM_GRP

Line 105: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

101: x_return_status OUT NOCOPY VARCHAR2 ,
102: x_msg_count OUT NOCOPY NUMBER ,
103: x_msg_data OUT NOCOPY VARCHAR2 ,
104:
105: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
106: p_template_id IN NUMBER := NULL,
107: p_template_name IN VARCHAR2 := NULL,
108: p_activity_type_code IN VARCHAR2 := NULL,
109: p_activity_cause_code IN VARCHAR2 := NULL,

Line 123: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

119:
120: -- x_inventory_item_id OUT NUMBER, -- the inventory_item_it the system has created
121: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
122:
123: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
124: x_curr_item_return_status OUT NOCOPY VARCHAR2,
125: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
126: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
127: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 125: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

121: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
122:
123: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
124: x_curr_item_return_status OUT NOCOPY VARCHAR2,
125: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
126: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
127: x_master_item_return_status OUT NOCOPY VARCHAR2,
128: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
129:

Line 126: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

122:
123: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
124: x_curr_item_return_status OUT NOCOPY VARCHAR2,
125: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
126: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
127: x_master_item_return_status OUT NOCOPY VARCHAR2,
128: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
129:
130: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

Line 128: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

124: x_curr_item_return_status OUT NOCOPY VARCHAR2,
125: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
126: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
127: x_master_item_return_status OUT NOCOPY VARCHAR2,
128: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
129:
130: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
131: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
132: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 167: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

163: x_msg_count OUT NOCOPY NUMBER ,
164: x_msg_data OUT NOCOPY VARCHAR2 ,
165:
166: -- target activity, need to set org, item name, description
167: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
168:
169:
170: p_template_id IN NUMBER := NULL,
171: p_template_name IN VARCHAR2 := NULL,

Line 192: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

188: p_bom_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
189: p_routing_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
190: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
191:
192: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
193: x_curr_item_return_status OUT NOCOPY VARCHAR2,
194: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
195: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
196: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 194: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

190: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
191:
192: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
193: x_curr_item_return_status OUT NOCOPY VARCHAR2,
194: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
195: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
196: x_master_item_return_status OUT NOCOPY VARCHAR2,
197: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
198:

Line 195: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

191:
192: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
193: x_curr_item_return_status OUT NOCOPY VARCHAR2,
194: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
195: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
196: x_master_item_return_status OUT NOCOPY VARCHAR2,
197: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
198:
199: x_assoc_return_status OUT NOCOPY VARCHAR2,

Line 197: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

193: x_curr_item_return_status OUT NOCOPY VARCHAR2,
194: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
195: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
196: x_master_item_return_status OUT NOCOPY VARCHAR2,
197: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
198:
199: x_assoc_return_status OUT NOCOPY VARCHAR2,
200: x_assoc_msg_count OUT NOCOPY NUMBER,
201: x_assoc_msg_data OUT NOCOPY VARCHAR2,

Line 287: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

283: p_shutdown_type_code IN VARCHAR2 := NULL,
284: p_notification_req_flag IN VARCHAR2 := NULL,
285: p_activity_source_code IN VARCHAR2 := NULL,
286:
287: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
288: x_curr_item_return_status OUT NOCOPY VARCHAR2,
289: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
290: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
291: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 289: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

285: p_activity_source_code IN VARCHAR2 := NULL,
286:
287: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
288: x_curr_item_return_status OUT NOCOPY VARCHAR2,
289: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
290: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
291: x_master_item_return_status OUT NOCOPY VARCHAR2,
292: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
293: );

Line 290: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

286:
287: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
288: x_curr_item_return_status OUT NOCOPY VARCHAR2,
289: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
290: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
291: x_master_item_return_status OUT NOCOPY VARCHAR2,
292: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
293: );
294:

Line 292: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

288: x_curr_item_return_status OUT NOCOPY VARCHAR2,
289: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
290: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
291: x_master_item_return_status OUT NOCOPY VARCHAR2,
292: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
293: );
294:
295: -- From Saurabh
296: procedure create_bom_header(

Line 297: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

293: );
294:
295: -- From Saurabh
296: procedure create_bom_header(
297: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
298: --p_source_org_id IN NUMBER,
299: --p_source_activity_id IN NUMBER, -- inventory_item_id
300:
301: --p_material_copy_option IN NUMBER,

Line 314: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

310: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
311: );
312:
313: procedure create_bom_header_form(
314: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
315: p_inventory_item_name varchar2,
316: p_organization_code varchar2,
317: x_return_status OUT NOCOPY VARCHAR2
318: );

Line 362: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,

358: p_shutdown_type_code IN VARCHAR2 := NULL,
359: p_notification_req_flag IN VARCHAR2 := NULL,
360: p_activity_source_code IN VARCHAR2 := NULL
361:
362: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
363: --x_curr_item_return_status OUT VARCHAR2,
364: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
365: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
366: --x_master_item_return_status OUT VARCHAR2,

Line 364: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,

360: p_activity_source_code IN VARCHAR2 := NULL
361:
362: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
363: --x_curr_item_return_status OUT VARCHAR2,
364: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
365: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
366: --x_master_item_return_status OUT VARCHAR2,
367: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
368: );

Line 365: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,

361:
362: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
363: --x_curr_item_return_status OUT VARCHAR2,
364: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
365: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
366: --x_master_item_return_status OUT VARCHAR2,
367: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
368: );
369:

Line 367: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type

363: --x_curr_item_return_status OUT VARCHAR2,
364: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
365: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
366: --x_master_item_return_status OUT VARCHAR2,
367: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
368: );
369:
370: PROCEDURE Create_Routing_Header(
371: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

Line 371: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

367: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
368: );
369:
370: PROCEDURE Create_Routing_Header(
371: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
372:
373: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
374: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
375: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 385: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

381: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
382: );
383:
384: procedure create_routing_header_form(
385: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
386: p_inventory_item_name varchar2,
387: p_organization_code varchar2,
388: x_return_status OUT NOCOPY VARCHAR2
389: );