APPS.MSC_E1APS_DSMCOLL dependencies on MSC_APPS_INSTANCES

Line 96: from msc_apps_instances

92: WSURL := fnd_profile.value('MSC_E1APS_ODIURL');
93: IF WSURL IS NOT NULL THEN
94: /* Launching Pre-Process Custom Hook ODI Scenario */
95: select instance_code into l_instance_code
96: from msc_apps_instances
97: where instance_id = parInstanceID;
98:
99: scenario_name := 'PREPROCESSHOOKPKG';
100: scenario_version := '001';

Line 119: select ATTRIBUTE14,ATTRIBUTE13 into source_file,destination_file from MSC_APPS_INSTANCES where INSTANCE_ID = parInstanceID;

115: RETURN;
116: END IF;
117: END IF;
118:
119: select ATTRIBUTE14,ATTRIBUTE13 into source_file,destination_file from MSC_APPS_INSTANCES where INSTANCE_ID = parInstanceID;
120:
121: /* Bug#8224935 - APP ID */
122: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID',
123: 'COMP_PTP',

Line 253: from msc_apps_instances

249: END IF;
250:
251: /* Launching Post-Process Custom Hook ODI Scenario */
252: select instance_code into l_instance_code
253: from msc_apps_instances
254: where instance_id = parInstanceID;
255:
256: scenario_name := 'POSTPROCESSHOOKPKG';
257: scenario_version := '001';