174: FND_API.G_MISS_CHAR, NULL,
175: x_attribute20),
176: x_object_version_number,
177: x_created_by_module,
178: hz_utility_v2pub.application_id,
179: hz_utility_v2pub.created_by,
180: SYSDATE,
181: hz_utility_v2pub.last_update_login,
182: SYSDATE,
175: x_attribute20),
176: x_object_version_number,
177: x_created_by_module,
178: hz_utility_v2pub.application_id,
179: hz_utility_v2pub.created_by,
180: SYSDATE,
181: hz_utility_v2pub.last_update_login,
182: SYSDATE,
183: hz_utility_v2pub.last_updated_by,
177: x_created_by_module,
178: hz_utility_v2pub.application_id,
179: hz_utility_v2pub.created_by,
180: SYSDATE,
181: hz_utility_v2pub.last_update_login,
182: SYSDATE,
183: hz_utility_v2pub.last_updated_by,
184: hz_utility_v2pub.request_id,
185: hz_utility_v2pub.program_application_id,
179: hz_utility_v2pub.created_by,
180: SYSDATE,
181: hz_utility_v2pub.last_update_login,
182: SYSDATE,
183: hz_utility_v2pub.last_updated_by,
184: hz_utility_v2pub.request_id,
185: hz_utility_v2pub.program_application_id,
186: hz_utility_v2pub.program_id,
187: fnd_global.conc_login_id
180: SYSDATE,
181: hz_utility_v2pub.last_update_login,
182: SYSDATE,
183: hz_utility_v2pub.last_updated_by,
184: hz_utility_v2pub.request_id,
185: hz_utility_v2pub.program_application_id,
186: hz_utility_v2pub.program_id,
187: fnd_global.conc_login_id
188: )
181: hz_utility_v2pub.last_update_login,
182: SYSDATE,
183: hz_utility_v2pub.last_updated_by,
184: hz_utility_v2pub.request_id,
185: hz_utility_v2pub.program_application_id,
186: hz_utility_v2pub.program_id,
187: fnd_global.conc_login_id
188: )
189: RETURNING
182: SYSDATE,
183: hz_utility_v2pub.last_updated_by,
184: hz_utility_v2pub.request_id,
185: hz_utility_v2pub.program_application_id,
186: hz_utility_v2pub.program_id,
187: fnd_global.conc_login_id
188: )
189: RETURNING
190: party_usg_assignment_id
376: object_version_number =
377: DECODE(x_object_version_number,
378: NULL, object_version_number,
379: x_object_version_number),
380: last_update_login = hz_utility_v2pub.last_update_login,
381: last_update_date = SYSDATE,
382: last_updated_by = hz_utility_v2pub.last_updated_by,
383: request_id = hz_utility_v2pub.request_id,
384: program_application_id = hz_utility_v2pub.program_application_id,
378: NULL, object_version_number,
379: x_object_version_number),
380: last_update_login = hz_utility_v2pub.last_update_login,
381: last_update_date = SYSDATE,
382: last_updated_by = hz_utility_v2pub.last_updated_by,
383: request_id = hz_utility_v2pub.request_id,
384: program_application_id = hz_utility_v2pub.program_application_id,
385: program_id = hz_utility_v2pub.program_id,
386: program_login_id = fnd_global.conc_login_id,
379: x_object_version_number),
380: last_update_login = hz_utility_v2pub.last_update_login,
381: last_update_date = SYSDATE,
382: last_updated_by = hz_utility_v2pub.last_updated_by,
383: request_id = hz_utility_v2pub.request_id,
384: program_application_id = hz_utility_v2pub.program_application_id,
385: program_id = hz_utility_v2pub.program_id,
386: program_login_id = fnd_global.conc_login_id,
387: application_id =
380: last_update_login = hz_utility_v2pub.last_update_login,
381: last_update_date = SYSDATE,
382: last_updated_by = hz_utility_v2pub.last_updated_by,
383: request_id = hz_utility_v2pub.request_id,
384: program_application_id = hz_utility_v2pub.program_application_id,
385: program_id = hz_utility_v2pub.program_id,
386: program_login_id = fnd_global.conc_login_id,
387: application_id =
388: NVL(application_id, hz_utility_v2pub.application_id)
381: last_update_date = SYSDATE,
382: last_updated_by = hz_utility_v2pub.last_updated_by,
383: request_id = hz_utility_v2pub.request_id,
384: program_application_id = hz_utility_v2pub.program_application_id,
385: program_id = hz_utility_v2pub.program_id,
386: program_login_id = fnd_global.conc_login_id,
387: application_id =
388: NVL(application_id, hz_utility_v2pub.application_id)
389: WHERE party_usg_assignment_id = x_party_usg_assignment_id;
384: program_application_id = hz_utility_v2pub.program_application_id,
385: program_id = hz_utility_v2pub.program_id,
386: program_login_id = fnd_global.conc_login_id,
387: application_id =
388: NVL(application_id, hz_utility_v2pub.application_id)
389: WHERE party_usg_assignment_id = x_party_usg_assignment_id;
390:
391: IF ( SQL%NOTFOUND ) THEN
392: RAISE NO_DATA_FOUND;