APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_INSTANCE_STATUSES

Line 2680: FROM csi_instance_statuses

2676:
2677: BEGIN
2678: SELECT name
2679: INTO p_instance_header_tbl(tab_row).instance_status
2680: FROM csi_instance_statuses
2681: WHERE instance_status_id = p_instance_header_tbl(tab_row).instance_status_id;
2682: EXCEPTION
2683: WHEN OTHERS THEN
2684: null;

Line 5563: FROM csi_instance_statuses

5559: BEGIN
5560: SELECT instance_status_id,terminated_flag
5561: INTO p_instance_rec.instance_status_id
5562: ,l_terminated_flag
5563: FROM csi_instance_statuses
5564: WHERE name = l_instance_status;
5565: --
5566: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5567: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');

Line 5619: from CSI_INSTANCE_STATUSES

5615: p_generic_id_tbl(p_ins_count_rec.generic_count).id_type := 'INS_STATUS';
5616: Begin
5617: select terminated_flag
5618: into l_terminated_flag
5619: from CSI_INSTANCE_STATUSES
5620: where instance_status_id = p_instance_rec.instance_status_id;
5621: --
5622: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'Y';
5623: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := l_terminated_flag;

Line 20845: -- l_instance_rec.instance_status_id := 1; -- '1' for expired instances defined in the csi instance statuses

20841: l_instance_rec.instance_status_id := 1;
20842: END IF;
20843: END IF;
20844: -- End addition by sguthiva for bug 2520978.
20845: -- l_instance_rec.instance_status_id := 1; -- '1' for expired instances defined in the csi instance statuses
20846: l_instance_rec.object_version_number := l_curr_instance_rec.object_version_number + 1;
20847:
20848: -- Start addition by sguthiva for bug 2416193
20849: -- Relaxing this check for RMA Receipt transaction