[Home] [Help]
141: x_return_status:= FND_API.G_RET_STS_SUCCESS;
142:
143: select x into y
144: from igw_prop_user_roles ppr,
145: igw_prop_users ppu
146: where ppr.proposal_id = p_proposal_id AND
147: ppr.proposal_id = ppu.proposal_id AND
148: ppr.user_id = ppu.user_id AND
149: ppr.role_id in (0,2) AND
208:
209: select count(*)
210: into l_count
211: from igw_prop_user_roles ppr,
212: igw_prop_users ppu
213: where ppr.proposal_id = p_proposal_id
214: and ppr.proposal_id = ppu.proposal_id
215: and ppr.user_id = ppu.user_id
216: and (ppr.role_id = 0 or ppr.role_id = 2)
425:
426:
427: cursor user_exists is
428: select 'x'
429: from igw_prop_users
430: where proposal_id = g_proposal_id
431: and user_id = l_user_id;
432:
433:
570: open user_exists;
571: fetch user_exists into l_dummy;
572: if user_exists%notfound then
573:
574: insert into igw_prop_users(proposal_id,user_id,start_date_active,
575: end_date_active,
576: last_update_date,last_updated_by,creation_date, created_by,
577: last_update_login)
578: values(
1089:
1090:
1091: cursor so_user_exists(l_user_id in number) is
1092: select 'x'
1093: from igw_prop_users
1094: where proposal_id = g_proposal_id
1095: and user_id = l_user_id;
1096:
1097: cursor so_user_role_exists(l_user_id in number, l_role_id in number) is
1119: open so_user_exists(l_sign_off_user_id);
1120: fetch so_user_exists into l_dummy;
1121: if so_user_exists%notfound then
1122:
1123: insert into igw_prop_users(proposal_id,user_id,start_date_active,
1124: end_date_active,last_update_date,last_updated_by,creation_date,
1125: created_by,last_update_login)
1126: values(
1127: g_proposal_id,l_sign_off_user_id,sysdate,
1135: open so_user_exists(l_admin_off_user_id);
1136: fetch so_user_exists into l_dummy;
1137: if so_user_exists%notfound then
1138:
1139: insert into igw_prop_users(proposal_id,user_id,start_date_active,
1140: end_date_active,last_update_date,last_updated_by,creation_date,
1141: created_by,last_update_login)
1142: values(
1143: g_proposal_id,l_admin_off_user_id,sysdate,