APPS.IEM_EMAILPROC_HDL_PVT dependencies on IEM_EMAILPROCS

Line 5: -- Purpose: Mantain IEM_EMAILPROCS, IEM_EMAILPROC_RULES, IEM_ACCOUNT_EMAILPROCS, IEM_ACTIONS, IEM_ACTION_DTLS

1: PACKAGE BODY IEM_EMAILPROC_HDL_PVT AS
2: /* $Header: iemvprob.pls 120.0.12010000.2 2009/07/11 16:52:07 lkullamb ship $ */
3: --
4: --
5: -- Purpose: Mantain IEM_EMAILPROCS, IEM_EMAILPROC_RULES, IEM_ACCOUNT_EMAILPROCS, IEM_ACTIONS, IEM_ACTION_DTLS
6: -- related operations
7: --
8: -- MODIFICATION HISTORY
9: -- Person Date Comments

Line 256: from iem_emailprocs

252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: --check duplicate value for attribute Name
255: select count(*) into l_name_count
256: from iem_emailprocs
257: where UPPER(name) = UPPER(p_name) and rule_type=p_rule_type and emailproc_id <> p_emailproc_id;
258:
259: if l_name_count > 0 then
260: raise IEM_ADM_DUP_NAME;

Line 303: update IEM_EMAILPROCS

299: elsif ( p_rule_type = FND_API.G_MISS_CHAR ) then
300: raise IEM_ADM_G_MISS_FOR_NOTNULL;
301: end if;
302:
303: update IEM_EMAILPROCS
304: set
305: name=decode(p_name,null,name,p_name),
306: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
307: boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),

Line 599: Select count(*) into l_emailproc_cnt from iem_emailprocs

595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: -- Check For Existing IEM Server Group
598:
599: Select count(*) into l_emailproc_cnt from iem_emailprocs
600: where emailproc_id=p_emailproc_id;
601:
602: IF l_emailproc_cnt = 0 then
603: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_EMAILPROC_NOT_EXIST');

Line 761: select count(*) into l_name_count from iem_emailprocs where rule_type=p_rule_type and UPPER(name) = UPPER(p_name);

757:
758: --begins here
759:
760: --check duplicate value for attribute Name
761: select count(*) into l_name_count from iem_emailprocs where rule_type=p_rule_type and UPPER(name) = UPPER(p_name);
762:
763: if l_name_count > 0 then
764: raise IEM_ADM_DUP_NAME;
765: end if;

Line 801: SELECT IEM_EMAILPROCS_s1.nextval

797: l_proc_name := null;
798: end if;
799: */
800: --get next sequential number for route_id
801: SELECT IEM_EMAILPROCS_s1.nextval
802: INTO l_seq_id
803: FROM dual;
804:
805: INSERT INTO IEM_EMAILPROCS

Line 805: INSERT INTO IEM_EMAILPROCS

801: SELECT IEM_EMAILPROCS_s1.nextval
802: INTO l_seq_id
803: FROM dual;
804:
805: INSERT INTO IEM_EMAILPROCS
806: (
807: EMAILPROC_ID,
808: NAME,
809: DESCRIPTION,

Line 1478: ( select emailproc_id from iem_emailprocs

1474: (Select priority from iem_account_emailprocs
1475: where emailproc_id=p_emailproc_ids_tbl(i)
1476: and email_account_id=p_account_id)
1477: and emailproc_id in
1478: ( select emailproc_id from iem_emailprocs
1479: where rule_type= p_rule_type);
1480:
1481: DELETE
1482: FROM IEM_ACCOUNT_EMAILPROCS