APPS.CSI_GIS_INSTANCE_LOC_UTL_PKG dependencies on CSI_ITEM_INSTANCES

Line 58: FROM CSI_ITEM_INSTANCES

54: BEGIN
55:
56: SELECT 'Y', INVENTORY_ITEM_ID, LAST_VLD_ORGANIZATION_ID, SERIAL_NUMBER, INSTANCE_NUMBER,NETWORK_ASSET_FLAG
57: INTO l_exists, l_inventory_item_id, l_organization_id,l_serial_number, l_instance_number,l_network_asset_flag
58: FROM CSI_ITEM_INSTANCES
59: WHERE INSTANCE_ID = p_instance_id;
60:
61:
62: IF l_debug_level > 0 THEN

Line 63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');

59: WHERE INSTANCE_ID = p_instance_id;
60:
61:
62: IF l_debug_level > 0 THEN
63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');
64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);
65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);
66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);
67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);

Line 71: From MFG_LOOKUPS ml1, MTL_SYSTEM_ITEMS_B_KFV msi,csi_item_instances cii

67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);
68: END IF;
69:
70: SELECT Nvl((SELECT 'EAM'
71: From MFG_LOOKUPS ml1, MTL_SYSTEM_ITEMS_B_KFV msi,csi_item_instances cii
72: where
73: msi.inventory_item_id = cii.inventory_item_id
74: AND cii.last_vld_organization_id=msi.organization_id
75: AND (cii.active_start_date IS NULL OR (cii.active_start_date <= sysdate))

Line 88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');

84:
85: csi_t_gen_utility_pvt.add( 'Instance Type:'||l_instance_type);
86:
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');
89: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_FOUND');
90: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
91: FND_MSG_PUB.ADD;
92: x_return_status := FND_API.G_RET_STS_ERROR;