[Home] [Help]
61: order by UPPER(name) asc;
62:
63: cursor c_routes is
64: select rt.route_id, rt.name, rt.description, rt.boolean_type_code, fu.user_name, to_char(rt.creation_date) creation_date
65: from iem_routes rt, fnd_user fu where fu.user_id = rt.created_by
66: order by UPPER(rt.name) asc;
67:
68: cursor c_emailProcs(v_rule_type varchar2) is
69: select ep.emailproc_id, ep.name, ep.description, ep.rule_type, fu.user_name, to_char(ep.creation_date) creation_date
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
604: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
605:
606: END ;
607:
608: --update iem_routes, update iem_route_rules, insert iem_route_rules
609: PROCEDURE update_emailproc_wrap (
610: p_api_version_number IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := null,
612: p_commit IN VARCHAR2 := null,
746: end if;
747:
748: end if;
749:
750: --update iem_routes table
751:
752: iem_emailproc_hdl_pvt.update_item_emailproc(
753: p_api_version_number => l_api_version_number,
754: p_init_msg_list => FND_API.G_FALSE,
1345: -- Initialize API return status to SUCCESS
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348:
1349: -- check if the route_id exist in iem_routes
1350: select count(*) into l_count from iem_emailprocs
1351: where emailproc_id = p_emailproc_id;
1352:
1353: if l_count < 1 then