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

Line 443: l_insertSQL DBMS_SQL.VARCHAR2S;

439: l_fv_table FND_FLEX_VALIDATION_TABLES.application_table_name%TYPE;
440: l_fv_col FND_FLEX_VALIDATION_TABLES.value_column_name%TYPE;
441: l_fv_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
442:
443: l_insertSQL DBMS_SQL.VARCHAR2S;
444: l_line_no NUMBER := 0;
445: l_cursorID INTEGER;
446: l_return_no NUMBER;
447:

Line 646: l_cursorID := DBMS_SQL.OPEN_CURSOR;

642: l_insertSQL(l_line_no) := 'AND bsv.summary_flag = ''N'' ';
643: END IF;
644:
645: -- Open cursor
646: l_cursorID := DBMS_SQL.OPEN_CURSOR;
647: DBMS_SQL.PARSE(l_cursorID, l_insertSQL, 1, l_line_no, TRUE, dbms_sql.native);
648:
649: -- Bind variables
650: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id1', p_ledger_id);

Line 647: DBMS_SQL.PARSE(l_cursorID, l_insertSQL, 1, l_line_no, TRUE, dbms_sql.native);

643: END IF;
644:
645: -- Open cursor
646: l_cursorID := DBMS_SQL.OPEN_CURSOR;
647: DBMS_SQL.PARSE(l_cursorID, l_insertSQL, 1, l_line_no, TRUE, dbms_sql.native);
648:
649: -- Bind variables
650: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id1', p_ledger_id);
651: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id2', p_ledger_id);

Line 650: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id1', p_ledger_id);

646: l_cursorID := DBMS_SQL.OPEN_CURSOR;
647: DBMS_SQL.PARSE(l_cursorID, l_insertSQL, 1, l_line_no, TRUE, dbms_sql.native);
648:
649: -- Bind variables
650: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id1', p_ledger_id);
651: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id2', p_ledger_id);
652:
653: -- Execute INSERT SQL
654: l_return_no := DBMS_SQL.EXECUTE(l_cursorID);

Line 651: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id2', p_ledger_id);

647: DBMS_SQL.PARSE(l_cursorID, l_insertSQL, 1, l_line_no, TRUE, dbms_sql.native);
648:
649: -- Bind variables
650: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id1', p_ledger_id);
651: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id2', p_ledger_id);
652:
653: -- Execute INSERT SQL
654: l_return_no := DBMS_SQL.EXECUTE(l_cursorID);
655:

Line 654: l_return_no := DBMS_SQL.EXECUTE(l_cursorID);

650: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id1', p_ledger_id);
651: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':lg_id2', p_ledger_id);
652:
653: -- Execute INSERT SQL
654: l_return_no := DBMS_SQL.EXECUTE(l_cursorID);
655:
656: -- Close cursor
657: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
658:

Line 657: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

653: -- Execute INSERT SQL
654: l_return_no := DBMS_SQL.EXECUTE(l_cursorID);
655:
656: -- Close cursor
657: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
658:
659: ELSE
660: -- Invalid BSV option code for the passed ledger
661: RETURN 'F';

Line 2310: l_insert_statement DBMS_SQL.VARCHAR2S;

2306: -- 16-JUL-03 MGOWDA Created
2307:
2308: PROCEDURE populate_ledger_bsv_gt (n_ledger_id IN NUMBER)
2309: IS
2310: l_insert_statement DBMS_SQL.VARCHAR2S;
2311: l_line_num NUMBER := 1;
2312: l_cursor integer;
2313: l_fv_table varchar2(30);
2314: l_fv_col varchar2(30);

Line 2394: l_cursor := dbms_sql.open_cursor;

2390: l_line_num := l_line_num + 1;
2391: l_insert_statement(l_line_num) := l_fv_description||','||n_ledger_id;
2392: l_line_num := l_line_num + 1;
2393: l_insert_statement(l_line_num) := 'FROM '||l_fv_table;
2394: l_cursor := dbms_sql.open_cursor;
2395: dbms_sql.parse(l_cursor, l_insert_statement,1,
2396: l_line_Num, true, dbms_sql.native);
2397: rows_processed := dbms_sql.execute(l_cursor);
2398: dbms_sql.close_cursor(l_cursor);

Line 2395: dbms_sql.parse(l_cursor, l_insert_statement,1,

2391: l_insert_statement(l_line_num) := l_fv_description||','||n_ledger_id;
2392: l_line_num := l_line_num + 1;
2393: l_insert_statement(l_line_num) := 'FROM '||l_fv_table;
2394: l_cursor := dbms_sql.open_cursor;
2395: dbms_sql.parse(l_cursor, l_insert_statement,1,
2396: l_line_Num, true, dbms_sql.native);
2397: rows_processed := dbms_sql.execute(l_cursor);
2398: dbms_sql.close_cursor(l_cursor);
2399: END IF;

Line 2396: l_line_Num, true, dbms_sql.native);

2392: l_line_num := l_line_num + 1;
2393: l_insert_statement(l_line_num) := 'FROM '||l_fv_table;
2394: l_cursor := dbms_sql.open_cursor;
2395: dbms_sql.parse(l_cursor, l_insert_statement,1,
2396: l_line_Num, true, dbms_sql.native);
2397: rows_processed := dbms_sql.execute(l_cursor);
2398: dbms_sql.close_cursor(l_cursor);
2399: END IF;
2400: END IF;

Line 2397: rows_processed := dbms_sql.execute(l_cursor);

2393: l_insert_statement(l_line_num) := 'FROM '||l_fv_table;
2394: l_cursor := dbms_sql.open_cursor;
2395: dbms_sql.parse(l_cursor, l_insert_statement,1,
2396: l_line_Num, true, dbms_sql.native);
2397: rows_processed := dbms_sql.execute(l_cursor);
2398: dbms_sql.close_cursor(l_cursor);
2399: END IF;
2400: END IF;
2401: END;

Line 2398: dbms_sql.close_cursor(l_cursor);

2394: l_cursor := dbms_sql.open_cursor;
2395: dbms_sql.parse(l_cursor, l_insert_statement,1,
2396: l_line_Num, true, dbms_sql.native);
2397: rows_processed := dbms_sql.execute(l_cursor);
2398: dbms_sql.close_cursor(l_cursor);
2399: END IF;
2400: END IF;
2401: END;
2402: