DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 89: FROM csi_item_instances

85: l_instance_number VARCHAR2(30):= substr(to_char(p_item_instance_id),1,30);
86: BEGIN
87: SELECT 'x'
88: INTO l_dummy
89: FROM csi_item_instances
90: WHERE instance_id = p_item_instance_id
91: OR instance_number = l_instance_number;
92: l_return_value := TRUE;
93: IF ( p_stack_err_msg = TRUE ) THEN

Line 171: FROM csi_item_instances

167: -- Added for eam integration
168: BEGIN
169: SELECT instance_number
170: INTO l_instance_number
171: FROM csi_item_instances
172: WHERE instance_number=p_instance_number;
173: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
174: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER',p_instance_number);
175: FND_MSG_PUB.Add;

Line 207: FROM csi_item_instances

203: -- Added for eam integration
204: BEGIN
205: SELECT instance_number
206: INTO l_instance_number
207: FROM csi_item_instances
208: WHERE instance_number = p_instance_number
209: AND instance_id <> p_item_instance_id;
210: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
211: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER',p_instance_number);

Line 1281: FROM csi_item_instances

1277: -- Check for fundamental uniqueness
1278: BEGIN
1279: SELECT 'x'
1280: INTO l_temp
1281: FROM csi_item_instances
1282: WHERE serial_number = p_serial_number
1283: AND inventory_item_id = p_inv_item_id
1284: AND instance_id <> l_instance_id
1285: AND ROWNUM = 1;

Line 1313: from CSI_ITEM_INSTANCES

1309: FOR base_rec in CTO_CUR(l_base_item_id) LOOP
1310: Begin
1311: select 'x'
1312: into l_temp
1313: from CSI_ITEM_INSTANCES
1314: where serial_number = p_serial_number
1315: and inventory_item_id = base_rec.inventory_item_id
1316: and rownum = 1;
1317: exit;

Line 1343: FROM csi_item_instances

1339: THEN
1340: BEGIN
1341: SELECT 'x'
1342: INTO l_temp
1343: FROM csi_item_instances
1344: WHERE serial_number = p_serial_number
1345: AND last_vld_organization_id = p_inv_org_id
1346: AND instance_id <> l_instance_id
1347: AND ROWNUM = 1;

Line 1425: FROM csi_item_instances

1421: THEN
1422: BEGIN
1423: SELECT 'x'
1424: INTO l_temp
1425: FROM csi_item_instances
1426: WHERE serial_number = p_serial_number
1427: AND instance_id <> l_instance_id
1428: AND ROWNUM=1;
1429: EXCEPTION

Line 1555: FROM CSI_ITEM_INSTANCES

1551: -- Check for the fundamental uniqueness in Install Base
1552: BEGIN
1553: SELECT 'x'
1554: INTO l_temp
1555: FROM CSI_ITEM_INSTANCES
1556: WHERE inventory_item_id <> p_inv_item_id
1557: AND lot_number = p_lot_number
1558: AND instance_id <> p_instance_id;
1559: EXCEPTION

Line 1877: FROM csi_item_instances

1873: l_config_found:=NULL;
1874: BEGIN
1875: SELECT 'x'
1876: INTO l_config_found
1877: FROM csi_item_instances
1878: WHERE config_inst_hdr_id = p_config_inst_hdr_id
1879: AND config_inst_item_id = p_config_inst_item_id
1880: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
1881:

Line 1897: FROM csi_item_instances

1893: l_config_found:=NULL;
1894: BEGIN
1895: SELECT 'x'
1896: INTO l_config_found
1897: FROM csi_item_instances
1898: WHERE config_inst_hdr_id = p_config_inst_hdr_id
1899: AND config_inst_item_id = p_config_inst_item_id
1900: AND instance_id <> p_instance_id
1901: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));

Line 2464: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES

2460: p_instance_rec.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2461: THEN
2462: BEGIN
2463: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized
2464: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2465: SELECT '1'
2466: INTO l_count
2467: FROM csi_item_instances a
2468: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII

Line 2467: FROM csi_item_instances a

2463: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized
2464: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2465: SELECT '1'
2466: INTO l_count
2467: FROM csi_item_instances a
2468: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII
2469: -- WHERE a.instance_id = b.instance_id
2470: WHERE a.inventory_item_id = p_instance_rec.inventory_item_id
2471: AND a.inv_organization_id = p_instance_rec.inv_organization_id

Line 3251: SELECT csi_item_instances_s.NEXTVAL

3247: RETURN NUMBER
3248: IS
3249: l_instance_id NUMBER;
3250: BEGIN
3251: SELECT csi_item_instances_s.NEXTVAL
3252: INTO l_instance_id
3253: FROM sys.dual;
3254: RETURN l_instance_id;
3255: END Get_instance_id;

Line 3272: SELECT csi_item_instances_h_s.NEXTVAL

3268: IS
3269: l_csi_item_instance_h_id NUMBER;
3270:
3271: BEGIN
3272: SELECT csi_item_instances_h_s.NEXTVAL
3273: INTO l_csi_item_instance_h_id
3274: FROM dual;
3275: RETURN l_csi_item_instance_h_id;
3276: EXCEPTION

Line 3300: FROM csi_item_instances

3296: l_return_value BOOLEAN := TRUE;
3297: BEGIN
3298: SELECT 'x'
3299: INTO l_dummy
3300: FROM csi_item_instances
3301: WHERE instance_id = p_Instance_id
3302: AND creation_complete_flag = 'Y';
3303: RETURN l_return_value;
3304: EXCEPTION

Line 3648: /* exists in csi_item_instances */

3644:
3645: /*-----------------------------------------------------------*/
3646: /* Procedure name: Is_InstanceID_Valid */
3647: /* Description : Check if the instance_id */
3648: /* exists in csi_item_instances */
3649: /*-----------------------------------------------------------*/
3650:
3651: FUNCTION Is_InstanceID_Valid
3652: (

Line 3665: FROM csi_item_instances

3661:
3662: BEGIN
3663: SELECT instance_id
3664: INTO l_instance_id
3665: FROM csi_item_instances
3666: WHERE instance_id = p_instance_id;
3667: l_return_value := TRUE;
3668: EXCEPTION
3669: WHEN NO_DATA_FOUND THEN

Line 3703: FROM csi_item_instances

3699:
3700: CURSOR c1 IS
3701: SELECT active_end_date,
3702: active_start_date
3703: FROM csi_item_instances
3704: WHERE instance_id = p_instance_id;
3705:
3706: BEGIN
3707: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN

Line 3897: FROM csi_item_instances

3893: p_instance_rec.OBJECT_VERSION_NUMBER ,
3894: p_instance_rec.instance_usage_code ,--Added for bug 2163942
3895: p_instance_rec.install_location_type_code ,
3896: p_instance_rec.install_location_id
3897: FROM csi_item_instances
3898: WHERE instance_id = p_item_instance_id;
3899:
3900: RETURN TRUE;
3901:

Line 4121: FROM csi_item_instances

4117:
4118: CURSOR c1 IS
4119: SELECT active_start_date,
4120: active_end_date
4121: FROM csi_item_instances
4122: WHERE instance_id = p_instance_id
4123: and ((active_end_date is null) OR (active_end_date >= sysdate));
4124: BEGIN
4125: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

Line 4183: FROM csi_item_instances

4179:
4180: CURSOR c1 IS
4181: SELECT active_end_date,
4182: active_start_date
4183: FROM csi_item_instances
4184: WHERE instance_id = p_instance_id
4185: and ((active_end_date is null) OR (active_end_date >= sysdate));
4186: BEGIN
4187: IF p_end_date is NOT NULL THEN

Line 4785: FROM csi_item_instances

4781: SELECT location_id,
4782: location_type_code
4783: INTO l_header_tbl(1).location_id,
4784: l_header_tbl(1).location_type_code
4785: FROM csi_item_instances
4786: WHERE instance_id=l_header_tbl(1).instance_id;
4787: EXCEPTION
4788: WHEN OTHERS THEN
4789: NULL;

Line 4803: FROM csi_item_instances

4799: SELECT location_id,
4800: location_type_code
4801: INTO l_header_tbl(2).location_id,
4802: l_header_tbl(2).location_type_code
4803: FROM csi_item_instances
4804: WHERE instance_id=l_header_tbl(2).instance_id;
4805: EXCEPTION
4806: WHEN OTHERS THEN
4807: NULL;

Line 5066: from csi_item_instances_h

5062: l_min_txn_id := NULL;
5063: l_src_txn_date := NULL;
5064: select min(transaction_id)
5065: into l_min_txn_id
5066: from csi_item_instances_h
5067: where instance_id = p_instance_rec.instance_id
5068: and creation_date = (select min(creation_date) from csi_item_instances_h
5069: where instance_id = p_instance_rec.instance_id
5070: );

Line 5068: and creation_date = (select min(creation_date) from csi_item_instances_h

5064: select min(transaction_id)
5065: into l_min_txn_id
5066: from csi_item_instances_h
5067: where instance_id = p_instance_rec.instance_id
5068: and creation_date = (select min(creation_date) from csi_item_instances_h
5069: where instance_id = p_instance_rec.instance_id
5070: );
5071: --
5072: IF l_min_txn_id IS NOT NULL THEN