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

Line 1928: v_cursor := dbms_sql.open_cursor;

1924: v_all_meas_no := v_measure_no+1;
1925: END IF;
1926:
1927: --open dynamic cursor
1928: v_cursor := dbms_sql.open_cursor;
1929: --Parse the results (row: qrm_saved_analyses_row)
1930: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
1931: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
1932: --remember to add end_date as binding variable

Line 1930: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);

1926:
1927: --open dynamic cursor
1928: v_cursor := dbms_sql.open_cursor;
1929: --Parse the results (row: qrm_saved_analyses_row)
1930: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
1931: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
1932: --remember to add end_date as binding variable
1933: --for special cases
1934: IF (g_proc_level>=g_debug_level) THEN

Line 1931: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);

1927: --open dynamic cursor
1928: v_cursor := dbms_sql.open_cursor;
1929: --Parse the results (row: qrm_saved_analyses_row)
1930: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
1931: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
1932: --remember to add end_date as binding variable
1933: --for special cases
1934: IF (g_proc_level>=g_debug_level) THEN
1935: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_tb_calc_used',v_tb_calc_used);

Line 1940: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_ref_date));

1936: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_end_date_fix',v_end_date_fix);
1937: END IF;
1938: IF v_style='X' THEN
1939: IF v_analysis_type<>'P' THEN
1940: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_ref_date));
1941: END IF;
1942: ELSE
1943: IF v_tb_calc_used THEN
1944: IF v_analysis_type='P' THEN

Line 1945: dbms_sql.bind_variable(v_cursor,'end_date',v_end_date_fix);

1941: END IF;
1942: ELSE
1943: IF v_tb_calc_used THEN
1944: IF v_analysis_type='P' THEN
1945: dbms_sql.bind_variable(v_cursor,'end_date',v_end_date_fix);
1946: ELSE
1947: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_ref_date));
1948: END IF;
1949: END IF;

Line 1947: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_ref_date));

1943: IF v_tb_calc_used THEN
1944: IF v_analysis_type='P' THEN
1945: dbms_sql.bind_variable(v_cursor,'end_date',v_end_date_fix);
1946: ELSE
1947: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_ref_date));
1948: END IF;
1949: END IF;
1950: END IF;
1951:

Line 1956: dbms_sql.define_column(v_cursor,i,v_header(i),20);

1952: --define columns for row agg
1953: v_header.EXTEND(2*v_row_agg_no); -- the extra storage to be used later
1954: v_measure.EXTEND(v_all_meas_no);
1955: FOR i IN 1..v_row_agg_no LOOP
1956: dbms_sql.define_column(v_cursor,i,v_header(i),20);
1957: END LOOP;
1958: IF (g_proc_level>=g_debug_level) THEN
1959: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_measure_no',v_measure_no);
1960: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_all_meas_no',v_all_meas_no||':'||v_measure.COUNT);

Line 1963: dbms_sql.define_column(v_cursor,i+v_row_agg_no,v_measure(i));

1959: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_measure_no',v_measure_no);
1960: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_all_meas_no',v_all_meas_no||':'||v_measure.COUNT);
1961: END IF;
1962: FOR i IN 1..v_all_meas_no LOOP
1963: dbms_sql.define_column(v_cursor,i+v_row_agg_no,v_measure(i));
1964: END LOOP;
1965:
1966: --execute
1967: v_rows_processed := dbms_sql.execute(v_cursor);

Line 1967: v_rows_processed := dbms_sql.execute(v_cursor);

1963: dbms_sql.define_column(v_cursor,i+v_row_agg_no,v_measure(i));
1964: END LOOP;
1965:
1966: --execute
1967: v_rows_processed := dbms_sql.execute(v_cursor);
1968: --xtr_risk_debug_pkg.dlog('v_cursor = ',v_cursor);
1969: --xtr_risk_debug_pkg.dlog('v_rows_processed = ',v_rows_processed);
1970:
1971: --calculate multiplier to be used in the total array for style=A

Line 1995: IF dbms_sql.fetch_rows(v_cursor)>0 THEN

1991:
1992: --loop through the fetched rows
1993: LOOP
1994: --fetch a row
1995: IF dbms_sql.fetch_rows(v_cursor)>0 THEN
1996: --fetch header/VARCHAR type
1997: FOR i IN 1..v_row_agg_no LOOP
1998: dbms_sql.column_value(v_cursor,i,v_header(i));
1999: --xtr_risk_debug_pkg.dlog('v_header(i)',i||':'||v_header(i));

Line 1998: dbms_sql.column_value(v_cursor,i,v_header(i));

1994: --fetch a row
1995: IF dbms_sql.fetch_rows(v_cursor)>0 THEN
1996: --fetch header/VARCHAR type
1997: FOR i IN 1..v_row_agg_no LOOP
1998: dbms_sql.column_value(v_cursor,i,v_header(i));
1999: --xtr_risk_debug_pkg.dlog('v_header(i)',i||':'||v_header(i));
2000: END LOOP;
2001:
2002: --first reset the indicator

Line 2014: dbms_sql.column_value(v_cursor,i+v_row_agg_no,v_measure(i));

2010:
2011: IF NOT v_skip_row THEN
2012: --fetch measure and other NUMBER type
2013: FOR i IN 1..v_all_meas_no LOOP
2014: dbms_sql.column_value(v_cursor,i+v_row_agg_no,v_measure(i));
2015: END LOOP;
2016:
2017: --different treatment for Cross Tab and Aggregated Table
2018: IF v_style='A' THEN --no need for pivoting for style=A

Line 2472: dbms_sql.close_cursor(v_cursor);

2468: END IF;
2469: END LOOP;
2470:
2471: COMMIT;
2472: dbms_sql.close_cursor(v_cursor);
2473:
2474: --update total
2475: v_success := update_total(p_name,p_ref_date);
2476: IF (g_proc_level>=g_debug_level) THEN

Line 3968: v_cursor := dbms_sql.open_cursor;

3964: IF (g_proc_level>=g_debug_level) THEN
3965: xtr_risk_debug_pkg.dlog('v_sql',v_sql);
3966: END IF;
3967: --open dynamic cursor
3968: v_cursor := dbms_sql.open_cursor;
3969: --Parse the results
3970: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
3971: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
3972: --remember to add end_date as binding variable

Line 3970: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);

3966: END IF;
3967: --open dynamic cursor
3968: v_cursor := dbms_sql.open_cursor;
3969: --Parse the results
3970: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
3971: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
3972: --remember to add end_date as binding variable
3973: --for special cases: v_tb_calc_used=TRUE
3974: IF v_tb_calc_used THEN

Line 3971: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);

3967: --open dynamic cursor
3968: v_cursor := dbms_sql.open_cursor;
3969: --Parse the results
3970: dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
3971: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
3972: --remember to add end_date as binding variable
3973: --for special cases: v_tb_calc_used=TRUE
3974: IF v_tb_calc_used THEN
3975: IF p_analysis_type='P' THEN

Line 3976: dbms_sql.bind_variable(v_cursor,'end_date',p_end_date_fix);

3972: --remember to add end_date as binding variable
3973: --for special cases: v_tb_calc_used=TRUE
3974: IF v_tb_calc_used THEN
3975: IF p_analysis_type='P' THEN
3976: dbms_sql.bind_variable(v_cursor,'end_date',p_end_date_fix);
3977: ELSE
3978: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_last_run_date));
3979: END IF;
3980: END IF;

Line 3978: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_last_run_date));

3974: IF v_tb_calc_used THEN
3975: IF p_analysis_type='P' THEN
3976: dbms_sql.bind_variable(v_cursor,'end_date',p_end_date_fix);
3977: ELSE
3978: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_last_run_date));
3979: END IF;
3980: END IF;
3981: --xtr_risk_debug_pkg.dlog('v_measure_no',v_measure_no);
3982: --the number of columns is twice as many in the SQL bec. of nom and denom

Line 3985: dbms_sql.define_column(v_cursor,i,v_total_temp(i));

3981: --xtr_risk_debug_pkg.dlog('v_measure_no',v_measure_no);
3982: --the number of columns is twice as many in the SQL bec. of nom and denom
3983: v_total_temp.EXTEND(p_att_name.COUNT*2);
3984: FOR i IN 1..v_total_temp.COUNT LOOP
3985: dbms_sql.define_column(v_cursor,i,v_total_temp(i));
3986: END LOOP;
3987: --execute
3988: v_rows_processed := dbms_sql.execute(v_cursor);
3989: --get the value

Line 3988: v_rows_processed := dbms_sql.execute(v_cursor);

3984: FOR i IN 1..v_total_temp.COUNT LOOP
3985: dbms_sql.define_column(v_cursor,i,v_total_temp(i));
3986: END LOOP;
3987: --execute
3988: v_rows_processed := dbms_sql.execute(v_cursor);
3989: --get the value
3990: LOOP
3991: IF dbms_sql.fetch_rows(v_cursor)>0 THEN
3992: FOR i IN 1..v_total_temp.COUNT LOOP

Line 3991: IF dbms_sql.fetch_rows(v_cursor)>0 THEN

3987: --execute
3988: v_rows_processed := dbms_sql.execute(v_cursor);
3989: --get the value
3990: LOOP
3991: IF dbms_sql.fetch_rows(v_cursor)>0 THEN
3992: FOR i IN 1..v_total_temp.COUNT LOOP
3993: dbms_sql.column_value(v_cursor,i,v_total_temp(i));
3994: END LOOP;
3995: ELSE

Line 3993: dbms_sql.column_value(v_cursor,i,v_total_temp(i));

3989: --get the value
3990: LOOP
3991: IF dbms_sql.fetch_rows(v_cursor)>0 THEN
3992: FOR i IN 1..v_total_temp.COUNT LOOP
3993: dbms_sql.column_value(v_cursor,i,v_total_temp(i));
3994: END LOOP;
3995: ELSE
3996: EXIT;
3997: END IF;

Line 4013: dbms_sql.close_cursor(v_cursor);

4009: xtr_risk_debug_pkg.dlog('p_total(i)',i||':'||p_att_name(i)||','||p_total(i)||','||p_table_col_curr(i));
4010: END IF;
4011: END LOOP;
4012: --close dynamic cursor
4013: dbms_sql.close_cursor(v_cursor);
4014:
4015: ELSE --just need to call MD API to get the FX Rate/Ccy multiplier
4016: --Find multiplier
4017: p_ccy_multiplier := get_fx_rate(p_md_set_code,