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

Line 990: cursor_id := DBMS_SQL.open_cursor;

986: cep_standard.debug('>>CE_CSH_FCST_POP.Execute_Main_Query');
987:
988: populate_aging_buckets;
989:
990: cursor_id := DBMS_SQL.open_cursor;
991: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
992: to_char(cursor_id));
993:
994: cep_standard.debug('Parsing ....');

Line 1016: DBMS_SQL.Parse(cursor_id,

1012: CODE_COMBINATION_ID,
1013: AMOUNT,
1014: TRX_AMOUNT)
1015: ' || main_query;
1016: DBMS_SQL.Parse(cursor_id,
1017: final_query,
1018: DBMS_SQL.v7);
1019:
1020: cep_standard.debug('Parsed sucessfully');

Line 1018: DBMS_SQL.v7);

1014: TRX_AMOUNT)
1015: ' || main_query;
1016: DBMS_SQL.Parse(cursor_id,
1017: final_query,
1018: DBMS_SQL.v7);
1019:
1020: cep_standard.debug('Parsed sucessfully');
1021:
1022: exec_id := DBMS_SQL.execute(cursor_id);

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

1018: DBMS_SQL.v7);
1019:
1020: cep_standard.debug('Parsed sucessfully');
1021:
1022: exec_id := DBMS_SQL.execute(cursor_id);
1023:
1024: DBMS_SQL.CLOSE_CURSOR(cursor_id);
1025:
1026: IF(CE_CASH_FCST.G_trx_type IN ('GLB', 'GLE', 'GLA', 'PAY')) THEN

Line 1024: DBMS_SQL.CLOSE_CURSOR(cursor_id);

1020: cep_standard.debug('Parsed sucessfully');
1021:
1022: exec_id := DBMS_SQL.execute(cursor_id);
1023:
1024: DBMS_SQL.CLOSE_CURSOR(cursor_id);
1025:
1026: IF(CE_CASH_FCST.G_trx_type IN ('GLB', 'GLE', 'GLA', 'PAY')) THEN
1027: DELETE from ce_forecast_trx_cells
1028: WHERE forecast_id = CE_CASH_FCST.G_forecast_id

Line 1056: IF DBMS_SQL.IS_OPEN(cursor_id) THEN

1052: zero_fill_cells;
1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: cep_standard.debug('EXCEPTION - OTHERS: Execute_Main_Query');
1056: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
1057: DBMS_SQL.CLOSE_CURSOR(cursor_id);
1058: cep_standard.debug('Cursor Closed');
1059: END IF;
1060: RAISE;

Line 1057: DBMS_SQL.CLOSE_CURSOR(cursor_id);

1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: cep_standard.debug('EXCEPTION - OTHERS: Execute_Main_Query');
1056: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
1057: DBMS_SQL.CLOSE_CURSOR(cursor_id);
1058: cep_standard.debug('Cursor Closed');
1059: END IF;
1060: RAISE;
1061: END Execute_Main_Query;

Line 5523: cursor_id := DBMS_SQL.open_cursor;

5519: END IF;
5520: end; ';
5521:
5522: BEGIN
5523: cursor_id := DBMS_SQL.open_cursor;
5524: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5525: exec_id := DBMS_SQL.execute(cursor_id);
5526: DBMS_SQL.close_cursor(cursor_id);
5527: EXCEPTION

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

5520: end; ';
5521:
5522: BEGIN
5523: cursor_id := DBMS_SQL.open_cursor;
5524: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5525: exec_id := DBMS_SQL.execute(cursor_id);
5526: DBMS_SQL.close_cursor(cursor_id);
5527: EXCEPTION
5528: WHEN OTHERS THEN

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

5521:
5522: BEGIN
5523: cursor_id := DBMS_SQL.open_cursor;
5524: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5525: exec_id := DBMS_SQL.execute(cursor_id);
5526: DBMS_SQL.close_cursor(cursor_id);
5527: EXCEPTION
5528: WHEN OTHERS THEN
5529: clear_aging_buckets;

Line 5526: DBMS_SQL.close_cursor(cursor_id);

5522: BEGIN
5523: cursor_id := DBMS_SQL.open_cursor;
5524: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5525: exec_id := DBMS_SQL.execute(cursor_id);
5526: DBMS_SQL.close_cursor(cursor_id);
5527: EXCEPTION
5528: WHEN OTHERS THEN
5529: clear_aging_buckets;
5530: IF DBMS_SQL.is_open(cursor_id) THEN

Line 5530: IF DBMS_SQL.is_open(cursor_id) THEN

5526: DBMS_SQL.close_cursor(cursor_id);
5527: EXCEPTION
5528: WHEN OTHERS THEN
5529: clear_aging_buckets;
5530: IF DBMS_SQL.is_open(cursor_id) THEN
5531: DBMS_SQL.close_cursor(cursor_id);
5532: END IF;
5533: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5534: error_msg := FND_MESSAGE.get;

Line 5531: DBMS_SQL.close_cursor(cursor_id);

5527: EXCEPTION
5528: WHEN OTHERS THEN
5529: clear_aging_buckets;
5530: IF DBMS_SQL.is_open(cursor_id) THEN
5531: DBMS_SQL.close_cursor(cursor_id);
5532: END IF;
5533: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5534: error_msg := FND_MESSAGE.get;
5535: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,