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_ORG_CONTACT_BO_PUB dependencies on HZ_ORG_CONTACT_BO

Line 1: PACKAGE BODY hz_org_contact_bo_pub AS

1: PACKAGE BODY hz_org_contact_bo_pub AS
2: /*$Header: ARHBOCBB.pls 120.19.12000000.2 2007/02/22 20:03:21 awu ship $ */
3:
4: -- PRIVATE PROCEDURE assign_person_profile_rec
5: --

Line 61: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

57: --
58: -- 14-DEC-2004 Arnold Ng Created.
59:
60: PROCEDURE assign_org_contact_rec(
61: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
62: p_person_id IN NUMBER,
63: p_related_org_id IN NUMBER,
64: p_oc_id IN NUMBER,
65: p_oc_os IN VARCHAR2,

Line 208: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

204: --
205: -- 14-DEC-2004 Arnold Ng Created.
206:
207: PROCEDURE assign_org_contact_rec(
208: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
209: p_person_id IN NUMBER,
210: p_related_org_id IN NUMBER,
211: p_oc_id IN NUMBER,
212: p_oc_os IN VARCHAR2,

Line 288: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,

284: -- Creates org contact business object.
285: PROCEDURE do_create_org_contact_bo(
286: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
287: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
288: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
289: p_created_by_module IN VARCHAR2,
290: p_obj_source IN VARCHAR2 := null,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,

Line 374: p_oc_objs => HZ_ORG_CONTACT_BO_TBL(p_org_contact_obj),

370: p_bus_object_code => 'ORG_CONTACT',
371: x_bus_object => l_bus_object
372: );
373: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_oc_bo_comp(
374: p_oc_objs => HZ_ORG_CONTACT_BO_TBL(p_org_contact_obj),
375: p_bus_object => l_bus_object
376: );
377: IF NOT(l_valid_obj) THEN
378: RAISE fnd_api.g_exc_error;

Line 529: HZ_ORG_CONTACT_BO_PVT.create_org_contact_roles(

525: -- Create org contact roles
526: ---------------------------
527: IF((p_org_contact_obj.org_contact_role_objs IS NOT NULL) AND
528: (p_org_contact_obj.org_contact_role_objs.COUNT > 0)) THEN
529: HZ_ORG_CONTACT_BO_PVT.create_org_contact_roles(
530: p_ocr_objs => p_org_contact_obj.org_contact_role_objs,
531: p_oc_id => x_org_contact_id,
532: x_return_status => x_return_status,
533: x_msg_count => x_msg_count,

Line 738: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

734:
735: PROCEDURE create_org_contact_bo(
736: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
737: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
738: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
739: p_created_by_module IN VARCHAR2,
740: x_return_status OUT NOCOPY VARCHAR2,
741: x_msg_count OUT NOCOPY NUMBER,
742: x_msg_data OUT NOCOPY VARCHAR2,

Line 750: l_oc_obj HZ_ORG_CONTACT_BO;

746: px_parent_org_id IN OUT NOCOPY NUMBER,
747: px_parent_org_os IN OUT NOCOPY VARCHAR2,
748: px_parent_org_osr IN OUT NOCOPY VARCHAR2
749: ) IS
750: l_oc_obj HZ_ORG_CONTACT_BO;
751: BEGIN
752: l_oc_obj := p_org_contact_obj;
753: do_create_org_contact_bo(
754: p_init_msg_list => p_init_msg_list,

Line 773: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

769: END create_org_contact_bo;
770:
771: PROCEDURE create_org_contact_bo(
772: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
773: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
774: p_created_by_module IN VARCHAR2,
775: p_obj_source IN VARCHAR2 := null,
776: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
777: x_return_status OUT NOCOPY VARCHAR2,

Line 779: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,

775: p_obj_source IN VARCHAR2 := null,
776: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
777: x_return_status OUT NOCOPY VARCHAR2,
778: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
779: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
780: x_org_contact_id OUT NOCOPY NUMBER,
781: x_org_contact_os OUT NOCOPY VARCHAR2,
782: x_org_contact_osr OUT NOCOPY VARCHAR2,
783: px_parent_org_id IN OUT NOCOPY NUMBER,

Line 789: l_oc_obj HZ_ORG_CONTACT_BO;

785: px_parent_org_osr IN OUT NOCOPY VARCHAR2
786: ) IS
787: l_msg_data VARCHAR2(2000);
788: l_msg_count NUMBER;
789: l_oc_obj HZ_ORG_CONTACT_BO;
790: BEGIN
791: l_oc_obj := p_org_contact_obj;
792: do_create_org_contact_bo(
793: p_init_msg_list => fnd_api.g_true,

Line 823: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

819: -- DESCRIPTION
820: -- Update org contact business object.
821: PROCEDURE update_org_contact_bo(
822: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
823: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
824: p_created_by_module IN VARCHAR2,
825: x_return_status OUT NOCOPY VARCHAR2,
826: x_msg_count OUT NOCOPY NUMBER,
827: x_msg_data OUT NOCOPY VARCHAR2,

Line 832: l_oc_obj HZ_ORG_CONTACT_BO;

828: x_org_contact_id OUT NOCOPY NUMBER,
829: x_org_contact_os OUT NOCOPY VARCHAR2,
830: x_org_contact_osr OUT NOCOPY VARCHAR2
831: )IS
832: l_oc_obj HZ_ORG_CONTACT_BO;
833: BEGIN
834: l_oc_obj := p_org_contact_obj;
835: do_update_org_contact_bo(
836: p_init_msg_list => p_init_msg_list,

Line 851: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

847: );
848: END update_org_contact_bo;
849:
850: PROCEDURE update_org_contact_bo(
851: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
852: p_created_by_module IN VARCHAR2,
853: p_obj_source IN VARCHAR2 := null,
854: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
855: x_return_status OUT NOCOPY VARCHAR2,

Line 857: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,

853: p_obj_source IN VARCHAR2 := null,
854: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
857: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
858: x_org_contact_id OUT NOCOPY NUMBER,
859: x_org_contact_os OUT NOCOPY VARCHAR2,
860: x_org_contact_osr OUT NOCOPY VARCHAR2
861: )IS

Line 864: l_oc_obj HZ_ORG_CONTACT_BO;

860: x_org_contact_osr OUT NOCOPY VARCHAR2
861: )IS
862: l_msg_data VARCHAR2(2000);
863: l_msg_count NUMBER;
864: l_oc_obj HZ_ORG_CONTACT_BO;
865: BEGIN
866: l_oc_obj := p_org_contact_obj;
867: do_update_org_contact_bo(
868: p_init_msg_list => fnd_api.g_true,

Line 894: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,

890: -- DESCRIPTION
891: -- Update org contact business object.
892: PROCEDURE do_update_org_contact_bo(
893: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
894: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
895: p_created_by_module IN VARCHAR2,
896: p_obj_source IN VARCHAR2 := null,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,

Line 1108: HZ_ORG_CONTACT_BO_PVT.save_org_contact_roles(

1104: -- For Org Contact Roles
1105: ------------------------
1106: IF((p_org_contact_obj.org_contact_role_objs IS NOT NULL) AND
1107: (p_org_contact_obj.org_contact_role_objs.COUNT > 0)) THEN
1108: HZ_ORG_CONTACT_BO_PVT.save_org_contact_roles(
1109: p_ocr_objs => p_org_contact_obj.org_contact_role_objs,
1110: p_oc_id => x_org_contact_id,
1111: x_return_status => x_return_status,
1112: x_msg_count => x_msg_count,

Line 1323: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,

1319: -- Creates or update org contact business object.
1320: PROCEDURE do_save_org_contact_bo(
1321: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1322: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1323: p_org_contact_obj IN OUT NOCOPY HZ_ORG_CONTACT_BO,
1324: p_created_by_module IN VARCHAR2,
1325: p_obj_source IN VARCHAR2 := null,
1326: x_return_status OUT NOCOPY VARCHAR2,
1327: x_msg_count OUT NOCOPY NUMBER,

Line 1493: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

1489:
1490: PROCEDURE save_org_contact_bo(
1491: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1492: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1493: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
1494: p_created_by_module IN VARCHAR2,
1495: x_return_status OUT NOCOPY VARCHAR2,
1496: x_msg_count OUT NOCOPY NUMBER,
1497: x_msg_data OUT NOCOPY VARCHAR2,

Line 1505: l_oc_obj HZ_ORG_CONTACT_BO;

1501: px_parent_org_id IN OUT NOCOPY NUMBER,
1502: px_parent_org_os IN OUT NOCOPY VARCHAR2,
1503: px_parent_org_osr IN OUT NOCOPY VARCHAR2
1504: ) IS
1505: l_oc_obj HZ_ORG_CONTACT_BO;
1506: BEGIN
1507: l_oc_obj := p_org_contact_obj;
1508: do_save_org_contact_bo(
1509: p_init_msg_list => p_init_msg_list,

Line 1528: p_org_contact_obj IN HZ_ORG_CONTACT_BO,

1524: END save_org_contact_bo;
1525:
1526: PROCEDURE save_org_contact_bo(
1527: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1528: p_org_contact_obj IN HZ_ORG_CONTACT_BO,
1529: p_created_by_module IN VARCHAR2,
1530: p_obj_source IN VARCHAR2 := null,
1531: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1532: x_return_status OUT NOCOPY VARCHAR2,

Line 1534: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,

1530: p_obj_source IN VARCHAR2 := null,
1531: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1532: x_return_status OUT NOCOPY VARCHAR2,
1533: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1534: x_return_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
1535: x_org_contact_id OUT NOCOPY NUMBER,
1536: x_org_contact_os OUT NOCOPY VARCHAR2,
1537: x_org_contact_osr OUT NOCOPY VARCHAR2,
1538: px_parent_org_id IN OUT NOCOPY NUMBER,

Line 1544: l_oc_obj HZ_ORG_CONTACT_BO;

1540: px_parent_org_osr IN OUT NOCOPY VARCHAR2
1541: ) IS
1542: l_msg_data VARCHAR2(2000);
1543: l_msg_count NUMBER;
1544: l_oc_obj HZ_ORG_CONTACT_BO;
1545: BEGIN
1546: l_oc_obj := p_org_contact_obj;
1547: do_save_org_contact_bo(
1548: p_init_msg_list => fnd_api.g_true,

Line 1611: x_org_contact_obj OUT NOCOPY HZ_ORG_CONTACT_BO,

1607: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1608: p_org_contact_id IN NUMBER,
1609: p_org_contact_os IN VARCHAR2,
1610: p_org_contact_osr IN VARCHAR2,
1611: x_org_contact_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
1612: x_return_status OUT NOCOPY VARCHAR2,
1613: x_msg_count OUT NOCOPY NUMBER,
1614: x_msg_data OUT NOCOPY VARCHAR2
1615: ) is

Line 1621: l_org_contact_objs HZ_ORG_CONTACT_BO_TBL;

1617:
1618: l_org_contact_id number;
1619: l_org_contact_os varchar2(30);
1620: l_org_contact_osr varchar2(255);
1621: l_org_contact_objs HZ_ORG_CONTACT_BO_TBL;
1622: BEGIN
1623:
1624: -- initialize API return status to success.
1625: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1635: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo(+)',

1631:
1632:
1633: -- Debug info.
1634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo(+)',
1636: p_prefix=>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_procedure);
1638: END IF;
1639:

Line 1686: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1682: END IF;
1683:
1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690:

Line 1709: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1705: p_msg_type=>'ERROR',
1706: p_msg_level=>fnd_log.level_error);
1707: END IF;
1708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1728: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1724: p_msg_type=>'UNEXPECTED ERROR',
1725: p_msg_level=>fnd_log.level_error);
1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;
1732: WHEN OTHERS THEN

Line 1751: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1747: p_msg_type=>'SQL ERROR',
1748: p_msg_level=>fnd_log.level_error);
1749: END IF;
1750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1751: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1752: p_prefix=>l_debug_prefix,
1753: p_msg_level=>fnd_log.level_procedure);
1754: END IF;
1755:

Line 1762: x_org_contact_obj OUT NOCOPY HZ_ORG_CONTACT_BO,

1758: PROCEDURE get_org_contact_bo(
1759: p_org_contact_id IN NUMBER,
1760: p_org_contact_os IN VARCHAR2,
1761: p_org_contact_osr IN VARCHAR2,
1762: x_org_contact_obj OUT NOCOPY HZ_ORG_CONTACT_BO,
1763: x_return_status OUT NOCOPY VARCHAR2,
1764: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1765: ) IS
1766: l_msg_data VARCHAR2(2000);

Line 1784: END hz_org_contact_bo_pub;

1780: x_msg_count => l_msg_count,
1781: x_msg_data => l_msg_data);
1782: END get_org_contact_bo;
1783:
1784: END hz_org_contact_bo_pub;