[Home] [Help]
21: HZ_CONTACT_POINT_V2PUB FOR BOTH CREATE AND UPDATE CONTACT POINTS THROUGHOUT
22: THE PACKAGE BODY.
23: | masehgal 26-Nov-2002 TCA_V2API_uptake corrected as per V2
24: ssawhney 30-apr-2003 V2API OVN changes
25: pkpatel 4-Oct-2005 Bug 4654735 (Replaced the reference of HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS)
26: */
27:
28: g_email CONSTANT VARCHAR2(10) := 'EMAIL';
29: g_status CONSTANT VARCHAR2(1) := 'A';
144: ssawhney bug 2338473. logic for more than one error modified.
145: kpadiyar 15-May-2002 Added the call to the local get_error_msg function to get the correct message
146: kpadiyar 19-May-2002 Added local function get_party_number to returnt the party_number instead of party_id.- Review comments
147: kumma 07-JUN-2002 Commented out NOCOPY the call to fnd_msg_pub.add as a call to igs_ge_msg_stact.add is also present
148: vskumar 24-May-2006 xbuild3 performace fix. changed first select statment related to table hz_relationships.
149: ***************************************************************** */
150: -- masehgal changed to hz_xxxx_V2PUB
151: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
152: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
155: org_rel_rec hz_relationship_v2pub.relationship_rec_type;
156:
157: l_var VARCHAR2(1);
158: l_party_number hz_parties.party_number%TYPE;
159: l_party_relationship_id hz_relationships.relationship_id%TYPE;
160: l_party_id hz_parties.party_id%TYPE;
161: l_contact_point_id NUMBER(10);
162:
163: tmp_var1 VARCHAR2(2000);
171: -- Contact Party Id
172: CURSOR cur_or_cntcts(cp_org_party_id NUMBER,
173: cp_contact_party_id NUMBER) IS
174: SELECT 1
175: FROM hz_relationships rel
176: WHERE object_id = cp_org_party_id AND
177: subject_id = cp_contact_party_id AND
178: REL.SUBJECT_TYPE = 'PERSON' AND
179: REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND