eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_DASHBOARD_GROUP_CUHK

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 9778: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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;
9780: ELSE
9781: OPEN group_crs;
9782: FETCH group_crs INTO l_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 9819: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

9815: l_party_rec.Cust_Party_Id := l_emp_id;
9816: l_party_rec.Cust_Party_Type := upper(l_which_ivr);
9817:
9818:
9819: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
9820: l_group_id := l_party_rec.group_id;
9821: ELSE
9822:
9823: OPEN group_crs;

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 9926: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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);
9927: l_group_id := l_party_rec.group_id;
9928: ELSE
9929: OPEN group_crs;
9930: FETCH group_crs INTO l_group_id;

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 9967: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

9963: l_party_rec.Cust_Party_Id := l_emp_id;
9964: l_party_rec.Cust_Party_Type := 'EMPLOYEE';
9965:
9966:
9967: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
9968: l_group_id := l_party_rec.group_id;
9969: ELSE
9970:
9971: OPEN group_crs;

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 10013: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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:
10013: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
10014: l_group_id := l_party_rec.group_id;
10015: ELSE
10016:
10017: OPEN group_crs;

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 10126: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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:
10126: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
10127: l_group_id := l_party_rec.group_id;
10128: ELSE
10129: OPEN group_crs;
10130: FETCH group_crs INTO l_group_id;

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:

Line 10168: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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:
10168: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
10169: l_group_id := l_party_rec.group_id;
10170: ELSE
10171:
10172: OPEN group_crs;