APPS.HRI_OLTP_PMV_WMV_SAL_CTR_SUP dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 30: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

26: /* translation values */
27: l_others_string VARCHAR2(80);
28:
29: /* Dynamic SQL controls */
30: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
31: l_wrkfc_fact_sql VARCHAR2(10000);
32:
33: BEGIN
34: /* Initialize out parameters */

Line 66: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

62: l_wrkfc_fact_params.bind_format := 'PMV';
63: l_wrkfc_fact_params.include_comp := 'Y';
64: l_wrkfc_fact_params.include_hdc := 'Y';
65: l_wrkfc_fact_params.include_sal := 'Y';
66: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
67: (p_parameter_rec => l_parameter_rec,
68: p_bind_tab => l_bind_tab,
69: p_wrkfc_params => l_wrkfc_fact_params,
70: p_calling_module => 'HRI_OLTP_PMV_WMV_SAL_CTR_SUP.GET_SQL2');