[Home] [Help]
109: leaf_node_flag VARCHAR2(1),
110: with_submc_flag VARCHAR2(1));
111: TYPE uc_descendant_tbl_type IS TABLE OF uc_descendant_rec_type INDEX BY BINARY_INTEGER;
112:
113: -- Define Record Type for alternate CSI item instances --
114: TYPE available_instance_rec_type IS RECORD (
115: csi_item_instance_id NUMBER,
116: csi_object_version_number NUMBER,
117: inventory_item_id NUMBER,
121: -- Increase this from 40 to 240 so that Rosetta will declare these
122: -- as VARCHAR2(300) instead of VARCHAR2(100).
123: item_number VARCHAR2(240),
124: item_description VARCHAR2(240),
125: csi_instance_number csi_item_instances.instance_number%type,
126: serial_number VARCHAR2(30),
127: lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE,
128: revision VARCHAR2(3),
129: uom_code VARCHAR2(3),
257: p_prod_user_flag IN VARCHAR2);
258:
259: -- Start of Comments --
260: -- Define procedure install_new_instance
261: -- This API is used to create a new instance in csi_item_instances and assign it
262: -- to a UC node.
263: --
264: -- Procedure name: install_new_instance
265: -- Type: Private
262: -- to a UC node.
263: --
264: -- Procedure name: install_new_instance
265: -- Type: Private
266: -- Function: To create a new instance in csi_item_instances and assign it
267: -- to a UC node.
268: -- Pre-reqs:
269: --
270: -- install_new_instance parameters:
302: -- This API is used to assign an existing instance to a UC node.
303: --
304: -- Procedure name : install_existing_instance
305: -- Type : Private
306: -- Function : To assign an existing instance in csi_item_instances to a UC node.
307: -- Pre-reqs :
308: --
309: -- install_existing_instance parameters :
310: -- p_uc_header_id IN NUMBER Required
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_uc_header_id IN NUMBER,
329: p_parent_instance_id IN NUMBER,
330: p_instance_id IN NUMBER,
331: p_instance_number IN csi_item_instances.instance_number%TYPE := NULL,
332: p_relationship_id IN NUMBER,
333: p_csi_ii_ovn IN NUMBER,
334: p_prod_user_flag IN VARCHAR2,
335: -- SURRKUMA :: 13694898 :: Flag to bypass the validation of position completeness, 29-FEB-2012
367: p_uc_header_id IN NUMBER,
368: p_parent_instance_id IN NUMBER,
369: p_old_instance_id IN NUMBER,
370: p_new_instance_id IN NUMBER,
371: p_new_instance_number IN csi_item_instances.instance_number%TYPE := NULL,
372: p_relationship_id IN NUMBER,
373: p_csi_ii_ovn IN NUMBER,
374: p_prod_user_flag IN VARCHAR2,
375: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
432: );
433:
434: -- Start of Comments --
435: -- Define procedure create_unassigned_instance.
436: -- This API is used to create a new instance in csi_item_instances and assign it
437: -- to the UC root node as extra node.
438: --
439: -- Procedure name: create_unassigned_instance
440: -- Type : Private
437: -- to the UC root node as extra node.
438: --
439: -- Procedure name: create_unassigned_instance
440: -- Type : Private
441: -- Function : To create a new instance in csi_item_instances and assign it
442: -- to the UC root node as extra node.
443: -- Pre-reqs:
444: --
445: -- create_unassigned_instance parameters: