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.OZF_APPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 29: FROM jtf_rs_resource_extns jre

25: l_return_status BOOLEAN := FALSE;
26:
27: CURSOR csr_resource (p_resource_id IN NUMBER) IS
28: SELECT jre.resource_id
29: FROM jtf_rs_resource_extns jre
30: WHERE jre.resource_id = p_resource_id;
31:
32: BEGIN
33: OPEN csr_resource(p_resource_id);

Line 90: from jtf_rs_resource_extns

86:
87:
88: CURSOR csr_person_user (p_source_id IN NUMBER )IS
89: select user_id
90: from jtf_rs_resource_extns
91: where source_id = p_source_id
92: and sysdate >= start_date_active
93: and sysdate <= nvl(end_date_active, sysdate)
94: and rownum < 2;

Line 128: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,

124: select count(1)
125: from jtf_auth_principal_maps jtfpm,
126: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
127: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
128: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
129: fnd_user usr
130: where PJ.user_name = jtfp1.principal_name
131: and pj.category = 'EMPLOYEE'
132: and usr.user_id = pj.user_id

Line 1269: , jtf_rs_resource_extns res

1265:
1266: CURSOR csr_cm (p_partner_id number) IS
1267: SELECT fnd_user.user_name
1268: FROM pv_partner_accesses acc
1269: , jtf_rs_resource_extns res
1270: , fnd_user
1271: WHERE acc.partner_id = p_partner_id
1272: AND acc.resource_id = res.resource_id
1273: AND res.user_id = fnd_user.user_id;

Line 1280: --, jtf_rs_resource_extns jre

1276: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1277: SELECT fu.user_name
1278: FROM ozf_approval_access oaa
1279: , fnd_user fu
1280: --, jtf_rs_resource_extns jre
1281: WHERE oaa.object_type = p_object_type
1282: AND oaa.object_id = p_object_id
1283: AND oaa.approver_type = 'USER'
1284: --AND fu.user_id = jre.user_id

Line 1291: , jtf_rs_resource_extns jre

1287: AND oaa.approval_access_flag = 'Y'
1288: UNION
1289: SELECT jre.user_name
1290: FROM ozf_approval_access oaa
1291: , jtf_rs_resource_extns jre
1292: WHERE oaa.object_type = p_object_type
1293: AND oaa.object_id = p_object_id
1294: AND oaa.approver_type = 'PERSON'
1295: AND oaa.approver_id = jre.source_id

Line 2020: FROM jtf_rs_resource_extns

2016: l_approver_count NUMBER := 0;
2017:
2018: CURSOR csr_person_info (p_person_id IN NUMBER )IS
2019: SELECT user_id, resource_id
2020: FROM jtf_rs_resource_extns
2021: WHERE category = 'EMPLOYEE'
2022: AND source_id = p_person_id
2023: AND user_id IS NOT NULL
2024: AND sysdate >= start_date_active

Line 2030: FROM jtf_rs_resource_extns

2026: AND rownum < 2;
2027:
2028: CURSOR csr_user_info (p_user_id IN NUMBER )IS
2029: SELECT resource_id
2030: FROM jtf_rs_resource_extns
2031: WHERE category = 'EMPLOYEE'
2032: AND user_id = p_user_id
2033: AND sysdate >= start_date_active
2034: AND sysdate <= nvl(end_date_active, sysdate)

Line 2398: from jtf_rs_resource_extns

2394: l_resource_id NUMBER;
2395:
2396: CURSOR csr_get_user_id (p_resource_id IN NUMBER )IS
2397: select user_id
2398: from jtf_rs_resource_extns
2399: where resource_id = p_resource_id
2400: and sysdate >= start_date_active
2401: and sysdate <= nvl(end_date_active, sysdate)
2402: and rownum < 2;

Line 2406: from jtf_rs_resource_extns

2402: and rownum < 2;
2403:
2404: CURSOR csr_get_resource_id (p_user_id IN NUMBER )IS
2405: select resource_id
2406: from jtf_rs_resource_extns
2407: where user_id = p_user_id
2408: and sysdate >= start_date_active
2409: and sysdate <= nvl(end_date_active, sysdate)
2410: and rownum < 2;

Line 2986: jtf_rs_resource_extns jre

2982: AND ora.enabled_flag = 'Y'
2983: UNION
2984: SELECT jre.user_name
2985: FROM ozf_sd_request_access ora,
2986: jtf_rs_resource_extns jre
2987: WHERE ora.request_header_id = p_object_id
2988: AND ora.person_id IS NOT NULL
2989: AND ora.person_id = jre.source_id
2990: AND ora.approver_flag = 'Y'

Line 3005: jtf_rs_resource_extns jre

3001: AND ora.enabled_flag = 'Y'
3002: UNION
3003: SELECT jre.user_name
3004: FROM ozf_sd_request_access ora,
3005: jtf_rs_resource_extns jre
3006: WHERE ora.request_header_id = p_object_id
3007: AND ora.person_id IS NOT NULL
3008: AND ora.person_id = jre.source_id
3009: AND ora.enabled_flag = 'Y'

Line 3029: , jtf_rs_resource_extns requester

3025: orh.supplier_response_by_date,
3026: orh.authorization_number
3027: FROM ozf_sd_request_headers_all_b orh
3028: , ap_suppliers aps
3029: , jtf_rs_resource_extns requester
3030: , hr_all_organization_units hou
3031: WHERE
3032: orh.request_header_id = p_object_id
3033: AND orh.requestor_id = requester.resource_id (+)

Line 3042: , jtf_rs_resource_extns assignee

3038: SELECT assignee.source_name,
3039: orh.asignee_response_date,
3040: orh.asignee_response_by_date
3041: FROM ozf_sd_request_headers_all_b orh
3042: , jtf_rs_resource_extns assignee
3043: WHERE
3044: orh.request_header_id = p_object_id
3045: AND orh.asignee_resource_id = assignee.resource_id;
3046: