APPS.HRI_OLTP_PMV_WMV_TRN_SUP_BCKT dependencies on HRI_OLTP_PMV_WMV_TRN_SUP_BCKT

Line 1: PACKAGE BODY hri_oltp_pmv_wmv_trn_sup_bckt AS

1: PACKAGE BODY hri_oltp_pmv_wmv_trn_sup_bckt AS
2: /* $Header: hrioptrp.pkb 120.3 2005/10/26 07:54:05 jrstewar noship $ */
3:
4: g_rtn VARCHAR2(5) := '
5: ';

Line 131: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_PERF');

127: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
128: (p_parameter_rec => l_parameter_rec,
129: p_bind_tab => l_bind_tab,
130: p_wrkfc_params => l_wrkfc_fact_params,
131: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_PERF');
132:
133: /* Get SQL for workforce changes fact */
134: l_wcnt_chg_fact_params.bind_format := 'PMV';
135: l_wcnt_chg_fact_params.include_comp := 'Y';

Line 142: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_PERF');

138: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
139: (p_parameter_rec => l_parameter_rec,
140: p_bind_tab => l_bind_tab,
141: p_wcnt_chg_params => l_wcnt_chg_fact_params,
142: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_PERF');
143:
144: /* Set the display row conditions */
145: IF (l_parameter_rec.view_by = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X' OR
146: l_parameter_rec.view_by = 'HRI_WRKACTVT+HRI_WAC_SEPCAT_X' OR

Line 547: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_LOW');

543: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
544: (p_parameter_rec => l_parameter_rec,
545: p_bind_tab => l_bind_tab,
546: p_wrkfc_params => l_wrkfc_fact_params,
547: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_LOW');
548:
549: /* Get SQL for workforce changes fact */
550: l_wcnt_chg_fact_params.bind_format := 'PMV';
551: l_wcnt_chg_fact_params.include_sep := 'Y';

Line 557: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_LOW');

553: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
554: (p_parameter_rec => l_parameter_rec,
555: p_bind_tab => l_bind_tab,
556: p_wcnt_chg_params => l_wcnt_chg_fact_params,
557: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_LOW');
558:
559: /* Set drill URLs for constant drills */
560: l_drill_trn_bn1_dtl := 'pFunctionName=HRI_P_WMV_TRN_SUP_DTL&' ||
561: 'VIEW_BY_NAME=VIEW_BY_ID&' ||

Line 887: p_calling_module => 'hri_oltp_pmv_wmv_trn_sup_bckt.get_trn_perf_kpi');

883: l_inn_sql := HRI_OLTP_PMV_QUERY_WCNT_CHG.get_sql
884: (p_parameter_rec => l_parameter_rec,
885: p_bind_tab => l_bind_tab,
886: p_wcnt_chg_params => l_wcnt_chg_params,
887: p_calling_module => 'hri_oltp_pmv_wmv_trn_sup_bckt.get_trn_perf_kpi');
888: --
889: -- Form the SQL
890: --
891: x_custom_sql :=

Line 934: END hri_oltp_pmv_wmv_trn_sup_bckt;

930: ' || l_security_clause;
931: --
932: END get_trn_perf_kpi;
933:
934: END hri_oltp_pmv_wmv_trn_sup_bckt;