DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_GAIN_HIRE_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

4: -- New-arch detail query
5: --
6: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
7: x_custom_sql OUT NOCOPY VARCHAR2,
8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
9:
10: l_sql_text VARCHAR2(32000);
11: l_security_clause VARCHAR2(4000);
12: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 12: l_custom_rec BIS_QUERY_ATTRIBUTES;

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

Line 22: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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