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.48.12020000.8 2013/03/22 10:58:22 mvaradam 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 334: csi_item_instance_vld_pvt.Validate_Serial_Number

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

Line 353: csi_item_instance_vld_pvt.Validate_Lot_Number

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

Line 369: csi_item_instance_vld_pvt.Validate_Revision

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

Line 1800: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized

1796:
1797: BEGIN
1798:
1799: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
1800: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
1801: ( p_serial_control_code => p_serial_control_code
1802: ,p_location_type_code => p_location_type_code
1803: ,p_transaction_type_id => p_csi_txn_type_id
1804: ))

Line 3591: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized

3587: FROM mtl_parameters
3588: WHERE organization_id = p_inv_organization_id;
3589: BEGIN
3590: -- IF ((p_serial_number IS NOT NULL) AND (p_serial_number <> FND_API.G_MISS_CHAR)) THEN
3591: IF (csi_Item_Instance_Vld_pvt.Is_treated_serialized
3592: ( p_serial_control_code => p_serial_control_code
3593: ,p_location_type_code => p_location_type_code
3594: )) --Added by sk on 09/14/01
3595: THEN

Line 6548: END csi_Item_Instance_Vld_Pvt;

6544: END IF;
6545: END LOOP;
6546: END IF;
6547: END get_mtl_txn_for_srl;
6548: END csi_Item_Instance_Vld_Pvt;