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 96: FROM DPP_APPROVAL_ACCESS daa, FND_USER fu

92: CURSOR csr_curr_approver (p_object_type IN VARCHAR2, p_object_id IN NUMBER,
93: p_action_performed IN VARCHAR2 )IS
94:
95: SELECT daa.approval_access_id, fu.user_id, fu.user_name
96: FROM DPP_APPROVAL_ACCESS daa, FND_USER fu
97: WHERE daa.approval_access_flag = 'Y'
98: AND object_type = p_object_type
99: AND object_id = p_object_id
100: AND daa.approver_id = DECODE(daa.approver_type, 'PERSON', fu.employee_id, fu.user_id)

Line 106: FROM DPP_APPROVAL_ACCESS

102: AND rownum < 2;
103:
104: CURSOR csr_count_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
105: SELECT count(1)
106: FROM DPP_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 DPP_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 DPP_APPROVAL_ACCESS
114: WHERE object_type = p_object_type
115: AND approval_access_flag = 'Y'
116: AND object_id = p_object_id;
117:

Line 120: FROM DPP_APPROVAL_ACCESS

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

Line 162: UPDATE DPP_APPROVAL_ACCESS

158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
160: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id : ' || p_approval_rec.object_id);
161:
162: UPDATE DPP_APPROVAL_ACCESS
163: SET action_code = p_approval_rec.action_code
164: , action_date = SYSDATE
165: , action_performed_by = p_approval_rec.action_performed_by
166: WHERE approval_access_id = l_approval_access_id;

Line 205: UPDATE DPP_APPROVAL_ACCESS

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

Line 390: FROM DPP_APPROVAL_ACCESS

386: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.GET_APPROVERS';
387:
388: CURSOR csr_approver_level (p_object_type in varchar2, p_object_id in number) IS
389: SELECT nvl(max(approval_level),0)
390: FROM DPP_APPROVAL_ACCESS
391: WHERE object_type = p_object_type
392: AND object_id = p_object_id;
393:
394: BEGIN

Line 1064: --Insert data into DPP_APPROVAL_ACCESS_all

1060: END IF;
1061: END IF;
1062: END LOOP;
1063:
1064: --Insert data into DPP_APPROVAL_ACCESS_all
1065: FOR i in 1..p_approvers.count LOOP
1066:
1067: BEGIN
1068:

Line 1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');

1065: FOR i in 1..p_approvers.count LOOP
1066:
1067: BEGIN
1068:
1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);

Line 1080: INSERT INTO DPP_APPROVAL_ACCESS(

1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1078: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_workflow_itemkey ' || l_workflow_itemkey);
1079:
1080: INSERT INTO DPP_APPROVAL_ACCESS(
1081: approval_access_id
1082: ,object_version_number
1083: ,last_update_date
1084: ,last_updated_by

Line 1096: DPP_APPROVAL_ACCESS_seq.NEXTVAL

1092: ,approver_id
1093: ,approval_access_flag
1094: ,workflow_itemkey
1095: ) VALUES (
1096: DPP_APPROVAL_ACCESS_seq.NEXTVAL
1097: ,1
1098: ,SYSDATE
1099: ,G_USER_ID
1100: ,SYSDATE

Line 1112: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'after Inserting data into DPP_APPROVAL_ACCESS table');

1108: ,'Y'
1109: ,l_workflow_itemkey
1110: );
1111:
1112: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'after Inserting data into DPP_APPROVAL_ACCESS table');
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF DPP_ERROR_ON THEN

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

1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF DPP_ERROR_ON THEN
1117: dpp_utility_pvt.error_message('DPP_APPROVAL_ACCESS_INSERT_ERR');
1118: x_return_status := FND_API.g_ret_sts_error;
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF;
1121: END;

Line 1219: FROM DPP_APPROVAL_ACCESS

1215: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.REVOKE_ACCESS';
1216:
1217: CURSOR csr_curr_approvers (p_object_type IN VARCHAR2, p_object_id IN NUMBER )IS
1218: SELECT approval_access_id
1219: FROM DPP_APPROVAL_ACCESS
1220: WHERE approval_access_flag = 'Y'
1221: AND object_type = p_object_type
1222: AND object_id = p_object_id
1223: AND action_code is not null;

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

1246: END IF;
1247: -- Initialize API return status to sucess
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;
1249:
1250: -- Update records in DPP_APPROVAL_ACCESS_all to revoke access
1251: OPEN csr_curr_approvers(p_object_type, p_object_id);
1252: LOOP
1253:
1254: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside revoke access');

Line 1262: UPDATE DPP_APPROVAL_ACCESS

1258:
1259: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside revoke access l_approval_access_id > ' || l_approval_access_id);
1260:
1261: -- Update approval access table to revoke access
1262: UPDATE DPP_APPROVAL_ACCESS
1263: SET approval_access_flag = 'N'
1264: WHERE approval_access_id = l_approval_access_id;
1265:
1266: -- Reset value to null

Line 1610: FROM dpp_approval_access

1606: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.SEND_NOTIFICATION';
1607:
1608: CURSOR csr_final_approval (p_object_type varchar2, p_object_id number) IS
1609: SELECT count(1)
1610: FROM dpp_approval_access
1611: WHERE object_type = p_object_type
1612: AND object_id = p_object_id
1613: AND approval_access_flag = 'Y';
1614:

Line 1617: FROM dpp_approval_access oaa

1613: AND approval_access_flag = 'Y';
1614:
1615: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1616: SELECT fu.user_name
1617: FROM dpp_approval_access oaa
1618: , fnd_user fu
1619: WHERE oaa.object_type = p_object_type
1620: AND oaa.object_id = p_object_id
1621: AND oaa.approver_type = 'USER'

Line 1626: FROM dpp_approval_access oaa

1622: AND oaa.approver_id = fu.user_id
1623: AND oaa.approval_access_flag = 'Y'
1624: UNION
1625: SELECT jre.user_name
1626: FROM dpp_approval_access oaa
1627: , jtf_rs_resource_extns jre
1628: WHERE oaa.object_type = p_object_type
1629: AND oaa.object_id = p_object_id
1630: AND oaa.approver_type = 'PERSON'

Line 1765: update DPP_APPROVAL_ACCESS

1761: -- no users returned from the search
1762: END IF;
1763:
1764: -- Update WorkFlow Item Key in approval Access Table
1765: update DPP_APPROVAL_ACCESS
1766: set workflow_itemkey = substr(l_item_key,1,239)
1767: where object_type = l_object_type
1768: and object_id = l_object_id
1769: and approval_level = ( select max (approval_level)

Line 1770: from DPP_APPROVAL_ACCESS

1766: set workflow_itemkey = substr(l_item_key,1,239)
1767: where object_type = l_object_type
1768: and object_id = l_object_id
1769: and approval_level = ( select max (approval_level)
1770: from DPP_APPROVAL_ACCESS
1771: where object_type = l_object_type
1772: and object_id = l_object_id);
1773: --Standard check of commit
1774: IF FND_API.To_Boolean ( p_commit ) THEN