APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on STANDARD

Line 1754: lv_standard_ret NUMBER;

1750: lv_initialization_flag NUMBER:= 2;
1751: lv_task_start_time DATE;
1752: lv_elapsed_mins NUMBER;
1753:
1754: lv_standard_ret NUMBER;
1755: lv_wfd_ret_code NUMBER;
1756: lv_wfd_err_msg VARCHAR2(400);
1757: lv_last_ref_type VARCHAR2(8);
1758:

Line 2128: lv_standard_ret :=

2124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Exploding SMC demand, LRN: ' || to_char (v_lrn));
2125:
2126: lv_task_start_time := SYSDATE;
2127:
2128: lv_standard_ret :=
2129: MRP_EXPL_STD_MANDATORY.Explode_ATO_SM_COMPS(v_lrn);
2130:
2131: lv_elapsed_mins :=
2132: CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;

Line 2136: IF lv_standard_ret = 2 THEN

2132: CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;
2133:
2134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, to_char(lv_elapsed_mins)|| ' Minutes Elapsed.');
2135:
2136: IF lv_standard_ret = 2 THEN
2137: RAISE CONFIG_BOM_NOT_FOUND;
2138: END IF;
2139:
2140: END IF;

Line 2234: IF lv_standard_ret = 2 AND RETCODE = G_WARNING THEN

2230: pINSTANCE_CODE,
2231: pA2M_DBLINK;
2232: COMMIT;
2233:
2234: IF lv_standard_ret = 2 AND RETCODE = G_WARNING THEN
2235: RETCODE := G_WARNING;
2236: ELSE
2237: RETCODE:= G_SUCCESS;
2238: END IF;