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 129: last_update_date = hz_utility_pub.last_update_date,

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

Line 130: last_updated_by = hz_utility_pub.user_id,

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

Line 131: last_update_login = hz_utility_pub.last_update_login,

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

Line 132: request_id = hz_utility_pub.request_id,

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

Line 133: program_application_id = hz_utility_pub.program_application_id,

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

Line 134: program_id = hz_utility_pub.program_id,

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