APPS.MSC_RELEASE_PK dependencies on MSC_APPS_INSTANCES

Line 649: FROM MSC_APPS_INSTANCES

645: INTO var_allow_release,
646: var_instance_code,
647: var_apps_ver,
648: var_dblink
649: FROM MSC_APPS_INSTANCES
650: WHERE INSTANCE_ID= lv_arg_instance_id_new;
651:
652: if ( var_apps_ver >= 3 ) then
653:

Line 731: FROM MSC_APPS_INSTANCES

727: SELECT DECODE( M2A_DBLINK, NULL, ' ', '@'||M2A_DBLINK),
728: APPS_VER
729: INTO var_dblink,
730: var_apps_ver
731: FROM MSC_APPS_INSTANCES
732: WHERE INSTANCE_ID= lv_arg_instance_id_new;
733:
734: --Fix for the bug#2538765. This enables the auto-release to use the user level
735: --profile value defined in the source instance.

Line 1533: from msc_apps_instances

1529: FOR i IN 1..var_released_instance_id.count LOOP
1530:
1531: select instance_code
1532: into lv_instance_code
1533: from msc_apps_instances
1534: where instance_id= var_released_instance_id(i);
1535:
1536: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1537: fnd_message.set_token('INSTANCE', lv_instance_code);

Line 1683: from msc_apps_instances

1679:
1680: FOR i IN 1..var_count_po LOOP
1681: select instance_code
1682: into lv_instance_code
1683: from msc_apps_instances
1684: where instance_id= var_released_instance(i);
1685:
1686: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1687: fnd_message.set_token('INSTANCE', lv_instance_code);

Line 1723: lv_instance_code msc_apps_instances.INSTANCE_CODE%TYPE;

1719: v_owning_org_id NUMBER;
1720:
1721: i number;
1722: j number := 1;
1723: lv_instance_code msc_apps_instances.INSTANCE_CODE%TYPE;
1724:
1725: BEGIN
1726: --get instance_id and org_for the given plan.
1727: BEGIN

Line 1758: from msc_apps_instances

1754: FOR i IN 1..var_released_instance_id.count LOOP
1755:
1756: select instance_code
1757: into lv_instance_code
1758: from msc_apps_instances
1759: where instance_id= var_released_instance_id(i);
1760:
1761: REQ_ID(j).instanceCode := lv_instance_code;
1762: REQ_ID(j).ReqID := var_wip_req_id(i);

Line 1885: from msc_apps_instances

1881:
1882: FOR i IN 1..var_count_po LOOP
1883: select instance_code
1884: into lv_instance_code
1885: from msc_apps_instances
1886: where instance_id= var_released_instance(i);
1887:
1888: REQ_ID(j).instanceCode := lv_instance_code;
1889: REQ_ID(j).ReqID := '';