DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_GAIN_HIRE_SUPJOB dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: hriopgh.pkb 120.2 2005/07/20 02:08:16 cbridge noship $ */
3: --
4: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5: x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_sql_text VARCHAR2(32000);
9: l_security_clause VARCHAR2(4000);
10: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 10: l_custom_rec BIS_QUERY_ATTRIBUTES;

6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_sql_text VARCHAR2(32000);
9: l_security_clause VARCHAR2(4000);
10: l_custom_rec BIS_QUERY_ATTRIBUTES;
11:
12: /* Parameter values */
13: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
14: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

16: BEGIN
17:
18: /* Initialize out parameters */
19: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
20: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
21:
22: /* Get common parameter values */
23: hri_oltp_pmv_util_param.get_parameters_from_table
24: (p_page_parameter_tbl => p_page_parameter_tbl,