DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on FND_INSTALLATION

Line 359: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);

355:
356:
357: BEGIN
358:
359: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
360: x_create_index := FALSE;
361: x_partitioned := FALSE;
362:
363: BEGIN

Line 716: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);

712: AND b.application_id = p_apps_id;
713:
714: ELSE
715: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);
716: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
717: END IF;
718:
719: RETURN lv_schema;
720:

Line 912: --bug #3777761 modified cursor c_obj and retrived owner value using function FND_INSTALLATION.GET_APP_INFO.

908:
909: PRAGMA AUTONOMOUS_TRANSACTION ;
910:
911: Begin
912: --bug #3777761 modified cursor c_obj and retrived owner value using function FND_INSTALLATION.GET_APP_INFO.
913: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
914:
915: open c_obj(P_Table_Name , v_msc_schema);
916: fetch c_obj into l_var;

Line 913: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);

909: PRAGMA AUTONOMOUS_TRANSACTION ;
910:
911: Begin
912: --bug #3777761 modified cursor c_obj and retrived owner value using function FND_INSTALLATION.GET_APP_INFO.
913: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
914:
915: open c_obj(P_Table_Name , v_msc_schema);
916: fetch c_obj into l_var;
917: close c_obj;

Line 1004: IF fnd_installation.get_app_info(l_prod_short_name, l_status, l_industry, l_schema) <> TRUE THEN

1000: l_schema VARCHAR2(30);
1001: l_prod_short_name VARCHAR2(30);
1002: BEGIN
1003: l_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_product);
1004: IF fnd_installation.get_app_info(l_prod_short_name, l_status, l_industry, l_schema) <> TRUE THEN
1005: RETURN FALSE;
1006: ELSE
1007: IF l_status = 'I' THEN
1008: RETURN TRUE;