[Home] [Help]
PACKAGE: APPS.OTA_RA_CON_API
Source
1 package ota_ra_con_api AUTHID CURRENT_USER as
2 /* $Header: otcon01t.pkh 120.0.12000000.1 2007/01/18 03:59:45 appldev noship $ */
3
4 --
5 -- |--------------------------------------------------------------------------|
6 -- |-------------------------< insert_contact >-------------------------------|
7 -- |--------------------------------------------------------------------------|
8 --
9 -- PUBLIC
10 -- Inserts a Contact into RA_CONTACTS using name and customer ID
11 -- Currently only used by Delegate Bookings
12 --
13 procedure insert_contact (p_contact_id out nocopy number,
14 p_customer_id in number,
15 p_last_name in varchar2,
16 p_first_name in varchar2,
17 p_title in varchar2,
18 p_administrator in number);
19
20 -- |--------------------------------------------------------------------------|
21 -- |-------------------------< update_contact >-------------------------------|
22 -- |--------------------------------------------------------------------------|
23 --
24 -- PUBLIC
25 -- Updates a given Contact in RA_CONTACTS
26 -- Currently only used by Delegate Bookings
27 --
28 --
29 procedure update_contact (p_contact_id in number,
30 p_last_name in varchar2,
31 p_first_name in varchar2,
32 p_title in varchar2);
33
34 -- |--------------------------------------------------------------------------|
35 -- |-------------------------< insert_row >-----------------------------------|
36 -- |--------------------------------------------------------------------------|
37 --
38 -- PUBLIC
39 --
40 PROCEDURE Insert_Row(
41 X_Contact_Id IN OUT NOCOPY NUMBER,
42 X_Created_By NUMBER,
43 X_Creation_Date DATE DEFAULT sysdate,
44 X_Customer_Id NUMBER,
45 X_Last_Name VARCHAR2,
46 X_Last_Updated_By NUMBER,
47 X_Last_Update_Date DATE DEFAULT sysdate,
48 X_Orig_System_Reference IN OUT NOCOPY VARCHAR2 ,
49 X_Status VARCHAR2 DEFAULT 'A',
50 X_Address_Id NUMBER DEFAULT NULL,
51 X_Contact_Key VARCHAR2 DEFAULT NULL,
52 X_First_Name VARCHAR2,
53 X_Job_Title VARCHAR2 DEFAULT NULL,
54 X_Last_Update_Login NUMBER DEFAULT NULL,
55 X_Mail_Stop VARCHAR2 DEFAULT NULL,
56 X_Title VARCHAR2,
57 X_Attribute_Category VARCHAR2 DEFAULT NULL,
58 X_Attribute1 VARCHAR2 DEFAULT NULL,
59 X_Attribute2 VARCHAR2 DEFAULT NULL,
60 X_Attribute3 VARCHAR2 DEFAULT NULL,
61 X_Attribute4 VARCHAR2 DEFAULT NULL,
62 X_Attribute5 VARCHAR2 DEFAULT NULL,
63 X_Attribute6 VARCHAR2 DEFAULT NULL,
64 X_Attribute7 VARCHAR2 DEFAULT NULL,
65 X_Attribute8 VARCHAR2 DEFAULT NULL,
66 X_Attribute9 VARCHAR2 DEFAULT NULL,
67 X_Attribute10 VARCHAR2 DEFAULT NULL,
68 X_Attribute11 VARCHAR2 DEFAULT NULL,
69 X_Attribute12 VARCHAR2 DEFAULT NULL,
70 X_Attribute13 VARCHAR2 DEFAULT NULL,
71 X_Attribute14 VARCHAR2 DEFAULT NULL,
72 X_Attribute15 VARCHAR2 DEFAULT NULL,
73 X_Attribute16 VARCHAR2 DEFAULT NULL,
74 X_Attribute17 VARCHAR2 DEFAULT NULL,
75 X_Attribute18 VARCHAR2 DEFAULT NULL,
76 X_Attribute19 VARCHAR2 DEFAULT NULL,
77 X_Attribute20 VARCHAR2 DEFAULT NULL,
78 X_Attribute21 VARCHAR2 DEFAULT NULL,
79 X_Attribute22 VARCHAR2 DEFAULT NULL,
80 X_Attribute23 VARCHAR2 DEFAULT NULL,
81 X_Attribute24 VARCHAR2 DEFAULT NULL,
82 X_Attribute25 VARCHAR2 DEFAULT NULL,
83 X_Email_Address VARCHAR2 DEFAULT NULL,
84 X_Last_Name_Alt VARCHAR2 DEFAULT NULL,
85 X_First_Name_Alt VARCHAR2 DEFAULT NULL,
86 X_Contact_Number IN OUT NOCOPY VARCHAR2 ,
87 X_Party_Id NUMBER DEFAULT NULL,
88 X_Party_Site_Id NUMBER DEFAULT NULL,
89 X_Contact_Party_Id IN OUT NOCOPY NUMBER ,
90 X_Rel_Party_Id IN OUT NOCOPY NUMBER ,
91 X_Org_Contact_Id IN OUT NOCOPY NUMBER ,
92 X_Contact_Point_Id NUMBER DEFAULT NULL,
93 X_Cust_Account_Role_Id IN OUT NOCOPY NUMBER ,
94 X_Return_Status OUT NOCOPY VARCHAR2,
95 X_Msg_Count OUT NOCOPY NUMBER,
96 X_Msg_Data OUT NOCOPY VARCHAR2
97 );
98
99
100 end ota_ra_con_api;