APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_ITEM_INSTANCES

Line 1140: FROM csi_item_instances

1136: LOOP
1137: BEGIN
1138: SELECT 'Y'
1139: INTO l_expired
1140: FROM csi_item_instances
1141: WHERE instance_id = l_instance_header_tbl(l_ind).instance_id
1142: AND instance_status_id = l_expired_status_id;
1143: EXCEPTION
1144: WHEN OTHERS THEN

Line 1453: FROM csi_item_instances

1449: LOOP
1450: BEGIN
1451: SELECT 'Y'
1452: INTO l_expired
1453: FROM csi_item_instances
1454: WHERE instance_id = l_instance_header_tbl(l_ind).instance_id
1455: AND instance_status_id = l_expired_status_id;
1456: EXCEPTION
1457: WHEN OTHERS THEN

Line 2124: FROM csi_item_instances

2120:
2121: IF nvl(l_location_type_code,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
2122: SELECT location_type_code
2123: INTO l_location_type_code
2124: FROM csi_item_instances
2125: WHERE instance_id = p_instance_rec.instance_id;
2126: END IF;
2127:
2128: IF p_parties_tbl.COUNT > 0 THEN

Line 2403: FROM csi_item_instances

2399: l_u_instance_rec.call_contracts := p_call_contracts;
2400:
2401: SELECT object_version_number
2402: INTO l_u_instance_rec.object_version_number
2403: FROM csi_item_instances
2404: WHERE instance_id = l_u_instance_rec.instance_id;
2405:
2406: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
2407:

Line 2891: FROM csi_item_instances

2887: SELECT object_version_number,
2888: quantity
2889: INTO l_instance_rec.object_version_number,
2890: l_dest_instance_qty
2891: FROM csi_item_instances
2892: WHERE instance_id = l_dest_instance_id;
2893:
2894: debug('Instance Quantity :'||l_dest_instance_qty);
2895: debug('Transaction Quantity :'||p_instance_rec.quantity);

Line 3033: FROM csi_item_instances

3029: -- Added as part of testing for 3810963. For RMA cancellation we need to
3030: -- check if the instance is expired
3031: SELECT active_end_date
3032: INTO l_active_end_date
3033: FROM csi_item_instances
3034: WHERE instance_id = l_instance_rec.instance_id;
3035:
3036: IF p_in_out_flag <> 'NONE' THEN
3037:

Line 3186: FROM csi_item_instances

3182: END IF;
3183:
3184: SELECT object_version_number
3185: INTO l_instance_rec.object_version_number
3186: FROM csi_item_instances
3187: WHERE instance_id = l_instance_rec.instance_id;
3188:
3189: l_current_procedure := 'update_item_instance';
3190:

Line 3246: FROM csi_item_instances

3242: l_serial_number,
3243: l_mfg_serial_number_flag,
3244: l_active_end_date,
3245: l_owner_party_account_id
3246: FROM csi_item_instances
3247: WHERE instance_id = l_instance_rec.instance_id;
3248:
3249: l_u_instance_rec.instance_id := l_instance_rec.instance_id;
3250: l_u_instance_rec.object_version_number := l_object_version_number;

Line 3556: FROM csi_item_instances

3552: END IF;
3553:
3554: SELECT object_version_number
3555: INTO l_object_version_number
3556: FROM csi_item_instances
3557: WHERE instance_id = l_u_instance_rec.instance_id;
3558:
3559: l_u_instance_rec.object_version_number := l_object_version_number;
3560: l_u_instance_rec.return_by_date := p_instance_rec.return_by_date;

Line 3784: FROM csi_item_instances

3780: object_version_number
3781: INTO l_dest_instance_qty,
3782: l_serial_number, --Bug 13951303
3783: l_object_version_number
3784: FROM csi_item_instances
3785: WHERE instance_id = l_dest_instance_id;
3786:
3787: l_u_instance_rec := l_dummy_instance_rec;
3788:

Line 3927: FROM csi_item_instances

3923: active_end_date
3924: INTO l_object_version_number,
3925: l_src_instance_qty,
3926: l_active_end_date
3927: FROM csi_item_instances
3928: WHERE instance_id = l_src_instance_id;
3929:
3930: debug(' src_instance_id : '||l_src_instance_id);
3931: debug(' quantity : '||l_src_instance_qty);

Line 4001: FROM csi_item_instances

3997: l_object_version_number,
3998: l_active_end_date,
3999: l_location_type_code,
4000: l_instance_usage_code
4001: FROM csi_item_instances
4002: WHERE inventory_item_id = l_instance_rec.inventory_item_id
4003: AND serial_number = l_instance_rec.serial_number;
4004:
4005: debug('returned customer product found');

Line 4429: FROM csi_item_instances cii

4425: l_instance_end_date DATE;
4426:
4427: CURSOR exp_inst_cur(p_instance_id in number) IS
4428: SELECT cii.active_end_date
4429: FROM csi_item_instances cii
4430: WHERE cii.instance_id = p_instance_id
4431: AND cii.active_end_date is not null
4432: AND EXISTS (
4433: SELECT 'X' from csi_ii_relationships cir

Line 4477: from CSI_ITEM_INSTANCES

4473: select config_inst_hdr_id,config_inst_item_id,config_inst_rev_num,
4474: instance_usage_code,active_end_date
4475: into l_instance_inst_hdr_id,l_instance_inst_item_id,
4476: l_instance_inst_rev_num,l_instance_usage_code,l_instance_end_date
4477: from CSI_ITEM_INSTANCES
4478: where instance_id = p_instance_id;
4479: --
4480: IF l_locked = TRUE THEN
4481: debug('Instance '||p_instance_id||' is Locked. Updating TLD and Unlocking it..');