[Home] [Help]
PACKAGE: APPS.IGS_OR_PHONES_PKG
Source
1 PACKAGE IGS_OR_PHONES_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSOI25S.pls 115.5 2003/05/06 09:30:58 ssawhney ship $ */
3 /******************************************************************
4 Change History
5
6 Who When What
7 npalanis 15-feb-2002 Bug ID - 2225917 : SWCR008 Removed parameters
8 Customer_Id ,Address_Id,Contact_Id, in
9 Insert_row and Update Row Procedure ,
10 ssawhney 30-APR-2003 OVN changes for V2API
11
12 ***************************************************************** */
13
14
15 PROCEDURE Insert_Row(
16 X_Phone_Id IN OUT NOCOPY NUMBER,
17 X_Last_Update_Date DATE,
18 X_Last_Updated_By NUMBER,
19 X_Creation_Date DATE,
20 X_Created_By NUMBER,
21 X_Phone_Number VARCHAR2,
22 X_Status VARCHAR2,
23 X_Phone_Type VARCHAR2,
24 X_Last_Update_Login NUMBER,
25 X_Country_code VARCHAR2,
26 X_Area_Code VARCHAR2,
27 X_Extension VARCHAR2,
28 X_Primary_Flag VARCHAR2,
29 X_Orig_System_Reference IN OUT NOCOPY VARCHAR2,
30 X_Attribute_Category VARCHAR2,
31 X_Attribute1 VARCHAR2,
32 X_Attribute2 VARCHAR2,
33 X_Attribute3 VARCHAR2,
34 X_Attribute4 VARCHAR2,
35 X_Attribute5 VARCHAR2,
36 X_Attribute6 VARCHAR2,
37 X_Attribute7 VARCHAR2,
38 X_Attribute8 VARCHAR2,
39 X_Attribute9 VARCHAR2,
40 X_Attribute10 VARCHAR2,
41 X_Attribute11 VARCHAR2,
42 X_Attribute12 VARCHAR2,
43 X_Attribute13 VARCHAR2,
44 X_Attribute14 VARCHAR2,
45 X_Attribute15 VARCHAR2,
46 X_Attribute16 VARCHAR2,
47 X_Attribute17 VARCHAR2,
48 X_Attribute18 VARCHAR2,
49 X_Attribute19 VARCHAR2,
50 X_Attribute20 VARCHAR2,
51 x_party_id NUMBER,
52 x_party_site_id NUMBER,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_contact_point_ovn IN OUT NOCOPY NUMBER);
57
58
59 PROCEDURE Update_Row(
60 X_phone_id NUMBER,
61 X_Last_Update_Date IN OUT NOCOPY DATE,
62 X_Last_Updated_By NUMBER,
63 X_Phone_Number VARCHAR2,
64 X_Status VARCHAR2,
65 X_Phone_Type VARCHAR2,
66 X_Last_Update_Login NUMBER,
67 X_country_code VARCHAR2,
68 X_Area_Code VARCHAR2,
69 X_Extension VARCHAR2,
70 X_Primary_Flag VARCHAR2,
71 X_Attribute_Category VARCHAR2,
72 X_Attribute1 VARCHAR2,
73 X_Attribute2 VARCHAR2,
74 X_Attribute3 VARCHAR2,
75 X_Attribute4 VARCHAR2,
76 X_Attribute5 VARCHAR2,
77 X_Attribute6 VARCHAR2,
78 X_Attribute7 VARCHAR2,
79 X_Attribute8 VARCHAR2,
80 X_Attribute9 VARCHAR2,
81 X_Attribute10 VARCHAR2,
82 X_Attribute11 VARCHAR2,
83 X_Attribute12 VARCHAR2,
84 X_Attribute13 VARCHAR2,
85 X_Attribute14 VARCHAR2,
86 X_Attribute15 VARCHAR2,
87 X_Attribute16 VARCHAR2,
88 X_Attribute17 VARCHAR2,
89 X_Attribute18 VARCHAR2,
90 X_Attribute19 VARCHAR2,
91 X_Attribute20 VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_contact_point_ovn IN OUT NOCOPY NUMBER);
96
97
98 PROCEDURE Delete_Row(X_phoneid VARCHAR2);
99
100 END igs_or_phones_pkg;