APPS.IGW_PROPOSAL_APPROVAL dependencies on IGW_PROP_USER_ROLES

Line 144: from igw_prop_user_roles ppr,

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

Line 211: from igw_prop_user_roles ppr,

207:
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

Line 436: from igw_prop_user_roles

432:
433:
434: cursor role_exists(l_role_id in number) is
435: select 'x'
436: from igw_prop_user_roles
437: where proposal_id = g_proposal_id
438: and user_id = l_user_id
439: and role_id = l_role_id;
440:

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

588: if p_rule_type = 'N' then
589: open role_exists(4);
590: fetch role_exists into l_dummy;
591: if role_exists%notfound then
592: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
593: last_update_date,last_updated_by,creation_date, created_by,
594: last_update_login)
595: values(
596: g_proposal_id,l_user_id,4,

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

602: elsif p_rule_type = 'R' then
603: open role_exists(1);
604: fetch role_exists into l_dummy;
605: if role_exists%notfound then
606: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
607: last_update_date,last_updated_by,creation_date, created_by,
608: last_update_login)
609: values(
610: g_proposal_id,l_user_id,1,

Line 1099: from igw_prop_user_roles

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
1098: select 'x'
1099: from igw_prop_user_roles
1100: where proposal_id = g_proposal_id
1101: and user_id = l_user_id
1102: and role_id = l_role_id;
1103:

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

1151:
1152: open so_user_role_exists(l_sign_off_user_id, 3);
1153: fetch so_user_role_exists into l_dummy;
1154: if so_user_role_exists%notfound then
1155: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
1156: last_update_date,last_updated_by,creation_date, created_by,
1157: last_update_login)
1158: values(
1159: g_proposal_id,l_sign_off_user_id,3,

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

1165: if l_sign_off_user_id <> l_admin_off_user_id then
1166: open so_user_role_exists(l_admin_off_user_id, 3);
1167: fetch so_user_role_exists into l_dummy;
1168: if so_user_role_exists%notfound then
1169: insert into igw_prop_user_roles(proposal_id,user_id,role_id,
1170: last_update_date,last_updated_by,creation_date, created_by,
1171: last_update_login)
1172: values(
1173: g_proposal_id,l_admin_off_user_id,3,