eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OLTP_PMV_WMV_SAL_SUP_PVT dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 24: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

20: l_security_clause VARCHAR2(4000);
21: l_custom_rec BIS_QUERY_ATTRIBUTES ;
22:
23: /* Dynamic SQL Controls */
24: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
25: l_wrkfc_fact_sql VARCHAR2(10000);
26:
27: /* Pre-calculations */
28: l_drill_url VARCHAR2(1000);

Line 69: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

65: l_wrkfc_fact_params.bind_format := 'PMV';
66: l_wrkfc_fact_params.include_comp := 'Y';
67: l_wrkfc_fact_params.include_hdc := 'Y';
68: l_wrkfc_fact_params.include_sal := 'Y';
69: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
70: (p_parameter_rec => l_parameter_rec,
71: p_bind_tab => l_bind_tab,
72: p_wrkfc_params => l_wrkfc_fact_params,
73: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_PVT.GET_SQL_CTR2');

Line 180: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

176: l_security_clause VARCHAR2(4000);
177: l_custom_rec BIS_QUERY_ATTRIBUTES ;
178:
179: /* Dynamic SQL Controls */
180: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
181: l_wrkfc_fact_sql VARCHAR2(10000);
182:
183: /* Pre-calculations */
184: l_drill_url VARCHAR2(1000);

Line 225: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

221: l_wrkfc_fact_params.bind_format := 'PMV';
222: l_wrkfc_fact_params.include_comp := 'Y';
223: l_wrkfc_fact_params.include_hdc := 'Y';
224: l_wrkfc_fact_params.include_sal := 'Y';
225: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
226: (p_parameter_rec => l_parameter_rec,
227: p_bind_tab => l_bind_tab,
228: p_wrkfc_params => l_wrkfc_fact_params,
229: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_PVT.GET_SQL_RGN2');

Line 339: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

335: l_security_clause VARCHAR2(4000);
336: l_custom_rec BIS_QUERY_ATTRIBUTES ;
337:
338: /* Dynamic SQL Controls */
339: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
340: l_wrkfc_fact_sql VARCHAR2(10000);
341:
342: /* Pre-calculations */
343: l_drill_url VARCHAR2(1000);

Line 395: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

391: l_wrkfc_fact_params.bind_format := 'PMV';
392: l_wrkfc_fact_params.include_comp := 'Y';
393: l_wrkfc_fact_params.include_hdc := 'Y';
394: l_wrkfc_fact_params.include_sal := 'Y';
395: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
396: (p_parameter_rec => l_parameter_rec,
397: p_bind_tab => l_bind_tab,
398: p_wrkfc_params => l_wrkfc_fact_params,
399: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_PVT.GET_SQL_CIT2');

Line 521: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

517: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
518: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
519:
520: /* Dynamic SQL Controls */
521: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
522: l_wrkfc_fact_sql VARCHAR2(10000);
523:
524: /* Pre-calculations */
525:

Line 549: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

545: l_wrkfc_fact_params.bind_format := 'PMV';
546: l_wrkfc_fact_params.include_comp := 'Y';
547: l_wrkfc_fact_params.include_hdc := 'Y';
548: l_wrkfc_fact_params.include_sal := 'Y';
549: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
550: (p_parameter_rec => l_parameter_rec,
551: p_bind_tab => l_bind_tab,
552: p_wrkfc_params => l_wrkfc_fact_params,
553: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_PVT.GET_SQL_JFM2');

Line 667: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

663: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
664: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
665:
666: /* Dynamic SQL Controls */
667: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
668: l_wrkfc_fact_sql VARCHAR2(10000);
669:
670: /* Pre-calculations */
671:

Line 711: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

707: l_wrkfc_fact_params.bind_format := 'PMV';
708: l_wrkfc_fact_params.include_comp := 'Y';
709: l_wrkfc_fact_params.include_hdc := 'Y';
710: l_wrkfc_fact_params.include_sal := 'Y';
711: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
712: (p_parameter_rec => l_parameter_rec,
713: p_bind_tab => l_bind_tab,
714: p_wrkfc_params => l_wrkfc_fact_params,
715: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_PVT.GET_SQL_JFMFN2');