DBA Data[Home] [Help]

APPS.HZ_PARTY_USG_ASSIGNMENTS_PKG dependencies on HZ_UTILITY_V2PUB

Line 178: hz_utility_v2pub.application_id,

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,

Line 179: hz_utility_v2pub.created_by,

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,

Line 181: hz_utility_v2pub.last_update_login,

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,

Line 183: hz_utility_v2pub.last_updated_by,

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

Line 184: hz_utility_v2pub.request_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: )

Line 185: hz_utility_v2pub.program_application_id,

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

Line 186: hz_utility_v2pub.program_id,

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

Line 380: last_update_login = hz_utility_v2pub.last_update_login,

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,

Line 382: last_updated_by = hz_utility_v2pub.last_updated_by,

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,

Line 383: request_id = hz_utility_v2pub.request_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 =

Line 384: program_application_id = hz_utility_v2pub.program_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)

Line 385: program_id = hz_utility_v2pub.program_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;

Line 388: NVL(application_id, hz_utility_v2pub.application_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;