DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 153: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

149: /* Dynamic SQL support */
150: l_dynsql_rec dynamic_sql_rec_type;
151:
152: /* Dynamic SQL Controls */
153: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
154: l_wrkfc_fact_sql VARCHAR2(10000);
155: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
156: l_wcnt_chg_fact_sql VARCHAR2(10000);
157:

Line 262: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

258: l_wrkfc_fact_params.bucket_dim := '';
259: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
260: l_wrkfc_fact_params.include_start := 'Y';
261: END IF;
262: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
263: (p_parameter_rec => l_parameter_rec,
264: p_bind_tab => l_bind_tab,
265: p_wrkfc_params => l_wrkfc_fact_params,
266: p_calling_module => 'HRI_OLTP_PMV_WRKFC_TRN_SUMMARY.GET_SQL_PVT');