DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on FND_API

Line 81: p_trackable_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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:

Line 111: p_rev_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM

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: (

Line 120: p_rev_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM

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 */

Line 149: p_transaction_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

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: /*----------------------------------------------------*/

Line 167: p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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: );

Line 168: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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:

Line 183: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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: /*---------------------------------------------------*/

Line 216: p_lot_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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: /*----------------------------------------------------*/

Line 430: p_srl_control_code IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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: );

Line 432: p_instance_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

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: /*----------------------------------------------------*/

Line 497: p_srl_control_code NUMBER DEFAULT FND_API.G_MISS_NUM,

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:

Line 498: p_csi_txn_type_id NUMBER DEFAULT FND_API.G_MISS_NUM

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: /*----------------------------------------------------*/

Line 729: p_eam_item_type IN NUMBER DEFAULT FND_API.G_MISS_NUM

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(