eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OLTP_PMV_WMV_SAL_SUP_PVT dependencies on BIS_QUERY_ATTRIBUTES

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 21: l_custom_rec BIS_QUERY_ATTRIBUTES ;

17: IS
18:
19: l_SQLText VARCHAR2(32000);
20: l_security_clause VARCHAR2(4000);
21: l_custom_rec BIS_QUERY_ATTRIBUTES ;
22:
23: /* Dynamic SQL Controls */
24: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
25: l_wrkfc_fact_sql VARCHAR2(10000);

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 177: l_custom_rec BIS_QUERY_ATTRIBUTES ;

173: IS
174:
175: l_SQLText VARCHAR2(32000);
176: l_security_clause VARCHAR2(4000);
177: l_custom_rec BIS_QUERY_ATTRIBUTES ;
178:
179: /* Dynamic SQL Controls */
180: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
181: l_wrkfc_fact_sql VARCHAR2(10000);

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 336: l_custom_rec BIS_QUERY_ATTRIBUTES ;

332: IS
333:
334: l_SQLText VARCHAR2(32000);
335: l_security_clause VARCHAR2(4000);
336: l_custom_rec BIS_QUERY_ATTRIBUTES ;
337:
338: /* Dynamic SQL Controls */
339: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
340: l_wrkfc_fact_sql VARCHAR2(10000);

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 514: l_custom_rec BIS_QUERY_ATTRIBUTES;

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;
515:
516: /* Parameter values */
517: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
518: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

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 660: l_custom_rec BIS_QUERY_ATTRIBUTES;

656: l_sqltext VARCHAR2(32767) ;
657: l_security_clause VARCHAR2(4000);
658: l_job_family_condition VARCHAR2(100);
659:
660: l_custom_rec BIS_QUERY_ATTRIBUTES;
661:
662: /* Parameter values */
663: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
664: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

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: