DBA Data[Home] [Help]

APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_DASHBOARD_GROUP_CUHK

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

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);
7073: l_group_id := l_party_rec.group_id;
7074: ELSE
7075: OPEN group_crs;
7076: FETCH group_crs INTO l_group_id;

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

7108: l_party_rec.Cust_Party_Id := l_emp_id;
7109: l_party_rec.Cust_Party_Type := upper(l_which_ivr);
7110:
7111:
7112: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
7113: l_group_id := l_party_rec.group_id;
7114: ELSE
7115:
7116: OPEN group_crs;

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

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);
7219: l_group_id := l_party_rec.group_id;
7220: ELSE
7221: OPEN group_crs;
7222: FETCH group_crs INTO l_group_id;

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

7254: l_party_rec.Cust_Party_Id := l_emp_id;
7255: l_party_rec.Cust_Party_Type := 'EMPLOYEE';
7256:
7257:
7258: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
7259: l_group_id := l_party_rec.group_id;
7260: ELSE
7261:
7262: OPEN group_crs;

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

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:
7303: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
7304: l_group_id := l_party_rec.group_id;
7305: ELSE
7306:
7307: OPEN group_crs;

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

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:
7415: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
7416: l_group_id := l_party_rec.group_id;
7417: ELSE
7418: OPEN group_crs;
7419: FETCH group_crs INTO l_group_id;

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:

Line 7456: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);

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:
7456: CSC_DASHBOARD_GROUP_CUHK.get_dashboard_group_pre(l_party_rec);
7457: l_group_id := l_party_rec.group_id;
7458: ELSE
7459:
7460: OPEN group_crs;