77: FUNCTION Is_Trackable
78: (
79: p_inv_item_id IN NUMBER,
80: p_org_id IN NUMBER,
81: p_trackable_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
82: p_stack_err_msg IN BOOLEAN DEFAULT TRUE
83: )
84: RETURN BOOLEAN;
85:
107: p_inv_org_id IN NUMBER,
108: p_revision IN VARCHAR2,
109: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
110: l_return_value IN OUT NOCOPY BOOLEAN,
111: p_rev_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM
112: );
113:
114: PROCEDURE Update_Revision
115: (
116: p_inv_item_id IN NUMBER,
117: p_inv_org_id IN NUMBER,
118: p_revision IN VARCHAR2,
119: l_return_value IN OUT NOCOPY BOOLEAN,
120: p_rev_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM
121: );
122:
123: /*------------------------------------------------------*/
124: /* This Procedure is called when creating a serial #s */
145:
146: FUNCTION Is_treated_serialized
147: ( p_serial_control_code IN NUMBER ,
148: p_location_type_code IN VARCHAR2,
149: p_transaction_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: )
151: RETURN BOOLEAN;
152:
153: /*----------------------------------------------------*/
163: P_mfg_serial_number_flag IN VARCHAR2,
164: p_txn_rec IN csi_datastructures_pub.transaction_rec,
165: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
166: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
167: p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
168: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169: p_instance_usage_code IN VARCHAR2,
170: l_return_value IN OUT NOCOPY BOOLEAN
171: );
164: p_txn_rec IN csi_datastructures_pub.transaction_rec,
165: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
166: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
167: p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
168: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
169: p_instance_usage_code IN VARCHAR2,
170: l_return_value IN OUT NOCOPY BOOLEAN
171: );
172:
179: (
180: p_inv_org_id IN NUMBER,
181: p_inv_item_id IN NUMBER,
182: p_serial_number IN VARCHAR2,
183: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
184: l_return_value IN OUT NOCOPY BOOLEAN
185: ) ;
186:
187: /*---------------------------------------------------*/
212: p_lot_number IN VARCHAR2,
213: p_mfg_serial_number_flag IN VARCHAR2,
214: p_txn_rec IN csi_datastructures_pub.transaction_rec,
215: p_creation_complete_flag IN OUT NOCOPY VARCHAR2,
216: p_lot_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
217: l_return_value IN OUT NOCOPY BOOLEAN
218: );
219:
220: /*----------------------------------------------------*/
426: p_serial_number IN VARCHAR2,
427: P_mfg_serial_number_flag IN VARCHAR2,
428: p_txn_rec IN csi_datastructures_pub.transaction_rec,
429: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
430: p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_instance_usage_code IN VARCHAR2,
432: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: l_return_value IN OUT NOCOPY BOOLEAN
434: );
428: p_txn_rec IN csi_datastructures_pub.transaction_rec,
429: p_location_type_code IN VARCHAR2, -- Added by sk on 09/13/01
430: p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_instance_usage_code IN VARCHAR2,
432: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: l_return_value IN OUT NOCOPY BOOLEAN
434: );
435:
436: /*----------------------------------------------------*/
493:
494: FUNCTION validate_uniqueness
495: ( p_instance_rec csi_datastructures_pub.instance_rec,
496: p_party_rec csi_datastructures_pub.party_rec,
497: p_srl_control_code NUMBER DEFAULT FND_API.G_MISS_NUM,
498: p_csi_txn_type_id NUMBER DEFAULT FND_API.G_MISS_NUM
499: )
500: RETURN BOOLEAN;
501:
494: FUNCTION validate_uniqueness
495: ( p_instance_rec csi_datastructures_pub.instance_rec,
496: p_party_rec csi_datastructures_pub.party_rec,
497: p_srl_control_code NUMBER DEFAULT FND_API.G_MISS_NUM,
498: p_csi_txn_type_id NUMBER DEFAULT FND_API.G_MISS_NUM
499: )
500: RETURN BOOLEAN;
501:
502: /*----------------------------------------------------*/
725: /*-----------------------------------------------------------*/
726: FUNCTION Check_for_eam_item
727: (p_inventory_item_id IN NUMBER,
728: p_organization_id IN NUMBER,
729: p_eam_item_type IN NUMBER DEFAULT FND_API.G_MISS_NUM
730: )
731: RETURN BOOLEAN;
732:
733: PROCEDURE validate_serial_for_upd(