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_BO_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 38: px_phone_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,

34: p_cp_os IN VARCHAR2,
35: p_cp_osr IN VARCHAR2,
36: p_cp_type IN VARCHAR2,
37: p_create_or_update IN VARCHAR2 := 'C',
38: px_phone_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
39: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
40: );
41:
42: -- PRIVATE PROCEDURE assign_telex_rec

Line 39: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

35: p_cp_osr IN VARCHAR2,
36: p_cp_type IN VARCHAR2,
37: p_create_or_update IN VARCHAR2 := 'C',
38: px_phone_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
39: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
40: );
41:
42: -- PRIVATE PROCEDURE assign_telex_rec
43: --

Line 76: px_telex_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE,

72: p_cp_os IN VARCHAR2,
73: p_cp_osr IN VARCHAR2,
74: p_cp_type IN VARCHAR2,
75: p_create_or_update IN VARCHAR2 := 'C',
76: px_telex_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE,
77: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
78: );
79:
80: -- PRIVATE PROCEDURE assign_email_rec

Line 77: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

73: p_cp_osr IN VARCHAR2,
74: p_cp_type IN VARCHAR2,
75: p_create_or_update IN VARCHAR2 := 'C',
76: px_telex_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE,
77: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
78: );
79:
80: -- PRIVATE PROCEDURE assign_email_rec
81: --

Line 114: px_email_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE,

110: p_cp_os IN VARCHAR2,
111: p_cp_osr IN VARCHAR2,
112: p_cp_type IN VARCHAR2,
113: p_create_or_update IN VARCHAR2 := 'C',
114: px_email_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE,
115: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
116: );
117:
118: -- PRIVATE PROCEDURE assign_web_rec

Line 115: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

111: p_cp_osr IN VARCHAR2,
112: p_cp_type IN VARCHAR2,
113: p_create_or_update IN VARCHAR2 := 'C',
114: px_email_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE,
115: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
116: );
117:
118: -- PRIVATE PROCEDURE assign_web_rec
119: --

Line 152: px_web_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE,

148: p_cp_os IN VARCHAR2,
149: p_cp_osr IN VARCHAR2,
150: p_cp_type IN VARCHAR2,
151: p_create_or_update IN VARCHAR2 := 'C',
152: px_web_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE,
153: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
154: );
155:
156: -- PRIVATE PROCEDURE assign_edi_rec

Line 153: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

149: p_cp_osr IN VARCHAR2,
150: p_cp_type IN VARCHAR2,
151: p_create_or_update IN VARCHAR2 := 'C',
152: px_web_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE,
153: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
154: );
155:
156: -- PRIVATE PROCEDURE assign_edi_rec
157: --

Line 190: px_edi_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE,

186: p_cp_os IN VARCHAR2,
187: p_cp_osr IN VARCHAR2,
188: p_cp_type IN VARCHAR2,
189: p_create_or_update IN VARCHAR2 := 'C',
190: px_edi_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE,
191: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
192: );
193:
194: -- PRIVATE PROCEDURE assign_eft_rec

Line 191: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

187: p_cp_osr IN VARCHAR2,
188: p_cp_type IN VARCHAR2,
189: p_create_or_update IN VARCHAR2 := 'C',
190: px_edi_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE,
191: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
192: );
193:
194: -- PRIVATE PROCEDURE assign_eft_rec
195: --

Line 228: px_eft_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE,

224: p_cp_os IN VARCHAR2,
225: p_cp_osr IN VARCHAR2,
226: p_cp_type IN VARCHAR2,
227: p_create_or_update IN VARCHAR2 := 'C',
228: px_eft_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE,
229: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
230: );
231:
232: -- PRIVATE PROCEDURE assign_sms_rec

Line 229: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

225: p_cp_osr IN VARCHAR2,
226: p_cp_type IN VARCHAR2,
227: p_create_or_update IN VARCHAR2 := 'C',
228: px_eft_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE,
229: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
230: );
231:
232: -- PRIVATE PROCEDURE assign_sms_rec
233: --

Line 266: px_sms_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,

262: p_cp_os IN VARCHAR2,
263: p_cp_osr IN VARCHAR2,
264: p_cp_type IN VARCHAR2,
265: p_create_or_update IN VARCHAR2 := 'C',
266: px_sms_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
267: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
268: );
269:
270: -- PROCEDURE create_phone_bo

Line 267: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

263: p_cp_osr IN VARCHAR2,
264: p_cp_type IN VARCHAR2,
265: p_create_or_update IN VARCHAR2 := 'C',
266: px_sms_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
267: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
268: );
269:
270: -- PROCEDURE create_phone_bo
271: --

Line 1085: px_phone_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,

1081: p_cp_os IN VARCHAR2,
1082: p_cp_osr IN VARCHAR2,
1083: p_cp_type IN VARCHAR2,
1084: p_create_or_update IN VARCHAR2 := 'C',
1085: px_phone_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
1086: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1087: ) IS
1088: BEGIN
1089: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1086: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1082: p_cp_osr IN VARCHAR2,
1083: p_cp_type IN VARCHAR2,
1084: p_create_or_update IN VARCHAR2 := 'C',
1085: px_phone_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
1086: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1087: ) IS
1088: BEGIN
1089: px_contact_point_rec.contact_point_id := p_cp_id;
1090: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1177: px_telex_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE,

1173: p_cp_os IN VARCHAR2,
1174: p_cp_osr IN VARCHAR2,
1175: p_cp_type IN VARCHAR2,
1176: p_create_or_update IN VARCHAR2 := 'C',
1177: px_telex_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE,
1178: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1179: ) IS
1180: BEGIN
1181: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1178: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1174: p_cp_osr IN VARCHAR2,
1175: p_cp_type IN VARCHAR2,
1176: p_create_or_update IN VARCHAR2 := 'C',
1177: px_telex_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE,
1178: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1179: ) IS
1180: BEGIN
1181: px_contact_point_rec.contact_point_id := p_cp_id;
1182: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1261: px_email_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE,

1257: p_cp_os IN VARCHAR2,
1258: p_cp_osr IN VARCHAR2,
1259: p_cp_type IN VARCHAR2,
1260: p_create_or_update IN VARCHAR2 := 'C',
1261: px_email_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE,
1262: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1263: ) IS
1264: BEGIN
1265: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1262: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1258: p_cp_osr IN VARCHAR2,
1259: p_cp_type IN VARCHAR2,
1260: p_create_or_update IN VARCHAR2 := 'C',
1261: px_email_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE,
1262: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1263: ) IS
1264: BEGIN
1265: px_contact_point_rec.contact_point_id := p_cp_id;
1266: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1346: px_web_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE,

1342: p_cp_os IN VARCHAR2,
1343: p_cp_osr IN VARCHAR2,
1344: p_cp_type IN VARCHAR2,
1345: p_create_or_update IN VARCHAR2 := 'C',
1346: px_web_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE,
1347: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1348: ) IS
1349: BEGIN
1350: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1347: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1343: p_cp_osr IN VARCHAR2,
1344: p_cp_type IN VARCHAR2,
1345: p_create_or_update IN VARCHAR2 := 'C',
1346: px_web_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE,
1347: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1348: ) IS
1349: BEGIN
1350: px_contact_point_rec.contact_point_id := p_cp_id;
1351: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1431: px_edi_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE,

1427: p_cp_os IN VARCHAR2,
1428: p_cp_osr IN VARCHAR2,
1429: p_cp_type IN VARCHAR2,
1430: p_create_or_update IN VARCHAR2 := 'C',
1431: px_edi_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE,
1432: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1433: ) IS
1434: BEGIN
1435: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1432: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1428: p_cp_osr IN VARCHAR2,
1429: p_cp_type IN VARCHAR2,
1430: p_create_or_update IN VARCHAR2 := 'C',
1431: px_edi_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE,
1432: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1433: ) IS
1434: BEGIN
1435: px_contact_point_rec.contact_point_id := p_cp_id;
1436: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1522: px_eft_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE,

1518: p_cp_os IN VARCHAR2,
1519: p_cp_osr IN VARCHAR2,
1520: p_cp_type IN VARCHAR2,
1521: p_create_or_update IN VARCHAR2 := 'C',
1522: px_eft_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE,
1523: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1524: ) IS
1525: BEGIN
1526: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1523: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1519: p_cp_osr IN VARCHAR2,
1520: p_cp_type IN VARCHAR2,
1521: p_create_or_update IN VARCHAR2 := 'C',
1522: px_eft_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE,
1523: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1524: ) IS
1525: BEGIN
1526: px_contact_point_rec.contact_point_id := p_cp_id;
1527: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1609: px_sms_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,

1605: p_cp_os IN VARCHAR2,
1606: p_cp_osr IN VARCHAR2,
1607: p_cp_type IN VARCHAR2,
1608: p_create_or_update IN VARCHAR2 := 'C',
1609: px_sms_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
1610: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1611: ) IS
1612: BEGIN
1613: px_contact_point_rec.contact_point_id := p_cp_id;

Line 1610: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE

1606: p_cp_osr IN VARCHAR2,
1607: p_cp_type IN VARCHAR2,
1608: p_create_or_update IN VARCHAR2 := 'C',
1609: px_sms_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE,
1610: px_contact_point_rec IN OUT NOCOPY HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE
1611: ) IS
1612: BEGIN
1613: px_contact_point_rec.contact_point_id := p_cp_id;
1614: px_contact_point_rec.contact_point_type := p_cp_type;

Line 1700: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

1696: px_parent_osr IN OUT NOCOPY VARCHAR2,
1697: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1698: ) IS
1699: l_debug_prefix VARCHAR2(30);
1700: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

Line 1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

1697: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1698: ) IS
1699: l_debug_prefix VARCHAR2(30);
1700: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

Line 1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

1698: ) IS
1699: l_debug_prefix VARCHAR2(30);
1700: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;

Line 1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

1699: l_debug_prefix VARCHAR2(30);
1700: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
1707: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

Line 1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

1700: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
1707: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1708: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

Line 1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

1701: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
1707: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1708: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
1709: l_contact_pref_id NUMBER;

Line 1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;

1702: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
1707: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1708: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
1709: l_contact_pref_id NUMBER;
1710: l_owner_table_name VARCHAR2(30);

Line 1707: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

1703: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
1704: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
1705: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
1706: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
1707: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1708: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
1709: l_contact_pref_id NUMBER;
1710: l_owner_table_name VARCHAR2(30);
1711: l_valid_obj BOOLEAN;

Line 1812: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point(

1808: px_phone_rec => l_phone_rec,
1809: px_contact_point_rec => l_contact_point_rec
1810: );
1811:
1812: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point(
1813: p_contact_point_rec => l_contact_point_rec,
1814: p_phone_rec => l_phone_rec,
1815: x_contact_point_id => x_cp_id,
1816: x_return_status => x_return_status,

Line 1837: HZ_CONTACT_POINT_V2PUB.create_email_contact_point(

1833: px_email_rec => l_email_rec,
1834: px_contact_point_rec => l_contact_point_rec
1835: );
1836:
1837: HZ_CONTACT_POINT_V2PUB.create_email_contact_point(
1838: p_contact_point_rec => l_contact_point_rec,
1839: p_email_rec => l_email_rec,
1840: x_contact_point_id => x_cp_id,
1841: x_return_status => x_return_status,

Line 1862: HZ_CONTACT_POINT_V2PUB.create_telex_contact_point(

1858: px_telex_rec => l_telex_rec,
1859: px_contact_point_rec => l_contact_point_rec
1860: );
1861:
1862: HZ_CONTACT_POINT_V2PUB.create_telex_contact_point(
1863: p_contact_point_rec => l_contact_point_rec,
1864: p_telex_rec => l_telex_rec,
1865: x_contact_point_id => x_cp_id,
1866: x_return_status => x_return_status,

Line 1887: HZ_CONTACT_POINT_V2PUB.create_web_contact_point(

1883: px_web_rec => l_web_rec,
1884: px_contact_point_rec => l_contact_point_rec
1885: );
1886:
1887: HZ_CONTACT_POINT_V2PUB.create_web_contact_point(
1888: p_contact_point_rec => l_contact_point_rec,
1889: p_web_rec => l_web_rec,
1890: x_contact_point_id => x_cp_id,
1891: x_return_status => x_return_status,

Line 1912: HZ_CONTACT_POINT_V2PUB.create_edi_contact_point(

1908: px_edi_rec => l_edi_rec,
1909: px_contact_point_rec => l_contact_point_rec
1910: );
1911:
1912: HZ_CONTACT_POINT_V2PUB.create_edi_contact_point(
1913: p_contact_point_rec => l_contact_point_rec,
1914: p_edi_rec => l_edi_rec,
1915: x_contact_point_id => x_cp_id,
1916: x_return_status => x_return_status,

Line 1937: HZ_CONTACT_POINT_V2PUB.create_eft_contact_point(

1933: px_eft_rec => l_eft_rec,
1934: px_contact_point_rec => l_contact_point_rec
1935: );
1936:
1937: HZ_CONTACT_POINT_V2PUB.create_eft_contact_point(
1938: p_contact_point_rec => l_contact_point_rec,
1939: p_eft_rec => l_eft_rec,
1940: x_contact_point_id => x_cp_id,
1941: x_return_status => x_return_status,

Line 1962: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point(

1958: px_sms_rec => l_sms_rec,
1959: px_contact_point_rec => l_contact_point_rec
1960: );
1961:
1962: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point(
1963: p_contact_point_rec => l_contact_point_rec,
1964: p_phone_rec => l_sms_rec,
1965: x_contact_point_id => x_cp_id,
1966: x_return_status => x_return_status,

Line 2771: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

2767: x_cp_osr OUT NOCOPY VARCHAR2,
2768: p_parent_os IN VARCHAR2
2769: ) IS
2770: l_debug_prefix VARCHAR2(30);
2771: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

Line 2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

2768: p_parent_os IN VARCHAR2
2769: ) IS
2770: l_debug_prefix VARCHAR2(30);
2771: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

Line 2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

2769: ) IS
2770: l_debug_prefix VARCHAR2(30);
2771: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;

Line 2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

2770: l_debug_prefix VARCHAR2(30);
2771: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
2778: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

Line 2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;

2771: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
2778: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2779: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

Line 2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

2772: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
2778: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2779: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
2780: l_contact_pref_id NUMBER;

Line 2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;

2773: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
2778: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2779: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
2780: l_contact_pref_id NUMBER;
2781: l_ovn NUMBER;

Line 2778: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

2774: l_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
2775: l_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
2776: l_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
2777: l_eft_rec HZ_CONTACT_POINT_V2PUB.EFT_REC_TYPE;
2778: l_sms_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
2779: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
2780: l_contact_pref_id NUMBER;
2781: l_ovn NUMBER;
2782: l_owner_table_id NUMBER;

Line 2861: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point(

2857: px_phone_rec => l_phone_rec,
2858: px_contact_point_rec => l_contact_point_rec
2859: );
2860:
2861: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point(
2862: p_contact_point_rec => l_contact_point_rec,
2863: p_phone_rec => l_phone_rec,
2864: p_object_version_number => l_ovn,
2865: x_return_status => x_return_status,

Line 2887: HZ_CONTACT_POINT_V2PUB.update_email_contact_point(

2883: px_email_rec => l_email_rec,
2884: px_contact_point_rec => l_contact_point_rec
2885: );
2886:
2887: HZ_CONTACT_POINT_V2PUB.update_email_contact_point(
2888: p_contact_point_rec => l_contact_point_rec,
2889: p_email_rec => l_email_rec,
2890: p_object_version_number => l_ovn,
2891: x_return_status => x_return_status,

Line 2913: HZ_CONTACT_POINT_V2PUB.update_telex_contact_point(

2909: px_telex_rec => l_telex_rec,
2910: px_contact_point_rec => l_contact_point_rec
2911: );
2912:
2913: HZ_CONTACT_POINT_V2PUB.update_telex_contact_point(
2914: p_contact_point_rec => l_contact_point_rec,
2915: p_telex_rec => l_telex_rec,
2916: p_object_version_number => l_ovn,
2917: x_return_status => x_return_status,

Line 2939: HZ_CONTACT_POINT_V2PUB.update_web_contact_point(

2935: px_web_rec => l_web_rec,
2936: px_contact_point_rec => l_contact_point_rec
2937: );
2938:
2939: HZ_CONTACT_POINT_V2PUB.update_web_contact_point(
2940: p_contact_point_rec => l_contact_point_rec,
2941: p_web_rec => l_web_rec,
2942: p_object_version_number => l_ovn,
2943: x_return_status => x_return_status,

Line 2965: HZ_CONTACT_POINT_V2PUB.update_edi_contact_point(

2961: px_edi_rec => l_edi_rec,
2962: px_contact_point_rec => l_contact_point_rec
2963: );
2964:
2965: HZ_CONTACT_POINT_V2PUB.update_edi_contact_point(
2966: p_contact_point_rec => l_contact_point_rec,
2967: p_edi_rec => l_edi_rec,
2968: p_object_version_number => l_ovn,
2969: x_return_status => x_return_status,

Line 2991: HZ_CONTACT_POINT_V2PUB.update_eft_contact_point(

2987: px_eft_rec => l_eft_rec,
2988: px_contact_point_rec => l_contact_point_rec
2989: );
2990:
2991: HZ_CONTACT_POINT_V2PUB.update_eft_contact_point(
2992: p_contact_point_rec => l_contact_point_rec,
2993: p_eft_rec => l_eft_rec,
2994: p_object_version_number => l_ovn,
2995: x_return_status => x_return_status,

Line 3017: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point(

3013: px_sms_rec => l_sms_rec,
3014: px_contact_point_rec => l_contact_point_rec
3015: );
3016:
3017: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point(
3018: p_contact_point_rec => l_contact_point_rec,
3019: p_phone_rec => l_sms_rec,
3020: p_object_version_number => l_ovn,
3021: x_return_status => x_return_status,