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_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_PARTIES

Line 86: l_party_name hz_parties.party_name%TYPE;

82: ) IS
83:
84: l_api_name CONSTANT VARCHAR2(30) := 'get_party_rec';
85: x_party_dup_rec party_dup_rec_type;
86: l_party_name hz_parties.party_name%TYPE;
87: l_party_type hz_parties.party_type%TYPE;
88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;

Line 87: l_party_type hz_parties.party_type%TYPE;

83:
84: l_api_name CONSTANT VARCHAR2(30) := 'get_party_rec';
85: x_party_dup_rec party_dup_rec_type;
86: l_party_name hz_parties.party_name%TYPE;
87: l_party_type hz_parties.party_type%TYPE;
88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;

Line 88: l_customer_key hz_parties.customer_key%TYPE;

84: l_api_name CONSTANT VARCHAR2(30) := 'get_party_rec';
85: x_party_dup_rec party_dup_rec_type;
86: l_party_name hz_parties.party_name%TYPE;
87: l_party_type hz_parties.party_type%TYPE;
88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;

Line 89: l_group_type hz_parties.group_type%TYPE;

85: x_party_dup_rec party_dup_rec_type;
86: l_party_name hz_parties.party_name%TYPE;
87: l_party_type hz_parties.party_type%TYPE;
88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;

Line 90: l_country hz_parties.country%TYPE;

86: l_party_name hz_parties.party_name%TYPE;
87: l_party_type hz_parties.party_type%TYPE;
88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;

Line 91: l_address1 hz_parties.address1%TYPE;

87: l_party_type hz_parties.party_type%TYPE;
88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;

Line 92: l_address2 hz_parties.address2%TYPE;

88: l_customer_key hz_parties.customer_key%TYPE;
89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;

Line 93: l_address3 hz_parties.address3%TYPE;

89: l_group_type hz_parties.group_type%TYPE;
90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;

Line 94: l_address4 hz_parties.address4%TYPE;

90: l_country hz_parties.country%TYPE;
91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;

Line 95: l_city hz_parties.city%TYPE;

91: l_address1 hz_parties.address1%TYPE;
92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;

Line 96: l_state hz_parties.state%TYPE;

92: l_address2 hz_parties.address2%TYPE;
93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;

Line 97: l_postal_code hz_parties.postal_code%TYPE;

93: l_address3 hz_parties.address3%TYPE;
94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;

Line 98: l_province hz_parties.province%TYPE;

94: l_address4 hz_parties.address4%TYPE;
95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;
102: l_language_name hz_parties.language_name%TYPE;

Line 99: l_county hz_parties.county%TYPE;

95: l_city hz_parties.city%TYPE;
96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;
102: l_language_name hz_parties.language_name%TYPE;
103: l_created_by_module hz_parties.created_by_module%TYPE;

Line 100: l_url hz_parties.url%TYPE;

96: l_state hz_parties.state%TYPE;
97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;
102: l_language_name hz_parties.language_name%TYPE;
103: l_created_by_module hz_parties.created_by_module%TYPE;
104: l_application_id NUMBER;

Line 101: l_email_address hz_parties.email_address%TYPE;

97: l_postal_code hz_parties.postal_code%TYPE;
98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;
102: l_language_name hz_parties.language_name%TYPE;
103: l_created_by_module hz_parties.created_by_module%TYPE;
104: l_application_id NUMBER;
105:

Line 102: l_language_name hz_parties.language_name%TYPE;

98: l_province hz_parties.province%TYPE;
99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;
102: l_language_name hz_parties.language_name%TYPE;
103: l_created_by_module hz_parties.created_by_module%TYPE;
104: l_application_id NUMBER;
105:
106: BEGIN

Line 103: l_created_by_module hz_parties.created_by_module%TYPE;

99: l_county hz_parties.county%TYPE;
100: l_url hz_parties.url%TYPE;
101: l_email_address hz_parties.email_address%TYPE;
102: l_language_name hz_parties.language_name%TYPE;
103: l_created_by_module hz_parties.created_by_module%TYPE;
104: l_application_id NUMBER;
105:
106: BEGIN
107:

Line 127: hz_parties_pkg.select_row (

123: END IF;
124:
125: x_party_rec.party_id := p_party_id;
126:
127: hz_parties_pkg.select_row (
128: X_PARTY_ID => x_party_rec.party_id,
129: X_PARTY_NUMBER => x_party_rec.party_number,
130: X_PARTY_NAME => l_party_name,
131: X_PARTY_TYPE => l_party_type,

Line 590: -- 'HZ_PARTIES'

586:
587: -- the PARTY_RELATIONSHIP type party will be created if
588: -- the relationship type has create_party_flag = 'Y' and
589: -- both the subject_table_name and object_table_name are
590: -- 'HZ_PARTIES'
591: IF r_rel_type.create_party_flag = 'Y'
592: AND
593: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
594: AND

Line 593: p_relationship_rec.subject_table_name = 'HZ_PARTIES'

589: -- both the subject_table_name and object_table_name are
590: -- 'HZ_PARTIES'
591: IF r_rel_type.create_party_flag = 'Y'
592: AND
593: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
594: AND
595: p_relationship_rec.object_table_name = 'HZ_PARTIES'
596: THEN
597: x_created_party := 'Y';

Line 595: p_relationship_rec.object_table_name = 'HZ_PARTIES'

591: IF r_rel_type.create_party_flag = 'Y'
592: AND
593: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
594: AND
595: p_relationship_rec.object_table_name = 'HZ_PARTIES'
596: THEN
597: x_created_party := 'Y';
598: do_create_party(
599: p_party_type => 'PARTY_RELATIONSHIP',

Line 613: -- Denormalize flags to HZ_PARTIES:

609: ELSE
610: x_created_party := 'N';
611: END IF;
612:
613: -- Denormalize flags to HZ_PARTIES:
614: -- COMPETITOR_FLAG
615: -- REFERENCE_USE_FLAG
616: -- THIRD_PARTY_FLAG
617: -- Denormalization will be done only if content_source_type

Line 619: -- object_table_name are 'HZ_PARTIES'

615: -- REFERENCE_USE_FLAG
616: -- THIRD_PARTY_FLAG
617: -- Denormalization will be done only if content_source_type
618: -- is 'USER_ENTERED' and both subject_table_name and
619: -- object_table_name are 'HZ_PARTIES'
620:
621: -- Bug 2197181: added for mix-n-match project. Denormalize
622: -- the three flags when the data source is visible (i.e.
623: -- selected).

Line 632: AND p_relationship_rec.subject_table_name = 'HZ_PARTIES'

628:
629: IF p_relationship_rec.relationship_code IN
630: ('COMPETITOR_OF', 'REFERENCE_FOR', 'PARTNER_OF')
631: --AND g_rel_is_datasource_selected = 'Y'
632: AND p_relationship_rec.subject_table_name = 'HZ_PARTIES'
633: AND p_relationship_rec.object_table_name = 'HZ_PARTIES' THEN
634:
635: do_update_party_flags(
636: p_relationship_rec,

Line 633: AND p_relationship_rec.object_table_name = 'HZ_PARTIES' THEN

629: IF p_relationship_rec.relationship_code IN
630: ('COMPETITOR_OF', 'REFERENCE_FOR', 'PARTNER_OF')
631: --AND g_rel_is_datasource_selected = 'Y'
632: AND p_relationship_rec.subject_table_name = 'HZ_PARTIES'
633: AND p_relationship_rec.object_table_name = 'HZ_PARTIES' THEN
634:
635: do_update_party_flags(
636: p_relationship_rec,
637: p_relationship_rec.subject_id);

Line 879: l_party_name hz_parties.PARTY_NAME%TYPE;

875: l_generate_party_number VARCHAR2(1);
876: l_rowid ROWID := NULL;
877: l_count NUMBER;
878: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
879: l_party_name hz_parties.PARTY_NAME%TYPE;
880: l_subject_name hz_parties.PARTY_NAME%TYPE;
881: l_object_name hz_parties.PARTY_NAME%TYPE;
882: l_customer_key hz_parties.CUSTOMER_KEY%TYPE;
883: l_code_assignment_id NUMBER;

Line 880: l_subject_name hz_parties.PARTY_NAME%TYPE;

876: l_rowid ROWID := NULL;
877: l_count NUMBER;
878: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
879: l_party_name hz_parties.PARTY_NAME%TYPE;
880: l_subject_name hz_parties.PARTY_NAME%TYPE;
881: l_object_name hz_parties.PARTY_NAME%TYPE;
882: l_customer_key hz_parties.CUSTOMER_KEY%TYPE;
883: l_code_assignment_id NUMBER;
884: l_msg_count NUMBER;

Line 881: l_object_name hz_parties.PARTY_NAME%TYPE;

877: l_count NUMBER;
878: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
879: l_party_name hz_parties.PARTY_NAME%TYPE;
880: l_subject_name hz_parties.PARTY_NAME%TYPE;
881: l_object_name hz_parties.PARTY_NAME%TYPE;
882: l_customer_key hz_parties.CUSTOMER_KEY%TYPE;
883: l_code_assignment_id NUMBER;
884: l_msg_count NUMBER;
885: l_msg_data VARCHAR2(2000);

Line 882: l_customer_key hz_parties.CUSTOMER_KEY%TYPE;

878: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
879: l_party_name hz_parties.PARTY_NAME%TYPE;
880: l_subject_name hz_parties.PARTY_NAME%TYPE;
881: l_object_name hz_parties.PARTY_NAME%TYPE;
882: l_customer_key hz_parties.CUSTOMER_KEY%TYPE;
883: l_code_assignment_id NUMBER;
884: l_msg_count NUMBER;
885: l_msg_data VARCHAR2(2000);
886: l_dummy VARCHAR2(1);

Line 898: FROM hz_parties

894:
895: -- build the party_name for relationship party
896: SELECT PARTY_NAME
897: INTO l_subject_name
898: FROM hz_parties
899: WHERE PARTY_ID = p_relationship_rec.subject_id;
900:
901: SELECT PARTY_NAME
902: INTO l_object_name

Line 903: FROM hz_parties

899: WHERE PARTY_ID = p_relationship_rec.subject_id;
900:
901: SELECT PARTY_NAME
902: INTO l_object_name
903: FROM hz_parties
904: WHERE PARTY_ID = p_relationship_rec.object_id;
905:
906: l_party_name := SUBSTRB(l_subject_name || '-' ||
907: l_object_name || '-' ||

Line 912: hz_parties_PKG.Insert_Row (

908: l_party_number, 1, 360);
909:
910:
911:
912: hz_parties_PKG.Insert_Row (
913: X_PARTY_ID => l_party_rec.party_id,
914: X_PARTY_NUMBER => l_party_rec.party_number,
915: X_PARTY_NAME => l_party_name,
916: X_PARTY_TYPE => p_party_type,

Line 1003: 'HZ_PARTIES',

999: /*
1000: per HLD,mosr record should not be created for copy case, since old osr is still active
1001: hz_orig_system_ref_pvt.create_mosr_for_merge(
1002: FND_API.G_FALSE,
1003: 'HZ_PARTIES',
1004: l_party_rec.party_id,
1005: x_return_status,
1006: l_msg_count,
1007: l_msg_data);

Line 1021: UPDATE hz_parties SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;

1017: l_party_name := SUBSTRB(l_subject_name || '-' ||
1018: l_object_name || '-' ||
1019: x_party_number, 1, 360);
1020:
1021: UPDATE hz_parties SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
1022:
1023: END do_create_party;
1024:
1025: PROCEDURE do_update_party_flags(

Line 1043: FROM hz_parties

1039:
1040: --check if party record is locked by any one else.
1041: BEGIN
1042: SELECT party_id INTO l_party_id
1043: FROM hz_parties
1044: WHERE party_id = p_party_id
1045: FOR UPDATE NOWAIT;
1046: EXCEPTION WHEN OTHERS THEN
1047: l_record_locked := 'Y';

Line 1072: UPDATE HZ_PARTIES

1068: THEN
1069: l_competitor_flag := 'Y';
1070: END IF;
1071:
1072: UPDATE HZ_PARTIES
1073: SET COMPETITOR_FLAG = l_competitor_flag
1074: WHERE PARTY_ID = p_party_id;
1075:
1076: ELSIF p_relationship_rec.relationship_code = 'REFERENCE_FOR' THEN

Line 1084: UPDATE HZ_PARTIES

1080: THEN
1081: l_reference_use_flag := 'Y';
1082: END IF;
1083:
1084: UPDATE HZ_PARTIES
1085: SET REFERENCE_USE_FLAG = l_reference_use_flag
1086: WHERE PARTY_ID = p_party_id;
1087:
1088: ELSIF p_relationship_rec.relationship_code = 'PARTNER_OF' THEN

Line 1095: UPDATE HZ_PARTIES

1091: THEN
1092: l_third_party_flag := 'Y';
1093: END IF;
1094:
1095: UPDATE HZ_PARTIES
1096: SET THIRD_PARTY_FLAG = l_third_party_flag
1097: WHERE PARTY_ID = p_party_id;
1098:
1099: END IF;

Line 1966: FROM hz_parties

1962: WHERE location_id = p_location_id;
1963:
1964: CURSOR c_party IS
1965: SELECT 'Y'
1966: FROM hz_parties
1967: WHERE party_id = p_party_id
1968: FOR UPDATE NOWAIT;
1969:
1970: l_location_rec c_loc%ROWTYPE;

Line 1988: -- components in hz_parties.

1984: END;
1985:
1986:
1987: -- if location_id is null, we will null out the location
1988: -- components in hz_parties.
1989:
1990: IF p_location_id IS NULL THEN
1991: l_location_rec.country := NULL;
1992: l_location_rec.address1 := NULL;

Line 2012: UPDATE hz_parties

2008: END IF;
2009:
2010: if l_do_not_normalize <> 'Y' then
2011:
2012: UPDATE hz_parties
2013: SET country = l_location_rec.country,
2014: address1 = l_location_rec.address1,
2015: address2 = l_location_rec.address2,
2016: address3 = l_location_rec.address3,

Line 3449: -- De-normalize primary contact point to hz_parties.

3445: END IF;
3446: CLOSE c_cp;
3447: END IF;
3448:
3449: -- De-normalize primary contact point to hz_parties.
3450: -- url is mandatory if contact_point_type = 'WEB'.
3451: -- email_address is mandatory if contact_point_type = 'EMAIL'.
3452:
3453: IF p_contact_point_rec.primary_flag = 'Y' AND

Line 3454: p_contact_point_rec.owner_table_name = 'HZ_PARTIES' AND

3450: -- url is mandatory if contact_point_type = 'WEB'.
3451: -- email_address is mandatory if contact_point_type = 'EMAIL'.
3452:
3453: IF p_contact_point_rec.primary_flag = 'Y' AND
3454: p_contact_point_rec.owner_table_name = 'HZ_PARTIES' AND
3455: (p_contact_point_rec.contact_point_type = 'WEB' OR
3456: p_contact_point_rec.contact_point_type = 'EMAIL')
3457: THEN
3458: do_denormalize_contact_point(p_contact_point_rec.owner_table_id,

Line 3625: UPDATE hz_parties

3621: p_email_address IN VARCHAR2
3622: ) IS
3623: BEGIN
3624: IF p_contact_point_type = 'WEB' THEN
3625: UPDATE hz_parties
3626: SET url = p_url
3627: WHERE party_id = p_party_id;
3628: ELSIF p_contact_point_type = 'EMAIL' THEN
3629: UPDATE hz_parties

Line 3629: UPDATE hz_parties

3625: UPDATE hz_parties
3626: SET url = p_url
3627: WHERE party_id = p_party_id;
3628: ELSIF p_contact_point_type = 'EMAIL' THEN
3629: UPDATE hz_parties
3630: SET email_address = p_email_address
3631: WHERE party_id = p_party_id;
3632: END IF;
3633: END do_denormalize_contact_point;