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.AMS_SCORERESULT_PVT dependencies on DBMS_SQL

Line 1136: l_temp_party_id_list dbms_sql.Varchar2_Table;

1132: l_counter NUMBER := 1;
1133: l_score_id NUMBER := p_score_id;
1134: l_party_ids VARCHAR2(4000) := '';
1135: l_sql_str VARCHAR2(5000) := '';
1136: l_temp_party_id_list dbms_sql.Varchar2_Table;
1137: l_party_id_list dbms_sql.Varchar2_Table;
1138: l_conf_list dbms_sql.NUMBER_table;
1139: l_bs_rows NUMBER := 0;
1140: l_ctr NUMBER := 0;

Line 1137: l_party_id_list dbms_sql.Varchar2_Table;

1133: l_score_id NUMBER := p_score_id;
1134: l_party_ids VARCHAR2(4000) := '';
1135: l_sql_str VARCHAR2(5000) := '';
1136: l_temp_party_id_list dbms_sql.Varchar2_Table;
1137: l_party_id_list dbms_sql.Varchar2_Table;
1138: l_conf_list dbms_sql.NUMBER_table;
1139: l_bs_rows NUMBER := 0;
1140: l_ctr NUMBER := 0;
1141: l_ctr_2 NUMBER :=0;

Line 1138: l_conf_list dbms_sql.NUMBER_table;

1134: l_party_ids VARCHAR2(4000) := '';
1135: l_sql_str VARCHAR2(5000) := '';
1136: l_temp_party_id_list dbms_sql.Varchar2_Table;
1137: l_party_id_list dbms_sql.Varchar2_Table;
1138: l_conf_list dbms_sql.NUMBER_table;
1139: l_bs_rows NUMBER := 0;
1140: l_ctr NUMBER := 0;
1141: l_ctr_2 NUMBER :=0;
1142: l_percentile_list dbms_sql.NUMBER_table;

Line 1142: l_percentile_list dbms_sql.NUMBER_table;

1138: l_conf_list dbms_sql.NUMBER_table;
1139: l_bs_rows NUMBER := 0;
1140: l_ctr NUMBER := 0;
1141: l_ctr_2 NUMBER :=0;
1142: l_percentile_list dbms_sql.NUMBER_table;
1143: l_record_count_list dbms_sql.NUMBER_table;
1144: l_num_recs_cum_list dbms_sql.NUMBER_table;
1145: l_avg_conf_list dbms_sql.NUMBER_table;
1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;

Line 1143: l_record_count_list dbms_sql.NUMBER_table;

1139: l_bs_rows NUMBER := 0;
1140: l_ctr NUMBER := 0;
1141: l_ctr_2 NUMBER :=0;
1142: l_percentile_list dbms_sql.NUMBER_table;
1143: l_record_count_list dbms_sql.NUMBER_table;
1144: l_num_recs_cum_list dbms_sql.NUMBER_table;
1145: l_avg_conf_list dbms_sql.NUMBER_table;
1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;
1147:

Line 1144: l_num_recs_cum_list dbms_sql.NUMBER_table;

1140: l_ctr NUMBER := 0;
1141: l_ctr_2 NUMBER :=0;
1142: l_percentile_list dbms_sql.NUMBER_table;
1143: l_record_count_list dbms_sql.NUMBER_table;
1144: l_num_recs_cum_list dbms_sql.NUMBER_table;
1145: l_avg_conf_list dbms_sql.NUMBER_table;
1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;
1147:
1148: BEGIN

Line 1145: l_avg_conf_list dbms_sql.NUMBER_table;

1141: l_ctr_2 NUMBER :=0;
1142: l_percentile_list dbms_sql.NUMBER_table;
1143: l_record_count_list dbms_sql.NUMBER_table;
1144: l_num_recs_cum_list dbms_sql.NUMBER_table;
1145: l_avg_conf_list dbms_sql.NUMBER_table;
1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;
1147:
1148: BEGIN
1149:

Line 1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;

1142: l_percentile_list dbms_sql.NUMBER_table;
1143: l_record_count_list dbms_sql.NUMBER_table;
1144: l_num_recs_cum_list dbms_sql.NUMBER_table;
1145: l_avg_conf_list dbms_sql.NUMBER_table;
1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;
1147:
1148: BEGIN
1149:
1150: -- Standard Start of API savepoint