APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 39: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

35: l_col_curr_tot_trn_hdc VARCHAR2(100);
36: l_col_comp_tot_trn_hdc VARCHAR2(100);
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:

Line 127: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

123: l_wrkfc_fact_params.bind_format := 'PMV';
124: l_wrkfc_fact_params.include_comp := 'Y';
125: l_wrkfc_fact_params.include_start := 'Y';
126: l_wrkfc_fact_params.include_hdc := 'Y';
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.GET_SQL2');

Line 346: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

342: l_col_curr_tot_trn_hdc VARCHAR2(100);
343: l_col_comp_tot_trn_hdc VARCHAR2(100);
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:

Line 436: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

432: /* Get SQL for workforce fact */
433: l_wrkfc_fact_params.bind_format := 'PMV';
434: l_wrkfc_fact_params.include_start := 'Y';
435: l_wrkfc_fact_params.include_hdc := 'Y';
436: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
437: (p_parameter_rec => l_parameter_rec,
438: p_bind_tab => l_bind_tab,
439: p_wrkfc_params => l_wrkfc_fact_params,
440: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP.GET_ACTUAL_DETAIL_SQL2');

Line 613: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

609: l_view_by_filter VARCHAR2(1000);
610: l_outer_join VARCHAR2(30);
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:

Line 718: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

714:
715: /* Get SQL for workforce fact */
716: l_wrkfc_fact_params.bind_format := 'PMV';
717: l_wrkfc_fact_params.include_hdc := 'Y';
718: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
719: (p_parameter_rec => l_parameter_rec,
720: p_bind_tab => l_bind_tab,
721: p_wrkfc_params => l_wrkfc_fact_params,
722: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP.GET_SQL_PVT');

Line 1014: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;

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;
1015: --
1016:
1017: l_curr_hdc_end_col VARCHAR2(100);
1018: l_comp_hdc_end_col VARCHAR2(100);