APPS.IEM_EMAILPROC_PVT dependencies on IEM_ACCOUNT_ROUTES

Line 303: from iem_routes r, iem_account_routes a

299:
300: cursor c_routes(v_acct_Id number) is
301: select a.account_route_id, a.priority, r.route_id, r.name,r.description,
302: r.boolean_type_code, a.enabled_flag
303: from iem_routes r, iem_account_routes a
304: where r.route_id=a.route_id and a.email_account_id = v_acct_Id
305: order by a.priority asc;
306:
307: BEGIN

Line 545: Update iem_account_routes set priority=priority-1

541: end if;
542:
543: ELSIF ( p_rule_type = 'ROUTE') THEN
544: -- update priority after delete an account_routes
545: Update iem_account_routes set priority=priority-1
546: where email_account_id=p_acct_id
547: and priority >
548: ( Select priority from iem_account_routes
549: where route_id=p_emailProc_id

Line 548: ( Select priority from iem_account_routes

544: -- update priority after delete an account_routes
545: Update iem_account_routes set priority=priority-1
546: where email_account_id=p_acct_id
547: and priority >
548: ( Select priority from iem_account_routes
549: where route_id=p_emailProc_id
550: and email_account_id=p_acct_id);
551:
552: DELETE

Line 553: FROM IEM_ACCOUNT_ROUTES

549: where route_id=p_emailProc_id
550: and email_account_id=p_acct_id);
551:
552: DELETE
553: FROM IEM_ACCOUNT_ROUTES
554: WHERE route_id = p_emailProc_id and email_account_id = p_acct_id;
555:
556: ELSE
557: -- update priority before delete an account_emailprocs

Line 1479: -- to update and delete new ruples in iem_account_routes

1475: );
1476:
1477: END create_wrap_account_emailprocs;
1478:
1479: -- to update and delete new ruples in iem_account_routes
1480: PROCEDURE update_wrap_account_emailprocs (
1481: p_api_version_number IN NUMBER,
1482: p_init_msg_list IN VARCHAR2 := null,
1483: p_commit IN VARCHAR2 := null,