DBA Data[Home] [Help]

APPS.IEM_CLASSIFICATIONS_PVT dependencies on IEM_CLASSIFICATIONS_S1

Line 106: select iem_classifications_s1.nextval into l_seq from dual;

102: SELECT count(*) into l_cnt from iem_classifications WHERE EMAIL_ACCOUNT_ID=p_email_account_id AND
103: CLASSIFICATION=p_classification AND rownum=1;
104:
105: IF l_cnt=0 THEN
106: select iem_classifications_s1.nextval into l_seq from dual;
107: INSERT INTO IEM_CLASSIFICATIONS
108: (
109: CLASSIFICATION_ID,
110: EMAIL_ACCOUNT_ID ,

Line 1271: select iem_classifications_s1.nextval into l_seq from dual;

1267: IF l_status='E' THEN
1268: raise DOC_EXCEP;
1269: END IF;
1270: EXCEPTION WHEN NO_DATA_FOUND THEN
1271: select iem_classifications_s1.nextval into l_seq from dual;
1272: INSERT INTO IEM_CLASSIFICATIONS
1273: (
1274: CLASSIFICATION_ID,
1275: EMAIL_ACCOUNT_ID ,