APPS.ARP_ADDR_LABEL_PKG dependencies on AR_LOOKUPS

Line 251: || retrieved value from AR_LOOKUPS

247: || RETURN
248: || 'Attn: Accounts Payable' :
249: || if lookup value is not defined
250: ||
251: || retrieved value from AR_LOOKUPS
252: || (lookup_type='ADDRESS_LABEL', lookup_code='ATTN_DEFAULT_MSG') :
253: || else
254: ||
255: || NOTES

Line 261: attn ar_lookups.meaning%TYPE;

257: ||
258: =============================================================================*/
259: FUNCTION get_default_attn return VARCHAR2 IS
260:
261: attn ar_lookups.meaning%TYPE;
262:
263: BEGIN
264:
265: select meaning

Line 267: from ar_lookups

263: BEGIN
264:
265: select meaning
266: into attn
267: from ar_lookups
268: where lookup_type = 'ADDRESS_LABEL'
269: and lookup_code = 'ATTN_DEFAULT_MSG';
270:
271: return( attn );

Line 295: || retrieved value from AR_LOOKUPS

291: || RETURN
292: || 'Mail Stop: ' :
293: || if lookup value is not defined
294: ||
295: || retrieved value from AR_LOOKUPS
296: || (lookup_type='ADDRESS_LABEL', lookup_code='MAIL_STOP') :
297: || else
298: ||
299: || NOTES

Line 305: label ar_lookups.meaning%TYPE;

301: ||
302: =============================================================================*/
303: FUNCTION get_mail_stop_label return VARCHAR2 IS
304:
305: label ar_lookups.meaning%TYPE;
306:
307: BEGIN
308:
309: select meaning into label from ar_lookups

Line 309: select meaning into label from ar_lookups

305: label ar_lookups.meaning%TYPE;
306:
307: BEGIN
308:
309: select meaning into label from ar_lookups
310: where lookup_type = 'ADDRESS_LABEL' and
311: lookup_code = 'MAIL_STOP';
312:
313: return( label );

Line 2902: || code dumps AR_LOOKUPS.meaning into

2898: || Modifications....
2899: ||
2900: || Dec 13 1997 Caroline M Clyde Changed f_name to a length of 80.
2901: || If the first name doesn't exist, the
2902: || code dumps AR_LOOKUPS.meaning into
2903: || the field (meaning is 80 chars long).
2904: ||
2905: ============================================================================*/
2906: FUNCTION format_address( address_style IN VARCHAR2,