APPS.MSC_E1APS_DEMCL dependencies on MSC_APPS_INSTANCES

Line 135: from msc_apps_instances

131: odi_url := fnd_profile.value('MSC_E1APS_ODIURL'); --Checking ODI Profile
132: IF odi_url IS NOT NULL THEN
133:
134: select instance_code into l_instance_code
135: from msc_apps_instances
136: where instance_id = p_instance_id;
137:
138: scenario_name := 'PREPROCESSHOOKPKG';
139: scenario_version := '001';

Line 270: from msc_apps_instances

266: odi_url := fnd_profile.value('MSC_E1APS_ODIURL'); --Checking ODI Profile
267: IF odi_url IS NOT NULL THEN
268:
269: select instance_code into l_instance_code
270: from msc_apps_instances
271: where instance_id = p_instance_id;
272:
273: scenario_name := 'POSTPROCESSHOOKPKG';
274: scenario_version := '001';

Line 356: select instance_code into l_instance_code from msc_apps_instances

352: /*Checking ODI Profile */
353: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
354: IF odi_url IS NOT NULL THEN
355: /* Launching Pre-Process Custom Hook ODI Scenario */
356: select instance_code into l_instance_code from msc_apps_instances
357: where instance_id = p_instance_id;
358:
359: scenario_name := 'PREPROCESSHOOKPKG';
360: scenario_version := '001';

Line 390: /* Accessing instance_id from MSC_APPS_INSTANCES*/

386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Truncated from T_SRC_SALES_TMPL');
387: RETCODE := MSC_UTIL.G_ERROR;
388: RETURN;
389: END;
390: /* Accessing instance_id from MSC_APPS_INSTANCES*/
391: SELECT ATTRIBUTE13,
392: ATTRIBUTE12,
393: ATTRIBUTE13,
394: ATTRIBUTE14

Line 399: FROM MSC_APPS_INSTANCES

395: INTO p_data_path ,
396: p_control_path ,
397: destination_file,
398: source_file
399: FROM MSC_APPS_INSTANCES
400: WHERE INSTANCE_ID = p_instance_id;
401:
402: BEGIN
403: /* Step 1: Deleting all rows and extracting data from MSC_CALENDARS */

Line 437: MSC_APPS_INSTANCES MAI

433: MC.CREATION_DATE ,
434: MC.CREATED_BY ,
435: MC.LAST_UPDATE_LOGIN
436: FROM MSC_CALENDARS MC,
437: MSC_APPS_INSTANCES MAI
438: WHERE MC.SR_INSTANCE_ID = p_instance_id
439: AND MAI.INSTANCE_ID = MC.SR_INSTANCE_ID;
440:
441: COMMIT;

Line 648: select instance_code into l_instance_code from msc_apps_instances

644: /* Checking ODI Profile*/
645: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
646: IF odi_url IS NOT NULL THEN
647: /* Launching Pre-Process Custom Hook ODI Scenario */
648: select instance_code into l_instance_code from msc_apps_instances
649: where instance_id = p_instance_id;
650:
651: scenario_name := 'PREPROCESSHOOKPKG';
652: scenario_version := '001';

Line 705: FROM MSC_APPS_INSTANCES

701: SELECT ATTRIBUTE14,
702: ATTRIBUTE13
703: INTO source_file,
704: destination_file
705: FROM MSC_APPS_INSTANCES
706: WHERE INSTANCE_ID = p_instance_id;
707:
708: /* Bug#8224935 - APP ID */
709: l_user_id := to_number(msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_PTP', 1, 'user_id'));

Line 956: select instance_code into l_instance_code from msc_apps_instances

952: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
953:
954: IF odi_url IS NOT NULL THEN
955: /* Launching Pre-Process Custom Hook ODI Scenario */
956: select instance_code into l_instance_code from msc_apps_instances
957: where instance_id = p_instance_id;
958:
959: scenario_name := 'PREPROCESSHOOKPKG';
960: scenario_version := '001';

Line 1127: select instance_code into l_instance_code from msc_apps_instances

1123: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1124:
1125: IF odi_url IS NOT NULL THEN
1126: /* Launching Pre-Process Custom Hook ODI Scenario */
1127: select instance_code into l_instance_code from msc_apps_instances
1128: where instance_id = p_instance_id;
1129:
1130: scenario_name := 'PREPROCESSHOOKPKG';
1131: scenario_version := '001';

Line 1306: from msc_apps_instances

1302: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1303: IF odi_url IS NOT NULL THEN
1304: /* Launching Pre-Process Custom Hook ODI Scenario */
1305: select instance_code into l_instance_code
1306: from msc_apps_instances
1307: where instance_id = p_instance_id;
1308:
1309: scenario_param := 'E1TOAPSPROJECT.PVV_PRE_PROCESS_VAR=';
1310: scenario_param := scenario_param

Line 1496: from msc_apps_instances

1492: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
1493: IF odi_url IS NOT NULL THEN
1494: /* Updating ODI Pre-Process custom hook scenario_param */
1495: select instance_code into l_instance_code
1496: from msc_apps_instances
1497: where instance_id = p_instance_id;
1498:
1499: scenario_param := 'E1TOAPSPROJECT.PVV_PRE_PROCESS_VAR=';
1500: scenario_param := scenario_param