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 OZF_APPROVAL_ACCESS

Line 98: FROM ozf_approval_access

94: and rownum < 2;
95:
96: CURSOR csr_curr_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
97: SELECT approval_access_id, approver_id, approver_type,action_code
98: FROM ozf_approval_access
99: WHERE approval_access_flag = 'Y'
100: AND object_type = p_object_type
101: AND object_id = p_object_id;
102:

Line 106: FROM ozf_approval_access

102:
103:
104: CURSOR csr_count_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
105: SELECT count(1)
106: FROM ozf_approval_access
107: WHERE approval_access_flag = 'Y'
108: AND object_type = p_object_type
109: AND object_id = p_object_id;
110:

Line 113: FROM ozf_approval_access

109: AND object_id = p_object_id;
110:
111: CURSOR csr_check_reassign_level (p_object_type in varchar2, p_object_id in number) IS
112: SELECT nvl(min(approval_level),0)
113: FROM ozf_approval_access
114: WHERE object_type = p_object_type
115: AND object_id = p_object_id;
116:
117: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS

Line 119: FROM ozf_approval_access

115: AND object_id = p_object_id;
116:
117: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
118: SELECT nvl(max(approval_level),0)
119: FROM ozf_approval_access
120: WHERE object_type = p_object_type
121: AND object_id = p_object_id;
122:
123: CURSOR crs_get_int_super_users(pc_permission varchar2, pc_userid number) is

Line 229: UPDATE ozf_approval_access

225: --As Action is always Performed by Approver check with User Id only
226: -- or action is performed by Super User
227: IF l_is_super_user = 'Y' OR l_act_approver_id = p_approval_rec.action_performed_by THEN
228: -- Update approval access table to revoke access
229: UPDATE ozf_approval_access
230: SET action_code = p_approval_rec.action_code
231: , action_date = SYSDATE
232: , action_performed_by = p_approval_rec.action_performed_by
233: WHERE approval_access_id = l_approval_access_id;

Line 276: UPDATE ozf_approval_access

272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274:
275: -- Update approval access table to revoke access
276: UPDATE ozf_approval_access
277: SET action_code = p_approval_rec.action_code
278: , action_date = SYSDATE
279: , action_performed_by = p_approval_rec.action_performed_by
280: WHERE object_type = p_approval_rec.object_type

Line 503: FROM ozf_approval_access

499: --l_ame_forward_rec ame_util.approverRecord default ame_util.emptyApproverRecord;
500:
501: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
502: SELECT nvl(max(approval_level),0)
503: FROM ozf_approval_access
504: WHERE object_type = p_object_type
505: AND object_id = p_object_id;
506:
507: BEGIN

Line 707: SELECT ozf_approval_access_s.NEXTVAL

703: l_approval_access_id NUMBER;
704: l_workflow_itemkey VARCHAR2(80);
705:
706: CURSOR c_id IS
707: SELECT ozf_approval_access_s.NEXTVAL
708: FROM dual;
709:
710: BEGIN
711: -- Standard begin of API savepoint

Line 779: --Insert data into ozf_approval_access_all

775: END IF;
776: END IF;
777: END LOOP;
778:
779: --Insert data into ozf_approval_access_all
780: FOR i in 1..p_approvers.count LOOP
781: BEGIN
782: IF G_DEBUG THEN
783: ozf_utility_pvt.debug_message( 'Inserting data into OZF_APPROVAL_ACCESS table');

Line 783: ozf_utility_pvt.debug_message( 'Inserting data into OZF_APPROVAL_ACCESS table');

779: --Insert data into ozf_approval_access_all
780: FOR i in 1..p_approvers.count LOOP
781: BEGIN
782: IF G_DEBUG THEN
783: ozf_utility_pvt.debug_message( 'Inserting data into OZF_APPROVAL_ACCESS table');
784: END IF;
785: --
786: INSERT INTO OZF_APPROVAL_ACCESS(
787: approval_access_id

Line 786: INSERT INTO OZF_APPROVAL_ACCESS(

782: IF G_DEBUG THEN
783: ozf_utility_pvt.debug_message( 'Inserting data into OZF_APPROVAL_ACCESS table');
784: END IF;
785: --
786: INSERT INTO OZF_APPROVAL_ACCESS(
787: approval_access_id
788: ,object_version_number
789: ,last_update_date
790: ,last_updated_by

Line 820: ozf_utility_pvt.error_message('OZF_APPROVAL_ACCESS_INSERT_ERR');

816: );
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF OZF_ERROR_ON THEN
820: ozf_utility_pvt.error_message('OZF_APPROVAL_ACCESS_INSERT_ERR');
821: x_return_status := FND_API.g_ret_sts_error;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: END;

Line 906: FROM ozf_approval_access

902: l_approval_access_id number;
903:
904: CURSOR csr_curr_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
905: SELECT approval_access_id
906: FROM ozf_approval_access
907: WHERE approval_access_flag = 'Y'
908: AND object_type = p_object_type
909: AND object_id = p_object_id;
910:

Line 936: -- Update records in ozf_approval_access_all to revoke access

932: END IF;
933: -- Initialize API return status to sucess
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935:
936: -- Update records in ozf_approval_access_all to revoke access
937: OPEN csr_curr_approvers(p_object_type, p_object_id);
938: LOOP
939: FETCH csr_curr_approvers INTO l_approval_access_id;
940: EXIT WHEN csr_curr_approvers%NOTFOUND;

Line 943: UPDATE ozf_approval_access

939: FETCH csr_curr_approvers INTO l_approval_access_id;
940: EXIT WHEN csr_curr_approvers%NOTFOUND;
941:
942: -- Update approval access table to revoke access
943: UPDATE ozf_approval_access
944: SET approval_access_flag = 'N'
945: WHERE approval_access_id = l_approval_access_id;
946:
947: -- Reset value to null

Line 1259: FROM ozf_approval_access

1255:
1256:
1257: CURSOR csr_final_approval (p_object_type varchar2, p_object_id number) IS
1258: SELECT count(1)
1259: FROM ozf_approval_access
1260: WHERE object_type = p_object_type
1261: AND object_id = p_object_id
1262: AND approval_access_flag = 'Y';
1263:

Line 1278: FROM ozf_approval_access oaa

1274:
1275:
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

Line 1290: FROM ozf_approval_access oaa

1286: AND oaa.approver_id = fu.user_id
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'

Line 1497: update ozf_approval_access

1493: END LOOP;
1494: CLOSE csr_message;
1495:
1496: -- Update WorkFlow Item Key in approval Access Table
1497: update ozf_approval_access
1498: set workflow_itemkey = substr(l_item_key,1,239)
1499: where object_type = l_object_type
1500: and object_id = l_object_id
1501: and approval_level = ( select max (approval_level)

Line 1502: from ozf_approval_access

1498: set workflow_itemkey = substr(l_item_key,1,239)
1499: where object_type = l_object_type
1500: and object_id = l_object_id
1501: and approval_level = ( select max (approval_level)
1502: from ozf_approval_access
1503: where object_type = l_object_type
1504: and object_id = l_object_id);
1505:
1506: --Standard check of commit

Line 1600: from ozf_approval_access

1596: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1597:
1598: CURSOR csr_forward_reassign (p_request_id in number , p_object_type in varchar2) IS
1599: select nvl(approval_level,1) + 1
1600: from ozf_approval_access
1601: where object_id = p_request_id
1602: and object_type = p_object_type
1603: and approval_access_flag = 'Y'
1604: and rownum < 2;