APPS.QP_PARTY_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 108: last_update_date = hz_utility_pub.last_update_date,

104: IF p_to_id IS NULL THEN /* Duplicate Does Not Exist. Therefore Transfer*/
105:
106: UPDATE qp_qualifiers
107: SET qualifier_attr_value = to_char(p_to_fk_id),
108: last_update_date = hz_utility_pub.last_update_date,
109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,
111: request_id = hz_utility_pub.request_id,
112: program_application_id = hz_utility_pub.program_application_id,

Line 109: last_updated_by = hz_utility_pub.user_id,

105:
106: UPDATE qp_qualifiers
107: SET qualifier_attr_value = to_char(p_to_fk_id),
108: last_update_date = hz_utility_pub.last_update_date,
109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,
111: request_id = hz_utility_pub.request_id,
112: program_application_id = hz_utility_pub.program_application_id,
113: program_id = hz_utility_pub.program_id,

Line 110: last_update_login = hz_utility_pub.last_update_login,

106: UPDATE qp_qualifiers
107: SET qualifier_attr_value = to_char(p_to_fk_id),
108: last_update_date = hz_utility_pub.last_update_date,
109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,
111: request_id = hz_utility_pub.request_id,
112: program_application_id = hz_utility_pub.program_application_id,
113: program_id = hz_utility_pub.program_id,
114: program_update_date = sysdate

Line 111: request_id = hz_utility_pub.request_id,

107: SET qualifier_attr_value = to_char(p_to_fk_id),
108: last_update_date = hz_utility_pub.last_update_date,
109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,
111: request_id = hz_utility_pub.request_id,
112: program_application_id = hz_utility_pub.program_application_id,
113: program_id = hz_utility_pub.program_id,
114: program_update_date = sysdate
115: WHERE qualifier_id = p_from_id;

Line 112: program_application_id = hz_utility_pub.program_application_id,

108: last_update_date = hz_utility_pub.last_update_date,
109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,
111: request_id = hz_utility_pub.request_id,
112: program_application_id = hz_utility_pub.program_application_id,
113: program_id = hz_utility_pub.program_id,
114: program_update_date = sysdate
115: WHERE qualifier_id = p_from_id;
116:

Line 113: program_id = hz_utility_pub.program_id,

109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,
111: request_id = hz_utility_pub.request_id,
112: program_application_id = hz_utility_pub.program_application_id,
113: program_id = hz_utility_pub.program_id,
114: program_update_date = sysdate
115: WHERE qualifier_id = p_from_id;
116:
117: RETURN;

Line 130: last_update_date = hz_utility_pub.last_update_date,

126: -- Start for bug 8399342 / 8210994 - deleting instead of end dating duplicate qualifiers
127: /* UPDATE qp_qualifiers
128: SET qualifier_attr_value = to_char(p_to_fk_id),
129: end_date_active = sysdate,
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: request_id = hz_utility_pub.request_id,
134: program_application_id = hz_utility_pub.program_application_id,

Line 131: last_updated_by = hz_utility_pub.user_id,

127: /* UPDATE qp_qualifiers
128: SET qualifier_attr_value = to_char(p_to_fk_id),
129: end_date_active = sysdate,
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: request_id = hz_utility_pub.request_id,
134: program_application_id = hz_utility_pub.program_application_id,
135: program_id = hz_utility_pub.program_id,

Line 132: last_update_login = hz_utility_pub.last_update_login,

128: SET qualifier_attr_value = to_char(p_to_fk_id),
129: end_date_active = sysdate,
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: request_id = hz_utility_pub.request_id,
134: program_application_id = hz_utility_pub.program_application_id,
135: program_id = hz_utility_pub.program_id,
136: program_update_date = sysdate

Line 133: request_id = hz_utility_pub.request_id,

129: end_date_active = sysdate,
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: request_id = hz_utility_pub.request_id,
134: program_application_id = hz_utility_pub.program_application_id,
135: program_id = hz_utility_pub.program_id,
136: program_update_date = sysdate
137: WHERE qualifier_id = p_from_id;

Line 134: program_application_id = hz_utility_pub.program_application_id,

130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: request_id = hz_utility_pub.request_id,
134: program_application_id = hz_utility_pub.program_application_id,
135: program_id = hz_utility_pub.program_id,
136: program_update_date = sysdate
137: WHERE qualifier_id = p_from_id;
138: */

Line 135: program_id = hz_utility_pub.program_id,

131: last_updated_by = hz_utility_pub.user_id,
132: last_update_login = hz_utility_pub.last_update_login,
133: request_id = hz_utility_pub.request_id,
134: program_application_id = hz_utility_pub.program_application_id,
135: program_id = hz_utility_pub.program_id,
136: program_update_date = sysdate
137: WHERE qualifier_id = p_from_id;
138: */
139: DELETE qp_qualifiers