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.RCI_OPEN_REMED_SUMM_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 32: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

28:
29: PROCEDURE get_kpi(
30: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
31: ,p_exp_source_sql out NOCOPY VARCHAR2
32: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
33: is
34: l_sqlstmt VARCHAR2(15000);
35: counter NUMBER := 0;
36: where_clause VARCHAR2(4000) := ' ';

Line 133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

129:
130: p_exp_source_sql := l_sqlstmt;
131:
132: /**04.21.2006 npanandi: adding code for dynamic binding of time period dimensions**/
133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135:
136: p_exp_source_output.EXTEND;
137: l_bind_rec.attribute_name := ':WFTIME';

Line 172: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

168: */
169: PROCEDURE get_open_remediation_result(
170: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
171: ,p_exp_source_sql out NOCOPY VARCHAR2
172: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
173: is
174: counter NUMBER := 0;
175: l_sqlstmt VARCHAR2(15000);
176: l_act_sqlstmt varchar2(15000);

Line 414: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

410: --todo remove the status_code condition
411: p_exp_source_sql := l_act_sqlstmt;
412:
413: /**04.25.2006 npanandi: adding code for dynamic binding of time period dimensions**/
414: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
415: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
416:
417: p_exp_source_output.EXTEND;
418: l_bind_rec.attribute_name := ':WFTIME';

Line 451: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

447:
448: PROCEDURE get_findings_details(
449: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
450: ,p_exp_source_sql out NOCOPY VARCHAR2
451: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
452: is
453: counter NUMBER := 0;
454: l_sqlstmt VARCHAR2(15000);
455: where_clause VARCHAR2(2000) := ' ';

Line 584: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

580: ;
581: p_exp_source_sql := l_sqlstmt;
582:
583: /**04.25.2006 npanandi: adding code for dynamic binding of time period dimensions**/
584: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
585: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
586:
587: p_exp_source_output.EXTEND;
588: l_bind_rec.attribute_name := ':TIME';

Line 600: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

596:
597: PROCEDURE get_remediations_details(
598: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
599: ,p_exp_source_sql out NOCOPY VARCHAR2
600: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
601: is
602: counter NUMBER := 0;
603: l_sqlstmt VARCHAR2(15000);
604: where_clause VARCHAR2(2000) := ' ';

Line 740: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();

736:
737: p_exp_source_sql := l_sqlstmt;
738:
739: /**04.25.2006 npanandi: adding code for dynamic binding of time period dimensions**/
740: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
741: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
742:
743: p_exp_source_output.EXTEND;
744: l_bind_rec.attribute_name := ':TIME';