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.ARH_CONT_PKG dependencies on HZ_PARTY_CONTACT_V2PUB

Line 31: ( p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,

27: --
28:
29: -- Local procedure specifications
30: PROCEDURE compare_existing_contact_info
31: ( p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,
32: x_update_required IN OUT NOCOPY VARCHAR2,
33: x_relationship_id IN OUT NOCOPY NUMBER,
34: x_ocon_version_number IN OUT NOCOPY NUMBER );
35:

Line 37: (p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type);

33: x_relationship_id IN OUT NOCOPY NUMBER,
34: x_ocon_version_number IN OUT NOCOPY NUMBER );
35:
36: PROCEDURE upd_ocon_update
37: (p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type);
38: --}
39:
40: FUNCTION INIT_SWITCH
41: ( p_date IN DATE,

Line 555: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;

551:
552: party_rec hz_party_v2pub.party_rec_type;
553: per_rec hz_party_v2pub.person_rec_type;
554: prel_rec hz_relationship_v2pub.relationship_rec_type;
555: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
556: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
557: email_rec hz_contact_point_v2pub.email_rec_type;
558: arole_rec hz_cust_account_role_v2pub.cust_account_role_rec_type;
559:

Line 760: HZ_PARTY_CONTACT_V2PUB.create_org_contact (

756: ocon_rec.created_by_module := 'TCA_FORM_WRAPPER';
757:
758: IF i_create_org_contact = 'Y' THEN
759:
760: HZ_PARTY_CONTACT_V2PUB.create_org_contact (
761: p_org_contact_rec => ocon_rec,
762: x_org_contact_id => i_org_contact_id,
763: x_party_rel_id => i_party_relationship_id,
764: x_party_id => i_party_id,

Line 788: -- mail_stop is not in V2 hz_party_contact_v2pub.org_contact_rec_type

784:
785: END IF;
786:
787: --
788: -- mail_stop is not in V2 hz_party_contact_v2pub.org_contact_rec_type
789: -- Need to do this additional update in replacement
790: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is
791: -- changed to support the attribute MAIL_STOP
792: --

Line 790: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is

786:
787: --
788: -- mail_stop is not in V2 hz_party_contact_v2pub.org_contact_rec_type
789: -- Need to do this additional update in replacement
790: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is
791: -- changed to support the attribute MAIL_STOP
792: --
793: IF ( (X_Mail_Stop IS NOT NULL)
794: AND (X_Mail_Stop <> FND_API.G_MISS_CHAR))

Line 1211: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;

1207: IS
1208: party_rec hz_party_v2pub.party_rec_type;
1209: per_rec hz_party_v2pub.person_rec_type;
1210: prel_rec hz_relationship_v2pub.relationship_rec_type;
1211: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
1212: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
1213: email_rec hz_contact_point_v2pub.email_rec_type;
1214: arole_rec hz_cust_account_role_v2pub.cust_account_role_rec_type;
1215:

Line 1501: HZ_PARTY_CONTACT_V2PUB.update_org_contact (

1497: ELSE
1498: ocon_rec.party_rel_rec.relationship_id := NULL;
1499: END IF;
1500:
1501: HZ_PARTY_CONTACT_V2PUB.update_org_contact (
1502: p_org_contact_rec => ocon_rec,
1503: p_cont_object_version_number => l_org_contact_object_version,
1504: p_rel_object_version_number => l_rel_object_version,
1505: p_party_object_version_number => l_party_object_version,

Line 1525: -- mail_stop is not in V2 hz_party_contact_v2pub.org_contact_rec_type

1521: END IF;
1522:
1523:
1524: --
1525: -- mail_stop is not in V2 hz_party_contact_v2pub.org_contact_rec_type
1526: -- Need to do this additional update in replacement
1527: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is
1528: -- changed to support the attribute MAIL_STOP
1529: --

Line 1527: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is

1523:
1524: --
1525: -- mail_stop is not in V2 hz_party_contact_v2pub.org_contact_rec_type
1526: -- Need to do this additional update in replacement
1527: -- This fix has to be removed if V2 hz_party_contact_v2pub.org_contact_rec_type is
1528: -- changed to support the attribute MAIL_STOP
1529: --
1530: IF (X_Mail_Stop IS NOT NULL)
1531: AND (X_Mail_Stop <> FND_API.G_MISS_CHAR)

Line 1808: ( p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,

1804:
1805:
1806: --{BUG#4064156
1807: PROCEDURE compare_existing_contact_info
1808: ( p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,
1809: x_update_required IN OUT NOCOPY VARCHAR2,
1810: x_relationship_id IN OUT NOCOPY NUMBER,
1811: x_ocon_version_number IN OUT NOCOPY NUMBER )
1812: IS

Line 1845: l_ocon_rec hz_party_contact_v2pub.org_contact_rec_type;

1841: object_version_number,
1842: party_relationship_id
1843: FROM hz_org_contacts
1844: WHERE org_contact_id = p_ocon_rec.org_contact_id;
1845: l_ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
1846: BEGIN
1847: x_update_required := 'N';
1848: IF p_ocon_rec.org_contact_id IS NOT NULL THEN
1849: OPEN c;

Line 1999: (p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type)

1995: WHEN NO_DATA_FOUND THEN NULL;
1996: END;
1997:
1998: PROCEDURE upd_ocon_update
1999: (p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type)
2000: IS
2001: BEGIN
2002: UPDATE hz_org_contacts
2003: SET contact_number = p_ocon_rec.contact_number,