APPS.CSC_PROFILE_ENGINE_PKG dependencies on JTF_USR_HKS

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

108: records by the profile engine.
109: *************************************************************************************/
110: l_custom_hook_enabled := 'N';
111: IF p_party_id IS NULL THEN
112: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN
113: l_custom_hook_enabled := 'Y';
114: CSC_PROF_PARTY_SQL_CUHK.Get_Party_Sql_Pre(l_ref_cursor);
115: LOOP
116: FETCH l_ref_cursor INTO l_party_id;

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

139: p_retcode := v_retcode;
140: END LOOP;
141: ELSE
142: l_custom_hook_enabled := 'N';
143: END IF; /* IF JTF_USR_HKS.ok_to_execute */
144: END IF; /* IF p_party_id IS NULL */
145:
146: IF l_custom_hook_enabled = 'N' THEN
147: /*Existing logic is used */

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

9771: END IF; /* l_acct_id is null -- outer */
9772: END IF; /* l_view_by_acct = 'Y' */
9773: /* If user hook for dashboard group is enabled, call user hook to get group_id.
9774: Else use the existing logic from setup form to get group_id */
9775: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
9776: l_party_rec.Cust_Party_Id := l_hidden_party_id;
9777: l_party_rec.Cust_Account_Id := l_acct_id;
9778: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
9779: l_group_id := l_party_rec.group_id;

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

9810: END IF; /* l_hidden_party_id is not null */
9811:
9812: ELSIF l_view_by = 'CONTACT' THEN --Refresh for employee
9813:
9814: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
9815: l_party_rec.Cust_Party_Id := l_emp_id;
9816: l_party_rec.Cust_Party_Type := upper(l_which_ivr);
9817:
9818:

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

9918:
9919: /* If user hook for dashboard group is enabled, call user hook to get group_id.
9920: Else use the existing logic from setup form to get group_id */
9921:
9922: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
9923: l_party_rec.Cust_Party_Id := l_hidden_party_id;
9924: l_party_rec.Cust_Account_Id := l_acct_id;
9925:
9926: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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

9958: END IF; /* l_party_id is not null */
9959:
9960: ELSIF l_view_by = 'CONTACT' and l_contact_type ='EMPLOYEE' THEN
9961:
9962: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
9963: l_party_rec.Cust_Party_Id := l_emp_id;
9964: l_party_rec.Cust_Party_Type := 'EMPLOYEE';
9965:
9966:

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

10004: CLOSE get_party_type;
10005:
10006: /* if view_by is contact and contact_id is not passed, don't process */
10007: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
10008: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
10009: l_party_rec.Cust_Party_Id := l_party_id;
10010: l_party_rec.Cust_Party_Type := l_party_type;
10011: l_party_rec.Cust_Account_Id := l_acct_id;
10012:

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

10117:
10118: /* If user hook for dashboard group is enabled, call user hook to get group_id.
10119: Else use the existing logic from setup form to get group_id */
10120:
10121: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
10122: l_party_rec.Cust_Party_Id := l_party_id;
10123: l_party_rec.Cust_Party_Type := l_party_type;
10124: l_party_rec.Cust_Account_Id := l_acct_id;
10125:

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

10159: ELSIF l_view_by = 'CONTACT' THEN
10160:
10161: /* if view_by is contact and contact_id is not passed, don't process */
10162: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
10163: IF JTF_USR_HKS.ok_to_execute('CSC_DASHBOARD_GROUP_CUHK', 'GET_DASHBOARD_GROUP_PRE', 'B', 'C') THEN
10164: l_party_rec.Cust_Party_Id := l_party_id;
10165: l_party_rec.Cust_Party_Type := l_party_type;
10166: l_party_rec.Cust_Account_Id := l_acct_id;
10167: