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.CSM_PO_LOCATIONS_EVENT_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 141: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))

137: AND cas.cust_account_id = rcr.customer_id
138: AND cas.cust_acct_site_id = p_cust_acct_site_id
139: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
140: OR
141: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))
142: AND au.enabled='Y';
143:
144: CURSOR l_location_access_csr(p_location_id IN NUMBER, p_user_id IN NUMBER)
145: IS

Line 229: PROCEDURE GRP_ADDRESS_I(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE)

225: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_EXCEPTION);
226: RETURN 'ERROR';
227: END CUST_ACCT_SITE_UPD_WF_EVENT;
228:
229: PROCEDURE GRP_ADDRESS_I(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE)
230: IS
231: CURSOR c_g_addr
232: IS
233: SELECT pla.location_id ,

Line 282: PROCEDURE GRP_ADDRESS_D(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE)

278: END LOOP;
279: END GRP_ADDRESS_I;
280:
281:
282: PROCEDURE GRP_ADDRESS_D(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE)
283: IS
284: CURSOR c_g_addr
285: IS
286: SELECT acc.location_id ,

Line 301: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE group_id<>p_group_id AND category='EMPLOYEE' AND resource_id = au.resource_id))))

297: AND NOT EXISTS( SELECT 1 FROM csp_rs_cust_relations rcr
298: WHERE cas.cust_account_id = rcr.customer_id
299: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
300: OR
301: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE group_id<>p_group_id AND category='EMPLOYEE' AND resource_id = au.resource_id))))
302: AND au.resource_id=p_resource_id;
303:
304: l_error_msg VARCHAR2(4000);
305: l_return_status VARCHAR2(20);