[Home] [Help]
150: x_return_status:= FND_API.G_RET_STS_SUCCESS;
151:
152: select x into y
153: from igw_prop_user_roles ppr,
154: igw_prop_users ppu
155: where ppr.proposal_id = p_proposal_id AND
156: ppr.proposal_id = ppu.proposal_id AND
157: ppr.user_id = ppu.user_id AND
158: ppr.role_id in (0,2) AND
212:
213: select count(*)
214: into l_count
215: from igw_prop_user_roles ppr,
216: igw_prop_users ppu
217: where ppr.proposal_id = p_proposal_id
218: and ppr.proposal_id = ppu.proposal_id
219: and ppr.user_id = ppu.user_id
220: and (ppr.role_id = 0 or ppr.role_id = 2)
421:
422:
423: cursor user_exists is
424: select 'x'
425: from igw_prop_users
426: where proposal_id = g_proposal_id
427: and user_id = l_user_id;
428:
429:
561: open user_exists;
562: fetch user_exists into l_dummy;
563: if user_exists%notfound then
564:
565: insert into igw_prop_users(proposal_id,user_id,start_date_active,
566: end_date_active,
567: last_update_date,last_updated_by,creation_date, created_by,
568: last_update_login)
569: values(
1073:
1074:
1075: cursor so_user_exists(l_user_id in number) is
1076: select 'x'
1077: from igw_prop_users
1078: where proposal_id = g_proposal_id
1079: and user_id = l_user_id;
1080:
1081: cursor so_user_role_exists(l_user_id in number, l_role_id in number) is
1104: fetch so_user_exists into l_dummy;
1105:
1106: if so_user_exists%notfound then
1107:
1108: insert into igw_prop_users(proposal_id,user_id,start_date_active,
1109: end_date_active,last_update_date,last_updated_by,creation_date,
1110: created_by,last_update_login)
1111: values(
1112: g_proposal_id,l_sign_off_user_id,sysdate,
1122: fetch so_user_exists into l_dummy;
1123:
1124: if so_user_exists%notfound then
1125:
1126: insert into igw_prop_users(proposal_id,user_id,start_date_active,
1127: end_date_active,last_update_date,last_updated_by,creation_date,
1128: created_by,last_update_login)
1129: values(
1130: g_proposal_id,l_admin_off_user_id,sysdate,