DBA Data[Home] [Help]

APPS.IGW_PROP dependencies on IGW_PROP_USERS

Line 308: INSERT INTO igw_prop_users

304: p_user_id number,
305: p_role_id number ) IS
306: BEGIN
307:
308: INSERT INTO igw_prop_users
309: (
310: proposal_id,
311: user_id,
312: start_date_active,

Line 334: FROM igw_prop_users

330: FROM
331: dual
332: WHERE not exists
333: ( SELECT 'X'
334: FROM igw_prop_users
335: WHERE proposal_id = p_proposal_id
336: AND user_id = p_user_id );
337:
338:

Line 383: DELETE igw_prop_users

379: WHERE proposal_id = p_proposal_id
380: AND user_id = p_user_id
381: AND role_id = p_role_id;
382:
383: DELETE igw_prop_users
384: WHERE proposal_id = p_proposal_id
385: AND user_id = p_user_id
386: AND not exists (
387: SELECT 'X'

Line 536: INSERT INTO igw_prop_users

532:
533: PROCEDURE copy_proposal_manager_role
534: ( p_old_proposal_id number, p_new_proposal_id number ) IS
535: BEGIN
536: INSERT INTO igw_prop_users
537: (
538: proposal_id,
539: user_id,
540: start_date_active,