104: p_credit_request_status IN VARCHAR2 )
105: RETURN VARCHAR2 IS
106:
107: l_update_permissions VARCHAR2(1) :='N';
108: l_user_employee_id NUMBER := fnd_global.employee_id;
109: l_resource_id NUMBER;
110:
111: CURSOR get_resource_analyst IS
112: SELECT c.resource_id
183: p_requestor_id IN NUMBER)
184: RETURN VARCHAR2 IS
185:
186: l_update_permissions VARCHAR2(1) :='N';
187: l_user_employee_id NUMBER := fnd_global.employee_id;
188: l_resource_id NUMBER;
189:
190: CURSOR get_resource_analyst IS
191: SELECT c.resource_id
292: FUNCTION check_emp_credit_analyst
293: RETURN VARCHAR2 IS
294:
295: l_credit_analyst VARCHAR2(1) :='N';
296: l_employee_id NUMBER := fnd_global.employee_id;
297:
298: BEGIN
299: SELECT 'Y'
300: INTO l_credit_analyst
748: p_credit_request_status IN VARCHAR2 )
749: RETURN VARCHAR2
750: IS
751: l_del_permission varchar2(1) := 'N';
752: l_user_employee_id NUMBER := fnd_global.employee_id;
753: BEGIN
754: IF p_credit_request_status = 'SAVE' THEN
755: IF p_requestor_id IS NOT NULL THEN
756: if l_user_employee_id = p_requestor_id then