APPS.HRI_OLTP_PMV_DTL_SALARY dependencies on BIS_QUERY_ATTRIBUTES

Line 19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

15: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
16: p_lnk_emp_name IN VARCHAR2,
17: p_lnk_mgr_name IN VARCHAR2,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
20:
21: /* Variable to return SQL query for report */
22: l_sqltext VARCHAR2(32000);
23: l_params_header VARCHAR2(10000);

Line 27: l_custom_rec BIS_QUERY_ATTRIBUTES;

23: l_params_header VARCHAR2(10000);
24: l_lnk_profile_chk VARCHAR2(4000);
25:
26: /* Table of custom parameters */
27: l_custom_rec BIS_QUERY_ATTRIBUTES;
28:
29: /* Security clause */
30: l_security_clause VARCHAR2(1000);
31:

Line 44: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

40: BEGIN
41:
42: /* Initialize table/record variables */
43: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
44: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
45:
46: /* Set drill URLS */
47: l_lnk_emp_name := p_lnk_emp_name;
48: l_lnk_mgr_name := p_lnk_mgr_name;

Line 237: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

233: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
234: p_lnk_emp_name IN VARCHAR2,
235: p_lnk_mgr_name IN VARCHAR2,
236: x_custom_sql OUT NOCOPY VARCHAR2,
237: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
238:
239: /* Variable to return SQL query for report */
240: l_sqltext VARCHAR2(32000);
241: l_params_header VARCHAR2(10000);

Line 245: l_custom_rec BIS_QUERY_ATTRIBUTES;

241: l_params_header VARCHAR2(10000);
242: l_lnk_profile_chk VARCHAR2(4000);
243:
244: /* Table of custom parameters */
245: l_custom_rec BIS_QUERY_ATTRIBUTES;
246:
247: /* Security clause */
248: l_security_clause VARCHAR2(1000);
249:

Line 261: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

257: BEGIN
258:
259: /* Initialize table/record variables */
260: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
261: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
262:
263: /* Set drill URLS */
264: l_lnk_emp_name := p_lnk_emp_name;
265: l_lnk_mgr_name := p_lnk_mgr_name;

Line 418: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

414: /* Worker Detail report */
415: /******************************************************************************/
416: PROCEDURE GET_SALARY_DETAIL2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
417: x_custom_sql OUT NOCOPY VARCHAR2,
418: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
419:
420:
421: /* Parameter values */
422: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 482: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

478: /******************************************************************************/
479: PROCEDURE get_hr_detail
480: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
481: x_custom_sql OUT NOCOPY VARCHAR2,
482: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
483:
484: /* Variable to return SQL query for report */
485: l_sqltext VARCHAR2(32000);
486: l_params_header VARCHAR2(10000);

Line 490: l_custom_rec BIS_QUERY_ATTRIBUTES;

486: l_params_header VARCHAR2(10000);
487: l_lnk_profile_chk VARCHAR2(4000);
488:
489: /* Table of custom parameters */
490: l_custom_rec BIS_QUERY_ATTRIBUTES;
491:
492: /* Parameter values */
493: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
494: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 510: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

506: BEGIN
507:
508: /* Initialize table/record variables */
509: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
510: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
511:
512: /* Get common parameter values */
513: hri_oltp_pmv_util_param.get_parameters_from_table
514: (p_page_parameter_tbl => p_page_parameter_tbl,