DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on FND_PROFILE

Line 78: x_return_value := fnd_profile.save (

74: RETURN NUMBER
75: IS
76: x_return_value BOOLEAN;
77: BEGIN
78: x_return_value := fnd_profile.save (
79: p_profile_code,
80: p_profile_value,
81: p_profile_level);
82: IF (x_return_value)

Line 106: x_category_set_id := fnd_profile.value ('MSD_DEM_CATEGORY_SET_NAME');

102: RETURN NUMBER
103: IS
104: x_category_set_id NUMBER := -1;
105: BEGIN
106: x_category_set_id := fnd_profile.value ('MSD_DEM_CATEGORY_SET_NAME');
107: RETURN x_category_set_id;
108: EXCEPTION
109: WHEN OTHERS THEN
110: RETURN NULL;

Line 122: x_conversion_type := fnd_profile.value ('MSD_DEM_CONVERSION_TYPE');

118: RETURN VARCHAR2
119: IS
120: x_conversion_type VARCHAR2(100) := NULL;
121: BEGIN
122: x_conversion_type := fnd_profile.value ('MSD_DEM_CONVERSION_TYPE');
123: RETURN x_conversion_type;
124: EXCEPTION
125: WHEN OTHERS THEN
126: RETURN NULL;

Line 153: x_master_organization := fnd_profile.value ('MSD_DEM_MASTER_ORG');

149: x_multi_org_flag := 'Y';
150:
151: END;
152:
153: x_master_organization := fnd_profile.value ('MSD_DEM_MASTER_ORG');
154:
155: IF (x_multi_org_flag = 'Y')
156: THEN
157: IF (x_master_organization IS NULL)

Line 194: x_customer_attribute := fnd_profile.value ('MSD_DEM_CUSTOMER_ATTRIBUTE');

190: RETURN VARCHAR2
191: IS
192: x_customer_attribute VARCHAR2(100) := NULL;
193: BEGIN
194: x_customer_attribute := fnd_profile.value ('MSD_DEM_CUSTOMER_ATTRIBUTE');
195: RETURN x_customer_attribute;
196: EXCEPTION
197: WHEN OTHERS THEN
198: RETURN NULL;

Line 833: var_organization_id := fnd_profile.value ('MSD_SPF_MASTER_ORG');

829: RETURN VARCHAR2
830: IS
831: var_organization_id VARCHAR2(100) DEFAULT NULL;
832: BEGIN
833: var_organization_id := fnd_profile.value ('MSD_SPF_MASTER_ORG');
834: RETURN var_organization_id;
835: EXCEPTION
836: WHEN OTHERS THEN
837: RETURN NULL;