APPS.HRI_OLTP_PMV_DTL_WRK_EVENT dependencies on HRI_OLTP_PMV_UTIL_PKG

Line 60: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

56: p_parameter_rec => l_parameter_rec,
57: p_bind_tab => l_bind_tab);
58:
59: /* Activite Drill URL for Link to HR Employee Directory */
60: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
61: ,p_bind_tab => l_bind_tab);
62:
63: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
64: l_lnk_emp_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_PER_ID&OAPB=FII_HR_BRAND_TEXT';

Line 212: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

208: || 'AND 1 = 1';
209: END IF;
210:
211: /* get security clause for Manager based security */
212: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
213: l_orderby_clause := '&ORDER_BY_CLAUSE';
214:
215: x_custom_sql := l_select_clause || g_rtn
216: ||l_from_clause || g_rtn

Line 261: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

257: p_parameter_rec => l_parameter_rec,
258: p_bind_tab => l_bind_tab);
259:
260: /* Activite Drill URL for Link to HR Employee Directory */
261: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
262: ,p_bind_tab => l_bind_tab);
263:
264: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
265: l_lnk_mgr_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_SUP_ID&OAPB=FII_HR_BRAND_TEXT';

Line 452: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

448: || 'AND 1 = 1';
449: END IF;
450:
451: /* get security clause for Manager based security */
452: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
453:
454: l_orderby_clause := '&ORDER_BY_CLAUSE';
455:
456: x_custom_sql := l_select_clause || g_rtn

Line 504: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

500: p_parameter_rec => l_parameter_rec,
501: p_bind_tab => l_bind_tab);
502:
503: /* Activite Drill URL for Link to HR Employee Directory */
504: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
505: ,p_bind_tab => l_bind_tab);
506:
507: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
508: l_lnk_emp_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_PER_ID&OAPB=FII_HR_BRAND_TEXT';

Line 608: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

604: || 'AND 1 = 1';
605: END IF;
606:
607: /* get security clause for Manager based security */
608: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
609:
610: l_orderby_clause := '&ORDER_BY_CLAUSE';
611:
612: x_custom_sql := l_select_clause || g_rtn

Line 659: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

655: p_parameter_rec => l_parameter_rec,
656: p_bind_tab => l_bind_tab);
657:
658: /* Activite Drill URL for Link to HR Employee Directory */
659: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
660: ,p_bind_tab => l_bind_tab);
661:
662: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
663: l_lnk_emp_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_PER_ID&OAPB=FII_HR_BRAND_TEXT';

Line 776: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

772: || 'AND 1 = 1';
773: END IF;
774:
775: /* get security clause for Manager based security */
776: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
777:
778: l_orderby_clause := '&ORDER_BY_CLAUSE';
779:
780: x_custom_sql := l_select_clause || g_rtn

Line 832: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

828: 'AND fact.wkth_wktyp_sk_fk = ''CWK''' || g_rtn;
829: END IF;
830:
831: /* Get security clause for Manager based security */
832: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
833:
834: /* Activate Drill URL for Link to HR Employee Directory */
835: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk
836: (p_parameter_rec => l_parameter_rec

Line 835: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk

831: /* Get security clause for Manager based security */
832: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
833:
834: /* Activate Drill URL for Link to HR Employee Directory */
835: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk
836: (p_parameter_rec => l_parameter_rec
837: ,p_bind_tab => l_bind_tab);
838:
839: /* Drill only possible on current date */

Line 979: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

975: p_parameter_rec => l_parameter_rec,
976: p_bind_tab => l_bind_tab);
977:
978: /* Activite Drill URL for Link to HR Employee Directory */
979: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
980: ,p_bind_tab => l_bind_tab);
981:
982: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
983: l_lnk_emp_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_PER_ID&OAPB=FII_HR_BRAND_TEXT';

Line 1087: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

1083: || 'AND 1 = 1';
1084: END IF;
1085:
1086: /* get security clause for Manager based security */
1087: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
1088:
1089: l_orderby_clause := '&ORDER_BY_CLAUSE';
1090:
1091: x_custom_sql := l_select_clause || g_rtn

Line 1133: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

1129: p_parameter_rec => l_parameter_rec,
1130: p_bind_tab => l_bind_tab);
1131:
1132: /* Activite Drill URL for Link to HR Employee Directory */
1133: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
1134: ,p_bind_tab => l_bind_tab);
1135:
1136: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
1137: l_lnk_emp_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_PER_ID&OAPB=FII_HR_BRAND_TEXT';

Line 1235: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

1231: || 'AND tch.direct_record_ind = 0';
1232: END IF;
1233:
1234: /* get security clause for Manager based security */
1235: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
1236:
1237: l_orderby_clause := '&ORDER_BY_CLAUSE';
1238:
1239: x_custom_sql := l_select_clause || g_rtn

Line 1280: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec

1276: p_parameter_rec => l_parameter_rec,
1277: p_bind_tab => l_bind_tab);
1278:
1279: /* Activite Drill URL for Link to HR Employee Directory */
1280: l_lnk_profile_chk := hri_oltp_pmv_util_pkg.chk_emp_dir_lnk(p_parameter_rec => l_parameter_rec
1281: ,p_bind_tab => l_bind_tab);
1282:
1283: IF (l_lnk_profile_chk = 1 AND l_parameter_rec.time_curr_end_date = TRUNC(SYSDATE)) THEN
1284: l_lnk_emp_name := 'pFunctionName=HR_EMPDIR_EMPDTL_PROXY_SS&pId=HRI_P_PER_ID&OAPB=FII_HR_BRAND_TEXT';

Line 1373: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

1369: || 'AND tch.direct_record_ind = 0';
1370: END IF;
1371:
1372: /* get security clause for Manager based security */
1373: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
1374:
1375: l_orderby_clause := '&ORDER_BY_CLAUSE';
1376:
1377: x_custom_sql := l_select_clause || g_rtn