APPS.IEM_EMAILPROC_HDL_PVT dependencies on IEM_EMAILPROC_RULES

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 439: select count(*) into l_rule from iem_emailproc_rules

435: -- Initialize API return status to SUCCESS
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: -- check if the route_id exist in iem_routes
439: select count(*) into l_rule from iem_emailproc_rules
440: where emailproc_rule_id = p_emailproc_rule_id;
441:
442: if l_rule < 1 then
443: raise IEM_NO_RULE_UPDATE;

Line 470: update IEM_EMAILPROC_RULES

466: elsif ( p_value = FND_API.G_MISS_CHAR ) then
467: raise IEM_ADM_G_MISS_FOR_NOTNULL;
468: end if;
469:
470: update IEM_EMAILPROC_RULES
471: set
472: key_type_code=decode(p_key_type_code,null,key_type_code,p_key_type_code),
473: operator_type_code=decode(p_operator_type_code,null,operator_type_code,p_operator_type_code),
474: value=decode(p_value,null,value,p_value),

Line 997: SELECT IEM_EMAILPROC_RULES_s1.nextval

993: end if;
994: */
995:
996:
997: SELECT IEM_EMAILPROC_RULES_s1.nextval
998: INTO l_seq_id
999: FROM dual;
1000:
1001: INSERT INTO IEM_EMAILPROC_RULES

Line 1001: INSERT INTO IEM_EMAILPROC_RULES

997: SELECT IEM_EMAILPROC_RULES_s1.nextval
998: INTO l_seq_id
999: FROM dual;
1000:
1001: INSERT INTO IEM_EMAILPROC_RULES
1002: (
1003: EMAILPROC_RULE_ID,
1004: EMAILPROC_ID,
1005: KEY_TYPE_CODE,