APPS.PQH_RNG_BUS dependencies on PQH_ROUTING_LIST_MEMBERS

Line 279: from pqh_routing_list_members a

275: l_dummy varchar2(1);
276: --
277: cursor c1 is
278: select null
279: from pqh_routing_list_members a
280: where a.routing_list_member_id = p_routing_list_member_id;
281: --
282: Begin
283: --

Line 296: -- check if routing_list_member_id value exists in pqh_routing_list_members table

292: <> nvl(pqh_rng_shd.g_old_rec.routing_list_member_id,hr_api.g_number)
293: or not l_api_updating) and
294: p_routing_list_member_id is not null then
295: --
296: -- check if routing_list_member_id value exists in pqh_routing_list_members table
297: --
298: open c1;
299: --
300: fetch c1 into l_dummy;

Line 305: -- raise error as FK does not relate to PK in pqh_routing_list_members

301: if c1%notfound then
302: --
303: close c1;
304: --
305: -- raise error as FK does not relate to PK in pqh_routing_list_members
306: -- table.
307: --
308: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK2');
309: --

Line 362: l_rlist_id2 pqh_routing_list_members.routing_list_id%type;

358: p_routing_category_id in number,
359: p_object_version_number in number) is
360: --
361: l_rlist_id1 pqh_routing_categories.routing_list_id%type;
362: l_rlist_id2 pqh_routing_list_members.routing_list_id%type;
363: l_enable_flag pqh_routing_list_members.enable_flag%type;
364: l_position_structure_id pqh_routing_categories.position_structure_id%type;
365: --
366: Cursor csr_list_id is

Line 363: l_enable_flag pqh_routing_list_members.enable_flag%type;

359: p_object_version_number in number) is
360: --
361: l_rlist_id1 pqh_routing_categories.routing_list_id%type;
362: l_rlist_id2 pqh_routing_list_members.routing_list_id%type;
363: l_enable_flag pqh_routing_list_members.enable_flag%type;
364: l_position_structure_id pqh_routing_categories.position_structure_id%type;
365: --
366: Cursor csr_list_id is
367: select nvl(routing_list_id,hr_api.g_number),

Line 374: from pqh_routing_list_members a

370: where a.routing_category_id = p_routing_category_id;
371: --
372: Cursor csr_routing_list_member is
373: Select nvl(routing_list_id,hr_api.g_number),nvl(enable_flag,'N')
374: from pqh_routing_list_members a
375: where a.routing_list_member_id = p_routing_list_member_id;
376: --
377: Cursor csr_pos_in_pos_hier(p_position_structure_id in number) is
378: select null

Line 853: From pqh_routing_list_members

849: RETURN NUMBER is
850: --
851: Cursor csr_member_enabled is
852: Select nvl(enable_flag,'N')
853: From pqh_routing_list_members
854: Where routing_list_id = p_routing_list_id
855: And routing_list_member_id = p_routing_list_member_id;
856: --
857: l_enable_flag pqh_routing_list_members.enable_flag%type;

Line 857: l_enable_flag pqh_routing_list_members.enable_flag%type;

853: From pqh_routing_list_members
854: Where routing_list_id = p_routing_list_id
855: And routing_list_member_id = p_routing_list_member_id;
856: --
857: l_enable_flag pqh_routing_list_members.enable_flag%type;
858: l_proc varchar2(72) := g_package||'chk_if_member_enabled';
859: --
860: Begin
861: --