APPS.XLE_PARTY_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 89: LAST_UPDATED_BY = hz_utility_pub.user_id,

85:
86: /* Update the "From" Party_ID to be equal to the new target */
87: UPDATE XLE_REGISTRATIONS
88: SET issuing_authority_id = p_To_FK_id,
89: LAST_UPDATED_BY = hz_utility_pub.user_id,
90: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
91: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
92: WHERE issuing_authority_id = p_From_FK_id;
93:

Line 90: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

86: /* Update the "From" Party_ID to be equal to the new target */
87: UPDATE XLE_REGISTRATIONS
88: SET issuing_authority_id = p_To_FK_id,
89: LAST_UPDATED_BY = hz_utility_pub.user_id,
90: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
91: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
92: WHERE issuing_authority_id = p_From_FK_id;
93:
94: RETURN;

Line 91: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

87: UPDATE XLE_REGISTRATIONS
88: SET issuing_authority_id = p_To_FK_id,
89: LAST_UPDATED_BY = hz_utility_pub.user_id,
90: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
91: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
92: WHERE issuing_authority_id = p_From_FK_id;
93:
94: RETURN;
95:

Line 109: LAST_UPDATED_BY = hz_utility_pub.user_id,

105: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
106:
107: UPDATE XLE_REGISTRATIONS
108: SET issuing_authority_site_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
112: WHERE issuing_authority_site_id = p_From_FK_id;
113: RETURN;

Line 110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

106:
107: UPDATE XLE_REGISTRATIONS
108: SET issuing_authority_site_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
112: WHERE issuing_authority_site_id = p_From_FK_id;
113: RETURN;
114: END IF;

Line 111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

107: UPDATE XLE_REGISTRATIONS
108: SET issuing_authority_site_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
112: WHERE issuing_authority_site_id = p_From_FK_id;
113: RETURN;
114: END IF;
115: END IF;

Line 220: LAST_UPDATED_BY = hz_utility_pub.user_id,

216:
217: /* Update the "From" Party_ID to be equal to the new target */
218: UPDATE XLE_REG_FUNCTIONS
219: SET authority_id = p_To_FK_id,
220: LAST_UPDATED_BY = hz_utility_pub.user_id,
221: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
222: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
223: WHERE authority_id = p_From_FK_id;
224: RETURN;

Line 221: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

217: /* Update the "From" Party_ID to be equal to the new target */
218: UPDATE XLE_REG_FUNCTIONS
219: SET authority_id = p_To_FK_id,
220: LAST_UPDATED_BY = hz_utility_pub.user_id,
221: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
222: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
223: WHERE authority_id = p_From_FK_id;
224: RETURN;
225:

Line 222: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

218: UPDATE XLE_REG_FUNCTIONS
219: SET authority_id = p_To_FK_id,
220: LAST_UPDATED_BY = hz_utility_pub.user_id,
221: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
222: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
223: WHERE authority_id = p_From_FK_id;
224: RETURN;
225:
226: ELSIF p_Parent_Entity_name = 'HZ_PARTY_SITES' THEN

Line 239: LAST_UPDATED_BY = hz_utility_pub.user_id,

235: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
236:
237: UPDATE XLE_REG_FUNCTIONS
238: SET authority_site_id = p_To_FK_id,
239: LAST_UPDATED_BY = hz_utility_pub.user_id,
240: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
241: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
242: WHERE authority_site_id = p_From_FK_id;
243: RETURN;

Line 240: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

236:
237: UPDATE XLE_REG_FUNCTIONS
238: SET authority_site_id = p_To_FK_id,
239: LAST_UPDATED_BY = hz_utility_pub.user_id,
240: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
241: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
242: WHERE authority_site_id = p_From_FK_id;
243: RETURN;
244: END IF;

Line 241: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

237: UPDATE XLE_REG_FUNCTIONS
238: SET authority_site_id = p_To_FK_id,
239: LAST_UPDATED_BY = hz_utility_pub.user_id,
240: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
241: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
242: WHERE authority_site_id = p_From_FK_id;
243: RETURN;
244: END IF;
245: END IF;