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

Line 460: l_bal_cursor := DBMS_SQL.OPEN_CURSOR;

456: FETCH cash_position_acct_cur INTO l_cash_ussgl_acct ;
457: EXIT WHEN cash_position_acct_cur%NOTFOUND;
458:
459: BEGIN
460: l_bal_cursor := DBMS_SQL.OPEN_CURSOR;
461:
462: EXCEPTION
463: WHEN OTHERS THEN
464: g_error_code := sqlcode ;

Line 499: DBMS_SQL.PARSE(l_bal_cursor, l_bal_select, DBMS_SQL.V7) ;

495:
496:
497:
498: BEGIN
499: DBMS_SQL.PARSE(l_bal_cursor, l_bal_select, DBMS_SQL.V7) ;
500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);
501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);

Line 500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);

496:
497:
498: BEGIN
499: DBMS_SQL.PARSE(l_bal_cursor, l_bal_select, DBMS_SQL.V7) ;
500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);
501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);

Line 501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);

497:
498: BEGIN
499: DBMS_SQL.PARSE(l_bal_cursor, l_bal_select, DBMS_SQL.V7) ;
500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);
501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);
505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);

Line 502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);

498: BEGIN
499: DBMS_SQL.PARSE(l_bal_cursor, l_bal_select, DBMS_SQL.V7) ;
500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);
501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);
505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);
506:

Line 503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);

499: DBMS_SQL.PARSE(l_bal_cursor, l_bal_select, DBMS_SQL.V7) ;
500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);
501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);
505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);
506:
507: DBMS_SQL.DEFINE_COLUMN(l_bal_cursor, 1, l_gl_cash_balance);

Line 504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);

500: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_cash_ussgl_acct',l_cash_ussgl_acct);
501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);
505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);
506:
507: DBMS_SQL.DEFINE_COLUMN(l_bal_cursor, 1, l_gl_cash_balance);
508:

Line 505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);

501: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_year',l_period_year);
502: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_period_num',l_period_num);
503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);
505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);
506:
507: DBMS_SQL.DEFINE_COLUMN(l_bal_cursor, 1, l_gl_cash_balance);
508:
509: BEGIN

Line 507: DBMS_SQL.DEFINE_COLUMN(l_bal_cursor, 1, l_gl_cash_balance);

503: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_set_of_books_id',g_set_of_books_id);
504: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':l_currency_code',l_currency_code);
505: DBMS_SQL.BIND_VARIABLE(l_bal_cursor,':g_value_set_id',g_value_set_id);
506:
507: DBMS_SQL.DEFINE_COLUMN(l_bal_cursor, 1, l_gl_cash_balance);
508:
509: BEGIN
510: l_exec_ret := DBMS_SQL.EXECUTE(l_bal_cursor);
511:

Line 510: l_exec_ret := DBMS_SQL.EXECUTE(l_bal_cursor);

506:
507: DBMS_SQL.DEFINE_COLUMN(l_bal_cursor, 1, l_gl_cash_balance);
508:
509: BEGIN
510: l_exec_ret := DBMS_SQL.EXECUTE(l_bal_cursor);
511:
512: EXCEPTION
513: WHEN OTHERS THEN
514: g_error_code := sqlcode ;

Line 520: IF dbms_sql.fetch_rows(l_bal_cursor) = 0 THEN

516: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);
517: RETURN ;
518: END ;
519:
520: IF dbms_sql.fetch_rows(l_bal_cursor) = 0 THEN
521: EXIT;
522: ELSE
523: -- Fetch the Records into Variables
524: DBMS_SQL.COLUMN_VALUE(l_bal_cursor, 1, l_gl_cash_balance);

Line 524: DBMS_SQL.COLUMN_VALUE(l_bal_cursor, 1, l_gl_cash_balance);

520: IF dbms_sql.fetch_rows(l_bal_cursor) = 0 THEN
521: EXIT;
522: ELSE
523: -- Fetch the Records into Variables
524: DBMS_SQL.COLUMN_VALUE(l_bal_cursor, 1, l_gl_cash_balance);
525: l_tot_cash_balance := NVL(l_gl_cash_balance,0) + l_tot_cash_balance;
526: END IF;
527:
528:

Line 531: DBMS_SQL.CLOSE_CURSOR(l_bal_cursor);

527:
528:
529: -- Close the SQL Cursor
530: BEGIN
531: DBMS_SQL.CLOSE_CURSOR(l_bal_cursor);
532: EXCEPTION
533: WHEN OTHERS THEN
534: g_error_code := sqlcode ;
535: g_error_buf := sqlerrm ||' Create_cash_position - Close Cursor]' ;