APPS.MSD_PURGE_LEG dependencies on MSC_APPS_INSTANCES

Line 76: UPDATE msc_apps_instances

72: IF v_debug THEN
73: msc_st_util.log_message ('Truncation flag is YES. Entering in truncation LOOP');
74: END IF;
75:
76: UPDATE msc_apps_instances
77: SET st_status= G_ST_PURGING;
78: COMMIT;
79:
80: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSD', lv_dummy1, lv_dummy2, v_applsys_schema);

Line 121: UPDATE msc_apps_instances

117:
118: END LOOP;
119: CLOSE table_names;
120:
121: UPDATE msc_apps_instances
122: SET st_status= G_ST_EMPTY;
123: COMMIT;
124:
125: ELSE --IF (lv_truncation_flag = SYS_YES) THEN

Line 258: FROM msc_apps_instances

254:
255: BEGIN
256:
257: SELECT ST_STATUS INTO lv_staging_table_status
258: FROM msc_apps_instances
259: WHERE INSTANCE_CODE= pINSTANCE_CODE
260: FOR UPDATE;
261:
262: IF v_debug THEN

Line 328: UPDATE msc_apps_instances

324: RETURN FALSE;
325:
326:
327: ELSE
328: UPDATE msc_apps_instances
329: SET st_status=G_ST_PURGING
330: WHERE INSTANCE_CODE= pINSTANCE_CODE;
331: COMMIT;
332:

Line 364: FROM msc_apps_instances

360:
361:
362: CURSOR instance_codes ( cp_instance_id NUMBER ) IS
363: SELECT instance_code,instance_type,instance_id,st_status
364: FROM msc_apps_instances
365: WHERE ( cp_instance_id = -1 or instance_id=cp_instance_id );
366:
367:
368: -- Cursor P is for update to lock the records before checking for the st_status.

Line 372: FROM msc_apps_instances

368: -- Cursor P is for update to lock the records before checking for the st_status.
369:
370: CURSOR p (cp_instance_id NUMBER ) IS
371: SELECT instance_code
372: FROM msc_apps_instances
373: WHERE st_status NOT IN (G_ST_PULLING,G_ST_COLLECTING,G_ST_PRE_PROCESSING)
374: AND ( cp_instance_id= -1 or instance_id=cp_instance_id )
375: FOR UPDATE;
376:

Line 379: FROM msc_apps_instances;

375: FOR UPDATE;
376:
377: CURSOR total_instances IS
378: SELECT count(*)
379: FROM msc_apps_instances;
380:
381: CURSOR staging_status (cp_instance_id NUMBER ) IS
382: SELECT count(*)
383: FROM msc_apps_instances

Line 383: FROM msc_apps_instances

379: FROM msc_apps_instances;
380:
381: CURSOR staging_status (cp_instance_id NUMBER ) IS
382: SELECT count(*)
383: FROM msc_apps_instances
384: WHERE st_status IN ( G_ST_PULLING,G_ST_COLLECTING,G_ST_PRE_PROCESSING )
385: AND ((instance_id=cp_instance_id) OR (cp_instance_id=-1));
386:
387:

Line 394: lv_instance_code MSC_APPS_INSTANCES.INSTANCE_CODE%TYPE;

390: lv_p_instance_id NUMBER ;
391:
392:
393: -- variable for cursor instance_codes
394: lv_instance_code MSC_APPS_INSTANCES.INSTANCE_CODE%TYPE;
395: lv_st_status MSC_APPS_INSTANCES.ST_STATUS%TYPE;
396: lv_instance_type MSC_APPS_INSTANCES.INSTANCE_TYPE%TYPE;
397: lv_instance_id MSC_APPS_INSTANCES.INSTANCE_ID%TYPE;
398:

Line 395: lv_st_status MSC_APPS_INSTANCES.ST_STATUS%TYPE;

391:
392:
393: -- variable for cursor instance_codes
394: lv_instance_code MSC_APPS_INSTANCES.INSTANCE_CODE%TYPE;
395: lv_st_status MSC_APPS_INSTANCES.ST_STATUS%TYPE;
396: lv_instance_type MSC_APPS_INSTANCES.INSTANCE_TYPE%TYPE;
397: lv_instance_id MSC_APPS_INSTANCES.INSTANCE_ID%TYPE;
398:
399: lv_inst_flag NUMBER := 0 ;

Line 396: lv_instance_type MSC_APPS_INSTANCES.INSTANCE_TYPE%TYPE;

392:
393: -- variable for cursor instance_codes
394: lv_instance_code MSC_APPS_INSTANCES.INSTANCE_CODE%TYPE;
395: lv_st_status MSC_APPS_INSTANCES.ST_STATUS%TYPE;
396: lv_instance_type MSC_APPS_INSTANCES.INSTANCE_TYPE%TYPE;
397: lv_instance_id MSC_APPS_INSTANCES.INSTANCE_ID%TYPE;
398:
399: lv_inst_flag NUMBER := 0 ;
400: lv_st_status_flag NUMBER:= 0;

Line 397: lv_instance_id MSC_APPS_INSTANCES.INSTANCE_ID%TYPE;

393: -- variable for cursor instance_codes
394: lv_instance_code MSC_APPS_INSTANCES.INSTANCE_CODE%TYPE;
395: lv_st_status MSC_APPS_INSTANCES.ST_STATUS%TYPE;
396: lv_instance_type MSC_APPS_INSTANCES.INSTANCE_TYPE%TYPE;
397: lv_instance_id MSC_APPS_INSTANCES.INSTANCE_ID%TYPE;
398:
399: lv_inst_flag NUMBER := 0 ;
400: lv_st_status_flag NUMBER:= 0;
401: lv_trunc_profile BOOLEAN:=FALSE;

Line 432: -- locking the records in msc_apps_instances before checking the st_status

428: OPEN total_instances;
429: FETCH total_instances into lv_inst_flag;
430: CLOSE total_instances;
431:
432: -- locking the records in msc_apps_instances before checking the st_status
433:
434: open p(lv_p_instance_id);
435: close p;
436:

Line 509: UPDATE msc_apps_instances

505: IF v_debug THEN
506: msc_st_util.log_message ('Setting the st_status to empty');
507: END IF;
508:
509: UPDATE msc_apps_instances
510: SET st_status=G_ST_EMPTY
511: WHERE instance_code=lv_instance_code;
512: COMMIT;
513: