APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on STANDARD

Line 1870: lv_standard_ret NUMBER;

1866: lv_initialization_flag NUMBER:= 2;
1867: lv_task_start_time DATE;
1868: lv_elapsed_mins NUMBER;
1869:
1870: lv_standard_ret NUMBER;
1871: lv_wfd_ret_code NUMBER;
1872: lv_wfd_err_msg VARCHAR2(400);
1873: lv_last_ref_type VARCHAR2(8);
1874:

Line 2360: lv_standard_ret :=

2356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Exploding SMC demand, LRN: ' || to_char (v_lrn));
2357:
2358: lv_task_start_time := SYSDATE;
2359:
2360: lv_standard_ret :=
2361: MRP_EXPL_STD_MANDATORY.Explode_ATO_SM_COMPS(v_lrn);
2362:
2363: lv_elapsed_mins :=
2364: CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;

Line 2368: IF lv_standard_ret = 2 THEN

2364: CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;
2365:
2366: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, to_char(lv_elapsed_mins)|| ' Minutes Elapsed.');
2367:
2368: IF lv_standard_ret = 2 THEN
2369: RAISE CONFIG_BOM_NOT_FOUND;
2370: END IF;
2371:
2372: END IF;

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

2462: pINSTANCE_CODE,
2463: pA2M_DBLINK;
2464: COMMIT;
2465:
2466: IF lv_standard_ret = 2 AND RETCODE = G_WARNING THEN
2467: RETCODE := G_WARNING;
2468: ELSE
2469: RETCODE:= G_SUCCESS;
2470: END IF;