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 484: FROM csi_iea_values_h s,

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

Line 657: FROM csi_iea_values

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

Line 684: SELECT csi_iea_values_s.nextval

680: RETURN NUMBER
681: IS
682: l_attribute_value_id NUMBER;
683: BEGIN
684: SELECT csi_iea_values_s.nextval
685: INTO l_attribute_value_id
686: FROM dual;
687: RETURN l_attribute_value_id;
688: EXCEPTION

Line 711: SELECT csi_iea_values_h_s.nextval

707: RETURN NUMBER
708: IS
709: l_attribute_value_id NUMBER;
710: BEGIN
711: SELECT csi_iea_values_h_s.nextval
712: INTO l_attribute_value_id
713: FROM dual;
714: RETURN l_attribute_value_id;
715: EXCEPTION