[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Customer_Id ,Address_Id,Contact_Id, in Insert_row and Update Row Procedure ,
Removed Cust contact point API
ssawhney 9-may-2002 Bug 2338473 -- allow for more than one HZ error to appear, where ever direct calls to HZ APIs are present.
gmuralid 26-NOV-2002 BUG 2466674 -- V2API uptake
Changed reference of HZ_CONTACT_POINT_PUB
TO HZ_CONTACT_POINT_V2PUB for create
and update of contact points
gmuralid 27-NOV-02 BUG 2676422 Commented created_by_module := IGS in update call
pkpatel 6-JAN-2003 Bug 2730137
Removed the hard coding with g_gen
ssawhney 30-APR-2003 OVN changes for V2API signature changes
***************************************************************** */
g_parties CONSTANT VARCHAR2(15) := 'HZ_PARTIES';
PROCEDURE Insert_Row(
X_Phone_Id IN OUT NOCOPY NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Phone_Number VARCHAR2,
X_Status VARCHAR2,
X_Phone_Type VARCHAR2,
X_Last_Update_Login NUMBER,
X_Country_code VARCHAR2,
X_Area_Code VARCHAR2,
X_Extension VARCHAR2,
X_Primary_Flag VARCHAR2,
X_Orig_System_Reference IN OUT NOCOPY VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2,
x_party_id NUMBER,
x_party_site_id NUMBER,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_contact_point_ovn IN OUT NOCOPY NUMBER) AS
/******************************************************************
Created By: Amit Gairola
Date Created By: 01-AUG-2001
Purpose: This procedure Inserts the record for the Contact Phones
Known limitations,enhancements,remarks:
Change History
Who When What
***************************************************************** */
email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
SELECT hz_contact_points_s.NEXTVAL
INTO x_phone_id
FROM dual;
END insert_row;
PROCEDURE Update_Row(
X_phone_id NUMBER,
X_Last_Update_Date IN OUT NOCOPY DATE,
X_Last_Updated_By NUMBER,
X_Phone_Number VARCHAR2,
X_Status VARCHAR2,
X_Phone_Type VARCHAR2,
X_Last_Update_Login NUMBER,
X_country_code VARCHAR2,
X_Area_Code VARCHAR2,
X_Extension VARCHAR2,
X_Primary_Flag VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_contact_point_ovn IN OUT NOCOPY NUMBER) AS
/******************************************************************
Created By: Amit Gairola
Date Created By: 01-AUG-2001
Purpose: This procedure updates the Phones Record
Known limitations,enhancements,remarks:
Change History
Who When What
***************************************************************** */
email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
HZ_CONTACT_POINT_V2PUB.update_contact_point(
p_init_msg_list => FND_API.G_FALSE,
p_contact_point_rec => cpoint_rec,
p_edi_rec => edi_rec,
p_email_rec => email_rec ,
p_phone_rec => phone_rec,
p_telex_rec => telex_rec,
p_web_rec => web_rec,
p_object_version_number => x_contact_point_ovn,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END update_row;
PROCEDURE Delete_Row(X_phoneid VARCHAR2) AS
/******************************************************************
Created By: Amit Gairola
Date Created By: 01-AUG-2001
Purpose: This procedure deletes the record for the Phone Id passed
as Input
Known limitations,enhancements,remarks:
Change History
Who When What
ssawhney made this NULL. Can not delete from HZ table
***************************************************************** */
BEGIN
Null;
END delete_row;