APPS.PQH_RLM_BUS dependencies on PQH_ROUTING_LIST_MEMBERS

Line 56: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');

52: <> pqh_rlm_shd.g_old_rec.routing_list_member_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');

62: if p_routing_list_member_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_PK');
67: --
68: end if;
69: --
70: end if;

Line 142: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK2');

138: --
139: hr_utility.set_message(8302, 'PQH_INVALID_ROUTING_LIST');
140: hr_utility.raise_error;
141:
142: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK2');
143: --
144: end if;
145: --
146: close c1;

Line 229: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');

225: -- table.
226: --
227: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
228: hr_utility.raise_error;
229: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
230: --
231: end if;
232: --
233: close c1;

Line 251: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');

247: -- table.
248: --
249: hr_utility.set_message(8302,'PQH_USER_NOT_OF_CUR_ROLE');
250: hr_utility.raise_error;
251: -- pqh_rlm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_FK1');
252: --
253: end if;
254: --
255: close c2;

Line 301: from pqh_routing_list_members a

297: l_dummy varchar2(1);
298: --
299: cursor c1 is
300: select null
301: from pqh_routing_list_members a
302: where a.routing_list_id=p_routing_list_id
303: and a.role_id = p_role_id
304: and nvl(a.user_id,-1) = nvl(p_user_id, -1);
305: --

Line 338: -- pqh_rtm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_UK1');

334: -- table.
335: --
336: hr_utility.set_message(8302,'PQH_DUP_RLM_NOT_ALLOWED');
337: hr_utility.raise_error;
338: -- pqh_rtm_shd.constraint_error('PQH_ROUTING_LIST_MEMBERS_UK1');
339: --
340: end if;
341: --
342: close c1;

Line 383: from pqh_routing_list_members a

379: l_dummy varchar2(1);
380: --
381: cursor c1 is
382: select null
383: from pqh_routing_list_members a
384: where a.routing_list_id=p_routing_list_id
385: and a.seq_no = p_seq_no;
386: --
387: Begin

Line 659: from pqh_routing_list_members rlm, pqh_routing_categories rct,

655: --
656: cursor c_txn_cats(p_routing_list_id number) is
657: select distinct ptc.transaction_category_id, ptc.name transaction_category_name,
658: ptc.business_group_id
659: from pqh_routing_list_members rlm, pqh_routing_categories rct,
660: pqh_transaction_categories ptc
661: where rlm.routing_list_id = rct.routing_list_id
662: and rct.routing_list_id = p_routing_list_id
663: and rct.transaction_category_id = ptc.transaction_category_id;