APPS.AMS_SOURCECODE_PVT dependencies on FND_PROFILE

Line 145: l_loc_hierarchy_id := TO_NUMBER (FND_PROFILE.value (L_CITY_PROFILE));

141: BEGIN
142: --
143: -- Pattern: AAA
144: -- User's geographic code
145: l_loc_hierarchy_id := TO_NUMBER (FND_PROFILE.value (L_CITY_PROFILE));
146:
147: -- Use AREA1 if the object is global
148: OPEN c_geo_code (p_global_flag, l_loc_hierarchy_id);
149: FETCH c_geo_code INTO l_geo_code;

Line 161: l_date_pattern := FND_PROFILE.value (L_DATE_PROFILE);

157:
158: --
159: -- Pattern: MMYY
160: -- Date pattern used to denote month and year
161: l_date_pattern := FND_PROFILE.value (L_DATE_PROFILE);
162:
163: --
164: -- choang - 18-May-2000
165: -- Added additional error handling for missing date

Line 871: l_sequence_length := TO_NUMBER (FND_PROFILE.value (L_LENGTH_PROFILE));

867: WHERE gde.scode_char_element = x_code_key
868: FOR UPDATE
869: ;
870: BEGIN
871: l_sequence_length := TO_NUMBER (FND_PROFILE.value (L_LENGTH_PROFILE));
872: l_code_chars := p_geo_code || p_date_code || p_cust_code;
873:
874: --
875: -- choang - 18-May-2000