[Home] [Help]
PACKAGE BODY: APPS.ARP_PHON_PKG
Source
1 PACKAGE BODY arp_phon_pkg as
2 /* $Header: AROPHONB.pls 120.1 2005/08/11 01:08:20 hyu noship $ */
3 --
4 -- PROCEDURE
5 -- get_level
6 --
7 -- DESCRIPTION
8 -- This procedure detemermins which level the phone
9 -- is connected to cust|addr|cont
10 --
11 -- SCOPE - PROVATE
12 --
13 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
14 --
15 -- ARGUMENTS : IN:
16 -- p_customer_id
17 -- p_address_id
18 -- p_contact_id
19 -- p_type
20 -- p_id
21 -- OUT:
22 -- None
23 --
24 -- RETURNS : NONE
25 --
26 -- NOTES
27 --
28 -- MODIFICATION HISTORY - Created by Kevin Hudson
29 -- 21-Jan-00 Satheesh Nambiar Bug 1171262
30 --
31 procedure get_level( p_customer_id in number,
32 p_address_id in number,
33 p_contact_id in number,
34 p_type out nocopy varchar2,
35 p_id out nocopy number ) is
36 begin
37 NULL;
38 end get_level;
39 --
40 --
41 -- PROCEDURE
42 --
43 -- check_primary
44 --
45 -- DESCRIPTION
46 -- This procedure ensure that a cust|addr|cont only
47 -- has one primary telephone.
48 --
49 -- SCOPE -
50 -- PUBLIC
51 --
52 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
53 --
54 -- ARGUMENTS : IN: p_phone_id
55 -- p_type (CUST|ADDR|CONT)
56 -- p_id
57 -- OUT:
58 -- None
59 --
60 -- RETURNS : NONE
61 --
62 -- NOTES
63 --
64 -- MODIFICATION HISTORY - Created by Kevin Hudson
65 --
66 --
67 PROCEDURE check_primary(p_phone_id in number,
68 p_type in varchar2,
69 p_id in number ) is
70 BEGIN
71 NULL;
72 END check_primary;
73 --
74 --
75 --
76 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
77 X_Phone_Id IN OUT NOCOPY NUMBER,
78 X_Last_Update_Date DATE,
79 X_Last_Updated_By NUMBER,
80 X_Creation_Date DATE,
81 X_Created_By NUMBER,
82 X_Phone_Number VARCHAR2,
83 X_Status VARCHAR2,
84 X_Phone_Type VARCHAR2,
85 X_Last_Update_Login NUMBER,
86 X_Customer_Id NUMBER,
87 X_Address_Id NUMBER,
88 X_Contact_Id NUMBER,
89 X_Area_Code VARCHAR2,
90 X_Extension VARCHAR2,
91 X_Primary_Flag VARCHAR2,
92 X_Orig_System_Reference IN OUT NOCOPY VARCHAR2,
93 X_Attribute_Category VARCHAR2,
94 X_Attribute1 VARCHAR2,
95 X_Attribute2 VARCHAR2,
96 X_Attribute3 VARCHAR2,
97 X_Attribute4 VARCHAR2,
98 X_Attribute5 VARCHAR2,
99 X_Attribute6 VARCHAR2,
100 X_Attribute7 VARCHAR2,
101 X_Attribute8 VARCHAR2,
102 X_Attribute9 VARCHAR2,
103 X_Attribute10 VARCHAR2,
104 X_Attribute11 VARCHAR2,
105 X_Attribute12 VARCHAR2,
106 X_Attribute13 VARCHAR2,
107 X_Attribute14 VARCHAR2,
108 X_Attribute15 VARCHAR2
109 ) IS
110 BEGIN
111 NULL;
112 END Insert_Row;
113
114
115 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
116 X_Phone_Number VARCHAR2,
117 X_Status VARCHAR2,
118 X_Phone_Type VARCHAR2,
119 X_Area_Code VARCHAR2,
120 X_Extension VARCHAR2,
121 X_Primary_Flag VARCHAR2,
122 X_Attribute_Category VARCHAR2,
123 X_Attribute1 VARCHAR2,
124 X_Attribute2 VARCHAR2,
125 X_Attribute3 VARCHAR2,
126 X_Attribute4 VARCHAR2,
127 X_Attribute5 VARCHAR2,
128 X_Attribute6 VARCHAR2,
129 X_Attribute7 VARCHAR2,
130 X_Attribute8 VARCHAR2,
131 X_Attribute9 VARCHAR2,
132 X_Attribute10 VARCHAR2,
133 X_Attribute11 VARCHAR2,
134 X_Attribute12 VARCHAR2,
135 X_Attribute13 VARCHAR2,
136 X_Attribute14 VARCHAR2,
137 X_Attribute15 VARCHAR2
138 ) IS
139 BEGIN
140 NULL;
141 END Lock_Row;
142
143
144
145 PROCEDURE Update_Row(X_Rowid VARCHAR2,
146 X_phone_id NUMBER,
147 X_Last_Update_Date DATE,
148 X_Last_Updated_By NUMBER,
149 X_Phone_Number VARCHAR2,
150 X_Status VARCHAR2,
151 X_Phone_Type VARCHAR2,
152 X_Last_Update_Login NUMBER,
153 X_customer_id NUMBER,
154 X_address_id NUMBER,
155 X_contact_id NUMBER,
156 X_Area_Code VARCHAR2,
157 X_Extension VARCHAR2,
158 X_Primary_Flag VARCHAR2,
159 X_Attribute_Category VARCHAR2,
160 X_Attribute1 VARCHAR2,
161 X_Attribute2 VARCHAR2,
162 X_Attribute3 VARCHAR2,
163 X_Attribute4 VARCHAR2,
164 X_Attribute5 VARCHAR2,
165 X_Attribute6 VARCHAR2,
166 X_Attribute7 VARCHAR2,
167 X_Attribute8 VARCHAR2,
168 X_Attribute9 VARCHAR2,
169 X_Attribute10 VARCHAR2,
170 X_Attribute11 VARCHAR2,
171 X_Attribute12 VARCHAR2,
172 X_Attribute13 VARCHAR2,
173 X_Attribute14 VARCHAR2,
174 X_Attribute15 VARCHAR2
175 ) IS
176 BEGIN
177 NULL;
178 END Update_Row;
179
180
181 PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
182 BEGIN
183 NULL;
184 END Delete_Row;
185
186
187 END arp_phon_pkg;