APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_WORK_BREAKDOWN_STRUCT

Line 4881: DELETE MSC_WORK_BREAKDOWN_STRUCT

4877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WBS- Inst :'||MSC_CL_COLLECTION.v_instance_id );
4878: FOR c_rec IN c_del LOOP
4879: BEGIN
4880:
4881: DELETE MSC_WORK_BREAKDOWN_STRUCT
4882: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
4883: AND PARAMETER_NAME = c_rec.parameter_name
4884: AND ORGANIZATION_ID = c_rec.organization_id;
4885:

Line 4904: UPDATE MSC_WORK_BREAKDOWN_STRUCT

4900: BEGIN
4901:
4902: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
4903:
4904: UPDATE MSC_WORK_BREAKDOWN_STRUCT
4905: SET DISPLAY_NAME = c_rec.DISPLAY_NAME,
4906: REFRESH_ID = MSC_CL_COLLECTION.v_last_collection_id,
4907: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
4908: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 4916: INSERT INTO MSC_WORK_BREAKDOWN_STRUCT (

4912:
4913:
4914: END IF;
4915: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
4916: INSERT INTO MSC_WORK_BREAKDOWN_STRUCT (
4917: PARAMETER_NAME,
4918: DISPLAY_NAME,
4919: ORGANIZATION_ID,
4920: REFRESH_ID,