APPS.CSC_PROFILE_ENGINE_PKG dependencies on JTF_USR_HKS

Line 107: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN

103: l_custom_hook_enabled := 'N';
104:
105:
106: IF p_party_id IS NULL THEN
107: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN
108:
109: l_custom_hook_enabled := 'Y';
110:
111:

Line 137: END IF; /* IF JTF_USR_HKS.ok_to_execute */

133: p_retcode := v_retcode;
134: END LOOP;
135: ELSE
136: l_custom_hook_enabled := 'N';
137: END IF; /* IF JTF_USR_HKS.ok_to_execute */
138: END IF; /* IF p_party_id IS NULL */
139:
140: IF l_custom_hook_enabled = 'N' THEN
141: /*Existing logic is used */

Line 7068: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7064:
7065: /* If user hook for dashboard group is enabled, call user hook to get group_id.
7066: Else use the existing logic from setup form to get group_id */
7067:
7068: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7069: l_party_rec.Cust_Party_Id := l_hidden_party_id;
7070: l_party_rec.Cust_Account_Id := l_acct_id;
7071:
7072: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

Line 7107: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7103: END IF; /* l_hidden_party_id is not null */
7104:
7105: ELSIF l_view_by = 'CONTACT' THEN --Refresh for employee
7106:
7107: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7108: l_party_rec.Cust_Party_Id := l_emp_id;
7109: l_party_rec.Cust_Party_Type := upper(l_which_ivr);
7110:
7111:

Line 7214: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7210:
7211: /* If user hook for dashboard group is enabled, call user hook to get group_id.
7212: Else use the existing logic from setup form to get group_id */
7213:
7214: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7215: l_party_rec.Cust_Party_Id := l_hidden_party_id;
7216: l_party_rec.Cust_Account_Id := l_acct_id;
7217:
7218: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

Line 7253: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7249: END IF; /* l_party_id is not null */
7250:
7251: ELSIF l_view_by = 'CONTACT' and l_contact_type ='EMPLOYEE' THEN
7252:
7253: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7254: l_party_rec.Cust_Party_Id := l_emp_id;
7255: l_party_rec.Cust_Party_Type := 'EMPLOYEE';
7256:
7257:

Line 7298: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7294: CLOSE get_party_type;
7295:
7296: /* if view_by is contact and contact_id is not passed, don't process */
7297: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
7298: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7299: l_party_rec.Cust_Party_Id := l_party_id;
7300: l_party_rec.Cust_Party_Type := l_party_type;
7301: l_party_rec.Cust_Account_Id := l_acct_id;
7302:

Line 7410: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7406:
7407: /* If user hook for dashboard group is enabled, call user hook to get group_id.
7408: Else use the existing logic from setup form to get group_id */
7409:
7410: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7411: l_party_rec.Cust_Party_Id := l_party_id;
7412: l_party_rec.Cust_Party_Type := l_party_type;
7413: l_party_rec.Cust_Account_Id := l_acct_id;
7414:

Line 7451: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN

7447: ELSIF l_view_by = 'CONTACT' THEN
7448:
7449: /* if view_by is contact and contact_id is not passed, don't process */
7450: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
7451: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
7452: l_party_rec.Cust_Party_Id := l_party_id;
7453: l_party_rec.Cust_Party_Type := l_party_type;
7454: l_party_rec.Cust_Account_Id := l_acct_id;
7455: