APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_WO_ATTRIBUTES

Line 292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',

288: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
289: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
290: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
291: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
292: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',
293: MSC_CL_COLLECTION.v_instance_id,
294: -1);
295: ELSE
296: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 297: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',

293: MSC_CL_COLLECTION.v_instance_id,
294: -1);
295: ELSE
296: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
297: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_ATTRIBUTES',
298: MSC_CL_COLLECTION.v_instance_id,
299: null,
300: v_sub_str);
301: END IF;

Line 310: lv_tbl:= 'MSC_WO_ATTRIBUTES';

306: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
307: lv_tbl:= 'WO_ATTRIBUTES_'||MSC_CL_COLLECTION.v_instance_code;
308: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
309: ELSE
310: lv_tbl:= 'MSC_WO_ATTRIBUTES';
311: lv_supplies_tbl:= 'MSC_SUPPLIES';
312: END IF;
313:
314: lv_cursor_stmt:=

Line 409: DELETE MSC_WO_ATTRIBUTES

405: (MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
406: FOR c1 IN c_del LOOP
407:
408: BEGIN
409: DELETE MSC_WO_ATTRIBUTES
410: WHERE SR_INSTANCE_ID= c1.sr_instance_id
411: AND VISIT_ID = c1.visit_id
412: AND SUPPLY_ID = c1.supply_id
413: AND ORGANIZATION_ID = c1.organization_id;

Line 463: UPDATE MSC_WO_ATTRIBUTES

459: OPEN c_ref_cur FOR lv_cursor_stmt;
460: LOOP
461: fetch c_ref_cur into c_rec;
462: exit when c_ref_cur%notfound;
463: UPDATE MSC_WO_ATTRIBUTES
464: SET
465: SERIAL_NUM = c_rec.SERIAL_NUM,
466: PRODUCES_TO_STOCK = c_rec.PRODUCES_TO_STOCK,
467: VISIT_ID = c_rec.VISIT_ID,

Line 593: 'MSC_WO_ATTRIBUTES',

589:
590: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
591: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
592: lv_retcode,
593: 'MSC_WO_ATTRIBUTES',
594: MSC_CL_COLLECTION.v_INSTANCE_CODE,
595: MSC_UTIL.G_ERROR);
596:
597: IF lv_retcode = MSC_UTIL.G_ERROR THEN