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.LNS_MERGE_PKG dependencies on HZ_UTILITY_V2PUB

Line 143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

139:
140: /* updating PRIMARY_BORROWER_ID column */
141: UPDATE LNS_LOAN_HEADERS_ALL
142: SET PRIMARY_BORROWER_ID = p_To_FK_id,
143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
144: last_updated_by = HZ_UTILITY_V2PUB.user_id,
145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
146: request_id = HZ_UTILITY_V2PUB.request_id,
147: program_id = HZ_UTILITY_V2PUB.program_id

Line 144: last_updated_by = HZ_UTILITY_V2PUB.user_id,

140: /* updating PRIMARY_BORROWER_ID column */
141: UPDATE LNS_LOAN_HEADERS_ALL
142: SET PRIMARY_BORROWER_ID = p_To_FK_id,
143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
144: last_updated_by = HZ_UTILITY_V2PUB.user_id,
145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
146: request_id = HZ_UTILITY_V2PUB.request_id,
147: program_id = HZ_UTILITY_V2PUB.program_id
148: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;

Line 145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

141: UPDATE LNS_LOAN_HEADERS_ALL
142: SET PRIMARY_BORROWER_ID = p_To_FK_id,
143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
144: last_updated_by = HZ_UTILITY_V2PUB.user_id,
145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
146: request_id = HZ_UTILITY_V2PUB.request_id,
147: program_id = HZ_UTILITY_V2PUB.program_id
148: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
149:

Line 146: request_id = HZ_UTILITY_V2PUB.request_id,

142: SET PRIMARY_BORROWER_ID = p_To_FK_id,
143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
144: last_updated_by = HZ_UTILITY_V2PUB.user_id,
145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
146: request_id = HZ_UTILITY_V2PUB.request_id,
147: program_id = HZ_UTILITY_V2PUB.program_id
148: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
149:
150: /* updating CONTACT_PERS_PARTY_ID column */

Line 147: program_id = HZ_UTILITY_V2PUB.program_id

143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
144: last_updated_by = HZ_UTILITY_V2PUB.user_id,
145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
146: request_id = HZ_UTILITY_V2PUB.request_id,
147: program_id = HZ_UTILITY_V2PUB.program_id
148: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
149:
150: /* updating CONTACT_PERS_PARTY_ID column */
151: UPDATE LNS_LOAN_HEADERS_ALL

Line 153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

149:
150: /* updating CONTACT_PERS_PARTY_ID column */
151: UPDATE LNS_LOAN_HEADERS_ALL
152: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
154: last_updated_by = HZ_UTILITY_V2PUB.user_id,
155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
156: request_id = HZ_UTILITY_V2PUB.request_id,
157: program_id = HZ_UTILITY_V2PUB.program_id

Line 154: last_updated_by = HZ_UTILITY_V2PUB.user_id,

150: /* updating CONTACT_PERS_PARTY_ID column */
151: UPDATE LNS_LOAN_HEADERS_ALL
152: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
154: last_updated_by = HZ_UTILITY_V2PUB.user_id,
155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
156: request_id = HZ_UTILITY_V2PUB.request_id,
157: program_id = HZ_UTILITY_V2PUB.program_id
158: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;

Line 155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

151: UPDATE LNS_LOAN_HEADERS_ALL
152: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
154: last_updated_by = HZ_UTILITY_V2PUB.user_id,
155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
156: request_id = HZ_UTILITY_V2PUB.request_id,
157: program_id = HZ_UTILITY_V2PUB.program_id
158: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
159:

Line 156: request_id = HZ_UTILITY_V2PUB.request_id,

152: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
154: last_updated_by = HZ_UTILITY_V2PUB.user_id,
155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
156: request_id = HZ_UTILITY_V2PUB.request_id,
157: program_id = HZ_UTILITY_V2PUB.program_id
158: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
159:
160: /* updating CONTACT_REL_PARTY_ID column */

Line 157: program_id = HZ_UTILITY_V2PUB.program_id

153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
154: last_updated_by = HZ_UTILITY_V2PUB.user_id,
155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
156: request_id = HZ_UTILITY_V2PUB.request_id,
157: program_id = HZ_UTILITY_V2PUB.program_id
158: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
159:
160: /* updating CONTACT_REL_PARTY_ID column */
161: UPDATE LNS_LOAN_HEADERS_ALL

Line 163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

159:
160: /* updating CONTACT_REL_PARTY_ID column */
161: UPDATE LNS_LOAN_HEADERS_ALL
162: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
164: last_updated_by = HZ_UTILITY_V2PUB.user_id,
165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
166: request_id = HZ_UTILITY_V2PUB.request_id,
167: program_id = HZ_UTILITY_V2PUB.program_id

Line 164: last_updated_by = HZ_UTILITY_V2PUB.user_id,

160: /* updating CONTACT_REL_PARTY_ID column */
161: UPDATE LNS_LOAN_HEADERS_ALL
162: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
164: last_updated_by = HZ_UTILITY_V2PUB.user_id,
165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
166: request_id = HZ_UTILITY_V2PUB.request_id,
167: program_id = HZ_UTILITY_V2PUB.program_id
168: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;

Line 165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

161: UPDATE LNS_LOAN_HEADERS_ALL
162: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
164: last_updated_by = HZ_UTILITY_V2PUB.user_id,
165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
166: request_id = HZ_UTILITY_V2PUB.request_id,
167: program_id = HZ_UTILITY_V2PUB.program_id
168: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
169:

Line 166: request_id = HZ_UTILITY_V2PUB.request_id,

162: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
164: last_updated_by = HZ_UTILITY_V2PUB.user_id,
165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
166: request_id = HZ_UTILITY_V2PUB.request_id,
167: program_id = HZ_UTILITY_V2PUB.program_id
168: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
169:
170: RETURN;

Line 167: program_id = HZ_UTILITY_V2PUB.program_id

163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
164: last_updated_by = HZ_UTILITY_V2PUB.user_id,
165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
166: request_id = HZ_UTILITY_V2PUB.request_id,
167: program_id = HZ_UTILITY_V2PUB.program_id
168: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
169:
170: RETURN;
171:

Line 218: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

214:
215: /* updating HZ_PARTY_ID column */
216: UPDATE LNS_PARTICIPANTS
217: SET HZ_PARTY_ID = p_To_FK_id,
218: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
219: last_updated_by = HZ_UTILITY_V2PUB.user_id,
220: last_update_login = HZ_UTILITY_V2PUB.last_update_login
221: WHERE HZ_PARTY_ID = p_from_fk_id;
222:

Line 219: last_updated_by = HZ_UTILITY_V2PUB.user_id,

215: /* updating HZ_PARTY_ID column */
216: UPDATE LNS_PARTICIPANTS
217: SET HZ_PARTY_ID = p_To_FK_id,
218: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
219: last_updated_by = HZ_UTILITY_V2PUB.user_id,
220: last_update_login = HZ_UTILITY_V2PUB.last_update_login
221: WHERE HZ_PARTY_ID = p_from_fk_id;
222:
223: /* updating CONTACT_PERS_PARTY_ID column */

Line 220: last_update_login = HZ_UTILITY_V2PUB.last_update_login

216: UPDATE LNS_PARTICIPANTS
217: SET HZ_PARTY_ID = p_To_FK_id,
218: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
219: last_updated_by = HZ_UTILITY_V2PUB.user_id,
220: last_update_login = HZ_UTILITY_V2PUB.last_update_login
221: WHERE HZ_PARTY_ID = p_from_fk_id;
222:
223: /* updating CONTACT_PERS_PARTY_ID column */
224: UPDATE LNS_PARTICIPANTS

Line 226: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

222:
223: /* updating CONTACT_PERS_PARTY_ID column */
224: UPDATE LNS_PARTICIPANTS
225: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
226: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
227: last_updated_by = HZ_UTILITY_V2PUB.user_id,
228: last_update_login = HZ_UTILITY_V2PUB.last_update_login
229: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
230:

Line 227: last_updated_by = HZ_UTILITY_V2PUB.user_id,

223: /* updating CONTACT_PERS_PARTY_ID column */
224: UPDATE LNS_PARTICIPANTS
225: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
226: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
227: last_updated_by = HZ_UTILITY_V2PUB.user_id,
228: last_update_login = HZ_UTILITY_V2PUB.last_update_login
229: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
230:
231: /* updating CONTACT_REL_PARTY_ID column */

Line 228: last_update_login = HZ_UTILITY_V2PUB.last_update_login

224: UPDATE LNS_PARTICIPANTS
225: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
226: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
227: last_updated_by = HZ_UTILITY_V2PUB.user_id,
228: last_update_login = HZ_UTILITY_V2PUB.last_update_login
229: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
230:
231: /* updating CONTACT_REL_PARTY_ID column */
232: UPDATE LNS_PARTICIPANTS

Line 234: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

230:
231: /* updating CONTACT_REL_PARTY_ID column */
232: UPDATE LNS_PARTICIPANTS
233: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
234: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
235: last_updated_by = HZ_UTILITY_V2PUB.user_id,
236: last_update_login = HZ_UTILITY_V2PUB.last_update_login
237: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
238:

Line 235: last_updated_by = HZ_UTILITY_V2PUB.user_id,

231: /* updating CONTACT_REL_PARTY_ID column */
232: UPDATE LNS_PARTICIPANTS
233: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
234: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
235: last_updated_by = HZ_UTILITY_V2PUB.user_id,
236: last_update_login = HZ_UTILITY_V2PUB.last_update_login
237: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
238:
239: RETURN;

Line 236: last_update_login = HZ_UTILITY_V2PUB.last_update_login

232: UPDATE LNS_PARTICIPANTS
233: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
234: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
235: last_updated_by = HZ_UTILITY_V2PUB.user_id,
236: last_update_login = HZ_UTILITY_V2PUB.last_update_login
237: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
238:
239: RETURN;
240: