DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_CTR dependencies on BIS_QUERY_ATTRIBUTES

Line 10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

6:
7: PROCEDURE GET_SQL_CTR_T4
8: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
11:
12: l_sqltext VARCHAR2(32767);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14: l_security_clause VARCHAR2(4000);

Line 13: l_custom_rec BIS_QUERY_ATTRIBUTES;

9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
11:
12: l_sqltext VARCHAR2(32767);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14: l_security_clause VARCHAR2(4000);
15:
16: -- Parameter values
17: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 34: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

30: BEGIN
31:
32: /* Initialize out parameters */
33: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
34: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
35:
36: /* Get common parameter values */
37: hri_oltp_pmv_util_param.get_parameters_from_table
38: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 182: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

178:
179: PROCEDURE GET_SQL_RNK_CTR
180: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
181: x_custom_sql OUT NOCOPY VARCHAR2,
182: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
183:
184: l_SQLText VARCHAR2(32767) ;
185: l_custom_rec BIS_QUERY_ATTRIBUTES;
186: l_security_clause VARCHAR2(5000);

Line 185: l_custom_rec BIS_QUERY_ATTRIBUTES;

181: x_custom_sql OUT NOCOPY VARCHAR2,
182: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
183:
184: l_SQLText VARCHAR2(32767) ;
185: l_custom_rec BIS_QUERY_ATTRIBUTES;
186: l_security_clause VARCHAR2(5000);
187:
188: /* Parameter values */
189: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 215: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

211: BEGIN
212:
213: /* Initialize out parameters */
214: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
215: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
216:
217: /* Get common parameter values */
218: hri_oltp_pmv_util_param.get_parameters_from_table
219: (p_page_parameter_tbl => p_page_parameter_tbl,