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

Line 1: package body hz_contact_point_v2pub_jw as

1: package body hz_contact_point_v2pub_jw as
2: /* $Header: ARH2CPJB.pls 120.3 2005/06/18 04:27:35 jhuang noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 86: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

82: , p6_a0 VARCHAR2 := null
83: , p6_a1 VARCHAR2 := null
84: )
85: as
86: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;

83: , p6_a1 VARCHAR2 := null
84: )
85: as
86: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
91: ddp_web_rec hz_contact_point_v2pub.web_rec_type;

Line 88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

84: )
85: as
86: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
91: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
92: ddindx binary_integer; indx binary_integer;

Line 89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;

85: as
86: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
91: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
92: ddindx binary_integer; indx binary_integer;
93: begin

Line 90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;

86: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
91: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
92: ddindx binary_integer; indx binary_integer;
93: begin
94:

Line 91: ddp_web_rec hz_contact_point_v2pub.web_rec_type;

87: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
88: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
89: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
90: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
91: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
92: ddindx binary_integer; indx binary_integer;
93: begin
94:
95: -- copy data to the local IN or IN-OUT args, if any

Line 165: hz_contact_point_v2pub.create_contact_point(p_init_msg_list,

161:
162:
163:
164: -- here's the delegated call to the old PL/SQL routine
165: hz_contact_point_v2pub.create_contact_point(p_init_msg_list,
166: ddp_contact_point_rec,
167: ddp_edi_rec,
168: ddp_email_rec,
169: ddp_phone_rec,

Line 240: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

236: , p2_a6 NUMBER := null
237: , p2_a7 VARCHAR2 := null
238: )
239: as
240: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
241: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
242: ddindx binary_integer; indx binary_integer;
243: begin
244:

Line 241: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;

237: , p2_a7 VARCHAR2 := null
238: )
239: as
240: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
241: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
242: ddindx binary_integer; indx binary_integer;
243: begin
244:
245: -- copy data to the local IN or IN-OUT args, if any

Line 297: hz_contact_point_v2pub.create_edi_contact_point(p_init_msg_list,

293:
294:
295:
296: -- here's the delegated call to the old PL/SQL routine
297: hz_contact_point_v2pub.create_edi_contact_point(p_init_msg_list,
298: ddp_contact_point_rec,
299: ddp_edi_rec,
300: x_contact_point_id,
301: x_return_status,

Line 358: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

354: , p2_a0 VARCHAR2 := null
355: , p2_a1 VARCHAR2 := null
356: )
357: as
358: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
359: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
360: ddindx binary_integer; indx binary_integer;
361: begin
362:

Line 359: ddp_web_rec hz_contact_point_v2pub.web_rec_type;

355: , p2_a1 VARCHAR2 := null
356: )
357: as
358: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
359: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
360: ddindx binary_integer; indx binary_integer;
361: begin
362:
363: -- copy data to the local IN or IN-OUT args, if any

Line 409: hz_contact_point_v2pub.create_web_contact_point(p_init_msg_list,

405:
406:
407:
408: -- here's the delegated call to the old PL/SQL routine
409: hz_contact_point_v2pub.create_web_contact_point(p_init_msg_list,
410: ddp_contact_point_rec,
411: ddp_web_rec,
412: x_contact_point_id,
413: x_return_status,

Line 472: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

468: , p2_a2 VARCHAR2 := null
469: , p2_a3 VARCHAR2 := null
470: )
471: as
472: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
473: ddp_eft_rec hz_contact_point_v2pub.eft_rec_type;
474: ddindx binary_integer; indx binary_integer;
475: begin
476:

Line 473: ddp_eft_rec hz_contact_point_v2pub.eft_rec_type;

469: , p2_a3 VARCHAR2 := null
470: )
471: as
472: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
473: ddp_eft_rec hz_contact_point_v2pub.eft_rec_type;
474: ddindx binary_integer; indx binary_integer;
475: begin
476:
477: -- copy data to the local IN or IN-OUT args, if any

Line 525: hz_contact_point_v2pub.create_eft_contact_point(p_init_msg_list,

521:
522:
523:
524: -- here's the delegated call to the old PL/SQL routine
525: hz_contact_point_v2pub.create_eft_contact_point(p_init_msg_list,
526: ddp_contact_point_rec,
527: ddp_eft_rec,
528: x_contact_point_id,
529: x_return_status,

Line 593: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

589: , p2_a7 VARCHAR2 := null
590: , p2_a8 VARCHAR2 := null
591: )
592: as
593: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
594: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:

Line 594: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;

590: , p2_a8 VARCHAR2 := null
591: )
592: as
593: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
594: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:
598: -- copy data to the local IN or IN-OUT args, if any

Line 651: hz_contact_point_v2pub.create_phone_contact_point(p_init_msg_list,

647:
648:
649:
650: -- here's the delegated call to the old PL/SQL routine
651: hz_contact_point_v2pub.create_phone_contact_point(p_init_msg_list,
652: ddp_contact_point_rec,
653: ddp_phone_rec,
654: x_contact_point_id,
655: x_return_status,

Line 711: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

707: , p1_a34 VARCHAR2 := null
708: , p2_a0 VARCHAR2 := null
709: )
710: as
711: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
712: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
715:

Line 712: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;

708: , p2_a0 VARCHAR2 := null
709: )
710: as
711: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
712: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
715:
716: -- copy data to the local IN or IN-OUT args, if any

Line 761: hz_contact_point_v2pub.create_telex_contact_point(p_init_msg_list,

757:
758:
759:
760: -- here's the delegated call to the old PL/SQL routine
761: hz_contact_point_v2pub.create_telex_contact_point(p_init_msg_list,
762: ddp_contact_point_rec,
763: ddp_telex_rec,
764: x_contact_point_id,
765: x_return_status,

Line 822: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

818: , p2_a0 VARCHAR2 := null
819: , p2_a1 VARCHAR2 := null
820: )
821: as
822: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
823: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
824: ddindx binary_integer; indx binary_integer;
825: begin
826:

Line 823: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

819: , p2_a1 VARCHAR2 := null
820: )
821: as
822: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
823: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
824: ddindx binary_integer; indx binary_integer;
825: begin
826:
827: -- copy data to the local IN or IN-OUT args, if any

Line 873: hz_contact_point_v2pub.create_email_contact_point(p_init_msg_list,

869:
870:
871:
872: -- here's the delegated call to the old PL/SQL routine
873: hz_contact_point_v2pub.create_email_contact_point(p_init_msg_list,
874: ddp_contact_point_rec,
875: ddp_email_rec,
876: x_contact_point_id,
877: x_return_status,

Line 954: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

950: , p6_a0 VARCHAR2 := null
951: , p6_a1 VARCHAR2 := null
952: )
953: as
954: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;

951: , p6_a1 VARCHAR2 := null
952: )
953: as
954: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
959: ddp_web_rec hz_contact_point_v2pub.web_rec_type;

Line 956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

952: )
953: as
954: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
959: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
960: ddindx binary_integer; indx binary_integer;

Line 957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;

953: as
954: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
959: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
960: ddindx binary_integer; indx binary_integer;
961: begin

Line 958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;

954: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
959: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
960: ddindx binary_integer; indx binary_integer;
961: begin
962:

Line 959: ddp_web_rec hz_contact_point_v2pub.web_rec_type;

955: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
956: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
957: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
958: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
959: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
960: ddindx binary_integer; indx binary_integer;
961: begin
962:
963: -- copy data to the local IN or IN-OUT args, if any

Line 1033: hz_contact_point_v2pub.update_contact_point(p_init_msg_list,

1029:
1030:
1031:
1032: -- here's the delegated call to the old PL/SQL routine
1033: hz_contact_point_v2pub.update_contact_point(p_init_msg_list,
1034: ddp_contact_point_rec,
1035: ddp_edi_rec,
1036: ddp_email_rec,
1037: ddp_phone_rec,

Line 1108: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1104: , p2_a6 NUMBER := null
1105: , p2_a7 VARCHAR2 := null
1106: )
1107: as
1108: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1109: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
1110: ddindx binary_integer; indx binary_integer;
1111: begin
1112:

Line 1109: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;

1105: , p2_a7 VARCHAR2 := null
1106: )
1107: as
1108: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1109: ddp_edi_rec hz_contact_point_v2pub.edi_rec_type;
1110: ddindx binary_integer; indx binary_integer;
1111: begin
1112:
1113: -- copy data to the local IN or IN-OUT args, if any

Line 1165: hz_contact_point_v2pub.update_edi_contact_point(p_init_msg_list,

1161:
1162:
1163:
1164: -- here's the delegated call to the old PL/SQL routine
1165: hz_contact_point_v2pub.update_edi_contact_point(p_init_msg_list,
1166: ddp_contact_point_rec,
1167: ddp_edi_rec,
1168: p_object_version_number,
1169: x_return_status,

Line 1226: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1222: , p2_a0 VARCHAR2 := null
1223: , p2_a1 VARCHAR2 := null
1224: )
1225: as
1226: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1227: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
1228: ddindx binary_integer; indx binary_integer;
1229: begin
1230:

Line 1227: ddp_web_rec hz_contact_point_v2pub.web_rec_type;

1223: , p2_a1 VARCHAR2 := null
1224: )
1225: as
1226: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1227: ddp_web_rec hz_contact_point_v2pub.web_rec_type;
1228: ddindx binary_integer; indx binary_integer;
1229: begin
1230:
1231: -- copy data to the local IN or IN-OUT args, if any

Line 1277: hz_contact_point_v2pub.update_web_contact_point(p_init_msg_list,

1273:
1274:
1275:
1276: -- here's the delegated call to the old PL/SQL routine
1277: hz_contact_point_v2pub.update_web_contact_point(p_init_msg_list,
1278: ddp_contact_point_rec,
1279: ddp_web_rec,
1280: p_object_version_number,
1281: x_return_status,

Line 1340: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1336: , p2_a2 VARCHAR2 := null
1337: , p2_a3 VARCHAR2 := null
1338: )
1339: as
1340: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1341: ddp_eft_rec hz_contact_point_v2pub.eft_rec_type;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:

Line 1341: ddp_eft_rec hz_contact_point_v2pub.eft_rec_type;

1337: , p2_a3 VARCHAR2 := null
1338: )
1339: as
1340: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1341: ddp_eft_rec hz_contact_point_v2pub.eft_rec_type;
1342: ddindx binary_integer; indx binary_integer;
1343: begin
1344:
1345: -- copy data to the local IN or IN-OUT args, if any

Line 1393: hz_contact_point_v2pub.update_eft_contact_point(p_init_msg_list,

1389:
1390:
1391:
1392: -- here's the delegated call to the old PL/SQL routine
1393: hz_contact_point_v2pub.update_eft_contact_point(p_init_msg_list,
1394: ddp_contact_point_rec,
1395: ddp_eft_rec,
1396: p_object_version_number,
1397: x_return_status,

Line 1461: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1457: , p2_a7 VARCHAR2 := null
1458: , p2_a8 VARCHAR2 := null
1459: )
1460: as
1461: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1462: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
1463: ddindx binary_integer; indx binary_integer;
1464: begin
1465:

Line 1462: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;

1458: , p2_a8 VARCHAR2 := null
1459: )
1460: as
1461: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1462: ddp_phone_rec hz_contact_point_v2pub.phone_rec_type;
1463: ddindx binary_integer; indx binary_integer;
1464: begin
1465:
1466: -- copy data to the local IN or IN-OUT args, if any

Line 1519: hz_contact_point_v2pub.update_phone_contact_point(p_init_msg_list,

1515:
1516:
1517:
1518: -- here's the delegated call to the old PL/SQL routine
1519: hz_contact_point_v2pub.update_phone_contact_point(p_init_msg_list,
1520: ddp_contact_point_rec,
1521: ddp_phone_rec,
1522: p_object_version_number,
1523: x_return_status,

Line 1579: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1575: , p1_a34 VARCHAR2 := null
1576: , p2_a0 VARCHAR2 := null
1577: )
1578: as
1579: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1580: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
1581: ddindx binary_integer; indx binary_integer;
1582: begin
1583:

Line 1580: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;

1576: , p2_a0 VARCHAR2 := null
1577: )
1578: as
1579: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1580: ddp_telex_rec hz_contact_point_v2pub.telex_rec_type;
1581: ddindx binary_integer; indx binary_integer;
1582: begin
1583:
1584: -- copy data to the local IN or IN-OUT args, if any

Line 1629: hz_contact_point_v2pub.update_telex_contact_point(p_init_msg_list,

1625:
1626:
1627:
1628: -- here's the delegated call to the old PL/SQL routine
1629: hz_contact_point_v2pub.update_telex_contact_point(p_init_msg_list,
1630: ddp_contact_point_rec,
1631: ddp_telex_rec,
1632: p_object_version_number,
1633: x_return_status,

Line 1690: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1686: , p2_a0 VARCHAR2 := null
1687: , p2_a1 VARCHAR2 := null
1688: )
1689: as
1690: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1691: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1692: ddindx binary_integer; indx binary_integer;
1693: begin
1694:

Line 1691: ddp_email_rec hz_contact_point_v2pub.email_rec_type;

1687: , p2_a1 VARCHAR2 := null
1688: )
1689: as
1690: ddp_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1691: ddp_email_rec hz_contact_point_v2pub.email_rec_type;
1692: ddindx binary_integer; indx binary_integer;
1693: begin
1694:
1695: -- copy data to the local IN or IN-OUT args, if any

Line 1741: hz_contact_point_v2pub.update_email_contact_point(p_init_msg_list,

1737:
1738:
1739:
1740: -- here's the delegated call to the old PL/SQL routine
1741: hz_contact_point_v2pub.update_email_contact_point(p_init_msg_list,
1742: ddp_contact_point_rec,
1743: ddp_email_rec,
1744: p_object_version_number,
1745: x_return_status,

Line 1822: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1818: , x_msg_count out nocopy NUMBER
1819: , x_msg_data out nocopy VARCHAR2
1820: )
1821: as
1822: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;

1819: , x_msg_data out nocopy VARCHAR2
1820: )
1821: as
1822: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
1827: ddx_web_rec hz_contact_point_v2pub.web_rec_type;

Line 1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;

1820: )
1821: as
1822: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
1827: ddx_web_rec hz_contact_point_v2pub.web_rec_type;
1828: ddindx binary_integer; indx binary_integer;

Line 1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;

1821: as
1822: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
1827: ddx_web_rec hz_contact_point_v2pub.web_rec_type;
1828: ddindx binary_integer; indx binary_integer;
1829: begin

Line 1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;

1822: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
1827: ddx_web_rec hz_contact_point_v2pub.web_rec_type;
1828: ddindx binary_integer; indx binary_integer;
1829: begin
1830:

Line 1827: ddx_web_rec hz_contact_point_v2pub.web_rec_type;

1823: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1824: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
1825: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
1826: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
1827: ddx_web_rec hz_contact_point_v2pub.web_rec_type;
1828: ddindx binary_integer; indx binary_integer;
1829: begin
1830:
1831: -- copy data to the local IN or IN-OUT args, if any

Line 1844: hz_contact_point_v2pub.get_contact_point_rec(p_init_msg_list,

1840:
1841:
1842:
1843: -- here's the delegated call to the old PL/SQL routine
1844: hz_contact_point_v2pub.get_contact_point_rec(p_init_msg_list,
1845: p_contact_point_id,
1846: ddx_contact_point_rec,
1847: ddx_edi_rec,
1848: ddx_email_rec,

Line 1976: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

1972: , x_msg_count out nocopy NUMBER
1973: , x_msg_data out nocopy VARCHAR2
1974: )
1975: as
1976: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1977: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1978: ddindx binary_integer; indx binary_integer;
1979: begin
1980:

Line 1977: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;

1973: , x_msg_data out nocopy VARCHAR2
1974: )
1975: as
1976: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1977: ddx_edi_rec hz_contact_point_v2pub.edi_rec_type;
1978: ddindx binary_integer; indx binary_integer;
1979: begin
1980:
1981: -- copy data to the local IN or IN-OUT args, if any

Line 1990: hz_contact_point_v2pub.get_edi_contact_point(p_init_msg_list,

1986:
1987:
1988:
1989: -- here's the delegated call to the old PL/SQL routine
1990: hz_contact_point_v2pub.get_edi_contact_point(p_init_msg_list,
1991: p_contact_point_id,
1992: ddx_contact_point_rec,
1993: ddx_edi_rec,
1994: x_return_status,

Line 2096: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

2092: , x_msg_count out nocopy NUMBER
2093: , x_msg_data out nocopy VARCHAR2
2094: )
2095: as
2096: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2097: ddx_eft_rec hz_contact_point_v2pub.eft_rec_type;
2098: ddindx binary_integer; indx binary_integer;
2099: begin
2100:

Line 2097: ddx_eft_rec hz_contact_point_v2pub.eft_rec_type;

2093: , x_msg_data out nocopy VARCHAR2
2094: )
2095: as
2096: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2097: ddx_eft_rec hz_contact_point_v2pub.eft_rec_type;
2098: ddindx binary_integer; indx binary_integer;
2099: begin
2100:
2101: -- copy data to the local IN or IN-OUT args, if any

Line 2110: hz_contact_point_v2pub.get_eft_contact_point(p_init_msg_list,

2106:
2107:
2108:
2109: -- here's the delegated call to the old PL/SQL routine
2110: hz_contact_point_v2pub.get_eft_contact_point(p_init_msg_list,
2111: p_contact_point_id,
2112: ddx_contact_point_rec,
2113: ddx_eft_rec,
2114: x_return_status,

Line 2210: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

2206: , x_msg_count out nocopy NUMBER
2207: , x_msg_data out nocopy VARCHAR2
2208: )
2209: as
2210: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2211: ddx_web_rec hz_contact_point_v2pub.web_rec_type;
2212: ddindx binary_integer; indx binary_integer;
2213: begin
2214:

Line 2211: ddx_web_rec hz_contact_point_v2pub.web_rec_type;

2207: , x_msg_data out nocopy VARCHAR2
2208: )
2209: as
2210: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2211: ddx_web_rec hz_contact_point_v2pub.web_rec_type;
2212: ddindx binary_integer; indx binary_integer;
2213: begin
2214:
2215: -- copy data to the local IN or IN-OUT args, if any

Line 2224: hz_contact_point_v2pub.get_web_contact_point(p_init_msg_list,

2220:
2221:
2222:
2223: -- here's the delegated call to the old PL/SQL routine
2224: hz_contact_point_v2pub.get_web_contact_point(p_init_msg_list,
2225: p_contact_point_id,
2226: ddx_contact_point_rec,
2227: ddx_web_rec,
2228: x_return_status,

Line 2329: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

2325: , x_msg_count out nocopy NUMBER
2326: , x_msg_data out nocopy VARCHAR2
2327: )
2328: as
2329: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2330: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
2331: ddindx binary_integer; indx binary_integer;
2332: begin
2333:

Line 2330: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;

2326: , x_msg_data out nocopy VARCHAR2
2327: )
2328: as
2329: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2330: ddx_phone_rec hz_contact_point_v2pub.phone_rec_type;
2331: ddindx binary_integer; indx binary_integer;
2332: begin
2333:
2334: -- copy data to the local IN or IN-OUT args, if any

Line 2343: hz_contact_point_v2pub.get_phone_contact_point(p_init_msg_list,

2339:
2340:
2341:
2342: -- here's the delegated call to the old PL/SQL routine
2343: hz_contact_point_v2pub.get_phone_contact_point(p_init_msg_list,
2344: p_contact_point_id,
2345: ddx_contact_point_rec,
2346: ddx_phone_rec,
2347: x_return_status,

Line 2447: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

2443: , x_msg_count out nocopy NUMBER
2444: , x_msg_data out nocopy VARCHAR2
2445: )
2446: as
2447: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2448: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
2449: ddindx binary_integer; indx binary_integer;
2450: begin
2451:

Line 2448: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;

2444: , x_msg_data out nocopy VARCHAR2
2445: )
2446: as
2447: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2448: ddx_telex_rec hz_contact_point_v2pub.telex_rec_type;
2449: ddindx binary_integer; indx binary_integer;
2450: begin
2451:
2452: -- copy data to the local IN or IN-OUT args, if any

Line 2461: hz_contact_point_v2pub.get_telex_contact_point(p_init_msg_list,

2457:
2458:
2459:
2460: -- here's the delegated call to the old PL/SQL routine
2461: hz_contact_point_v2pub.get_telex_contact_point(p_init_msg_list,
2462: p_contact_point_id,
2463: ddx_contact_point_rec,
2464: ddx_telex_rec,
2465: x_return_status,

Line 2558: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

2554: , x_msg_count out nocopy NUMBER
2555: , x_msg_data out nocopy VARCHAR2
2556: )
2557: as
2558: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2559: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
2560: ddindx binary_integer; indx binary_integer;
2561: begin
2562:

Line 2559: ddx_email_rec hz_contact_point_v2pub.email_rec_type;

2555: , x_msg_data out nocopy VARCHAR2
2556: )
2557: as
2558: ddx_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2559: ddx_email_rec hz_contact_point_v2pub.email_rec_type;
2560: ddindx binary_integer; indx binary_integer;
2561: begin
2562:
2563: -- copy data to the local IN or IN-OUT args, if any

Line 2572: hz_contact_point_v2pub.get_email_contact_point(p_init_msg_list,

2568:
2569:
2570:
2571: -- here's the delegated call to the old PL/SQL routine
2572: hz_contact_point_v2pub.get_email_contact_point(p_init_msg_list,
2573: p_contact_point_id,
2574: ddx_contact_point_rec,
2575: ddx_email_rec,
2576: x_return_status,

Line 2626: end hz_contact_point_v2pub_jw;

2622:
2623:
2624: end;
2625:
2626: end hz_contact_point_v2pub_jw;