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

Line 354: l_cursor := dbms_sql.open_cursor;

350: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_gl_segment ' || l_gl_segment);
351: l_rows := 0;
352: l_cost_value := 0;
353: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- p_cost_keyflex_id ' || to_char(p_cost_keyflex_id));
354: l_cursor := dbms_sql.open_cursor;
355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);
356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);
357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);

Line 355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);

351: l_rows := 0;
352: l_cost_value := 0;
353: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- p_cost_keyflex_id ' || to_char(p_cost_keyflex_id));
354: l_cursor := dbms_sql.open_cursor;
355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);
356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);
357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);
359: dbms_sql.column_value(l_cursor,1,l_cost_value);

Line 356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);

352: l_cost_value := 0;
353: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- p_cost_keyflex_id ' || to_char(p_cost_keyflex_id));
354: l_cursor := dbms_sql.open_cursor;
355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);
356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);
357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);
359: dbms_sql.column_value(l_cursor,1,l_cost_value);
360: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_cost_value ' || l_cost_value);

Line 357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);

353: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- p_cost_keyflex_id ' || to_char(p_cost_keyflex_id));
354: l_cursor := dbms_sql.open_cursor;
355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);
356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);
357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);
359: dbms_sql.column_value(l_cursor,1,l_cost_value);
360: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_cost_value ' || l_cost_value);
361: dbms_sql.close_cursor(l_cursor);

Line 358: l_rows := dbms_sql.execute_and_fetch(l_cursor);

354: l_cursor := dbms_sql.open_cursor;
355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);
356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);
357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);
359: dbms_sql.column_value(l_cursor,1,l_cost_value);
360: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_cost_value ' || l_cost_value);
361: dbms_sql.close_cursor(l_cursor);
362:

Line 359: dbms_sql.column_value(l_cursor,1,l_cost_value);

355: dbms_sql.parse(l_cursor,'select ' || l_cost_segment || ' from pay_cost_allocation_keyflex where cost_allocation_keyflex_id = :p_cost_keyflex_id',dbms_sql.V7);
356: dbms_sql.bind_variable(l_cursor,'p_cost_keyflex_id',p_cost_keyflex_id);
357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);
359: dbms_sql.column_value(l_cursor,1,l_cost_value);
360: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_cost_value ' || l_cost_value);
361: dbms_sql.close_cursor(l_cursor);
362:
363: l_sql_string := l_sql_string || ' and ' || l_gl_segment || ' = ''' || l_cost_value || '''';

Line 361: dbms_sql.close_cursor(l_cursor);

357: dbms_sql.define_column(l_cursor,1,l_cost_value,22);
358: l_rows := dbms_sql.execute_and_fetch(l_cursor);
359: dbms_sql.column_value(l_cursor,1,l_cost_value);
360: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_cost_value ' || l_cost_value);
361: dbms_sql.close_cursor(l_cursor);
362:
363: l_sql_string := l_sql_string || ' and ' || l_gl_segment || ' = ''' || l_cost_value || '''';
364:
365: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_sql_string ' || l_sql_string);

Line 379: l_cursor :=dbms_sql.open_cursor;

375: --dbms_output.put_line('DEBUG.....NotFound');
376: --dbms_output.put_line('DEBUG.....Chart of accounts ' || to_char(l_chart_of_accounts_id));
377: --dbms_output.put_line('DEBUG.....Set of Books ' || to_char(p_set_of_books_id));
378: if l_chart_of_accounts_id <> 0 then
379: l_cursor :=dbms_sql.open_cursor;
380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);
381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);
382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);
383: l_rows := dbms_sql.execute_and_fetch(l_cursor);

Line 380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);

376: --dbms_output.put_line('DEBUG.....Chart of accounts ' || to_char(l_chart_of_accounts_id));
377: --dbms_output.put_line('DEBUG.....Set of Books ' || to_char(p_set_of_books_id));
378: if l_chart_of_accounts_id <> 0 then
379: l_cursor :=dbms_sql.open_cursor;
380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);
381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);
382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);
383: l_rows := dbms_sql.execute_and_fetch(l_cursor);
384: dbms_sql.column_value(l_cursor,1,l_gl_ccid);

Line 381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);

377: --dbms_output.put_line('DEBUG.....Set of Books ' || to_char(p_set_of_books_id));
378: if l_chart_of_accounts_id <> 0 then
379: l_cursor :=dbms_sql.open_cursor;
380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);
381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);
382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);
383: l_rows := dbms_sql.execute_and_fetch(l_cursor);
384: dbms_sql.column_value(l_cursor,1,l_gl_ccid);
385: if l_gl_ccid > 0 then

Line 382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);

378: if l_chart_of_accounts_id <> 0 then
379: l_cursor :=dbms_sql.open_cursor;
380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);
381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);
382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);
383: l_rows := dbms_sql.execute_and_fetch(l_cursor);
384: dbms_sql.column_value(l_cursor,1,l_gl_ccid);
385: if l_gl_ccid > 0 then
386: x_gl_ccid := l_gl_ccid;

Line 383: l_rows := dbms_sql.execute_and_fetch(l_cursor);

379: l_cursor :=dbms_sql.open_cursor;
380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);
381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);
382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);
383: l_rows := dbms_sql.execute_and_fetch(l_cursor);
384: dbms_sql.column_value(l_cursor,1,l_gl_ccid);
385: if l_gl_ccid > 0 then
386: x_gl_ccid := l_gl_ccid;
387: else

Line 384: dbms_sql.column_value(l_cursor,1,l_gl_ccid);

380: dbms_sql.parse(l_cursor,'select code_combination_id from gl_code_combinations where chart_of_accounts_id = :p_chart_of_accounts_id ' || l_sql_string,dbms_sql.V7);
381: dbms_sql.bind_variable(l_cursor,'p_chart_of_accounts_id',l_chart_of_accounts_id);
382: dbms_sql.define_column(l_cursor,1,l_gl_ccid);
383: l_rows := dbms_sql.execute_and_fetch(l_cursor);
384: dbms_sql.column_value(l_cursor,1,l_gl_ccid);
385: if l_gl_ccid > 0 then
386: x_gl_ccid := l_gl_ccid;
387: else
388: x_gl_ccid := 0;

Line 392: dbms_sql.close_cursor(l_cursor);

388: x_gl_ccid := 0;
389: end if;
390:
391: --DBMS_OUTPUT.PUT_LINE(' DEBUG -- l_gl_ccid ' || to_char(l_gl_ccid));
392: dbms_sql.close_cursor(l_cursor);
393: end if;
394:
395: END;
396: