APPS.MSC_CL_COPY_STG_TBL dependencies on MSC_APPS_INSTANCES

Line 34: FROM msc_apps_instances

30: CURSOR source_instances IS
31: SELECT m2a_dblink
32: , instance_id
33: , instance_code
34: FROM msc_apps_instances
35: WHERE
36: m2a_dblink IS NOT NULL;
37:
38: lv_sql_stmt VARCHAR2 (1000);

Line 206: FROM MSC_APPS_INSTANCES

202: NULL,'',
203: '@'||M2A_DBLINK)
204: , INSTANCE_CODE||':'
205: INTO v_dblink, v_icode
206: FROM MSC_APPS_INSTANCES
207: WHERE
208: INSTANCE_ID=v_instance_id;
209:
210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'DB Link 1 : '|| v_dblink ||':'|| v_icode);

Line 226: -- Now get the parameters from msc_apps_instances of the source ASCP

222: ERRBUF := SQLERRM;
223: RETURN;
224: END;
225:
226: -- Now get the parameters from msc_apps_instances of the source ASCP
227: -- instance
228:
229: BEGIN
230: v_sql_stmt:=

Line 237: 'FROM MSC_APPS_INSTANCES'||v_dblink ||

233: 'COLLECTIONS_START_TIME, ' ||
234: 'SO_TBL_STATUS, ' ||
235: 'SO_LRTYPE,'||
236: 'LRTYPE '||
237: 'FROM MSC_APPS_INSTANCES'||v_dblink ||
238: ' WHERE ' ||
239: ' ST_STATUS IN (' || to_char(MSC_UTIL.G_ST_READY)||','||to_char(MSC_UTIL.G_ST_COLLECTING)||')'||
240: ' AND instance_id = ' || to_char(pINSTANCE_ID);
241:

Line 274: -- Now update msc_apps_instances

270: RETURN;
271:
272: END IF;
273: BEGIN
274: -- Now update msc_apps_instances
275: UPDATE MSC_APPS_INSTANCES
276: SET
277: COLLECTIONS_START_TIME = lv_coll_start_time,
278: SO_TBL_STATUS = lv_so_tbl_status,

Line 275: UPDATE MSC_APPS_INSTANCES

271:
272: END IF;
273: BEGIN
274: -- Now update msc_apps_instances
275: UPDATE MSC_APPS_INSTANCES
276: SET
277: COLLECTIONS_START_TIME = lv_coll_start_time,
278: SO_TBL_STATUS = lv_so_tbl_status,
279: LRTYPE =lv_lrtype,

Line 306: --harshit - This code has been commented out since we achieve the same in the previous update of msc_apps_instances

302: -- Now call the procedures to copy the staging table data.
303: v_retcode := 0;
304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Update statement is '||lv_lrtype);
305: /*
306: --harshit - This code has been commented out since we achieve the same in the previous update of msc_apps_instances
307: lv_sql_stmt := 'update msc_apps_instances set lrtype = (select lrtype from msc_apps_instances'||
308: v_dblink||'where instance_id = '||v_src_instance_id||') where instance_id = '||v_inst_rp_src_id;
309:
310: EXECUTE IMMEDIATE lv_sql_stmt;

Line 307: lv_sql_stmt := 'update msc_apps_instances set lrtype = (select lrtype from msc_apps_instances'||

303: v_retcode := 0;
304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Update statement is '||lv_lrtype);
305: /*
306: --harshit - This code has been commented out since we achieve the same in the previous update of msc_apps_instances
307: lv_sql_stmt := 'update msc_apps_instances set lrtype = (select lrtype from msc_apps_instances'||
308: v_dblink||'where instance_id = '||v_src_instance_id||') where instance_id = '||v_inst_rp_src_id;
309:
310: EXECUTE IMMEDIATE lv_sql_stmt;
311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Update statement is '||lv_sql_stmt);*/

Line 463: lv_sql_stmt := 'update msc_apps_instances'||v_dblink||

459: */
460:
461: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Reaches after Copy,Value of v_retcode = '|| v_retcode);
462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Reaches after Copy,Value of RETCODE = '|| RETCODE);
463: lv_sql_stmt := 'update msc_apps_instances'||v_dblink||
464: ' set staging_copy_complete = 1 '||
465: ' where instance_id = '||pINSTANCE_ID;
466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Update statement is '||lv_sql_stmt);
467:

Line 472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Reaches after update of msc_apps_instances');

468: EXECUTE IMMEDIATE lv_sql_stmt;
469: --USING v_instance_id;
470:
471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Reaches after update,Value of v_dblink = '|| v_dblink);
472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Reaches after update of msc_apps_instances');
473: EXCEPTION
474: WHEN OTHERS THEN
475: ROLLBACK;
476: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'An Error was encountered during the copy');