APPS.HRI_OLTP_PMV_WMV_SAL_SUP_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 16: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

12: --****************************************************************************
13: --
14: PROCEDURE get_sql_ctr2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
15: ,x_custom_sql OUT NOCOPY VARCHAR2
16: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
17: IS
18:
19: l_SQLText VARCHAR2(32000);
20: l_security_clause VARCHAR2(4000);

Line 38: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

34:
35: BEGIN
36: /* Initialize out parameters */
37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
38: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
39:
40: /* Get security clause for Manager based security */
41: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
42:

Line 172: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

168: --****************************************************************************
169: --
170: PROCEDURE get_sql_rgn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
171: ,x_custom_sql OUT NOCOPY VARCHAR2
172: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
173: IS
174:
175: l_SQLText VARCHAR2(32000);
176: l_security_clause VARCHAR2(4000);

Line 195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

191:
192: BEGIN
193: /* Initialize out parameters */
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
196:
197: /* Get security clause for Manager based security */
198: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
199:

Line 330: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

326: --****************************************************************************
327: --
328: PROCEDURE get_sql_cit2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
329: ,x_custom_sql OUT NOCOPY VARCHAR2
330: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
331: )
332: IS
333:
334: l_SQLText VARCHAR2(32000);

Line 355: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

351:
352: BEGIN
353: /* Initialize out parameters */
354: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
355: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
356:
357: /* Get security clause for Manager based security */
358: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
359:

Line 510: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

506: --****************************************************************************
507: --
508: PROCEDURE get_sql_jfm2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
509: x_custom_sql OUT NOCOPY VARCHAR2,
510: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
511:
512: l_sqltext VARCHAR2(32767) ;
513: l_security_clause VARCHAR2(4000);
514: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 530: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

526: BEGIN
527:
528: /* Initialize out parameters */
529: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
530: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
531:
532: /* Get security clause for Manager based security */
533: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
534:

Line 654: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

650: --****************************************************************************
651: --
652: PROCEDURE get_sql_jfmfn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
653: x_custom_sql OUT NOCOPY VARCHAR2,
654: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
655:
656: l_sqltext VARCHAR2(32767) ;
657: l_security_clause VARCHAR2(4000);
658: l_job_family_condition VARCHAR2(100);

Line 678: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

674: BEGIN
675:
676: /* Initialize out parameters */
677: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
678: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
679:
680: /* Get security clause for Manager based security */
681: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
682: