[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
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_uc_header_id IN NUMBER,
328: p_parent_instance_id IN NUMBER,
329: p_instance_id IN NUMBER,
330: p_instance_number IN csi_item_instances.instance_number%TYPE := NULL,
331: p_relationship_id IN NUMBER,
332: p_csi_ii_ovn IN NUMBER,
333: p_prod_user_flag IN VARCHAR2,
334: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
364: p_uc_header_id IN NUMBER,
365: p_parent_instance_id IN NUMBER,
366: p_old_instance_id IN NUMBER,
367: p_new_instance_id IN NUMBER,
368: p_new_instance_number IN csi_item_instances.instance_number%TYPE := NULL,
369: p_relationship_id IN NUMBER,
370: p_csi_ii_ovn IN NUMBER,
371: p_prod_user_flag IN VARCHAR2,
372: x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
429: );
430:
431: -- Start of Comments --
432: -- Define procedure create_unassigned_instance.
433: -- This API is used to create a new instance in csi_item_instances and assign it
434: -- to the UC root node as extra node.
435: --
436: -- Procedure name: create_unassigned_instance
437: -- Type : Private
434: -- to the UC root node as extra node.
435: --
436: -- Procedure name: create_unassigned_instance
437: -- Type : Private
438: -- Function : To create a new instance in csi_item_instances and assign it
439: -- to the UC root node as extra node.
440: -- Pre-reqs:
441: --
442: -- create_unassigned_instance parameters: