[Home] [Help]
PACKAGE: APPS.IGS_OR_CONTACTS_PKG
Source
1 PACKAGE IGS_OR_CONTACTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSOI24S.pls 115.5 2003/05/06 09:26:14 ssawhney ship $ */
3 /* Change History
4 | who when what
5 | npalanis 15-feb-2002 Bug ID - 2225917 : SWCR008 Removed parameters
6 | Customer_Id ,Address_Id,Contact_Id, in
7 | Insert_row and cust_acct_role_id is removed
8 | from Update Row Procedure .Org_contact_role_id is added
9 | in both insert_row and update_row
10 | ssawhney 30-apr-2003 V2API OVN changes
11 */
12
13 g_varchar2 CONSTANT VARCHAR2(10) := '$Sys_Def$';
14 PROCEDURE Insert_Row(x_last_name VARCHAR2,
15 x_orig_system_reference IN OUT NOCOPY VARCHAR2,
16 x_status VARCHAR2,
17 x_contact_key VARCHAR2,
18 x_first_name VARCHAR2,
19 x_job_title VARCHAR2,
20 x_mail_stop VARCHAR2,
21 x_title VARCHAR2,
22 x_attribute_category VARCHAR2 DEFAULT NULL,
23 x_attribute1 VARCHAR2 DEFAULT NULL,
24 x_attribute2 VARCHAR2 DEFAULT NULL,
25 x_attribute3 VARCHAR2 DEFAULT NULL,
26 x_attribute4 VARCHAR2 DEFAULT NULL,
27 x_attribute5 VARCHAR2 DEFAULT NULL,
28 x_attribute6 VARCHAR2 DEFAULT NULL,
29 x_attribute7 VARCHAR2 DEFAULT NULL,
30 x_attribute8 VARCHAR2 DEFAULT NULL,
31 x_attribute9 VARCHAR2 DEFAULT NULL,
32 x_attribute10 VARCHAR2 DEFAULT NULL,
33 x_attribute11 VARCHAR2 DEFAULT NULL,
34 x_attribute12 VARCHAR2 DEFAULT NULL,
35 x_attribute13 VARCHAR2 DEFAULT NULL,
36 x_attribute14 VARCHAR2 DEFAULT NULL,
37 x_attribute15 VARCHAR2 DEFAULT NULL,
38 x_attribute16 VARCHAR2 DEFAULT NULL,
39 x_attribute17 VARCHAR2 DEFAULT NULL,
40 x_attribute18 VARCHAR2 DEFAULT NULL,
41 x_attribute19 VARCHAR2 DEFAULT NULL,
42 x_attribute20 VARCHAR2 DEFAULT NULL,
43 x_attribute21 VARCHAR2 DEFAULT NULL,
44 x_attribute22 VARCHAR2 DEFAULT NULL,
45 x_attribute23 VARCHAR2 DEFAULT NULL,
46 x_attribute24 VARCHAR2 DEFAULT NULL,
47 x_attribute25 VARCHAR2 DEFAULT NULL,
48 x_email_address VARCHAR2,
49 x_last_name_alt VARCHAR2 DEFAULT NULL,
50 x_first_name_alt VARCHAR2 DEFAULT NULL,
51 x_contact_number IN OUT NOCOPY VARCHAR2 ,
52 x_party_id NUMBER ,
53 x_party_site_id NUMBER ,
54 x_contact_party_id IN OUT NOCOPY NUMBER ,
55 x_org_contact_id IN OUT NOCOPY NUMBER ,
56 x_contact_point_id IN OUT NOCOPY NUMBER ,
57 x_rel_party_id IN OUT NOCOPY NUMBER,
58 x_created_by NUMBER,
59 x_creation_date DATE ,
60 x_updated_by NUMBER ,
61 x_update_date DATE ,
62 x_last_update_login NUMBER ,
63 x_return_status OUT NOCOPY VARCHAR2 ,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 x_org_contact_role_id IN OUT NOCOPY NUMBER,
67 P_ORG_ROLE_OVN IN OUT NOCOPY NUMBER,
68 P_REL_OVN IN OUT NOCOPY NUMBER,
69 P_REL_PARTY_OVN IN OUT NOCOPY NUMBER,
70 P_ORG_CONT_OVN IN OUT NOCOPY NUMBER,
71 P_CONTACT_POINT_OVN IN OUT NOCOPY NUMBER
72 );
73
74 PROCEDURE Update_Row( x_Last_Name VARCHAR2,
75 x_Last_Updated_By NUMBER,
76 x_Last_Update_Date IN OUT NOCOPY DATE,
77 x_party_Last_Update_Date IN OUT NOCOPY DATE,
78 x_org_cont_Last_Update_Date IN OUT NOCOPY DATE,
79 x_cont_point_Last_Update_Date IN OUT NOCOPY DATE,
80 x_prel_Last_Update_Date IN OUT NOCOPY DATE,
81 x_rel_party_Last_Update_Date IN OUT NOCOPY DATE,
82 x_Status VARCHAR2,
83 x_Contact_Key VARCHAR2,
84 x_First_Name VARCHAR2,
85 x_Job_Title VARCHAR2,
86 x_Last_Update_Login NUMBER,
87 x_Mail_Stop VARCHAR2,
88 x_Title VARCHAR2,
89 x_Attribute_Category VARCHAR2,
90 x_Attribute1 VARCHAR2,
91 x_Attribute2 VARCHAR2,
92 x_Attribute3 VARCHAR2,
93 x_Attribute4 VARCHAR2,
94 x_Attribute5 VARCHAR2,
95 x_Attribute6 VARCHAR2,
96 x_Attribute7 VARCHAR2,
97 x_Attribute8 VARCHAR2,
98 x_Attribute9 VARCHAR2,
99 x_Attribute10 VARCHAR2,
100 x_Attribute11 VARCHAR2,
101 x_Attribute12 VARCHAR2,
102 x_Attribute13 VARCHAR2,
103 x_Attribute14 VARCHAR2,
104 x_Attribute15 VARCHAR2,
105 x_Attribute16 VARCHAR2,
106 x_Attribute17 VARCHAR2,
107 x_Attribute18 VARCHAR2,
108 x_Attribute19 VARCHAR2,
109 x_Attribute20 VARCHAR2,
110 x_Attribute21 VARCHAR2,
111 x_Attribute22 VARCHAR2,
112 x_Attribute23 VARCHAR2,
113 x_Attribute24 VARCHAR2,
114 x_Attribute25 VARCHAR2,
115 x_Email_Address VARCHAR2,
116 x_Last_Name_Alt VARCHAR2 DEFAULT g_varchar2,
117 x_First_Name_Alt VARCHAR2 DEFAULT g_varchar2,
118 x_contact_number VARCHAR2,
119 x_party_id NUMBER,
120 x_party_site_id NUMBER,
121 x_contact_party_id NUMBER,
122 x_org_contact_id NUMBER,
123 x_contact_point_id IN OUT NOCOPY NUMBER,
124 x_party_relationship_id NUMBER,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 x_rel_party_id NUMBER DEFAULT NULL,
129 x_org_contact_role_id IN OUT NOCOPY NUMBER,
130 P_ORG_ROLE_OVN IN OUT NOCOPY NUMBER,
131 P_REL_OVN IN OUT NOCOPY NUMBER,
132 P_REL_PARTY_OVN IN OUT NOCOPY NUMBER,
133 P_ORG_CONT_OVN IN OUT NOCOPY NUMBER,
134 P_CONTACT_POINT_OVN IN OUT NOCOPY NUMBER
135 );
136
137 END igs_or_contacts_pkg;