DBA Data[Home] [Help]

APPS.MSC_PURGE_LID dependencies on DUAL

Line 1919: SELECT REPLACE(lv_inst_str,'''','') INTO lv_inst_str FROM DUAL;

1915:
1916:
1917: -- make inst str number only
1918:
1919: SELECT REPLACE(lv_inst_str,'''','') INTO lv_inst_str FROM DUAL;
1920:
1921: --
1922:
1923: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Delete Rows for Instance *******');

Line 2319: SELECT REPLACE(lv_plan_str,'''','') INTO lv_plan_str FROM DUAL;

2315: END;
2316:
2317: -- change plan list to number only
2318:
2319: SELECT REPLACE(lv_plan_str,'''','') INTO lv_plan_str FROM DUAL;
2320:
2321: --
2322:
2323: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Delete Rows for plan***********');