DBA Data[Home] [Help]

APPS.CS_CIC_ATTRIBUTE_PUB dependencies on CUG_INCIDNT_ATTR_VALS_B

Line 401: SELECT CUG_INCIDNT_ATTR_VALS_B_S.nextval

397:
398: l_create_attribute_note := l_create_attribute_note || l_attr_name || ' = ' || l_attr_value || fnd_global.newline();
399:
400: -- Generate the New Sequence # to store in INCIDNT_ATTR_VAL_ID.
401: SELECT CUG_INCIDNT_ATTR_VALS_B_S.nextval
402: INTO l_incident_attr_val_id
403: FROM sys.dual;
404:
405: --- Create Attributes ---

Line 524: FROM CUG_INCIDNT_ATTR_VALS_B

520: -- Begin fix for 12.2.2 CIC changes
521: BEGIN
522: SELECT count(1)
523: INTO l_value_count
524: FROM CUG_INCIDNT_ATTR_VALS_B
525: WHERE INCIDENT_ID = p_incident_id;
526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN
528: l_values_exist :='N';