APPS.IGW_PROP_APPROVALS_PVT dependencies on IGW_PROP_USER_ROLES

Line 153: from igw_prop_user_roles ppr,

149: BEGIN
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

Line 215: from igw_prop_user_roles ppr,

211: -- or the Proposal Manager
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

Line 432: from igw_prop_user_roles

428:
429:
430: cursor role_exists(l_role_id in number) is
431: select 'x'
432: from igw_prop_user_roles
433: where proposal_id = g_proposal_id
434: and user_id = l_user_id
435: and role_id = l_role_id;
436:

Line 583: insert into igw_prop_user_roles(proposal_id,user_id,role_id,

579: if p_rule_type = 'N' then
580: open role_exists(4);
581: fetch role_exists into l_dummy;
582: if role_exists%notfound then
583: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
584: last_update_date,last_updated_by,creation_date, created_by,
585: last_update_login)
586: values(
587: g_proposal_id,l_user_id,4,

Line 597: insert into igw_prop_user_roles(proposal_id,user_id,role_id,

593: elsif p_rule_type = 'R' then
594: open role_exists(1);
595: fetch role_exists into l_dummy;
596: if role_exists%notfound then
597: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
598: last_update_date,last_updated_by,creation_date, created_by,
599: last_update_login)
600: values(
601: g_proposal_id,l_user_id,1,

Line 1083: from igw_prop_user_roles

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
1082: select 'x'
1083: from igw_prop_user_roles
1084: where proposal_id = g_proposal_id
1085: and user_id = l_user_id
1086: and role_id = l_role_id;
1087:

Line 1143: insert into igw_prop_user_roles(proposal_id,user_id,role_id,

1139:
1140: open so_user_role_exists(l_sign_off_user_id, 3);
1141: fetch so_user_role_exists into l_dummy;
1142: if so_user_role_exists%notfound then
1143: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
1144: last_update_date,last_updated_by,creation_date, created_by,
1145: last_update_login)
1146: values(
1147: g_proposal_id,l_sign_off_user_id,3,

Line 1158: insert into igw_prop_user_roles(proposal_id,user_id,role_id,

1154: if l_sign_off_user_id <> l_admin_off_user_id then
1155: open so_user_role_exists(l_admin_off_user_id, 3);
1156: fetch so_user_role_exists into l_dummy;
1157: if so_user_role_exists%notfound then
1158: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
1159: last_update_date,last_updated_by,creation_date, created_by,
1160: last_update_login)
1161: values(
1162: g_proposal_id,l_admin_off_user_id,3,