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.AS_SALES_LEADS_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 88: last_update_date = hz_utility_pub.last_update_date,

84: BEGIN
85: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
86: UPDATE AS_SALES_LEADS
87: set customer_id = p_to_fk_id,
88: last_update_date = hz_utility_pub.last_update_date,
89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,
91: request_id = hz_utility_pub.request_id,
92: program_application_id = hz_utility_pub.program_application_id,

Line 89: last_updated_by = hz_utility_pub.user_id,

85: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
86: UPDATE AS_SALES_LEADS
87: set customer_id = p_to_fk_id,
88: last_update_date = hz_utility_pub.last_update_date,
89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,
91: request_id = hz_utility_pub.request_id,
92: program_application_id = hz_utility_pub.program_application_id,
93: program_id = hz_utility_pub.program_id,

Line 90: last_update_login = hz_utility_pub.last_update_login,

86: UPDATE AS_SALES_LEADS
87: set customer_id = p_to_fk_id,
88: last_update_date = hz_utility_pub.last_update_date,
89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,
91: request_id = hz_utility_pub.request_id,
92: program_application_id = hz_utility_pub.program_application_id,
93: program_id = hz_utility_pub.program_id,
94: program_update_date = sysdate

Line 91: request_id = hz_utility_pub.request_id,

87: set customer_id = p_to_fk_id,
88: last_update_date = hz_utility_pub.last_update_date,
89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,
91: request_id = hz_utility_pub.request_id,
92: program_application_id = hz_utility_pub.program_application_id,
93: program_id = hz_utility_pub.program_id,
94: program_update_date = sysdate
95: where customer_id = p_from_fk_id;

Line 92: program_application_id = hz_utility_pub.program_application_id,

88: last_update_date = hz_utility_pub.last_update_date,
89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,
91: request_id = hz_utility_pub.request_id,
92: program_application_id = hz_utility_pub.program_application_id,
93: program_id = hz_utility_pub.program_id,
94: program_update_date = sysdate
95: where customer_id = p_from_fk_id;
96:

Line 93: program_id = hz_utility_pub.program_id,

89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,
91: request_id = hz_utility_pub.request_id,
92: program_application_id = hz_utility_pub.program_application_id,
93: program_id = hz_utility_pub.program_id,
94: program_update_date = sysdate
95: where customer_id = p_from_fk_id;
96:
97: UPDATE AS_SALES_LEADS

Line 99: last_update_date = hz_utility_pub.last_update_date,

95: where customer_id = p_from_fk_id;
96:
97: UPDATE AS_SALES_LEADS
98: set incumbent_partner_party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: request_id = hz_utility_pub.request_id,
103: program_application_id = hz_utility_pub.program_application_id,

Line 100: last_updated_by = hz_utility_pub.user_id,

96:
97: UPDATE AS_SALES_LEADS
98: set incumbent_partner_party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: request_id = hz_utility_pub.request_id,
103: program_application_id = hz_utility_pub.program_application_id,
104: program_id = hz_utility_pub.program_id,

Line 101: last_update_login = hz_utility_pub.last_update_login,

97: UPDATE AS_SALES_LEADS
98: set incumbent_partner_party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: request_id = hz_utility_pub.request_id,
103: program_application_id = hz_utility_pub.program_application_id,
104: program_id = hz_utility_pub.program_id,
105: program_update_date = sysdate

Line 102: request_id = hz_utility_pub.request_id,

98: set incumbent_partner_party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: request_id = hz_utility_pub.request_id,
103: program_application_id = hz_utility_pub.program_application_id,
104: program_id = hz_utility_pub.program_id,
105: program_update_date = sysdate
106: where incumbent_partner_party_id = p_from_fk_id;

Line 103: program_application_id = hz_utility_pub.program_application_id,

99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: request_id = hz_utility_pub.request_id,
103: program_application_id = hz_utility_pub.program_application_id,
104: program_id = hz_utility_pub.program_id,
105: program_update_date = sysdate
106: where incumbent_partner_party_id = p_from_fk_id;
107:

Line 104: program_id = hz_utility_pub.program_id,

100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,
102: request_id = hz_utility_pub.request_id,
103: program_application_id = hz_utility_pub.program_application_id,
104: program_id = hz_utility_pub.program_id,
105: program_update_date = sysdate
106: where incumbent_partner_party_id = p_from_fk_id;
107:
108: UPDATE AS_SALES_LEADS

Line 110: last_update_date = hz_utility_pub.last_update_date,

106: where incumbent_partner_party_id = p_from_fk_id;
107:
108: UPDATE AS_SALES_LEADS
109: set primary_contact_party_id = p_to_fk_id,
110: last_update_date = hz_utility_pub.last_update_date,
111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,
113: request_id = hz_utility_pub.request_id,
114: program_application_id = hz_utility_pub.program_application_id,

Line 111: last_updated_by = hz_utility_pub.user_id,

107:
108: UPDATE AS_SALES_LEADS
109: set primary_contact_party_id = p_to_fk_id,
110: last_update_date = hz_utility_pub.last_update_date,
111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,
113: request_id = hz_utility_pub.request_id,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,

Line 112: last_update_login = hz_utility_pub.last_update_login,

108: UPDATE AS_SALES_LEADS
109: set primary_contact_party_id = p_to_fk_id,
110: last_update_date = hz_utility_pub.last_update_date,
111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,
113: request_id = hz_utility_pub.request_id,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate

Line 113: request_id = hz_utility_pub.request_id,

109: set primary_contact_party_id = p_to_fk_id,
110: last_update_date = hz_utility_pub.last_update_date,
111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,
113: request_id = hz_utility_pub.request_id,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where primary_contact_party_id = p_from_fk_id;

Line 114: program_application_id = hz_utility_pub.program_application_id,

110: last_update_date = hz_utility_pub.last_update_date,
111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,
113: request_id = hz_utility_pub.request_id,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where primary_contact_party_id = p_from_fk_id;
118:

Line 115: program_id = hz_utility_pub.program_id,

111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,
113: request_id = hz_utility_pub.request_id,
114: program_application_id = hz_utility_pub.program_application_id,
115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where primary_contact_party_id = p_from_fk_id;
118:
119: UPDATE AS_SALES_LEADS

Line 121: last_update_date = hz_utility_pub.last_update_date,

117: where primary_contact_party_id = p_from_fk_id;
118:
119: UPDATE AS_SALES_LEADS
120: set primary_cnt_person_party_id = p_to_fk_id,
121: last_update_date = hz_utility_pub.last_update_date,
122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,
124: request_id = hz_utility_pub.request_id,
125: program_application_id = hz_utility_pub.program_application_id,

Line 122: last_updated_by = hz_utility_pub.user_id,

118:
119: UPDATE AS_SALES_LEADS
120: set primary_cnt_person_party_id = p_to_fk_id,
121: last_update_date = hz_utility_pub.last_update_date,
122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,
124: request_id = hz_utility_pub.request_id,
125: program_application_id = hz_utility_pub.program_application_id,
126: program_id = hz_utility_pub.program_id,

Line 123: last_update_login = hz_utility_pub.last_update_login,

119: UPDATE AS_SALES_LEADS
120: set primary_cnt_person_party_id = p_to_fk_id,
121: last_update_date = hz_utility_pub.last_update_date,
122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,
124: request_id = hz_utility_pub.request_id,
125: program_application_id = hz_utility_pub.program_application_id,
126: program_id = hz_utility_pub.program_id,
127: program_update_date = sysdate

Line 124: request_id = hz_utility_pub.request_id,

120: set primary_cnt_person_party_id = p_to_fk_id,
121: last_update_date = hz_utility_pub.last_update_date,
122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,
124: request_id = hz_utility_pub.request_id,
125: program_application_id = hz_utility_pub.program_application_id,
126: program_id = hz_utility_pub.program_id,
127: program_update_date = sysdate
128: where primary_cnt_person_party_id = p_from_fk_id;

Line 125: program_application_id = hz_utility_pub.program_application_id,

121: last_update_date = hz_utility_pub.last_update_date,
122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,
124: request_id = hz_utility_pub.request_id,
125: program_application_id = hz_utility_pub.program_application_id,
126: program_id = hz_utility_pub.program_id,
127: program_update_date = sysdate
128: where primary_cnt_person_party_id = p_from_fk_id;
129:

Line 126: program_id = hz_utility_pub.program_id,

122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,
124: request_id = hz_utility_pub.request_id,
125: program_application_id = hz_utility_pub.program_application_id,
126: program_id = hz_utility_pub.program_id,
127: program_update_date = sysdate
128: where primary_cnt_person_party_id = p_from_fk_id;
129:
130: UPDATE AS_SALES_LEADS

Line 132: last_update_date = hz_utility_pub.last_update_date,

128: where primary_cnt_person_party_id = p_from_fk_id;
129:
130: UPDATE AS_SALES_LEADS
131: set referred_by = p_to_fk_id,
132: last_update_date = hz_utility_pub.last_update_date,
133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,
135: request_id = hz_utility_pub.request_id,
136: program_application_id = hz_utility_pub.program_application_id,

Line 133: last_updated_by = hz_utility_pub.user_id,

129:
130: UPDATE AS_SALES_LEADS
131: set referred_by = p_to_fk_id,
132: last_update_date = hz_utility_pub.last_update_date,
133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,
135: request_id = hz_utility_pub.request_id,
136: program_application_id = hz_utility_pub.program_application_id,
137: program_id = hz_utility_pub.program_id,

Line 134: last_update_login = hz_utility_pub.last_update_login,

130: UPDATE AS_SALES_LEADS
131: set referred_by = p_to_fk_id,
132: last_update_date = hz_utility_pub.last_update_date,
133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,
135: request_id = hz_utility_pub.request_id,
136: program_application_id = hz_utility_pub.program_application_id,
137: program_id = hz_utility_pub.program_id,
138: program_update_date = sysdate

Line 135: request_id = hz_utility_pub.request_id,

131: set referred_by = p_to_fk_id,
132: last_update_date = hz_utility_pub.last_update_date,
133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,
135: request_id = hz_utility_pub.request_id,
136: program_application_id = hz_utility_pub.program_application_id,
137: program_id = hz_utility_pub.program_id,
138: program_update_date = sysdate
139: where referred_by = p_from_fk_id;

Line 136: program_application_id = hz_utility_pub.program_application_id,

132: last_update_date = hz_utility_pub.last_update_date,
133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,
135: request_id = hz_utility_pub.request_id,
136: program_application_id = hz_utility_pub.program_application_id,
137: program_id = hz_utility_pub.program_id,
138: program_update_date = sysdate
139: where referred_by = p_from_fk_id;
140: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site

Line 137: program_id = hz_utility_pub.program_id,

133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,
135: request_id = hz_utility_pub.request_id,
136: program_application_id = hz_utility_pub.program_application_id,
137: program_id = hz_utility_pub.program_id,
138: program_update_date = sysdate
139: where referred_by = p_from_fk_id;
140: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
141: UPDATE AS_SALES_LEADS

Line 143: last_update_date = hz_utility_pub.last_update_date,

139: where referred_by = p_from_fk_id;
140: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
141: UPDATE AS_SALES_LEADS
142: set address_id = p_to_fk_id,
143: last_update_date = hz_utility_pub.last_update_date,
144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,
146: request_id = hz_utility_pub.request_id,
147: program_application_id = hz_utility_pub.program_application_id,

Line 144: last_updated_by = hz_utility_pub.user_id,

140: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
141: UPDATE AS_SALES_LEADS
142: set address_id = p_to_fk_id,
143: last_update_date = hz_utility_pub.last_update_date,
144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,
146: request_id = hz_utility_pub.request_id,
147: program_application_id = hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,

Line 145: last_update_login = hz_utility_pub.last_update_login,

141: UPDATE AS_SALES_LEADS
142: set address_id = p_to_fk_id,
143: last_update_date = hz_utility_pub.last_update_date,
144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,
146: request_id = hz_utility_pub.request_id,
147: program_application_id = hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate

Line 146: request_id = hz_utility_pub.request_id,

142: set address_id = p_to_fk_id,
143: last_update_date = hz_utility_pub.last_update_date,
144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,
146: request_id = hz_utility_pub.request_id,
147: program_application_id = hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where address_id = p_from_fk_id;

Line 147: program_application_id = hz_utility_pub.program_application_id,

143: last_update_date = hz_utility_pub.last_update_date,
144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,
146: request_id = hz_utility_pub.request_id,
147: program_application_id = hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where address_id = p_from_fk_id;
151: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points

Line 148: program_id = hz_utility_pub.program_id,

144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,
146: request_id = hz_utility_pub.request_id,
147: program_application_id = hz_utility_pub.program_application_id,
148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where address_id = p_from_fk_id;
151: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
152: UPDATE AS_SALES_LEADS

Line 154: last_update_date = hz_utility_pub.last_update_date,

150: where address_id = p_from_fk_id;
151: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
152: UPDATE AS_SALES_LEADS
153: set primary_contact_phone_id = p_to_fk_id,
154: last_update_date = hz_utility_pub.last_update_date,
155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,
157: request_id = hz_utility_pub.request_id,
158: program_application_id = hz_utility_pub.program_application_id,

Line 155: last_updated_by = hz_utility_pub.user_id,

151: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
152: UPDATE AS_SALES_LEADS
153: set primary_contact_phone_id = p_to_fk_id,
154: last_update_date = hz_utility_pub.last_update_date,
155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,
157: request_id = hz_utility_pub.request_id,
158: program_application_id = hz_utility_pub.program_application_id,
159: program_id = hz_utility_pub.program_id,

Line 156: last_update_login = hz_utility_pub.last_update_login,

152: UPDATE AS_SALES_LEADS
153: set primary_contact_phone_id = p_to_fk_id,
154: last_update_date = hz_utility_pub.last_update_date,
155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,
157: request_id = hz_utility_pub.request_id,
158: program_application_id = hz_utility_pub.program_application_id,
159: program_id = hz_utility_pub.program_id,
160: program_update_date = sysdate

Line 157: request_id = hz_utility_pub.request_id,

153: set primary_contact_phone_id = p_to_fk_id,
154: last_update_date = hz_utility_pub.last_update_date,
155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,
157: request_id = hz_utility_pub.request_id,
158: program_application_id = hz_utility_pub.program_application_id,
159: program_id = hz_utility_pub.program_id,
160: program_update_date = sysdate
161: where primary_contact_phone_id = p_from_fk_id;

Line 158: program_application_id = hz_utility_pub.program_application_id,

154: last_update_date = hz_utility_pub.last_update_date,
155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,
157: request_id = hz_utility_pub.request_id,
158: program_application_id = hz_utility_pub.program_application_id,
159: program_id = hz_utility_pub.program_id,
160: program_update_date = sysdate
161: where primary_contact_phone_id = p_from_fk_id;
162: END IF;

Line 159: program_id = hz_utility_pub.program_id,

155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,
157: request_id = hz_utility_pub.request_id,
158: program_application_id = hz_utility_pub.program_application_id,
159: program_id = hz_utility_pub.program_id,
160: program_update_date = sysdate
161: where primary_contact_phone_id = p_from_fk_id;
162: END IF;
163: EXCEPTION

Line 250: last_update_date = hz_utility_pub.last_update_date,

246: BEGIN
247: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
248: UPDATE AS_SALES_LEAD_CONTACTS
249: set customer_id = p_to_fk_id,
250: last_update_date = hz_utility_pub.last_update_date,
251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,
253: request_id = hz_utility_pub.request_id,
254: program_application_id = hz_utility_pub.program_application_id,

Line 251: last_updated_by = hz_utility_pub.user_id,

247: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
248: UPDATE AS_SALES_LEAD_CONTACTS
249: set customer_id = p_to_fk_id,
250: last_update_date = hz_utility_pub.last_update_date,
251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,
253: request_id = hz_utility_pub.request_id,
254: program_application_id = hz_utility_pub.program_application_id,
255: program_id = hz_utility_pub.program_id,

Line 252: last_update_login = hz_utility_pub.last_update_login,

248: UPDATE AS_SALES_LEAD_CONTACTS
249: set customer_id = p_to_fk_id,
250: last_update_date = hz_utility_pub.last_update_date,
251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,
253: request_id = hz_utility_pub.request_id,
254: program_application_id = hz_utility_pub.program_application_id,
255: program_id = hz_utility_pub.program_id,
256: program_update_date = sysdate

Line 253: request_id = hz_utility_pub.request_id,

249: set customer_id = p_to_fk_id,
250: last_update_date = hz_utility_pub.last_update_date,
251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,
253: request_id = hz_utility_pub.request_id,
254: program_application_id = hz_utility_pub.program_application_id,
255: program_id = hz_utility_pub.program_id,
256: program_update_date = sysdate
257: where customer_id = p_from_fk_id;

Line 254: program_application_id = hz_utility_pub.program_application_id,

250: last_update_date = hz_utility_pub.last_update_date,
251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,
253: request_id = hz_utility_pub.request_id,
254: program_application_id = hz_utility_pub.program_application_id,
255: program_id = hz_utility_pub.program_id,
256: program_update_date = sysdate
257: where customer_id = p_from_fk_id;
258:

Line 255: program_id = hz_utility_pub.program_id,

251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,
253: request_id = hz_utility_pub.request_id,
254: program_application_id = hz_utility_pub.program_application_id,
255: program_id = hz_utility_pub.program_id,
256: program_update_date = sysdate
257: where customer_id = p_from_fk_id;
258:
259: UPDATE AS_SALES_LEAD_CONTACTS

Line 261: last_update_date = hz_utility_pub.last_update_date,

257: where customer_id = p_from_fk_id;
258:
259: UPDATE AS_SALES_LEAD_CONTACTS
260: set contact_party_id = p_to_fk_id,
261: last_update_date = hz_utility_pub.last_update_date,
262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,
264: request_id = hz_utility_pub.request_id,
265: program_application_id = hz_utility_pub.program_application_id,

Line 262: last_updated_by = hz_utility_pub.user_id,

258:
259: UPDATE AS_SALES_LEAD_CONTACTS
260: set contact_party_id = p_to_fk_id,
261: last_update_date = hz_utility_pub.last_update_date,
262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,
264: request_id = hz_utility_pub.request_id,
265: program_application_id = hz_utility_pub.program_application_id,
266: program_id = hz_utility_pub.program_id,

Line 263: last_update_login = hz_utility_pub.last_update_login,

259: UPDATE AS_SALES_LEAD_CONTACTS
260: set contact_party_id = p_to_fk_id,
261: last_update_date = hz_utility_pub.last_update_date,
262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,
264: request_id = hz_utility_pub.request_id,
265: program_application_id = hz_utility_pub.program_application_id,
266: program_id = hz_utility_pub.program_id,
267: program_update_date = sysdate

Line 264: request_id = hz_utility_pub.request_id,

260: set contact_party_id = p_to_fk_id,
261: last_update_date = hz_utility_pub.last_update_date,
262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,
264: request_id = hz_utility_pub.request_id,
265: program_application_id = hz_utility_pub.program_application_id,
266: program_id = hz_utility_pub.program_id,
267: program_update_date = sysdate
268: where contact_party_id = p_from_fk_id;

Line 265: program_application_id = hz_utility_pub.program_application_id,

261: last_update_date = hz_utility_pub.last_update_date,
262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,
264: request_id = hz_utility_pub.request_id,
265: program_application_id = hz_utility_pub.program_application_id,
266: program_id = hz_utility_pub.program_id,
267: program_update_date = sysdate
268: where contact_party_id = p_from_fk_id;
269: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site

Line 266: program_id = hz_utility_pub.program_id,

262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,
264: request_id = hz_utility_pub.request_id,
265: program_application_id = hz_utility_pub.program_application_id,
266: program_id = hz_utility_pub.program_id,
267: program_update_date = sysdate
268: where contact_party_id = p_from_fk_id;
269: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
270: UPDATE AS_SALES_LEAD_CONTACTS

Line 272: last_update_date = hz_utility_pub.last_update_date,

268: where contact_party_id = p_from_fk_id;
269: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
270: UPDATE AS_SALES_LEAD_CONTACTS
271: set address_id = p_to_fk_id,
272: last_update_date = hz_utility_pub.last_update_date,
273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,
275: request_id = hz_utility_pub.request_id,
276: program_application_id = hz_utility_pub.program_application_id,

Line 273: last_updated_by = hz_utility_pub.user_id,

269: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
270: UPDATE AS_SALES_LEAD_CONTACTS
271: set address_id = p_to_fk_id,
272: last_update_date = hz_utility_pub.last_update_date,
273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,
275: request_id = hz_utility_pub.request_id,
276: program_application_id = hz_utility_pub.program_application_id,
277: program_id = hz_utility_pub.program_id,

Line 274: last_update_login = hz_utility_pub.last_update_login,

270: UPDATE AS_SALES_LEAD_CONTACTS
271: set address_id = p_to_fk_id,
272: last_update_date = hz_utility_pub.last_update_date,
273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,
275: request_id = hz_utility_pub.request_id,
276: program_application_id = hz_utility_pub.program_application_id,
277: program_id = hz_utility_pub.program_id,
278: program_update_date = sysdate

Line 275: request_id = hz_utility_pub.request_id,

271: set address_id = p_to_fk_id,
272: last_update_date = hz_utility_pub.last_update_date,
273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,
275: request_id = hz_utility_pub.request_id,
276: program_application_id = hz_utility_pub.program_application_id,
277: program_id = hz_utility_pub.program_id,
278: program_update_date = sysdate
279: where address_id = p_from_fk_id;

Line 276: program_application_id = hz_utility_pub.program_application_id,

272: last_update_date = hz_utility_pub.last_update_date,
273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,
275: request_id = hz_utility_pub.request_id,
276: program_application_id = hz_utility_pub.program_application_id,
277: program_id = hz_utility_pub.program_id,
278: program_update_date = sysdate
279: where address_id = p_from_fk_id;
280: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact

Line 277: program_id = hz_utility_pub.program_id,

273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,
275: request_id = hz_utility_pub.request_id,
276: program_application_id = hz_utility_pub.program_application_id,
277: program_id = hz_utility_pub.program_id,
278: program_update_date = sysdate
279: where address_id = p_from_fk_id;
280: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
281: UPDATE AS_SALES_LEAD_CONTACTS

Line 283: last_update_date = hz_utility_pub.last_update_date,

279: where address_id = p_from_fk_id;
280: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
281: UPDATE AS_SALES_LEAD_CONTACTS
282: set contact_id = p_to_fk_id,
283: last_update_date = hz_utility_pub.last_update_date,
284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,
286: request_id = hz_utility_pub.request_id,
287: program_application_id = hz_utility_pub.program_application_id,

Line 284: last_updated_by = hz_utility_pub.user_id,

280: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
281: UPDATE AS_SALES_LEAD_CONTACTS
282: set contact_id = p_to_fk_id,
283: last_update_date = hz_utility_pub.last_update_date,
284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,
286: request_id = hz_utility_pub.request_id,
287: program_application_id = hz_utility_pub.program_application_id,
288: program_id = hz_utility_pub.program_id,

Line 285: last_update_login = hz_utility_pub.last_update_login,

281: UPDATE AS_SALES_LEAD_CONTACTS
282: set contact_id = p_to_fk_id,
283: last_update_date = hz_utility_pub.last_update_date,
284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,
286: request_id = hz_utility_pub.request_id,
287: program_application_id = hz_utility_pub.program_application_id,
288: program_id = hz_utility_pub.program_id,
289: program_update_date = sysdate

Line 286: request_id = hz_utility_pub.request_id,

282: set contact_id = p_to_fk_id,
283: last_update_date = hz_utility_pub.last_update_date,
284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,
286: request_id = hz_utility_pub.request_id,
287: program_application_id = hz_utility_pub.program_application_id,
288: program_id = hz_utility_pub.program_id,
289: program_update_date = sysdate
290: where contact_id = p_from_fk_id;

Line 287: program_application_id = hz_utility_pub.program_application_id,

283: last_update_date = hz_utility_pub.last_update_date,
284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,
286: request_id = hz_utility_pub.request_id,
287: program_application_id = hz_utility_pub.program_application_id,
288: program_id = hz_utility_pub.program_id,
289: program_update_date = sysdate
290: where contact_id = p_from_fk_id;
291: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points

Line 288: program_id = hz_utility_pub.program_id,

284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,
286: request_id = hz_utility_pub.request_id,
287: program_application_id = hz_utility_pub.program_application_id,
288: program_id = hz_utility_pub.program_id,
289: program_update_date = sysdate
290: where contact_id = p_from_fk_id;
291: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
292: UPDATE AS_SALES_LEAD_CONTACTS

Line 294: last_update_date = hz_utility_pub.last_update_date,

290: where contact_id = p_from_fk_id;
291: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
292: UPDATE AS_SALES_LEAD_CONTACTS
293: set phone_id = p_to_fk_id,
294: last_update_date = hz_utility_pub.last_update_date,
295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,
297: request_id = hz_utility_pub.request_id,
298: program_application_id = hz_utility_pub.program_application_id,

Line 295: last_updated_by = hz_utility_pub.user_id,

291: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
292: UPDATE AS_SALES_LEAD_CONTACTS
293: set phone_id = p_to_fk_id,
294: last_update_date = hz_utility_pub.last_update_date,
295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,
297: request_id = hz_utility_pub.request_id,
298: program_application_id = hz_utility_pub.program_application_id,
299: program_id = hz_utility_pub.program_id,

Line 296: last_update_login = hz_utility_pub.last_update_login,

292: UPDATE AS_SALES_LEAD_CONTACTS
293: set phone_id = p_to_fk_id,
294: last_update_date = hz_utility_pub.last_update_date,
295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,
297: request_id = hz_utility_pub.request_id,
298: program_application_id = hz_utility_pub.program_application_id,
299: program_id = hz_utility_pub.program_id,
300: program_update_date = sysdate

Line 297: request_id = hz_utility_pub.request_id,

293: set phone_id = p_to_fk_id,
294: last_update_date = hz_utility_pub.last_update_date,
295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,
297: request_id = hz_utility_pub.request_id,
298: program_application_id = hz_utility_pub.program_application_id,
299: program_id = hz_utility_pub.program_id,
300: program_update_date = sysdate
301: where phone_id = p_from_fk_id;

Line 298: program_application_id = hz_utility_pub.program_application_id,

294: last_update_date = hz_utility_pub.last_update_date,
295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,
297: request_id = hz_utility_pub.request_id,
298: program_application_id = hz_utility_pub.program_application_id,
299: program_id = hz_utility_pub.program_id,
300: program_update_date = sysdate
301: where phone_id = p_from_fk_id;
302: END IF;

Line 299: program_id = hz_utility_pub.program_id,

295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,
297: request_id = hz_utility_pub.request_id,
298: program_application_id = hz_utility_pub.program_application_id,
299: program_id = hz_utility_pub.program_id,
300: program_update_date = sysdate
301: where phone_id = p_from_fk_id;
302: END IF;
303: EXCEPTION