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

Line 1023: cursornum := dbms_sql.open_cursor;

1019: -- Save the SQL string in the debug string
1020: --
1021: FND_FLEX_SERVER1.add_sql_string(fnd_dsql.get_text(p_with_debug => TRUE));
1022:
1023: cursornum := dbms_sql.open_cursor;
1024: fnd_dsql.set_cursor(cursornum);
1025:
1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);
1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);

Line 1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);

1023: cursornum := dbms_sql.open_cursor;
1024: fnd_dsql.set_cursor(cursornum);
1025:
1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);
1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);
1028:
1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);

Line 1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);

1026: sql_str := fnd_dsql.get_text(p_with_debug => FALSE);
1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);
1028:
1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);

Line 1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);

1027: dbms_sql.parse(cursornum, sql_str, dbms_sql.v7);
1028:
1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);
1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);

Line 1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);

1028:
1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);
1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);
1036: if(num_returned = 1) then

Line 1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);

1029: fnd_dsql.do_binds;
1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);
1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);
1036: if(num_returned = 1) then
1037: dbms_sql.column_value(cursornum, 1, selected_rule);

Line 1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);

1030: dbms_sql.bind_variable(cursornum, ':VDATE', v_date);
1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);
1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);
1036: if(num_returned = 1) then
1037: dbms_sql.column_value(cursornum, 1, selected_rule);
1038: IF (fnd_flex_server1.g_debug_level > 0) THEN

Line 1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);

1031: dbms_sql.bind_variable(cursornum, ':APID', fstruct.application_id);
1032: dbms_sql.bind_variable(cursornum, ':CODE', fstruct.id_flex_code);
1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);
1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);
1036: if(num_returned = 1) then
1037: dbms_sql.column_value(cursornum, 1, selected_rule);
1038: IF (fnd_flex_server1.g_debug_level > 0) THEN
1039: FND_FLEX_SERVER1.add_debug('(DSQL returned ' || selected_rule || ')');

Line 1037: dbms_sql.column_value(cursornum, 1, selected_rule);

1033: dbms_sql.bind_variable(cursornum, ':NUM', fstruct.id_flex_num);
1034: dbms_sql.define_column(cursornum, 1, selected_rule, 15);
1035: num_returned := dbms_sql.execute_and_fetch(cursornum, FALSE);
1036: if(num_returned = 1) then
1037: dbms_sql.column_value(cursornum, 1, selected_rule);
1038: IF (fnd_flex_server1.g_debug_level > 0) THEN
1039: FND_FLEX_SERVER1.add_debug('(DSQL returned ' || selected_rule || ')');
1040: END IF;
1041: bad_rule := selected_rule;

Line 1048: dbms_sql.close_cursor(cursornum);

1044: IF (fnd_flex_server1.g_debug_level > 0) THEN
1045: FND_FLEX_SERVER1.add_debug('(DSQL returned: NULL)');
1046: END IF;
1047: end if;
1048: dbms_sql.close_cursor(cursornum);
1049: return(num_returned);
1050:
1051: EXCEPTION
1052: WHEN OTHERS then

Line 1053: if(dbms_sql.is_open(cursornum)) then

1049: return(num_returned);
1050:
1051: EXCEPTION
1052: WHEN OTHERS then
1053: if(dbms_sql.is_open(cursornum)) then
1054: dbms_sql.close_cursor(cursornum);
1055: end if;
1056: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
1057: FND_MESSAGE.set_token('MSG', SQLERRM);

Line 1054: dbms_sql.close_cursor(cursornum);

1050:
1051: EXCEPTION
1052: WHEN OTHERS then
1053: if(dbms_sql.is_open(cursornum)) then
1054: dbms_sql.close_cursor(cursornum);
1055: end if;
1056: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
1057: FND_MESSAGE.set_token('MSG', SQLERRM);
1058: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_str, 1, 1000));