1 PACKAGE ams_phone_utils AUTHID CURRENT_USER as
2 /* $Header: amsvlphs.pls 115.7 2002/11/22 08:55:47 jieli ship $ */
3 --
4 -- Copyright (c) 2001 by Oracle Corporation
5 --
6 -- NAME
7 -- ams_phone_utils_spec.sql - Functions to retrieve a desired phone number
8 -- based on order of creation date.
9 --
10 -- DESCRIPTION
11 -- These functions return the phone number for the desired preferred
12 -- order based on the order of creation date.
13 --
14 -- NOTES
15 -- This is to statisfy the Advanced Outbound requirements to see phone
16 -- numbers 1 through 6 and because the HZ tables can not handle this
17 -- type of quering at it's present state.
18 --
19 -- REQUIREMENTS
20 -- This package MUST be created with the authority of the definer.
21 -- (authid definer)
22 -- All variables passed in must start with: p_
23 -- All out variables must start with: x_
24 --
25 --------------------------------------------------------------------------------
26 -- FUNCTIONS:
27 -- get_phone - Return the phone number
28 -- get_raw_phone - Return the raw phone number
29 -- get_creation_date - Return the creation date
30 --
31 -- PROCEDURES:
32 -- None at this time
33 --
34 -- PRIVATE FUNCTIONS/PROCEDURES:
35 -- None at this time
36 --
37 --------------------------------------------------------------------------------
38 -- MODIFIED (MM/DD/YYYY) DESCRIPTION
39 -- jmanzell 02/14/2001 Initial creation
40 --
41 --------------------------------------------------------------------------------
42 ------------- FUNCTIONS ------------------------------------------------
43 --------------------------------------------------------------------------------
44
45 --
46 -- get_phone
47 --
48 -- This function returns the phone number for the specified PARTY_ID and
49 -- preferred order.
50 --
51 -- Arguments: number (Party ID)
52 -- number (Perferred order)
53 --
54 -- Returns: varchar2 (Phone Number)
55 --
56 FUNCTION get_phone(p_party_id in number, p_phone_pref_order in number)
57 RETURN varchar2;
58
59 --
60 -- get_raw_phone
61 --
62 -- This function returns the raw phone number for the specified PARTY_ID
63 -- and preferred order.
64 --
65 -- Arguments: number (Party ID)
66 -- number (Perferred order)
67 --
68 -- Returns: varchar2 (Raw Phone Number)
69 --
70 FUNCTION get_raw_phone(p_party_id in number, p_phone_pref_order in number)
71 RETURN varchar2;
72
73 --
74 -- get_creation_date
75 --
76 -- This function returns the creation date for the specified PARTY_ID and
77 -- preferred order.
78 --
79 -- Arguments: number (Party ID)
80 -- number (Perferred order)
81 --
82 -- Returns: date (Creation Date)
83 --
84 FUNCTION get_creation_date(p_party_id in number, p_phone_pref_order in number)
85 RETURN date;
86 END ams_phone_utils;