APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_WORK_BREAKDOWN_STRUCT

Line 636: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',

632: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
633: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
634: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
635: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
636: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',
637: MSC_CL_COLLECTION.v_instance_id,
638: -1);
639: ELSE
640: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 641: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',

637: MSC_CL_COLLECTION.v_instance_id,
638: -1);
639: ELSE
640: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
641: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WORK_BREAKDOWN_STRUCT',
642: MSC_CL_COLLECTION.v_instance_id,
643: null,
644: v_sub_str);
645: END IF;

Line 654: lv_tbl:= 'MSC_WORK_BREAKDOWN_STRUCT';

650: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
651: lv_tbl:= 'WORK_BREAKDOWN_STRUCT_'
652: ||MSC_CL_COLLECTION.v_instance_code;
653: ELSE
654: lv_tbl:= 'MSC_WORK_BREAKDOWN_STRUCT';
655: END IF;
656:
657: lv_cursor_stmt:=
658: 'INSERT INTO '||lv_tbl

Line 702: DELETE MSC_WORK_BREAKDOWN_STRUCT

698: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR
699: MSC_CL_COLLECTION.v_is_legacy_refresh THEN
700: FOR c_rec IN c_del LOOP
701: BEGIN
702: DELETE MSC_WORK_BREAKDOWN_STRUCT
703: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
704: AND PARAMETER_NAME = c_rec.parameter_name
705: AND ORGANIZATION_ID = c_rec.organization_id;
706:

Line 718: UPDATE MSC_WORK_BREAKDOWN_STRUCT

714:
715: END LOOP;
716: COMMIT;
717: FOR c_rec IN c1 LOOP
718: UPDATE MSC_WORK_BREAKDOWN_STRUCT
719: SET DISPLAY_NAME = c_rec.DISPLAY_NAME,
720: REFRESH_ID = MSC_CL_COLLECTION.v_last_collection_id,
721: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
722: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 768: 'MSC_WORK_BREAKDOWN_STRUCT',

764:
765: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
766: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
767: lv_retcode,
768: 'MSC_WORK_BREAKDOWN_STRUCT',
769: MSC_CL_COLLECTION.v_INSTANCE_CODE,
770: MSC_UTIL.G_ERROR);
771:
772: IF lv_retcode = MSC_UTIL.G_ERROR THEN