APPS.IEM_CLASSIFICATIONS_PVT dependencies on DUAL

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 517: from dual;

513: -- APP_EXCEPTION.RAISE_EXCEPTION;
514: end if;
515:
516: select replace (replace ( replace (p_classification, '<', ''), '>', ''), '"', '''') into l_classification
517: from dual;
518:
519: /*
520: select replace (replace ( replace (p_classification, '<', '<'), '>', '>'), '"', '''')
521: from dual;

Line 521: from dual;

517: from dual;
518:
519: /*
520: select replace (replace ( replace (p_classification, '<', '<'), '>', '>'), '"', '''')
521: from dual;
522: */
523:
524: l_classification2 := rtrim(ltrim(l_classification, ' '), ' ');
525:

Line 656: from dual;

652: -- APP_EXCEPTION.RAISE_EXCEPTION;
653: end if;
654:
655: select replace (replace ( replace (p_classification, '<', ''), '>', ''), '"', '''') into l_classification
656: from dual;
657:
658: /*
659: select replace (replace ( replace (p_classification, '<', '<'), '>', '>'), '"', '''')
660: from dual;

Line 660: from dual;

656: from dual;
657:
658: /*
659: select replace (replace ( replace (p_classification, '<', '<'), '>', '>'), '"', '''')
660: from dual;
661: */
662:
663: l_classification2 := rtrim(ltrim(l_classification, ' '), ' ');
664:

Line 990: from dual;

986: -- Initialize API return status to SUCCESS
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: select replace (replace ( replace (p_classification, '<', ''), '>', ''), '"', '''') into l_classification
990: from dual;
991:
992: l_classification2 := rtrim(ltrim(l_classification, ' '), ' ');
993:
994: -- Take this out when create_item procedure handles duplicates in the exception block.

Line 1117: from dual;

1113: -- Initialize API return status to SUCCESS
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: select replace (replace ( replace (p_classification, '<', ''), '>', ''), '"', '''') into l_classification
1117: from dual;
1118:
1119: l_classification2 := rtrim(ltrim(l_classification, ' '), ' ');
1120:
1121: -- Take this out when create_item procedure handles duplicates in the exception block.

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 ,