APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_VISITS

Line 41: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',

37: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
38: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
39: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
40: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
41: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',
42: MSC_CL_COLLECTION.v_instance_id,
43: -1);
44: ELSE
45: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 46: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',

42: MSC_CL_COLLECTION.v_instance_id,
43: -1);
44: ELSE
45: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
46: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_VISITS',
47: MSC_CL_COLLECTION.v_instance_id,
48: null,
49: v_sub_str);
50: END IF;

Line 57: lv_tbl:= 'MSC_VISITS';

53: BEGIN
54: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
55: lv_tbl:= 'VISITS_'||MSC_CL_COLLECTION.v_instance_code;
56: ELSE
57: lv_tbl:= 'MSC_VISITS';
58: END IF;
59: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
60: 'In Procedure LOAD_VISITS lv_tbl'||lv_tbl);
61:

Line 132: DELETE MSC_VISITS

128: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
129: AND VISIT_ID = c_rec.visit_id
130: AND ORGANIZATION_ID = c_rec.organization_id;
131:
132: DELETE MSC_VISITS
133: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
134: AND VISIT_ID = c_rec.visit_id
135: AND ORGANIZATION_ID = c_rec.organization_id;
136:

Line 150: UPDATE MSC_VISITS

146: COMMIT;
147:
148: FOR c_rec IN c1 LOOP
149:
150: UPDATE MSC_VISITS
151: SET
152: VISIT_DESC = c_rec.VISIT_DESC,
153: VISIT_NAME = c_rec.VISIT_NAME,
154: VISIT_START_DATE = c_rec.VISIT_START_DATE,

Line 229: 'MSC_VISITS',

225:
226: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
227: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
228: lv_retcode,
229: 'MSC_VISITS',
230: MSC_CL_COLLECTION.v_INSTANCE_CODE,
231: MSC_UTIL.G_ERROR);
232:
233: IF lv_retcode = MSC_UTIL.G_ERROR THEN