APPS.MSC_RELEASE_PK dependencies on MSC_APPS_INSTANCES

Line 529: FROM MSC_APPS_INSTANCES

525: INTO var_allow_release,
526: var_instance_code,
527: var_apps_ver,
528: var_dblink
529: FROM MSC_APPS_INSTANCES
530: WHERE INSTANCE_ID= arg_instance_id;
531:
532: if ( var_apps_ver >= 3 ) then
533:

Line 584: FROM MSC_APPS_INSTANCES

580: SELECT DECODE( M2A_DBLINK, NULL, ' ', '@'||M2A_DBLINK),
581: APPS_VER
582: INTO var_dblink,
583: var_apps_ver
584: FROM MSC_APPS_INSTANCES
585: WHERE INSTANCE_ID= arg_instance_id;
586:
587: --Fix for the bug#2538765. This enables the auto-release to use the user level
588: --profile value defined in the source instance.

Line 1227: from msc_apps_instances

1223: FOR i IN 1..var_released_instance_id.count LOOP
1224:
1225: select instance_code
1226: into lv_instance_code
1227: from msc_apps_instances
1228: where instance_id= var_released_instance_id(i);
1229:
1230: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1231: fnd_message.set_token('INSTANCE', lv_instance_code);

Line 1327: from msc_apps_instances

1323:
1324: FOR i IN 1..var_count_po LOOP
1325: select instance_code
1326: into lv_instance_code
1327: from msc_apps_instances
1328: where instance_id= var_released_instance(i);
1329:
1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);

Line 1367: lv_instance_code msc_apps_instances.INSTANCE_CODE%TYPE;

1363: v_owning_org_id NUMBER;
1364:
1365: i number;
1366: j number := 1;
1367: lv_instance_code msc_apps_instances.INSTANCE_CODE%TYPE;
1368:
1369: BEGIN
1370: --get instance_id and org_for the given plan.
1371: BEGIN

Line 1402: from msc_apps_instances

1398: FOR i IN 1..var_released_instance_id.count LOOP
1399:
1400: select instance_code
1401: into lv_instance_code
1402: from msc_apps_instances
1403: where instance_id= var_released_instance_id(i);
1404:
1405: REQ_ID(j).instanceCode := lv_instance_code;
1406: REQ_ID(j).ReqID := var_wip_req_id(i);

Line 1491: from msc_apps_instances

1487:
1488: FOR i IN 1..var_count_po LOOP
1489: select instance_code
1490: into lv_instance_code
1491: from msc_apps_instances
1492: where instance_id= var_released_instance(i);
1493:
1494: REQ_ID(j).instanceCode := lv_instance_code;
1495: REQ_ID(j).ReqID := '';