DBA Data[Home] [Help]

APPS.GMD_TECH_PARAMS dependencies on FND_PROFILE

Line 533: X_mass_type := FND_PROFILE.VALUE('LM$UOM_MASS_TYPE');

529: X_vol_ind := 1;
530: END IF;
531: END LOOP;
532: IF (X_mass_ind = 1) THEN
533: X_mass_type := FND_PROFILE.VALUE('LM$UOM_MASS_TYPE');
534: OPEN Cur_get_um(X_mass_type);
535: FETCH Cur_get_um INTO X_mass_um;
536: IF (Cur_get_um%NOTFOUND) THEN
537: CLOSE Cur_get_um;

Line 543: X_vol_type := FND_PROFILE.VALUE('LM$UOM_VOLUME_TYPE');

539: END IF;
540: CLOSE Cur_get_um;
541: END IF;
542: IF (X_vol_ind = 1) THEN
543: X_vol_type := FND_PROFILE.VALUE('LM$UOM_VOLUME_TYPE');
544: OPEN Cur_get_um(X_vol_type);
545: FETCH Cur_get_um INTO X_vol_um;
546: IF (Cur_get_um%NOTFOUND) THEN
547: CLOSE Cur_get_um;

Line 995: IF FND_PROFILE.DEFINED('GEMMS_DEFAULT_LAB_TYPE') THEN

991: END IF;
992:
993: /* If no value was been sent in or it was not a valid lab type, get the default lab type */
994: IF (x_lab_type IS NULL) THEN
995: IF FND_PROFILE.DEFINED('GEMMS_DEFAULT_LAB_TYPE') THEN
996: x_lab_type := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');
997: ELSE
998: /* No default lab type, raise an error */
999: RAISE NO_LAB_TYPE;

Line 996: x_lab_type := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');

992:
993: /* If no value was been sent in or it was not a valid lab type, get the default lab type */
994: IF (x_lab_type IS NULL) THEN
995: IF FND_PROFILE.DEFINED('GEMMS_DEFAULT_LAB_TYPE') THEN
996: x_lab_type := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');
997: ELSE
998: /* No default lab type, raise an error */
999: RAISE NO_LAB_TYPE;
1000: END IF;