DBA Data[Home] [Help]

APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_TMP_BIG_IN_COND

Line 269: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, VARIABLE_ID, VALUE_N, VALUE_V)

265: PRAGMA AUTONOMOUS_TRANSACTION;
266: BEGIN
267: g_progressCounter := g_progressCounter+1;
268:
269: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, VARIABLE_ID, VALUE_N, VALUE_V)
270: values (USERENV('SESSIONID'), -200, g_progressCounter,
271: pStage||' '||pMessage||' '||bsc_mo_helper_pkg.get_time);
272: commit;
273: EXCEPTION WHEN others then

Line 1027: delete bsc_tmp_big_in_cond where variable_id = -200;

1023: BEGIN
1024: gGAA_RUN_MODE := p_runMode;
1025: g_retcode := 0;
1026: g_processID := p_processID;
1027: delete bsc_tmp_big_in_cond where variable_id = -200;
1028: Setup;
1029: Init_Locks;
1030: Initialize;
1031: run_metadata_optimizer_pvt;