DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_ITEM_INSTANCE_VLD_PVT

Line 1: PACKAGE BODY csi_Item_Instance_Vld_pvt AS

1: PACKAGE BODY csi_Item_Instance_Vld_pvt AS
2: /* $Header: csiviivb.pls 120.38.12010000.2 2008/10/03 19:47:59 rsinn ship $ */
3:
4: -- ------------------------------------------------------------
5: -- Define global variables

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCE_VLD_PVT';

4: -- ------------------------------------------------------------
5: -- Define global variables
6: -- ------------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCE_VLD_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csiviivb.pls';
10:
11: /*-----------------------------------------------------------*/
12: /* Procedure name: Check_Reqd_Param */

Line 333: csi_item_instance_vld_pvt.Validate_Serial_Number

329: BEGIN
330: IF p_instance_rec.serial_number <> fnd_api.g_miss_char
331: AND p_instance_rec.serial_number IS NOT NULL
332: THEN
333: csi_item_instance_vld_pvt.Validate_Serial_Number
334: (
335: p_inv_org_id => p_instance_rec.vld_organization_id,
336: p_inv_item_id => p_instance_rec.inventory_item_id ,
337: p_serial_number => p_instance_rec.serial_number,

Line 352: csi_item_instance_vld_pvt.Validate_Lot_Number

348: IF p_instance_rec.lot_number <> fnd_api.g_miss_char
349: AND p_instance_rec.lot_number IS NOT NULL
350: AND l_return_value
351: THEN
352: csi_item_instance_vld_pvt.Validate_Lot_Number
353: (
354: p_inv_org_id => p_instance_rec.vld_organization_id,
355: p_inv_item_id => p_instance_rec.inventory_item_id ,
356: p_lot_number => p_instance_rec.lot_number,

Line 368: csi_item_instance_vld_pvt.Validate_Revision

364: IF p_instance_rec.inventory_revision <> fnd_api.g_miss_char
365: AND p_instance_rec.inventory_revision IS NOT NULL
366: AND l_return_value
367: THEN
368: csi_item_instance_vld_pvt.Validate_Revision
369: (
370: p_inv_item_id => p_instance_rec.inventory_item_id ,
371: p_inv_org_id => p_instance_rec.vld_organization_id,
372: p_creation_complete_flag => p_instance_rec.creation_complete_flag,

Line 1755: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized

1751:
1752: BEGIN
1753:
1754: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
1755: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
1756: ( p_serial_control_code => p_serial_control_code
1757: ,p_location_type_code => p_location_type_code
1758: ,p_transaction_type_id => p_csi_txn_type_id
1759: ))

Line 3512: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized

3508: FROM mtl_parameters
3509: WHERE organization_id = p_inv_organization_id;
3510: BEGIN
3511: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3512: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
3513: ( p_serial_control_code => p_serial_control_code
3514: ,p_location_type_code => p_location_type_code
3515: )) --Added by sk on 09/14/01
3516: THEN

Line 6253: END csi_Item_Instance_Vld_Pvt;

6249: END IF;
6250: END LOOP;
6251: END IF;
6252: END get_mtl_txn_for_srl;
6253: END csi_Item_Instance_Vld_Pvt;