APPS.PA_SECURITY_PVT dependencies on HZ_WF_SYNCH

Line 78: p_HZ_WF_Synch IN VARCHAR2 DEFAULT 'N') -- Modified default value to 'N' for bug 3471913

74:
75: FUNCTION get_grantee_key(
76: p_source_type IN VARCHAR2 DEFAULT 'USER',
77: p_source_id IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
78: p_HZ_WF_Synch IN VARCHAR2 DEFAULT 'N') -- Modified default value to 'N' for bug 3471913
79: RETURN VARCHAR2 IS
80: l_emp_id NUMBER;
81: l_cust_id NUMBER;
82: l_grantee_key VARCHAR2(240) := '';

Line 143: AND p_HZ_WF_Synch = 'Y' THEN

139:
140: -- Invoke TCA API to create WF_ROLES if it does not exists
141: /* Bug 3417803 - Modified condition l_grantee_key = '' to l_grantee_key is null */
142: IF (l_grantee_key is null OR l_grantee_key = '')
143: AND p_HZ_WF_Synch = 'Y' THEN
144: /* Added get_party_id code and if condition for bug 3484332 */
145: IF l_cust_id is null THEN
146: OPEN get_party_id(l_emp_id);
147: FETCH get_party_id into l_cust_id;

Line 150: HZ_WF_Synch.SynchPersonWFRole(partyid => l_cust_id);

146: OPEN get_party_id(l_emp_id);
147: FETCH get_party_id into l_cust_id;
148: CLOSE get_party_id;
149: END IF;
150: HZ_WF_Synch.SynchPersonWFRole(partyid => l_cust_id);
151: OPEN get_role_for_customer(l_cust_id);
152: FETCH get_role_for_customer into l_grantee_key;
153: CLOSE get_role_for_customer;
154: