APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on HRI_BPL_FACT_SUP_WCNT_CHG_SQL

Line 41: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

37:
38: /* Dynamic SQL Controls */
39: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
40: l_wrkfc_fact_sql VARCHAR2(10000);
41: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
42: l_wcnt_chg_fact_sql VARCHAR2(10000);
43:
44: /* Messages */
45: l_direct_reports_string VARCHAR2(100);

Line 139: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

135: l_wcnt_chg_fact_params.include_comp := 'Y';
136: l_wcnt_chg_fact_params.include_sep := 'Y';
137: l_wcnt_chg_fact_params.include_sep_vol := 'Y';
138: l_wcnt_chg_fact_params.include_sep_inv := 'Y';
139: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
140: (p_parameter_rec => l_parameter_rec,
141: p_bind_tab => l_bind_tab,
142: p_wcnt_chg_params => l_wcnt_chg_fact_params,
143: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP.GET_SQL2');

Line 348: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

344:
345: /* Dynamic SQL Controls */
346: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
347: l_wrkfc_fact_sql VARCHAR2(10000);
348: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
349: l_wcnt_chg_fact_sql VARCHAR2(10000);
350:
351: /* Messages */
352: l_direct_reports_string VARCHAR2(100);

Line 447: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

443: l_wcnt_chg_fact_params.bind_format := 'PMV';
444: l_wcnt_chg_fact_params.include_sep := 'Y';
445: l_wcnt_chg_fact_params.include_sep_vol := 'Y';
446: l_wcnt_chg_fact_params.include_sep_inv := 'Y';
447: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
448: (p_parameter_rec => l_parameter_rec,
449: p_bind_tab => l_bind_tab,
450: p_wcnt_chg_params => l_wcnt_chg_fact_params,
451: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP.GET_ACTUAL_DETAIL_SQL2');

Line 615: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

611:
612: /* Dynamic SQL Controls */
613: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
614: l_wrkfc_fact_sql VARCHAR2(10000);
615: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
616: l_wcnt_chg_fact_sql VARCHAR2(10000);
617:
618: /* Messages */
619: l_direct_reports_string VARCHAR2(100);

Line 704: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

700: /* Get SQL for workforce changes fact */
701: l_wcnt_chg_fact_params.bind_format := 'PMV';
702: l_wcnt_chg_fact_params.include_comp := 'Y';
703: l_wcnt_chg_fact_params.include_sep := 'Y';
704: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
705: (p_parameter_rec => l_parameter_rec,
706: p_bind_tab => l_bind_tab,
707: p_wcnt_chg_params => l_wcnt_chg_fact_params,
708: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP.GET_SQL_PVT');

Line 909: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.WCNT_CHG_FACT_PARAM_TYPE;

905: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
906: --
907: -- Parameter values for getting the inner SQL
908: --
909: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.WCNT_CHG_FACT_PARAM_TYPE;
910: --
911:
912: BEGIN
913: --

Line 1010: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.WCNT_CHG_FACT_PARAM_TYPE;

1006: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
1007: --
1008: -- Parameter values for getting the inner SQL for termination
1009: --
1010: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.WCNT_CHG_FACT_PARAM_TYPE;
1011: --
1012: -- Parameter values for getting the inner SQL for headcount
1013: --
1014: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;