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.41.12020000.5 2012/10/19 08:38:48 rgokavar 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 204: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)

200: -- appending 'http://' to the URL
201: --
202: --
203:
204: FUNCTION get_protocol_prefixed_url (p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type)
205: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type IS
206: l_web_type VARCHAR2(60);
207: l_url VARCHAR2(2000);
208: l_http_position NUMBER;

Line 205: RETURN HZ_CONTACT_POINT_V2PUB.web_rec_type IS

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

Line 209: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

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

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

7173: | HISTORY |
7174: | 15-Mar-2004 Ramesh Ch Created |
7175: *----------------------------------------------------------------------------*/
7176:
7177: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7178: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7179: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7180: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7181: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type

Line 7178: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

7174: | 15-Mar-2004 Ramesh Ch Created |
7175: *----------------------------------------------------------------------------*/
7176:
7177: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7178: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7179: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7180: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7181: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7182: )

Line 7179: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

7175: *----------------------------------------------------------------------------*/
7176:
7177: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7178: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7179: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7180: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7181: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7182: )
7183: IS

Line 7180: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

7176:
7177: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7178: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7179: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7180: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7181: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7182: )
7183: IS
7184:

Line 7181: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type

7177: PROCEDURE update_contact_point_search(p_cp_rec IN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE,
7178: p_old_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7179: p_new_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
7180: p_old_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
7181: p_new_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type
7182: )
7183: IS
7184:
7185: ----(Party level Contact Point)

Line 7308: END hz_contact_point_v2pub;

7304: RETURN FALSE;
7305: END IF;
7306: END;
7307:
7308: END hz_contact_point_v2pub;