eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_USER_PVT dependencies on AMV_U_ACCESS

Line 241: Select amv_u_access_s.nextval, sysdate

237: l_date DATE;
238: l_access_obj AMV_ACCESS_OBJ_TYPE;
239: --
240: CURSOR Get_IDandDate_csr is
241: Select amv_u_access_s.nextval, sysdate
242: From Dual;
243: --
244: BEGIN
245: SAVEPOINT Add_Access_helper_PVT;

Line 264: Insert into amv_u_access

260: FETCH Get_IDandDate_csr INTO l_access_id, l_date;
261: CLOSE Get_IDandDate_csr;
262: l_access_obj := p_access_obj;
263: -- Maybe we add more checking on the passed object and make some change.
264: Insert into amv_u_access
265: (
266: ACCESS_ID,
267: OBJECT_VERSION_NUMBER,
268: CREATION_DATE,

Line 355: Update amv_u_access

351: l_current_resource_id := -1;
352: END IF;
353: l_access_obj := p_access_obj;
354: -- Maybe we add more checking on the passed object and make some change.
355: Update amv_u_access
356: Set LAST_UPDATE_DATE = sysdate,
357: LAST_UPDATED_BY = l_current_user_id,
358: LAST_UPDATE_LOGIN = l_current_login_id,
359: OBJECT_VERSION_NUMBER = object_version_number + 1,

Line 3924: Delete from amv_u_access

3920: END IF;
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;
3923: --Now do the job.
3924: Delete from amv_u_access
3925: Where user_or_group_id = l_group_id
3926: And User_OR_group_type = G_GROUP_ARC_TYPE;
3927: --
3928: Delete from amv_u_my_channels

Line 5361: From amv_u_access

5357: l_temp NUMBER;
5358: --
5359: CURSOR Get_AccessId_csr IS
5360: Select access_id
5361: From amv_u_access
5362: Where user_or_group_id = l_access_obj.user_or_group_id
5363: And user_or_group_type = l_access_obj.user_or_group_type
5364: And access_to_table_record_id = l_access_obj.access_to_table_record_id
5365: And access_to_table_code = l_access_obj.access_to_table_code;

Line 6380: From amv_u_access u, amv_c_channels_vl c

6376: U.CAN_CREATE_DIST_RULE_FLAG,
6377: U.CHL_APPROVER_FLAG,
6378: U.CHL_REQUIRED_FLAG,
6379: U.CHL_REQUIRED_NEED_NOTIF_FLAG
6380: From amv_u_access u, amv_c_channels_vl c
6381: Where u.user_or_group_id = p_user_or_group_id
6382: And u.user_or_group_type = p_user_or_group_type
6383: And access_to_table_code = G_CHAN_ARC_TYPE
6384: And u.access_to_table_record_id = c.channel_id;

Line 6542: From amv_u_access u, jtf_rs_groups_vl g

6538: U.CAN_CREATE_DIST_RULE_FLAG,
6539: U.CHL_APPROVER_FLAG,
6540: U.CHL_REQUIRED_FLAG,
6541: U.CHL_REQUIRED_NEED_NOTIF_FLAG
6542: From amv_u_access u, jtf_rs_groups_vl g
6543: Where u.user_or_group_id = g.group_id
6544: And u.user_or_group_type = G_GROUP_ARC_TYPE
6545: And access_to_table_code = G_CHAN_ARC_TYPE
6546: And u.access_to_table_record_id = p_channel_id;

Line 6567: From amv_u_access u, amv_rs_all_res_extns_vl r

6563: U.CAN_CREATE_DIST_RULE_FLAG,
6564: U.CHL_APPROVER_FLAG,
6565: U.CHL_REQUIRED_FLAG,
6566: U.CHL_REQUIRED_NEED_NOTIF_FLAG
6567: From amv_u_access u, amv_rs_all_res_extns_vl r
6568: Where u.user_or_group_id = r.resource_id
6569: And u.user_or_group_type = G_USER_ARC_TYPE
6570: And access_to_table_code = G_CHAN_ARC_TYPE
6571: And u.access_to_table_record_id = p_channel_id;

Line 6772: From amv_u_access

6768: CAN_CREATE_DIST_RULE_FLAG,
6769: CHL_APPROVER_FLAG,
6770: CHL_REQUIRED_FLAG,
6771: CHL_REQUIRED_NEED_NOTIF_FLAG
6772: From amv_u_access
6773: Where user_or_group_id = p_user_or_group_id
6774: And user_or_group_type = p_user_or_group_type
6775: And access_to_table_record_id = p_business_object_id
6776: And access_to_table_code = p_business_object_type;

Line 6952: From amv_u_access

6948: CAN_CREATE_DIST_RULE_FLAG,
6949: CHL_APPROVER_FLAG,
6950: CHL_REQUIRED_FLAG,
6951: CHL_REQUIRED_NEED_NOTIF_FLAG
6952: From amv_u_access
6953: Where user_or_group_id = p_user_or_group_id
6954: And user_or_group_type = p_user_or_group_type
6955: And access_to_table_record_id = p_business_object_id
6956: And access_to_table_code = p_business_object_type;

Line 6967: From amv_u_access a

6963: A.CAN_CREATE_DIST_RULE_FLAG,
6964: A.CHL_APPROVER_FLAG,
6965: A.CHL_REQUIRED_FLAG,
6966: A.CHL_REQUIRED_NEED_NOTIF_FLAG
6967: From amv_u_access a
6968: , jtf_rs_resource_extns r
6969: Where a.user_or_group_id = p_user_or_group_id
6970: And a.user_or_group_type = G_USER_ARC_TYPE
6971: And a.access_to_table_record_id = p_business_object_id

Line 6989: From amv_u_access a, jtf_rs_groups_vl g

6985: A.CAN_CREATE_DIST_RULE_FLAG,
6986: A.CHL_APPROVER_FLAG,
6987: A.CHL_REQUIRED_FLAG,
6988: A.CHL_REQUIRED_NEED_NOTIF_FLAG
6989: From amv_u_access a, jtf_rs_groups_vl g
6990: Where a.user_or_group_id = p_user_or_group_id
6991: And a.user_or_group_type = G_GROUP_ARC_TYPE
6992: And a.access_to_table_record_id = p_business_object_id
6993: And a.access_to_table_code = p_business_object_type

Line 7010: From amv_u_access a, jtf_rs_group_members m

7006: A.CAN_CREATE_DIST_RULE_FLAG,
7007: A.CHL_APPROVER_FLAG,
7008: A.CHL_REQUIRED_FLAG,
7009: A.CHL_REQUIRED_NEED_NOTIF_FLAG
7010: From amv_u_access a, jtf_rs_group_members m
7011: Where a.access_to_table_record_id = p_business_object_id
7012: And a.access_to_table_code = p_business_object_type
7013: And a.user_or_group_type = G_GROUP_ARC_TYPE
7014: And a.user_or_group_id = m.group_id

Line 7027: From amv_u_access a, jtf_rs_group_members m, jtf_rs_groups_vl g

7023: A.CAN_CREATE_DIST_RULE_FLAG,
7024: A.CHL_APPROVER_FLAG,
7025: A.CHL_REQUIRED_FLAG,
7026: A.CHL_REQUIRED_NEED_NOTIF_FLAG
7027: From amv_u_access a, jtf_rs_group_members m, jtf_rs_groups_vl g
7028: Where a.access_to_table_record_id = p_business_object_id
7029: And a.access_to_table_code =p_business_object_type
7030: And nvl(a.effective_start_date, sysdate-1) < sysdate
7031: And nvl(a.expiration_date, sysdate+1) > sysdate