APPS.CSI_EXTEND_ATTRIB_VLD_PVT dependencies on CSI_IEA_VALUES

Line 231: FROM csi_iea_values

227: p_ext_attrib_rec.attribute13,
228: p_ext_attrib_rec.attribute14,
229: p_ext_attrib_rec.attribute15,
230: p_ext_attrib_rec.object_version_number
231: FROM csi_iea_values
232: WHERE attribute_value_id = p_att_value_id;
233: RETURN TRUE;
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN

Line 346: FROM csi_iea_values

342: -- Verify the alternate PK's
343: BEGIN
344: SELECT '1'
345: INTO l_dummy
346: FROM csi_iea_values
347: WHERE instance_id = p_instance_id
348: AND attribute_id = p_attribute_id;
349:
350: IF ( p_stack_err_msg = TRUE ) THEN

Line 486: FROM csi_iea_values_h s,

482:
483: IF p_end_date < sysdate THEN
484: SELECT MAX(t.transaction_date)
485: INTO l_transaction_date
486: FROM csi_iea_values_h s,
487: csi_transactions t
488: WHERE s.attribute_value_id=p_attr_value_id
489: AND s.transaction_id=t.transaction_id
490: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 661: FROM csi_iea_values

657: BEGIN
658: -- Verify that attribute_value_id is passed
659: SELECT '1'
660: INTO l_attribute_value_id
661: FROM csi_iea_values
662: WHERE attribute_value_id = p_attribute_value_id ;
663: IF ( p_stack_err_msg = TRUE ) THEN
664: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_attribute_value_id);

Line 688: SELECT csi_iea_values_s.nextval

684: RETURN NUMBER
685: IS
686: l_attribute_value_id NUMBER;
687: BEGIN
688: SELECT csi_iea_values_s.nextval
689: INTO l_attribute_value_id
690: FROM dual;
691: RETURN l_attribute_value_id;
692: EXCEPTION

Line 715: SELECT csi_iea_values_h_s.nextval

711: RETURN NUMBER
712: IS
713: l_attribute_value_id NUMBER;
714: BEGIN
715: SELECT csi_iea_values_h_s.nextval
716: INTO l_attribute_value_id
717: FROM dual;
718: RETURN l_attribute_value_id;
719: EXCEPTION