eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 1: PACKAGE BODY hz_contact_point_v2pub AS

1: PACKAGE BODY hz_contact_point_v2pub AS
2: /*$Header: ARH2CPSB.pls 120.37 2008/02/01 06:58:51 nshinde ship $ */
3:
4: --------------------------------------
5: -- declaration of private global varibles

Line 109: p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,

105: x_phone_number OUT NOCOPY VARCHAR2
106: );
107:
108: PROCEDURE update_contact_point_search(
109: p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
110: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
111: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
112: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
113: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type

Line 110: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

106: );
107:
108: PROCEDURE update_contact_point_search(
109: p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
110: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
111: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
112: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
113: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
114: );

Line 111: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

107:
108: PROCEDURE update_contact_point_search(
109: p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
110: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
111: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
112: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
113: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
114: );
115: FUNCTION isModified(p_old_value IN VARCHAR2,

Line 112: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

108: PROCEDURE update_contact_point_search(
109: p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
110: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
111: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
112: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
113: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
114: );
115: FUNCTION isModified(p_old_value IN VARCHAR2,
116: p_new_value IN VARCHAR2

Line 113: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type

109: p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
110: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
111: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
112: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
113: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
114: );
115: FUNCTION isModified(p_old_value IN VARCHAR2,
116: p_new_value IN VARCHAR2
117: ) RETURN BOOLEAN;

Line 119: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)

115: FUNCTION isModified(p_old_value IN VARCHAR2,
116: p_new_value IN VARCHAR2
117: ) RETURN BOOLEAN;
118:
119: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)
120: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type;
121:
122: --------------------------------------
123: -- private procedures and functions

Line 120: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type;

116: p_new_value IN VARCHAR2
117: ) RETURN BOOLEAN;
118:
119: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)
120: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type;
121:
122: --------------------------------------
123: -- private procedures and functions
124: --------------------------------------

Line 201: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)

197: -- 02-MAY-2006 Nishant Singhai o Created for Bug 4960793 (for HTTP)
198: --
199: --
200:
201: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)
202: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type IS
203: l_web_type VARCHAR2(60);
204: l_url VARCHAR2(2000);
205: l_http_position NUMBER;

Line 202: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type IS

198: --
199: --
200:
201: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)
202: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type IS
203: l_web_type VARCHAR2(60);
204: l_url VARCHAR2(2000);
205: l_http_position NUMBER;
206: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

Line 206: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

202: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type IS
203: l_web_type VARCHAR2(60);
204: l_url VARCHAR2(2000);
205: l_http_position NUMBER;
206: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
207: BEGIN
208: l_web_type := p_web_rec.web_type;
209: l_url := LTRIM(RTRIM(p_web_rec.url));
210:

Line 7021: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,

7017: | HISTORY |
7018: | 15-Mar-2004 Ramesh Ch Created |
7019: *----------------------------------------------------------------------------*/
7020:
7021: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7022: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7023: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7024: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7025: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type

Line 7022: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

7018: | 15-Mar-2004 Ramesh Ch Created |
7019: *----------------------------------------------------------------------------*/
7020:
7021: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7022: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7023: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7024: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7025: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7026: )

Line 7023: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

7019: *----------------------------------------------------------------------------*/
7020:
7021: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7022: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7023: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7024: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7025: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7026: )
7027: IS

Line 7024: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

7020:
7021: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7022: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7023: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7024: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7025: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7026: )
7027: IS
7028:

Line 7025: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type

7021: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7022: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7023: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7024: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7025: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7026: )
7027: IS
7028:
7029: ----(Party level Contact Point)

Line 7152: END hz_contact_point_v2pub;

7148: RETURN FALSE;
7149: END IF;
7150: END;
7151:
7152: END hz_contact_point_v2pub;