APPS.IGW_PROP dependencies on IGW_PROP_USER_ROLES

Line 239: from igw_prop_user_roles

235: RETURN varchar2 IS
236:
237: CURSOR cur_user_roles IS
238: select 'Y'
239: from igw_prop_user_roles
240: where proposal_id = p_proposal_id
241: and user_id = p_user_id
242: and role_id = 3;
243:

Line 339: INSERT INTO igw_prop_user_roles

335: WHERE proposal_id = p_proposal_id
336: AND user_id = p_user_id );
337:
338:
339: INSERT INTO igw_prop_user_roles
340: (
341: proposal_id,
342: user_id,
343: role_id,

Line 363: FROM igw_prop_user_roles

359: FROM
360: dual
361: WHERE not exists
362: ( SELECT 'X'
363: FROM igw_prop_user_roles
364: WHERE proposal_id = p_proposal_id
365: AND user_id = p_user_id
366: AND role_id = p_role_id );
367:

Line 378: DELETE igw_prop_user_roles

374: p_user_id number,
375: p_role_id number ) IS
376: BEGIN
377:
378: DELETE igw_prop_user_roles
379: WHERE proposal_id = p_proposal_id
380: AND user_id = p_user_id
381: AND role_id = p_role_id;
382:

Line 388: FROM igw_prop_user_roles

384: WHERE proposal_id = p_proposal_id
385: AND user_id = p_user_id
386: AND not exists (
387: SELECT 'X'
388: FROM igw_prop_user_roles
389: WHERE proposal_id = p_proposal_id
390: AND user_id = p_user_id );
391:
392: END del_prop_user_role;

Line 561: igw_prop_user_roles

557: SYSDATE,
558: FND_GLOBAL.USER_ID,
559: FND_GLOBAL.LOGIN_ID
560: FROM
561: igw_prop_user_roles
562: WHERE
563: proposal_id = p_old_proposal_id and
564: role_id = 0
565: ;

Line 568: INSERT INTO igw_prop_user_roles

564: role_id = 0
565: ;
566:
567:
568: INSERT INTO igw_prop_user_roles
569: (
570: proposal_id,
571: user_id,
572: role_id,

Line 591: igw_prop_user_roles

587: SYSDATE,
588: FND_GLOBAL.USER_ID,
589: FND_GLOBAL.LOGIN_ID
590: FROM
591: igw_prop_user_roles
592: WHERE
593: proposal_id = p_old_proposal_id and
594: role_id = 0
595: ;