DBA Data[Home] [Help]

APPS.RCI_SIG_ACCT_EVAL_SUMM_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 138: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

134: ';
135:
136: p_exp_source_sql := l_sqlstmt;
137: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
138: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
139:
140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';
142: l_bind_rec.attribute_value := v_period;

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

139:
140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';
142: l_bind_rec.attribute_value := v_period;
143: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
144: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
145: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
146:
147: END get_kpi;

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

140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';
142: l_bind_rec.attribute_value := v_period;
143: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
144: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
145: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
146:
147: END get_kpi;
148:

Line 259: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

255: ';
256:
257: p_exp_source_sql := l_sqlstmt;
258: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
259: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
260:
261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';
263: l_bind_rec.attribute_value := v_period;

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

260:
261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';
263: l_bind_rec.attribute_value := v_period;
264: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
265: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
266: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
267:
268: END get_sig_acct_eval_details;

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

261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';
263: l_bind_rec.attribute_value := v_period;
264: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
265: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
266: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
267:
268: END get_sig_acct_eval_details;
269:

Line 469: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

465:
466:
467: p_exp_source_sql := l_act_sqlstmt;
468: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
469: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
470:
471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';
473: l_bind_rec.attribute_value := v_period;

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

470:
471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';
473: l_bind_rec.attribute_value := v_period;
474: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
475: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
476: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
477: END get_org_details;
478:

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

471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';
473: l_bind_rec.attribute_value := v_period;
474: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
475: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
476: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
477: END get_org_details;
478:
479: -- used in get_org_def_details

Line 645: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

641: '||where_clause;
642:
643: p_exp_source_sql := l_sqlstmt;
644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
645: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
646:
647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';
649: l_bind_rec.attribute_value := v_period;

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

646:
647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';
649: l_bind_rec.attribute_value := v_period;
650: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
651: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
652: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
653:
654: END get_org_def_details;

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

647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';
649: l_bind_rec.attribute_value := v_period;
650: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
651: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
652: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
653:
654: END get_org_def_details;
655:

Line 752: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

748: ' || where_clause;
749:
750: p_exp_source_sql := l_sqlstmt;
751: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
752: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
753:
754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';
756: l_bind_rec.attribute_value := v_period;

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

753:
754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';
756: l_bind_rec.attribute_value := v_period;
757: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
758: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
759: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
760:
761: END get_sig_acct_details;

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

754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';
756: l_bind_rec.attribute_value := v_period;
757: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
758: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
759: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
760:
761: END get_sig_acct_details;
762:

Line 915: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

911: order by a.col_rank ';
912:
913: p_exp_source_sql := l_act_sqlstmt;
914: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
915: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
916:
917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';
919: l_bind_rec.attribute_value := v_period;

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

916:
917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';
919: l_bind_rec.attribute_value := v_period;
920: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
921: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
922: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
923:
924: END get_sig_acct_eval_result;

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

917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';
919: l_bind_rec.attribute_value := v_period;
920: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
921: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
922: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
923:
924: END get_sig_acct_eval_result;
925:

Line 1134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1130: order by a.col_rank ';
1131:
1132: p_exp_source_sql := l_act_sqlstmt;
1133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1135:
1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';
1138: l_bind_rec.attribute_value := v_period;

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

1135:
1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';
1138: l_bind_rec.attribute_value := v_period;
1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1141: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1142: END get_sig_acct_eval_summ_result;
1143:

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

1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';
1138: l_bind_rec.attribute_value := v_period;
1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1141: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1142: END get_sig_acct_eval_summ_result;
1143:
1144: /*