DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on FND_INSTALLATION

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

370:
371:
372: BEGIN
373:
374: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
375: x_create_index := FALSE;
376: x_partitioned := FALSE;
377:
378: BEGIN

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

970: AND b.application_id = p_apps_id;
971:
972: ELSE
973: lv_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_apps_id);
974: lv_retval := FND_INSTALLATION.GET_APP_INFO (lv_prod_short_name, lv_dummy1, lv_dummy2, lv_schema);
975: END IF;
976:
977: RETURN lv_schema;
978:

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

1166:
1167: PRAGMA AUTONOMOUS_TRANSACTION ;
1168:
1169: Begin
1170: --bug #3777761 modified cursor c_obj and retrived owner value using function FND_INSTALLATION.GET_APP_INFO.
1171: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
1172:
1173: open c_obj(P_Table_Name , v_msc_schema);
1174: fetch c_obj into l_var;

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

1167: PRAGMA AUTONOMOUS_TRANSACTION ;
1168:
1169: Begin
1170: --bug #3777761 modified cursor c_obj and retrived owner value using function FND_INSTALLATION.GET_APP_INFO.
1171: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
1172:
1173: open c_obj(P_Table_Name , v_msc_schema);
1174: fetch c_obj into l_var;
1175: close c_obj;

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

1258: l_schema VARCHAR2(30);
1259: l_prod_short_name VARCHAR2(30);
1260: BEGIN
1261: l_prod_short_name := AD_TSPACE_UTIL.get_product_short_name(p_product);
1262: IF fnd_installation.get_app_info(l_prod_short_name, l_status, l_industry, l_schema) <> TRUE THEN
1263: RETURN FALSE;
1264: ELSE
1265: IF l_status = 'I' THEN
1266: RETURN TRUE;