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_PMV_PARAMETERS_PUB

Line 134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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';
138: l_bind_rec.attribute_value := v_period;

Line 139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

135:
136: p_exp_source_output.EXTEND;
137: l_bind_rec.attribute_name := ':WFTIME';
138: l_bind_rec.attribute_value := v_period;
139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
141: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
142:
143: p_exp_source_output.EXTEND;

Line 140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

136: p_exp_source_output.EXTEND;
137: l_bind_rec.attribute_name := ':WFTIME';
138: l_bind_rec.attribute_value := v_period;
139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
141: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
142:
143: p_exp_source_output.EXTEND;
144: l_bind_rec.attribute_name := ':WRTIME';

Line 146: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

142:
143: p_exp_source_output.EXTEND;
144: l_bind_rec.attribute_name := ':WRTIME';
145: l_bind_rec.attribute_value := v_period;
146: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
147: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
148: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
149:
150: p_exp_source_output.EXTEND;

Line 147: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

143: p_exp_source_output.EXTEND;
144: l_bind_rec.attribute_name := ':WRTIME';
145: l_bind_rec.attribute_value := v_period;
146: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
147: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
148: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
149:
150: p_exp_source_output.EXTEND;
151: l_bind_rec.attribute_name := ':FWTIME';

Line 153: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

149:
150: p_exp_source_output.EXTEND;
151: l_bind_rec.attribute_name := ':FWTIME';
152: l_bind_rec.attribute_value := v_period;
153: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
154: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
155: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
156:
157: p_exp_source_output.EXTEND;

Line 154: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

150: p_exp_source_output.EXTEND;
151: l_bind_rec.attribute_name := ':FWTIME';
152: l_bind_rec.attribute_value := v_period;
153: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
154: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
155: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
156:
157: p_exp_source_output.EXTEND;
158: l_bind_rec.attribute_name := ':RWTIME';

Line 160: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

156:
157: p_exp_source_output.EXTEND;
158: l_bind_rec.attribute_name := ':RWTIME';
159: l_bind_rec.attribute_value := v_period;
160: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
161: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
162: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
163: /**04.21.2006 npanandi: finished code for dynamic binding of time period dimensions**/
164: END get_kpi;

Line 161: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

157: p_exp_source_output.EXTEND;
158: l_bind_rec.attribute_name := ':RWTIME';
159: l_bind_rec.attribute_value := v_period;
160: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
161: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
162: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
163: /**04.21.2006 npanandi: finished code for dynamic binding of time period dimensions**/
164: END get_kpi;
165:

Line 415: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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';
419: l_bind_rec.attribute_value := v_period;

Line 420: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

416:
417: p_exp_source_output.EXTEND;
418: l_bind_rec.attribute_name := ':WFTIME';
419: l_bind_rec.attribute_value := v_period;
420: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
421: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
422: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
423:
424: p_exp_source_output.EXTEND;

Line 421: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

417: p_exp_source_output.EXTEND;
418: l_bind_rec.attribute_name := ':WFTIME';
419: l_bind_rec.attribute_value := v_period;
420: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
421: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
422: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
423:
424: p_exp_source_output.EXTEND;
425: l_bind_rec.attribute_name := ':WRTIME';

Line 427: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

423:
424: p_exp_source_output.EXTEND;
425: l_bind_rec.attribute_name := ':WRTIME';
426: l_bind_rec.attribute_value := v_period;
427: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
428: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
429: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
430:
431: p_exp_source_output.EXTEND;

Line 428: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

424: p_exp_source_output.EXTEND;
425: l_bind_rec.attribute_name := ':WRTIME';
426: l_bind_rec.attribute_value := v_period;
427: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
428: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
429: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
430:
431: p_exp_source_output.EXTEND;
432: l_bind_rec.attribute_name := ':FWTIME';

Line 434: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

430:
431: p_exp_source_output.EXTEND;
432: l_bind_rec.attribute_name := ':FWTIME';
433: l_bind_rec.attribute_value := v_period;
434: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
435: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
436: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
437:
438: p_exp_source_output.EXTEND;

Line 435: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

431: p_exp_source_output.EXTEND;
432: l_bind_rec.attribute_name := ':FWTIME';
433: l_bind_rec.attribute_value := v_period;
434: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
435: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
436: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
437:
438: p_exp_source_output.EXTEND;
439: l_bind_rec.attribute_name := ':RWTIME';

Line 441: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

437:
438: p_exp_source_output.EXTEND;
439: l_bind_rec.attribute_name := ':RWTIME';
440: l_bind_rec.attribute_value := v_period;
441: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
442: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
443: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
444: /**04.25.2006 npanandi: finished code for dynamic binding of time period dimensions**/
445:

Line 442: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

438: p_exp_source_output.EXTEND;
439: l_bind_rec.attribute_name := ':RWTIME';
440: l_bind_rec.attribute_value := v_period;
441: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
442: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
443: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
444: /**04.25.2006 npanandi: finished code for dynamic binding of time period dimensions**/
445:
446: END get_open_remediation_result;

Line 585: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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';
589: l_bind_rec.attribute_value := v_period;

Line 590: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

586:
587: p_exp_source_output.EXTEND;
588: l_bind_rec.attribute_name := ':TIME';
589: l_bind_rec.attribute_value := v_period;
590: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
591: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
592: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
593: /**04.25.2006 npanandi: finished code for dynamic binding of time period dimensions**/
594:

Line 591: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

587: p_exp_source_output.EXTEND;
588: l_bind_rec.attribute_name := ':TIME';
589: l_bind_rec.attribute_value := v_period;
590: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
591: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
592: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
593: /**04.25.2006 npanandi: finished code for dynamic binding of time period dimensions**/
594:
595: END get_findings_details;

Line 741: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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';
745: l_bind_rec.attribute_value := v_period;

Line 746: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

742:
743: p_exp_source_output.EXTEND;
744: l_bind_rec.attribute_name := ':TIME';
745: l_bind_rec.attribute_value := v_period;
746: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
747: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
748: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
749: /**04.25.2006 npanandi: finished code for dynamic binding of time period dimensions**/
750:

Line 747: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

743: p_exp_source_output.EXTEND;
744: l_bind_rec.attribute_name := ':TIME';
745: l_bind_rec.attribute_value := v_period;
746: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
747: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
748: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
749: /**04.25.2006 npanandi: finished code for dynamic binding of time period dimensions**/
750:
751: