APPS.LNS_MERGE_PKG dependencies on HZ_UTILITY_V2PUB

Line 40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

36:
37: /* updating PRIMARY_BORROWER_ID column */
38: UPDATE LNS_LOAN_HEADERS_ALL
39: SET PRIMARY_BORROWER_ID = p_To_FK_id,
40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
43: request_id = HZ_UTILITY_V2PUB.request_id,
44: program_id = HZ_UTILITY_V2PUB.program_id

Line 41: last_updated_by = HZ_UTILITY_V2PUB.user_id,

37: /* updating PRIMARY_BORROWER_ID column */
38: UPDATE LNS_LOAN_HEADERS_ALL
39: SET PRIMARY_BORROWER_ID = p_To_FK_id,
40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
43: request_id = HZ_UTILITY_V2PUB.request_id,
44: program_id = HZ_UTILITY_V2PUB.program_id
45: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;

Line 42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

38: UPDATE LNS_LOAN_HEADERS_ALL
39: SET PRIMARY_BORROWER_ID = p_To_FK_id,
40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
43: request_id = HZ_UTILITY_V2PUB.request_id,
44: program_id = HZ_UTILITY_V2PUB.program_id
45: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
46:

Line 43: request_id = HZ_UTILITY_V2PUB.request_id,

39: SET PRIMARY_BORROWER_ID = p_To_FK_id,
40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
43: request_id = HZ_UTILITY_V2PUB.request_id,
44: program_id = HZ_UTILITY_V2PUB.program_id
45: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
46:
47: /* updating CONTACT_PERS_PARTY_ID column */

Line 44: program_id = HZ_UTILITY_V2PUB.program_id

40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
43: request_id = HZ_UTILITY_V2PUB.request_id,
44: program_id = HZ_UTILITY_V2PUB.program_id
45: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
46:
47: /* updating CONTACT_PERS_PARTY_ID column */
48: UPDATE LNS_LOAN_HEADERS_ALL

Line 50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

46:
47: /* updating CONTACT_PERS_PARTY_ID column */
48: UPDATE LNS_LOAN_HEADERS_ALL
49: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
53: request_id = HZ_UTILITY_V2PUB.request_id,
54: program_id = HZ_UTILITY_V2PUB.program_id

Line 51: last_updated_by = HZ_UTILITY_V2PUB.user_id,

47: /* updating CONTACT_PERS_PARTY_ID column */
48: UPDATE LNS_LOAN_HEADERS_ALL
49: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
53: request_id = HZ_UTILITY_V2PUB.request_id,
54: program_id = HZ_UTILITY_V2PUB.program_id
55: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;

Line 52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

48: UPDATE LNS_LOAN_HEADERS_ALL
49: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
53: request_id = HZ_UTILITY_V2PUB.request_id,
54: program_id = HZ_UTILITY_V2PUB.program_id
55: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
56:

Line 53: request_id = HZ_UTILITY_V2PUB.request_id,

49: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
53: request_id = HZ_UTILITY_V2PUB.request_id,
54: program_id = HZ_UTILITY_V2PUB.program_id
55: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
56:
57: /* updating CONTACT_REL_PARTY_ID column */

Line 54: program_id = HZ_UTILITY_V2PUB.program_id

50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
53: request_id = HZ_UTILITY_V2PUB.request_id,
54: program_id = HZ_UTILITY_V2PUB.program_id
55: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
56:
57: /* updating CONTACT_REL_PARTY_ID column */
58: UPDATE LNS_LOAN_HEADERS_ALL

Line 60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

56:
57: /* updating CONTACT_REL_PARTY_ID column */
58: UPDATE LNS_LOAN_HEADERS_ALL
59: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
63: request_id = HZ_UTILITY_V2PUB.request_id,
64: program_id = HZ_UTILITY_V2PUB.program_id

Line 61: last_updated_by = HZ_UTILITY_V2PUB.user_id,

57: /* updating CONTACT_REL_PARTY_ID column */
58: UPDATE LNS_LOAN_HEADERS_ALL
59: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
63: request_id = HZ_UTILITY_V2PUB.request_id,
64: program_id = HZ_UTILITY_V2PUB.program_id
65: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;

Line 62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

58: UPDATE LNS_LOAN_HEADERS_ALL
59: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
63: request_id = HZ_UTILITY_V2PUB.request_id,
64: program_id = HZ_UTILITY_V2PUB.program_id
65: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
66:

Line 63: request_id = HZ_UTILITY_V2PUB.request_id,

59: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
63: request_id = HZ_UTILITY_V2PUB.request_id,
64: program_id = HZ_UTILITY_V2PUB.program_id
65: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
66:
67: RETURN;

Line 64: program_id = HZ_UTILITY_V2PUB.program_id

60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
63: request_id = HZ_UTILITY_V2PUB.request_id,
64: program_id = HZ_UTILITY_V2PUB.program_id
65: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
66:
67: RETURN;
68:

Line 115: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

111:
112: /* updating HZ_PARTY_ID column */
113: UPDATE LNS_PARTICIPANTS
114: SET HZ_PARTY_ID = p_To_FK_id,
115: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
116: last_updated_by = HZ_UTILITY_V2PUB.user_id,
117: last_update_login = HZ_UTILITY_V2PUB.last_update_login
118: WHERE HZ_PARTY_ID = p_from_fk_id;
119:

Line 116: last_updated_by = HZ_UTILITY_V2PUB.user_id,

112: /* updating HZ_PARTY_ID column */
113: UPDATE LNS_PARTICIPANTS
114: SET HZ_PARTY_ID = p_To_FK_id,
115: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
116: last_updated_by = HZ_UTILITY_V2PUB.user_id,
117: last_update_login = HZ_UTILITY_V2PUB.last_update_login
118: WHERE HZ_PARTY_ID = p_from_fk_id;
119:
120: /* updating CONTACT_PERS_PARTY_ID column */

Line 117: last_update_login = HZ_UTILITY_V2PUB.last_update_login

113: UPDATE LNS_PARTICIPANTS
114: SET HZ_PARTY_ID = p_To_FK_id,
115: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
116: last_updated_by = HZ_UTILITY_V2PUB.user_id,
117: last_update_login = HZ_UTILITY_V2PUB.last_update_login
118: WHERE HZ_PARTY_ID = p_from_fk_id;
119:
120: /* updating CONTACT_PERS_PARTY_ID column */
121: UPDATE LNS_PARTICIPANTS

Line 123: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

119:
120: /* updating CONTACT_PERS_PARTY_ID column */
121: UPDATE LNS_PARTICIPANTS
122: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
123: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
124: last_updated_by = HZ_UTILITY_V2PUB.user_id,
125: last_update_login = HZ_UTILITY_V2PUB.last_update_login
126: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
127:

Line 124: last_updated_by = HZ_UTILITY_V2PUB.user_id,

120: /* updating CONTACT_PERS_PARTY_ID column */
121: UPDATE LNS_PARTICIPANTS
122: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
123: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
124: last_updated_by = HZ_UTILITY_V2PUB.user_id,
125: last_update_login = HZ_UTILITY_V2PUB.last_update_login
126: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
127:
128: /* updating CONTACT_REL_PARTY_ID column */

Line 125: last_update_login = HZ_UTILITY_V2PUB.last_update_login

121: UPDATE LNS_PARTICIPANTS
122: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
123: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
124: last_updated_by = HZ_UTILITY_V2PUB.user_id,
125: last_update_login = HZ_UTILITY_V2PUB.last_update_login
126: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
127:
128: /* updating CONTACT_REL_PARTY_ID column */
129: UPDATE LNS_PARTICIPANTS

Line 131: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

127:
128: /* updating CONTACT_REL_PARTY_ID column */
129: UPDATE LNS_PARTICIPANTS
130: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
131: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
132: last_updated_by = HZ_UTILITY_V2PUB.user_id,
133: last_update_login = HZ_UTILITY_V2PUB.last_update_login
134: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
135:

Line 132: last_updated_by = HZ_UTILITY_V2PUB.user_id,

128: /* updating CONTACT_REL_PARTY_ID column */
129: UPDATE LNS_PARTICIPANTS
130: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
131: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
132: last_updated_by = HZ_UTILITY_V2PUB.user_id,
133: last_update_login = HZ_UTILITY_V2PUB.last_update_login
134: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
135:
136: RETURN;

Line 133: last_update_login = HZ_UTILITY_V2PUB.last_update_login

129: UPDATE LNS_PARTICIPANTS
130: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
131: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
132: last_updated_by = HZ_UTILITY_V2PUB.user_id,
133: last_update_login = HZ_UTILITY_V2PUB.last_update_login
134: WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;
135:
136: RETURN;
137: