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

Line 672: cursor_id := DBMS_SQL.open_cursor;

668: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
669: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Execute_Main_Query');
670: END IF;
671:
672: cursor_id := DBMS_SQL.open_cursor;
673: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
674: xtr_debug_pkg.debug('Execute_Main_Query: Cursor opened sucessfully with cursor_id: '||
675: to_char(cursor_id));
676: xtr_debug_pkg.debug('Execute_Main_Query: Parsing ....');

Line 679: DBMS_SQL.Parse(cursor_id,

675: to_char(cursor_id));
676: xtr_debug_pkg.debug('Execute_Main_Query: Parsing ....');
677: END IF;
678:
679: DBMS_SQL.Parse(cursor_id,
680: main_query,
681: DBMS_SQL.v7);
682:
683: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 681: DBMS_SQL.v7);

677: END IF;
678:
679: DBMS_SQL.Parse(cursor_id,
680: main_query,
681: DBMS_SQL.v7);
682:
683: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
684: xtr_debug_pkg.debug('Execute_Main_Query: Parsed sucessfully');
685: END IF;

Line 687: DBMS_SQL.Define_Column(cursor_id, 1, forecast_period_temp_id);

683: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
684: xtr_debug_pkg.debug('Execute_Main_Query: Parsed sucessfully');
685: END IF;
686:
687: DBMS_SQL.Define_Column(cursor_id, 1, forecast_period_temp_id);
688: DBMS_SQL.Define_Column(cursor_id, 2, currency, 15);
689: DBMS_SQL.Define_Column(cursor_id, 3, forecast_amount);
690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);

Line 688: DBMS_SQL.Define_Column(cursor_id, 2, currency, 15);

684: xtr_debug_pkg.debug('Execute_Main_Query: Parsed sucessfully');
685: END IF;
686:
687: DBMS_SQL.Define_Column(cursor_id, 1, forecast_period_temp_id);
688: DBMS_SQL.Define_Column(cursor_id, 2, currency, 15);
689: DBMS_SQL.Define_Column(cursor_id, 3, forecast_amount);
690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);
692: end if;

Line 689: DBMS_SQL.Define_Column(cursor_id, 3, forecast_amount);

685: END IF;
686:
687: DBMS_SQL.Define_Column(cursor_id, 1, forecast_period_temp_id);
688: DBMS_SQL.Define_Column(cursor_id, 2, currency, 15);
689: DBMS_SQL.Define_Column(cursor_id, 3, forecast_amount);
690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);
692: end if;
693:

Line 691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);

687: DBMS_SQL.Define_Column(cursor_id, 1, forecast_period_temp_id);
688: DBMS_SQL.Define_Column(cursor_id, 2, currency, 15);
689: DBMS_SQL.Define_Column(cursor_id, 3, forecast_amount);
690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);
692: end if;
693:
694: exec_id := DBMS_SQL.execute(cursor_id);
695: LOOP

Line 694: exec_id := DBMS_SQL.execute(cursor_id);

690: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
691: DBMS_SQL.Define_Column(cursor_id, 4, bank_account_id);
692: end if;
693:
694: exec_id := DBMS_SQL.execute(cursor_id);
695: LOOP
696: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
697: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
698: xtr_debug_pkg.debug('Execute_Main_Query: Getting column information');

Line 696: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN

692: end if;
693:
694: exec_id := DBMS_SQL.execute(cursor_id);
695: LOOP
696: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
697: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
698: xtr_debug_pkg.debug('Execute_Main_Query: Getting column information');
699: END IF;
700:

Line 701: DBMS_SQL.Column_Value(cursor_id, 1, forecast_period_temp_id);

697: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
698: xtr_debug_pkg.debug('Execute_Main_Query: Getting column information');
699: END IF;
700:
701: DBMS_SQL.Column_Value(cursor_id, 1, forecast_period_temp_id);
702: DBMS_SQL.Column_Value(cursor_id, 2, currency);
703: DBMS_SQL.Column_Value(cursor_id, 3, forecast_amount);
704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);

Line 702: DBMS_SQL.Column_Value(cursor_id, 2, currency);

698: xtr_debug_pkg.debug('Execute_Main_Query: Getting column information');
699: END IF;
700:
701: DBMS_SQL.Column_Value(cursor_id, 1, forecast_period_temp_id);
702: DBMS_SQL.Column_Value(cursor_id, 2, currency);
703: DBMS_SQL.Column_Value(cursor_id, 3, forecast_amount);
704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);
706: end if;

Line 703: DBMS_SQL.Column_Value(cursor_id, 3, forecast_amount);

699: END IF;
700:
701: DBMS_SQL.Column_Value(cursor_id, 1, forecast_period_temp_id);
702: DBMS_SQL.Column_Value(cursor_id, 2, currency);
703: DBMS_SQL.Column_Value(cursor_id, 3, forecast_amount);
704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);
706: end if;
707:

Line 705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);

701: DBMS_SQL.Column_Value(cursor_id, 1, forecast_period_temp_id);
702: DBMS_SQL.Column_Value(cursor_id, 2, currency);
703: DBMS_SQL.Column_Value(cursor_id, 3, forecast_amount);
704: if XTR_CASH_FCST.G_trx_type in ('APP','ARR','PAY') then -- AW Bug 2261452
705: DBMS_SQL.Column_Value(cursor_id, 4, bank_account_id);
706: end if;
707:
708: IF(amount_date < XTR_CASH_FCST.G_rp_forecast_start_date)THEN -- Overdue Periods
709: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 777: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);

773: EXIT;
774: END IF;
775: END LOOP;
776:
777: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
778:
779: EXCEPTION
780: WHEN OTHERS THEN
781: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 784: IF DBMS_SQL.IS_OPEN(cursor_id) THEN

780: WHEN OTHERS THEN
781: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
782: xtr_debug_pkg.debug('EXCEPTION - OTHERS: Execute_Main_Query');
783: END IF;
784: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
785: DBMS_SQL.CLOSE_CURSOR(cursor_id);
786: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
787: xtr_debug_pkg.debug('Execute_Main_Query: Cursor Closed');
788: END IF;

Line 785: DBMS_SQL.CLOSE_CURSOR(cursor_id);

781: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
782: xtr_debug_pkg.debug('EXCEPTION - OTHERS: Execute_Main_Query');
783: END IF;
784: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
785: DBMS_SQL.CLOSE_CURSOR(cursor_id);
786: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
787: xtr_debug_pkg.debug('Execute_Main_Query: Cursor Closed');
788: END IF;
789: END IF;

Line 1581: cursor_id := DBMS_SQL.open_cursor;

1577: return;
1578: END IF;
1579: end; ';
1580: BEGIN
1581: cursor_id := DBMS_SQL.open_cursor;
1582: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
1583: exec_id := DBMS_SQL.execute(cursor_id);
1584: DBMS_SQL.close_cursor(cursor_id);
1585: EXCEPTION

Line 1582: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);

1578: END IF;
1579: end; ';
1580: BEGIN
1581: cursor_id := DBMS_SQL.open_cursor;
1582: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
1583: exec_id := DBMS_SQL.execute(cursor_id);
1584: DBMS_SQL.close_cursor(cursor_id);
1585: EXCEPTION
1586: WHEN OTHERS THEN

Line 1583: exec_id := DBMS_SQL.execute(cursor_id);

1579: end; ';
1580: BEGIN
1581: cursor_id := DBMS_SQL.open_cursor;
1582: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
1583: exec_id := DBMS_SQL.execute(cursor_id);
1584: DBMS_SQL.close_cursor(cursor_id);
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: IF DBMS_SQL.is_open(cursor_id) THEN

Line 1584: DBMS_SQL.close_cursor(cursor_id);

1580: BEGIN
1581: cursor_id := DBMS_SQL.open_cursor;
1582: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
1583: exec_id := DBMS_SQL.execute(cursor_id);
1584: DBMS_SQL.close_cursor(cursor_id);
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: IF DBMS_SQL.is_open(cursor_id) THEN
1588: DBMS_SQL.close_cursor(cursor_id);

Line 1587: IF DBMS_SQL.is_open(cursor_id) THEN

1583: exec_id := DBMS_SQL.execute(cursor_id);
1584: DBMS_SQL.close_cursor(cursor_id);
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: IF DBMS_SQL.is_open(cursor_id) THEN
1588: DBMS_SQL.close_cursor(cursor_id);
1589: END IF;
1590: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
1591: error_msg := FND_MESSAGE.get;

Line 1588: DBMS_SQL.close_cursor(cursor_id);

1584: DBMS_SQL.close_cursor(cursor_id);
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: IF DBMS_SQL.is_open(cursor_id) THEN
1588: DBMS_SQL.close_cursor(cursor_id);
1589: END IF;
1590: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
1591: error_msg := FND_MESSAGE.get;
1592: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,