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

Line 946: source_cursor := dbms_sql.open_cursor;

942: x_err_stack := x_err_stack || '-> create_collection_views';
943:
944: pa_debug.debug(x_err_stage);
945:
946: source_cursor := dbms_sql.open_cursor;
947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);

Line 947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);

943:
944: pa_debug.debug(x_err_stage);
945:
946: source_cursor := dbms_sql.open_cursor;
947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);

Line 948: retcode := dbms_sql.execute(source_cursor);

944: pa_debug.debug(x_err_stage);
945:
946: source_cursor := dbms_sql.open_cursor;
947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);

Line 949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);

945:
946: source_cursor := dbms_sql.open_cursor;
947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);

Line 950: retcode := dbms_sql.execute(source_cursor);

946: source_cursor := dbms_sql.open_cursor;
947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);

Line 951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);

947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);

Line 952: retcode := dbms_sql.execute(source_cursor);

948: retcode := dbms_sql.execute(source_cursor);
949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);
956: retcode := dbms_sql.execute(source_cursor);

Line 953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);

949: dbms_sql.parse(source_cursor,view_ref_act_cmt,1,view_idx_ref_act_cmt,TRUE,dbms_sql.v7);
950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);
956: retcode := dbms_sql.execute(source_cursor);
957:

Line 954: retcode := dbms_sql.execute(source_cursor);

950: retcode := dbms_sql.execute(source_cursor);
951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);
956: retcode := dbms_sql.execute(source_cursor);
957:
958: dbms_sql.close_cursor(source_cursor);

Line 955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);

951: dbms_sql.parse(source_cursor,view_ref_ser_type_act_cmt,1,view_idx_ref_ser_type_act_cmt,TRUE,dbms_sql.v7);
952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);
956: retcode := dbms_sql.execute(source_cursor);
957:
958: dbms_sql.close_cursor(source_cursor);
959:

Line 956: retcode := dbms_sql.execute(source_cursor);

952: retcode := dbms_sql.execute(source_cursor);
953: dbms_sql.parse(source_cursor,view_budget_lines,1,view_idx_budget_lines,TRUE,dbms_sql.v7);
954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);
956: retcode := dbms_sql.execute(source_cursor);
957:
958: dbms_sql.close_cursor(source_cursor);
959:
960: x_err_stack := x_old_err_stack;

Line 958: dbms_sql.close_cursor(source_cursor);

954: retcode := dbms_sql.execute(source_cursor);
955: dbms_sql.parse(source_cursor,view_ref_budget_lines,1,view_idx_ref_budget_lines,TRUE,dbms_sql.v7);
956: retcode := dbms_sql.execute(source_cursor);
957:
958: dbms_sql.close_cursor(source_cursor);
959:
960: x_err_stack := x_old_err_stack;
961:
962: EXCEPTION