APPS.IEM_EMAILPROC_PVT dependencies on IEM_EMAILPROC_RULES

Line 798: FROM IEM_EMAILPROC_RULES

794: -- update by deleting rules from iem_route_rules table
795: if ( p_remove_rule_ids_tbl.count <> 0 ) then
796: FORALL i IN p_remove_rule_ids_tbl.FIRST..p_remove_rule_ids_tbl.LAST
797: DELETE
798: FROM IEM_EMAILPROC_RULES
799: WHERE emailproc_rule_id = p_remove_rule_ids_tbl(i);
800:
801: if SQL%NOTFOUND then
802: raise IEM_RULE_NOT_DELETED;

Line 832: select count(*) into l_rule_count from iem_emailproc_rules where emailproc_id = p_emailproc_id;

828: select all_email into l_all_emails
829: from iem_emailprocs where emailproc_id = p_emailproc_id;
830:
831: if l_all_emails<>'Y' then
832: select count(*) into l_rule_count from iem_emailproc_rules where emailproc_id = p_emailproc_id;
833:
834: if l_rule_count < 1 then
835: raise IEM_ADMIN_EMAILPROC_NO_RULE;
836: end if;

Line 1037: l_route_rule_id IEM_EMAILPROC_RULES.EMAILPROC_RULE_ID%TYPE;

1033: l_api_name VARCHAR2(255):='create_emailproc_wrap';
1034: l_api_version_number NUMBER:=1.0;
1035:
1036: l_emailproc_id IEM_EMAILPROCS.EMAILPROC_ID%TYPE;
1037: l_route_rule_id IEM_EMAILPROC_RULES.EMAILPROC_RULE_ID%TYPE;
1038: l_action_id IEM_ACTIONS.ACTION_ID%type;
1039: l_param2_count NUMBER := 0;
1040: l_param3_count NUMBER := 0;
1041: l_param_tag_count NUMBER := 0;

Line 1128: --Create iem_emailproc_rules

1124: raise IEM_EMAILPROC_NOT_CREATED;
1125: end if;
1126:
1127:
1128: --Create iem_emailproc_rules
1129: if p_rule_key_typecode_tbl.count<> 0 then
1130: FOR i IN p_rule_key_typecode_tbl.FIRST..p_rule_key_typecode_tbl.LAST loop
1131:
1132: iem_emailproc_hdl_pvt.create_item_emailproc_rules (

Line 1705: --remove iem_emailproc_rules

1701: DELETE
1702: FROM iem_account_emailprocs
1703: WHERE emailproc_id = p_emailproc_id;
1704:
1705: --remove iem_emailproc_rules
1706: DELETE
1707: FROM IEM_EMAILPROC_RULES
1708: WHERE emailproc_id=p_emailproc_id;
1709:

Line 1707: FROM IEM_EMAILPROC_RULES

1703: WHERE emailproc_id = p_emailproc_id;
1704:
1705: --remove iem_emailproc_rules
1706: DELETE
1707: FROM IEM_EMAILPROC_RULES
1708: WHERE emailproc_id=p_emailproc_id;
1709:
1710: --remove iem_action_dtls
1711: FOR v_action_id IN action_id_cursor(p_emailproc_id) LOOP