APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_INSTANCE_STATUSES

Line 2661: FROM csi_instance_statuses

2657:
2658: BEGIN
2659: SELECT name
2660: INTO p_instance_header_tbl(tab_row).instance_status
2661: FROM csi_instance_statuses
2662: WHERE instance_status_id = p_instance_header_tbl(tab_row).instance_status_id;
2663: EXCEPTION
2664: WHEN OTHERS THEN
2665: null;

Line 5499: FROM csi_instance_statuses

5495: BEGIN
5496: SELECT instance_status_id,terminated_flag
5497: INTO p_instance_rec.instance_status_id
5498: ,l_terminated_flag
5499: FROM csi_instance_statuses
5500: WHERE name = l_instance_status;
5501: --
5502: IF nvl(l_terminated_flag,'N') = 'Y' THEN
5503: FND_MESSAGE.SET_NAME('CSI','CSI_API_STATUS_NOT_ALLOWED');

Line 5555: from CSI_INSTANCE_STATUSES

5551: p_generic_id_tbl(p_ins_count_rec.generic_count).id_type := 'INS_STATUS';
5552: Begin
5553: select terminated_flag
5554: into l_terminated_flag
5555: from CSI_INSTANCE_STATUSES
5556: where instance_status_id = p_instance_rec.instance_status_id;
5557: --
5558: p_generic_id_tbl(p_ins_count_rec.generic_count).valid_flag := 'Y';
5559: p_generic_id_tbl(p_ins_count_rec.generic_count).terminated_flag := l_terminated_flag;

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

20307: l_instance_rec.instance_status_id := 1;
20308: END IF;
20309: END IF;
20310: -- End addition by sguthiva for bug 2520978.
20311: -- l_instance_rec.instance_status_id := 1; -- '1' for expired instances defined in the csi instance statuses
20312: l_instance_rec.object_version_number := l_curr_instance_rec.object_version_number + 1;
20313:
20314: -- Start addition by sguthiva for bug 2416193
20315: -- Relaxing this check for RMA Receipt transaction