APPS.IEM_EML_CLASSIFICATIONS_PVT dependencies on IEM_EMAIL_CLASSIFICATIONS

Line 8: -- Function : This procedure create a record in the table IEM_EMAIL_CLASSIFICATIONS

4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EML_CLASSIFICATIONS_PVT ';
5: -- Start of Comments
6: -- API name : create_item
7: -- Type : Private
8: -- Function : This procedure create a record in the table IEM_EMAIL_CLASSIFICATIONS
9: -- Pre-reqs : None.
10: -- Parameters :
11: -- IN
12: -- p_api_version_number IN NUMBER Required

Line 70: select count(*) into l_count from iem_email_classifications

66: FND_MSG_PUB.initialize;
67: END IF;
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70: select count(*) into l_count from iem_email_classifications
71: where message_id=p_message_id
72: and classification_id=p_classification_id;
73: IF l_count=0 then
74: INSERT INTO IEM_EMAIL_CLASSIFICATIONS

Line 74: INSERT INTO IEM_EMAIL_CLASSIFICATIONS

70: select count(*) into l_count from iem_email_classifications
71: where message_id=p_message_id
72: and classification_id=p_classification_id;
73: IF l_count=0 then
74: INSERT INTO IEM_EMAIL_CLASSIFICATIONS
75: (
76: MESSAGE_ID,
77: EMAIL_ACCOUNT_ID ,
78: CLASSIFICATION_ID ,

Line 145: -- Function : This procedure delete a record in the table IEM_EMAIL_CLASSIFICATIONS

141:
142: -- Start of Comments
143: -- API name : delete_item
144: -- Type : Private
145: -- Function : This procedure delete a record in the table IEM_EMAIL_CLASSIFICATIONS
146: -- Pre-reqs : None.
147: -- Parameters :
148: -- IN
149: -- p_api_version_number IN NUMBER Required

Line 198: DELETE FROM IEM_EMAIL_CLASSIFICATIONS

194: FND_MSG_PUB.initialize;
195: END IF;
196: -- Initialize API return status to SUCCESS
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198: DELETE FROM IEM_EMAIL_CLASSIFICATIONS
199: where message_id=p_message_id
200: and classification_id=p_classification_id
201: and email_account_id=p_email_account_id;
202: -- Standard Check Of p_commit.

Line 260: FROM IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b

256: l_cnt NUMBER:=1;
257:
258: CURSOR class_scr IS
259: SELECT a.classification_id,b.intent,a.score
260: FROM IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b
261: WHERE a.classification_id=b.intent_id
262: AND a.message_id = p_message_id
263: AND a.email_account_id = p_email_account_id;
264:

Line 358: FROM IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b

354: l_category_map_id number;
355:
356: CURSOR class_scr IS
357: SELECT a.classification_id,b.intent,a.score
358: FROM IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b
359: WHERE a.classification_id=b.intent_id
360: AND a.message_id = p_message_id
361: AND a.email_account_id = p_email_account_id;
362:

Line 449: -- Function : This procedure create a record in the table IEM_EMAIL_CLASSIFICATIONS

445:
446: -- Start of Comments
447: -- API name : create_item
448: -- Type : Private
449: -- Function : This procedure create a record in the table IEM_EMAIL_CLASSIFICATIONS
450: -- Pre-reqs : None.
451: -- Parameters :
452: -- IN
453: -- p_api_version_number IN NUMBER Required

Line 512: select count(*) into l_count from iem_email_classifications

508: FND_MSG_PUB.initialize;
509: END IF;
510: -- Initialize API return status to SUCCESS
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: select count(*) into l_count from iem_email_classifications
513: where message_id=p_message_id
514: and classification_id=p_classification_id;
515: If l_count=0 then
516: INSERT INTO IEM_EMAIL_CLASSIFICATIONS

Line 516: INSERT INTO IEM_EMAIL_CLASSIFICATIONS

512: select count(*) into l_count from iem_email_classifications
513: where message_id=p_message_id
514: and classification_id=p_classification_id;
515: If l_count=0 then
516: INSERT INTO IEM_EMAIL_CLASSIFICATIONS
517: (
518: MESSAGE_ID,
519: EMAIL_ACCOUNT_ID ,
520: CLASSIFICATION_ID ,