APPS.PA_SECURITY_PVT dependencies on HZ_WF_SYNCH

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

64:
65: FUNCTION get_grantee_key(
66: p_source_type IN VARCHAR2 DEFAULT 'USER',
67: p_source_id IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
68: p_HZ_WF_Synch IN VARCHAR2 DEFAULT 'N') -- Modified default value to 'N' for bug 3471913
69: RETURN VARCHAR2 IS
70: l_emp_id NUMBER;
71: l_cust_id NUMBER;
72: l_grantee_key VARCHAR2(240) := '';

Line 133: AND p_HZ_WF_Synch = 'Y' THEN

129:
130: -- Invoke TCA API to create WF_ROLES if it does not exists
131: /* Bug 3417803 - Modified condition l_grantee_key = '' to l_grantee_key is null */
132: IF (l_grantee_key is null OR l_grantee_key = '')
133: AND p_HZ_WF_Synch = 'Y' THEN
134: /* Added get_party_id code and if condition for bug 3484332 */
135: IF l_cust_id is null THEN
136: OPEN get_party_id(l_emp_id);
137: FETCH get_party_id into l_cust_id;

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

136: OPEN get_party_id(l_emp_id);
137: FETCH get_party_id into l_cust_id;
138: CLOSE get_party_id;
139: END IF;
140: HZ_WF_Synch.SynchPersonWFRole(partyid => l_cust_id);
141: OPEN get_role_for_customer(l_cust_id);
142: FETCH get_role_for_customer into l_grantee_key;
143: CLOSE get_role_for_customer;
144: