APPS.HRI_OLTP_PMV_WMV_SAL_SUP_PVT dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 31: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

27: /* Pre-calculations */
28: l_drill_url VARCHAR2(1000);
29:
30: /* Parameter values */
31: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
32: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
33: l_debug_header VARCHAR(550);
34:
35: BEGIN

Line 32: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

28: l_drill_url VARCHAR2(1000);
29:
30: /* Parameter values */
31: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
32: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
33: l_debug_header VARCHAR(550);
34:
35: BEGIN
36: /* Initialize out parameters */

Line 44: hri_oltp_pmv_util_param.get_parameters_from_table

40: /* Get security clause for Manager based security */
41: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
42:
43: /* Get common parameter values */
44: hri_oltp_pmv_util_param.get_parameters_from_table
45: (p_page_parameter_tbl => p_page_parameter_tbl,
46: p_parameter_rec => l_parameter_rec,
47: p_bind_tab => l_bind_tab);
48:

Line 188: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

184: l_drill_url VARCHAR2(1000);
185: l_country_code VARCHAR2(1000);
186:
187: /* Parameter values */
188: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
189: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
190: l_debug_header VARCHAR(550);
191:
192: BEGIN

Line 189: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

185: l_country_code VARCHAR2(1000);
186:
187: /* Parameter values */
188: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
189: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
190: l_debug_header VARCHAR(550);
191:
192: BEGIN
193: /* Initialize out parameters */

Line 201: hri_oltp_pmv_util_param.get_parameters_from_table

197: /* Get security clause for Manager based security */
198: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
199:
200: /* Get common parameter values */
201: hri_oltp_pmv_util_param.get_parameters_from_table
202: (p_page_parameter_tbl => p_page_parameter_tbl,
203: p_parameter_rec => l_parameter_rec,
204: p_bind_tab => l_bind_tab);
205:

Line 346: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

342: /* Pre-calculations */
343: l_drill_url VARCHAR2(1000);
344:
345: /* Parameter values */
346: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
347: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
348: l_debug_header VARCHAR(550);
349: l_country_code VARCHAR2(240);
350: l_region_code VARCHAR(240);

Line 347: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

343: l_drill_url VARCHAR2(1000);
344:
345: /* Parameter values */
346: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
347: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
348: l_debug_header VARCHAR(550);
349: l_country_code VARCHAR2(240);
350: l_region_code VARCHAR(240);
351:

Line 361: hri_oltp_pmv_util_param.get_parameters_from_table

357: /* Get security clause for Manager based security */
358: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
359:
360: /* Get common parameter values */
361: hri_oltp_pmv_util_param.get_parameters_from_table
362: (p_page_parameter_tbl => p_page_parameter_tbl,
363: p_parameter_rec => l_parameter_rec,
364: p_bind_tab => l_bind_tab);
365:

Line 517: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

513: l_security_clause VARCHAR2(4000);
514: l_custom_rec BIS_QUERY_ATTRIBUTES;
515:
516: /* Parameter values */
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;

Line 518: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

514: l_custom_rec BIS_QUERY_ATTRIBUTES;
515:
516: /* Parameter values */
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);

Line 536: hri_oltp_pmv_util_param.get_parameters_from_table

532: /* Get security clause for Manager based security */
533: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
534:
535: /* Get common parameter values */
536: hri_oltp_pmv_util_param.get_parameters_from_table
537: (p_page_parameter_tbl => p_page_parameter_tbl,
538: p_parameter_rec => l_parameter_rec,
539: p_bind_tab => l_bind_tab);
540:

Line 663: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

659:
660: l_custom_rec BIS_QUERY_ATTRIBUTES;
661:
662: /* Parameter values */
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;

Line 664: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

660: l_custom_rec BIS_QUERY_ATTRIBUTES;
661:
662: /* Parameter values */
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);

Line 684: hri_oltp_pmv_util_param.get_parameters_from_table

680: /* Get security clause for Manager based security */
681: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
682:
683: /* Get common parameter values */
684: hri_oltp_pmv_util_param.get_parameters_from_table
685: (p_page_parameter_tbl => p_page_parameter_tbl,
686: p_parameter_rec => l_parameter_rec,
687: p_bind_tab => l_bind_tab);
688: