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.DPP_APPROVAL_PVT dependencies on DPP_APPROVAL_ACCESS

Line 94: FROM DPP_APPROVAL_ACCESS

90: and rownum < 2;
91:
92: CURSOR csr_curr_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
93: SELECT approval_access_id, approver_id, approver_type,action_code
94: FROM DPP_APPROVAL_ACCESS
95: WHERE approval_access_flag = 'Y'
96: AND object_type = p_object_type
97: AND object_id = p_object_id;
98:

Line 101: FROM DPP_APPROVAL_ACCESS

97: AND object_id = p_object_id;
98:
99: CURSOR csr_count_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
100: SELECT count(1)
101: FROM DPP_APPROVAL_ACCESS
102: WHERE approval_access_flag = 'Y'
103: AND object_type = p_object_type
104: AND object_id = p_object_id;
105:

Line 108: FROM DPP_APPROVAL_ACCESS

104: AND object_id = p_object_id;
105:
106: CURSOR csr_check_reassign_level (p_object_type in varchar2, p_object_id in number) IS
107: SELECT nvl(min(approval_level),0)
108: FROM DPP_APPROVAL_ACCESS
109: WHERE object_type = p_object_type
110: AND approval_access_flag = 'Y'
111: AND object_id = p_object_id;
112:

Line 115: FROM DPP_APPROVAL_ACCESS

111: AND object_id = p_object_id;
112:
113: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
114: SELECT nvl(max(approval_level),0)
115: FROM DPP_APPROVAL_ACCESS
116: WHERE object_type = p_object_type
117: AND object_id = p_object_id;
118:
119: BEGIN

Line 163: UPDATE DPP_APPROVAL_ACCESS

159: dpp_utility_pvt.debug_message( 'l_act_approver_id : '||l_act_approver_id);
160: END IF;
161: IF l_act_approver_id = p_approval_rec.action_performed_by THEN
162: -- Update approval access table to revoke access
163: UPDATE DPP_APPROVAL_ACCESS
164: SET action_code = p_approval_rec.action_code
165: , action_date = SYSDATE
166: , action_performed_by = p_approval_rec.action_performed_by
167: WHERE approval_access_id = l_approval_access_id;

Line 209: UPDATE DPP_APPROVAL_ACCESS

205: RAISE FND_API.g_exc_unexpected_error;
206: END IF;
207:
208: -- Update approval access table to revoke access
209: UPDATE DPP_APPROVAL_ACCESS
210: SET action_code = p_approval_rec.action_code
211: , action_date = SYSDATE
212: , action_performed_by = p_approval_rec.action_performed_by
213: WHERE object_type = p_approval_rec.object_type

Line 399: FROM DPP_APPROVAL_ACCESS

395: l_resource_id number;
396:
397: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
398: SELECT nvl(max(approval_level),0)
399: FROM DPP_APPROVAL_ACCESS
400: WHERE object_type = p_object_type
401: AND object_id = p_object_id;
402:
403: BEGIN

Line 860: SELECT DPP_APPROVAL_ACCESS_seq.NEXTVAL

856: l_approval_access_id NUMBER;
857: l_workflow_itemkey VARCHAR2(80);
858:
859: CURSOR c_id IS
860: SELECT DPP_APPROVAL_ACCESS_seq.NEXTVAL
861: FROM dual;
862:
863: BEGIN
864: -- Standard begin of API savepoint

Line 926: --Insert data into DPP_APPROVAL_ACCESS_all

922: END IF;
923: END IF;
924: END LOOP;
925:
926: --Insert data into DPP_APPROVAL_ACCESS_all
927: FOR i in 1..p_approvers.count LOOP
928: BEGIN
929: IF G_DEBUG THEN
930: dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');

Line 930: dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');

926: --Insert data into DPP_APPROVAL_ACCESS_all
927: FOR i in 1..p_approvers.count LOOP
928: BEGIN
929: IF G_DEBUG THEN
930: dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');
931: END IF;
932: --
933: INSERT INTO DPP_APPROVAL_ACCESS(
934: approval_access_id

Line 933: INSERT INTO DPP_APPROVAL_ACCESS(

929: IF G_DEBUG THEN
930: dpp_utility_pvt.debug_message( 'Inserting data into DPP_APPROVAL_ACCESS table');
931: END IF;
932: --
933: INSERT INTO DPP_APPROVAL_ACCESS(
934: approval_access_id
935: ,object_version_number
936: ,last_update_date
937: ,last_updated_by

Line 967: dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');

963: );
964: EXCEPTION
965: WHEN OTHERS THEN
966: IF DPP_ERROR_ON THEN
967: dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');
968: x_return_status := FND_API.g_ret_sts_error;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: END;

Line 1068: FROM DPP_APPROVAL_ACCESS

1064: l_approval_access_id number;
1065:
1066: CURSOR csr_curr_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
1067: SELECT approval_access_id
1068: FROM DPP_APPROVAL_ACCESS
1069: WHERE approval_access_flag = 'Y'
1070: AND object_type = p_object_type
1071: AND object_id = p_object_id;
1072:

Line 1098: -- Update records in DPP_APPROVAL_ACCESS_all to revoke access

1094: END IF;
1095: -- Initialize API return status to sucess
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: -- Update records in DPP_APPROVAL_ACCESS_all to revoke access
1099: OPEN csr_curr_approvers(p_object_type, p_object_id);
1100: LOOP
1101: FETCH csr_curr_approvers INTO l_approval_access_id;
1102: EXIT WHEN csr_curr_approvers%NOTFOUND;

Line 1105: UPDATE DPP_APPROVAL_ACCESS

1101: FETCH csr_curr_approvers INTO l_approval_access_id;
1102: EXIT WHEN csr_curr_approvers%NOTFOUND;
1103:
1104: -- Update approval access table to revoke access
1105: UPDATE DPP_APPROVAL_ACCESS
1106: SET approval_access_flag = 'N'
1107: WHERE approval_access_id = l_approval_access_id;
1108:
1109: -- Reset value to null

Line 1446: FROM dpp_approval_access

1442: l_final_approval number;
1443:
1444: CURSOR csr_final_approval (p_object_type varchar2, p_object_id number) IS
1445: SELECT count(1)
1446: FROM dpp_approval_access
1447: WHERE object_type = p_object_type
1448: AND object_id = p_object_id
1449: AND approval_access_flag = 'Y';
1450:

Line 1453: FROM dpp_approval_access oaa

1449: AND approval_access_flag = 'Y';
1450:
1451: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1452: SELECT fu.user_name
1453: FROM dpp_approval_access oaa
1454: , fnd_user fu
1455: WHERE oaa.object_type = p_object_type
1456: AND oaa.object_id = p_object_id
1457: AND oaa.approver_type = 'USER'

Line 1462: FROM dpp_approval_access oaa

1458: AND oaa.approver_id = fu.user_id
1459: AND oaa.approval_access_flag = 'Y'
1460: UNION
1461: SELECT jre.user_name
1462: FROM dpp_approval_access oaa
1463: , jtf_rs_resource_extns jre
1464: WHERE oaa.object_type = p_object_type
1465: AND oaa.object_id = p_object_id
1466: AND oaa.approver_type = 'PERSON'

Line 1615: update DPP_APPROVAL_ACCESS

1611: -- no users returned from the search
1612: END IF;
1613:
1614: -- Update WorkFlow Item Key in approval Access Table
1615: update DPP_APPROVAL_ACCESS
1616: set workflow_itemkey = substr(l_item_key,1,239)
1617: where object_type = l_object_type
1618: and object_id = l_object_id
1619: and approval_level = ( select max (approval_level)

Line 1620: from DPP_APPROVAL_ACCESS

1616: set workflow_itemkey = substr(l_item_key,1,239)
1617: where object_type = l_object_type
1618: and object_id = l_object_id
1619: and approval_level = ( select max (approval_level)
1620: from DPP_APPROVAL_ACCESS
1621: where object_type = l_object_type
1622: and object_id = l_object_id);
1623: --Standard check of commit
1624: IF FND_API.To_Boolean ( p_commit ) THEN