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 922: cursor_id := DBMS_SQL.open_cursor;

918: cep_standard.debug('>>CE_CSH_FCST_POP.Execute_Main_Query');
919:
920: populate_aging_buckets;
921:
922: cursor_id := DBMS_SQL.open_cursor;
923: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
924: to_char(cursor_id));
925:
926: cep_standard.debug('Parsing ....');

Line 948: DBMS_SQL.Parse(cursor_id,

944: CODE_COMBINATION_ID,
945: AMOUNT,
946: TRX_AMOUNT)
947: ' || main_query;
948: DBMS_SQL.Parse(cursor_id,
949: final_query,
950: DBMS_SQL.v7);
951:
952: cep_standard.debug('Parsed sucessfully');

Line 950: DBMS_SQL.v7);

946: TRX_AMOUNT)
947: ' || main_query;
948: DBMS_SQL.Parse(cursor_id,
949: final_query,
950: DBMS_SQL.v7);
951:
952: cep_standard.debug('Parsed sucessfully');
953:
954: exec_id := DBMS_SQL.execute(cursor_id);

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

950: DBMS_SQL.v7);
951:
952: cep_standard.debug('Parsed sucessfully');
953:
954: exec_id := DBMS_SQL.execute(cursor_id);
955:
956: DBMS_SQL.CLOSE_CURSOR(cursor_id);
957:
958: IF(CE_CASH_FCST.G_trx_type IN ('GLB', 'GLE', 'GLA', 'PAY')) THEN

Line 956: DBMS_SQL.CLOSE_CURSOR(cursor_id);

952: cep_standard.debug('Parsed sucessfully');
953:
954: exec_id := DBMS_SQL.execute(cursor_id);
955:
956: DBMS_SQL.CLOSE_CURSOR(cursor_id);
957:
958: IF(CE_CASH_FCST.G_trx_type IN ('GLB', 'GLE', 'GLA', 'PAY')) THEN
959: DELETE from ce_forecast_trx_cells
960: WHERE forecast_id = CE_CASH_FCST.G_forecast_id

Line 988: IF DBMS_SQL.IS_OPEN(cursor_id) THEN

984: zero_fill_cells;
985: EXCEPTION
986: WHEN OTHERS THEN
987: cep_standard.debug('EXCEPTION - OTHERS: Execute_Main_Query');
988: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
989: DBMS_SQL.CLOSE_CURSOR(cursor_id);
990: cep_standard.debug('Cursor Closed');
991: END IF;
992: RAISE;

Line 989: DBMS_SQL.CLOSE_CURSOR(cursor_id);

985: EXCEPTION
986: WHEN OTHERS THEN
987: cep_standard.debug('EXCEPTION - OTHERS: Execute_Main_Query');
988: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
989: DBMS_SQL.CLOSE_CURSOR(cursor_id);
990: cep_standard.debug('Cursor Closed');
991: END IF;
992: RAISE;
993: END Execute_Main_Query;

Line 5372: cursor_id := DBMS_SQL.open_cursor;

5368: END IF;
5369: end; ';
5370:
5371: BEGIN
5372: cursor_id := DBMS_SQL.open_cursor;
5373: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5374: exec_id := DBMS_SQL.execute(cursor_id);
5375: DBMS_SQL.close_cursor(cursor_id);
5376: EXCEPTION

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

5369: end; ';
5370:
5371: BEGIN
5372: cursor_id := DBMS_SQL.open_cursor;
5373: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5374: exec_id := DBMS_SQL.execute(cursor_id);
5375: DBMS_SQL.close_cursor(cursor_id);
5376: EXCEPTION
5377: WHEN OTHERS THEN

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

5370:
5371: BEGIN
5372: cursor_id := DBMS_SQL.open_cursor;
5373: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5374: exec_id := DBMS_SQL.execute(cursor_id);
5375: DBMS_SQL.close_cursor(cursor_id);
5376: EXCEPTION
5377: WHEN OTHERS THEN
5378: clear_aging_buckets;

Line 5375: DBMS_SQL.close_cursor(cursor_id);

5371: BEGIN
5372: cursor_id := DBMS_SQL.open_cursor;
5373: DBMS_SQL.parse(cursor_id, main_query, DBMS_SQL.v7);
5374: exec_id := DBMS_SQL.execute(cursor_id);
5375: DBMS_SQL.close_cursor(cursor_id);
5376: EXCEPTION
5377: WHEN OTHERS THEN
5378: clear_aging_buckets;
5379: IF DBMS_SQL.is_open(cursor_id) THEN

Line 5379: IF DBMS_SQL.is_open(cursor_id) THEN

5375: DBMS_SQL.close_cursor(cursor_id);
5376: EXCEPTION
5377: WHEN OTHERS THEN
5378: clear_aging_buckets;
5379: IF DBMS_SQL.is_open(cursor_id) THEN
5380: DBMS_SQL.close_cursor(cursor_id);
5381: END IF;
5382: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5383: error_msg := FND_MESSAGE.get;

Line 5380: DBMS_SQL.close_cursor(cursor_id);

5376: EXCEPTION
5377: WHEN OTHERS THEN
5378: clear_aging_buckets;
5379: IF DBMS_SQL.is_open(cursor_id) THEN
5380: DBMS_SQL.close_cursor(cursor_id);
5381: END IF;
5382: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5383: error_msg := FND_MESSAGE.get;
5384: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,