APPS.ARP_ADDR_LABEL_PKG dependencies on FND_TERRITORIES_VL

Line 132: || if country code is not defined in FND_TERRITORIES_VL

128: || country_code : country code
129: ||
130: || RETURN
131: || NULL :
132: || if country code is not defined in FND_TERRITORIES_VL
133: ||
134: || retrieved value from FND_TERRITORIES_VL :
135: || else
136: ||

Line 134: || retrieved value from FND_TERRITORIES_VL :

130: || RETURN
131: || NULL :
132: || if country code is not defined in FND_TERRITORIES_VL
133: ||
134: || retrieved value from FND_TERRITORIES_VL :
135: || else
136: ||
137: || NOTE
138: || retrieved value can be NULL

Line 143: st fnd_territories_vl.address_style%TYPE;

139: ||
140: =============================================================================*/
141: FUNCTION get_address_style( country_code VARCHAR2 ) return VARCHAR2 IS
142:
143: st fnd_territories_vl.address_style%TYPE;
144:
145: BEGIN
146:
147: select address_style into st from fnd_territories_vl

Line 147: select address_style into st from fnd_territories_vl

143: st fnd_territories_vl.address_style%TYPE;
144:
145: BEGIN
146:
147: select address_style into st from fnd_territories_vl
148: where territory_code = country_code;
149:
150: return( st );
151:

Line 182: || 2) if country_code is not defined in FND_TERRITORIES_vl table

178: || print_home_country_flag = 'N'
179: ||
180: || country_code :
181: || 1) if the retrieved territory_short_name is NULL
182: || 2) if country_code is not defined in FND_TERRITORIES_vl table
183: ||
184: || default_country_desc :
185: || if country_code = default_country_code AND print_home_country_flag = 'Y'
186: ||

Line 187: || retrieved value from FND_TERRITORIES_vl :

183: ||
184: || default_country_desc :
185: || if country_code = default_country_code AND print_home_country_flag = 'Y'
186: ||
187: || retrieved value from FND_TERRITORIES_vl :
188: || else
189: ||
190: || NOTE
191: || This function simulates the report local function

Line 202: description fnd_territories_vl.territory_short_name%TYPE;

198: default_country_desc VARCHAR2,
199: print_home_country_flag VARCHAR2 )
200: return VARCHAR2 IS
201:
202: description fnd_territories_vl.territory_short_name%TYPE;
203:
204: BEGIN
205:
206: IF country_code IS NULL THEN

Line 212: from fnd_territories_vl

208: ELSE
209: IF country_code <> NVL(default_country_code, 'xxxxxx') THEN
210:
211: select territory_short_name into description
212: from fnd_territories_vl
213: where territory_code = country_code;
214:
215: IF description IS NULL THEN
216: description := country_code;

Line 1062: style fnd_territories_vl.address_style%TYPE; --Bug2107418

1058: /*-----------------------------------------------------------------------------
1059: Other Local Variables
1060: -----------------------------------------------------------------------------*/
1061: /* address style */
1062: style fnd_territories_vl.address_style%TYPE; --Bug2107418
1063:
1064: /* display order of the first non-NULL segment in the entire address
1065: segments */
1066: first_nn_seg NUMBER(5);

Line 2724: /* if address_style is not given, obtain from FND_TERRITORIES_vl

2720: END IF;
2721:
2722: END IF;
2723:
2724: /* if address_style is not given, obtain from FND_TERRITORIES_vl
2725: database table via county_code: if country_code is NULL
2726: then use default_country_code. */
2727:
2728: IF address_style IS NULL THEN

Line 2932: style fnd_territories_vl.address_style%TYPE; --Bug2107418

2928: height_min IN NUMBER,
2929: height_max IN NUMBER
2930: )return VARCHAR2 IS
2931:
2932: style fnd_territories_vl.address_style%TYPE; --Bug2107418
2933: f_name VARCHAR2(80); -- contact first name
2934: l_name VARCHAR2(50); -- contact last name
2935: m_stop VARCHAR2(80); -- mail stop label
2936:

Line 2947: /* if address_style is not given, obtain from FND_TERRITORIES_vl

2943: from nls_database_parameters
2944: where parameter = 'NLS_CHARACTERSET';
2945:
2946:
2947: /* if address_style is not given, obtain from FND_TERRITORIES_vl
2948: database table via county_code: if country_code is NULL
2949: then use default_country_code. */
2950:
2951: IF address_style IS NULL THEN