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.POA_DBI_PQC_PKG dependencies on POA_DBI_SUTIL_PKG

Line 51: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

47: BEGIN
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
50:
51: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
52: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
53: poa_dbi_sutil_pkg.process_parameters(
54: p_param => p_param,
55: p_view_by => l_view_by,

Line 53: poa_dbi_sutil_pkg.process_parameters(

49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
50:
51: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
52: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
53: poa_dbi_sutil_pkg.process_parameters(
54: p_param => p_param,
55: p_view_by => l_view_by,
56: p_view_by_col_name => l_view_by_col,
57: p_view_by_value => l_view_by_value,

Line 113: poa_dbi_sutil_pkg.process_parameters(

109: p_use_grpid => 'N',
110: p_filter_where => get_status_filter_where(l_view_by),
111: p_in_join_tables => l_in_join_tbl);
112: elsif (l_sec_context = 'COMP') then
113: poa_dbi_sutil_pkg.process_parameters(
114: p_param => p_param,
115: p_view_by => l_view_by,
116: p_view_by_col_name => l_view_by_col,
117: p_view_by_value => l_view_by_value,

Line 146: poa_dbi_sutil_pkg.process_parameters(

142: end if;
143: end loop;
144:
145: if(l_use_only_agg_mv = 'N') then
146: poa_dbi_sutil_pkg.process_parameters(
147: p_param => p_param,
148: p_view_by => l_view_by,
149: p_view_by_col_name => l_view_by_col,
150: p_view_by_value => l_view_by_value,

Line 244: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

240:
241:
242: FUNCTION get_status_filter_where(p_view_by IN VARCHAR2) return VARCHAR2
243: IS
244: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
245: BEGIN
246: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
247: l_col_tbl.extend;
248: l_col_tbl(1) := 'POA_MEASURE1';

Line 246: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

242: FUNCTION get_status_filter_where(p_view_by IN VARCHAR2) return VARCHAR2
243: IS
244: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
245: BEGIN
246: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
247: l_col_tbl.extend;
248: l_col_tbl(1) := 'POA_MEASURE1';
249: l_col_tbl.extend;
250: l_col_tbl(2) := 'POA_MEASURE2';

Line 270: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

266: l_col_tbl(9) := 'POA_MEASURE15';
267: l_col_tbl.extend;
268: l_col_tbl(10) := 'POA_MEASURE16';
269: end if;
270: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
271: END;
272:
273:
274: FUNCTION get_status_sel_clause(p_view_by_dim IN VARCHAR2

Line 282: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');

278: ,p_sec_context IN VARCHAR2) RETURN VARCHAR2
279: IS
280: l_sel_clause VARCHAR2(4000);
281: BEGIN
282: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0');
283:
284: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
285: l_sel_clause := l_sel_clause || '
286: v.description POA_ATTRIBUTE1, --Description

Line 444: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

440: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
441: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
443:
444: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
445: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
446: poa_dbi_sutil_pkg.process_parameters(
447: p_param => p_param,
448: p_view_by => l_view_by,

Line 446: poa_dbi_sutil_pkg.process_parameters(

442: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
443:
444: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
445: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
446: poa_dbi_sutil_pkg.process_parameters(
447: p_param => p_param,
448: p_view_by => l_view_by,
449: p_view_by_col_name => l_view_by_col,
450: p_view_by_value => l_view_by_value,

Line 504: poa_dbi_sutil_pkg.process_parameters(

500: p_use_grpid => 'N',
501: p_in_join_tables => l_in_join_tbl);
502:
503: elsif(l_sec_context = 'COMP') then
504: poa_dbi_sutil_pkg.process_parameters(
505: p_param => p_param,
506: p_view_by => l_view_by,
507: p_view_by_col_name => l_view_by_col,
508: p_view_by_value => l_view_by_value,

Line 547: poa_dbi_sutil_pkg.process_parameters(

543: end if;
544: end loop;
545:
546: if(l_use_only_agg_mv = 'N') then
547: poa_dbi_sutil_pkg.process_parameters(
548: p_param => p_param,
549: p_view_by => l_view_by,
550: p_view_by_col_name => l_view_by_col,
551: p_view_by_value => l_view_by_value,

Line 633: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0') ;

629: ,p_prev_sameyear IN NUMBER) RETURN VARCHAR2
630: IS
631: l_sel_clause VARCHAR2(4000);
632: BEGIN
633: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0') ;
634: l_sel_clause := l_sel_clause || '
635: oset.POA_MEASURE1 POA_MEASURE1,
636: oset.POA_MEASURE3 POA_MEASURE3,
637: oset.POA_MEASURE5 POA_MEASURE5,

Line 711: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0') ;

707: ,p_prev_sameyear IN NUMBER) RETURN VARCHAR2
708: IS
709: l_sel_clause VARCHAR2(4000);
710: BEGIN
711: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim, 'PO', '6.0') ;
712: l_sel_clause := l_sel_clause || '
713: oset.POA_MEASURE1 POA_MEASURE1,
714: oset.POA_MEASURE3 POA_MEASURE3,
715: oset.POA_MEASURE5 POA_MEASURE5,

Line 779: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

775: */
776:
777: FUNCTION get_dtl_filter_where return VARCHAR2
778: IS
779: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
780: BEGIN
781: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
782: l_col_tbl.extend;
783: l_col_tbl(1) := 'POA_MEASURE1';

Line 781: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

777: FUNCTION get_dtl_filter_where return VARCHAR2
778: IS
779: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
780: BEGIN
781: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
782: l_col_tbl.extend;
783: l_col_tbl(1) := 'POA_MEASURE1';
784: l_col_tbl.extend;
785: l_col_tbl(2) := 'POA_MEASURE3';

Line 791: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

787: l_col_tbl(3) := 'POA_MEASURE5';
788: l_col_tbl.extend;
789: l_col_tbl(4) := 'POA_MEASURE6';
790:
791: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
792:
793: END;
794:
795:

Line 812: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

808: BEGIN
809: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
810: l_filter_where := get_dtl_filter_where;
811:
812: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
813: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
814: poa_dbi_sutil_pkg.drill_process_parameters(
815: p_param,
816: l_cur_suffix,

Line 814: poa_dbi_sutil_pkg.drill_process_parameters(

810: l_filter_where := get_dtl_filter_where;
811:
812: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
813: if(l_sec_context = 'OU' or l_sec_context = 'OU/COM') then
814: poa_dbi_sutil_pkg.drill_process_parameters(
815: p_param,
816: l_cur_suffix,
817: l_where_clause,
818: l_in_join_tbl,

Line 824: poa_dbi_sutil_pkg.drill_process_parameters(

820: '6.0',
821: 'COM',
822: 'PQC');
823: else
824: poa_dbi_sutil_pkg.drill_process_parameters(
825: p_param,
826: l_cur_suffix,
827: l_where_clause,
828: l_in_join_tbl,

Line 949: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);

945:
946: x_custom_sql := l_query;
947: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
948: if(l_sec_context = 'COMP')then
949: poa_dbi_sutil_pkg.bind_com_cc_values(x_custom_output, p_param);
950: end if;
951: end;
952:
953:

Line 999: poa_dbi_sutil_pkg.get_parameters(p_param);

995: BEGIN
996:
997: /* sets up calls to ("fii_msg.get_curr_label") for col labels */
998: /*fii_gl_util_pkg.reset_globals;*/
999: poa_dbi_sutil_pkg.get_parameters(p_param);
1000:
1001: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1003:

Line 1004: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);

1000:
1001: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1003:
1004: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1005: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1006: poa_dbi_sutil_pkg.process_parameters(
1007: p_param => p_param,
1008: p_view_by => l_view_by,

Line 1006: poa_dbi_sutil_pkg.process_parameters(

1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1003:
1004: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
1005: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM')then
1006: poa_dbi_sutil_pkg.process_parameters(
1007: p_param => p_param,
1008: p_view_by => l_view_by,
1009: p_view_by_col_name => l_view_by_col,
1010: p_view_by_value => l_view_by_value,

Line 1028: poa_dbi_sutil_pkg.process_parameters(

1024: p_version => '6.0',
1025: p_role => 'COM',
1026: p_mv_set => 'PQC');
1027: elsif (l_sec_context = 'COMP') then
1028: poa_dbi_sutil_pkg.process_parameters(
1029: p_param => p_param,
1030: p_view_by => l_view_by,
1031: p_view_by_col_name => l_view_by_col,
1032: p_view_by_value => l_view_by_value,

Line 1060: poa_dbi_sutil_pkg.process_parameters(

1056: end if;
1057: end if;
1058: end loop;
1059: if(l_use_only_agg_mv = 'N') then
1060: poa_dbi_sutil_pkg.process_parameters(
1061: p_param => p_param,
1062: p_view_by => l_view_by,
1063: p_view_by_col_name => l_view_by_col,
1064: p_view_by_value => l_view_by_value,