APPS.HZ_IMP_BATCH_SUMMARY_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 81: hz_utility_v2pub.validate_mandatory (

77: -- do validation
78: ----------------
79:
80: -- batch name is mandatory
81: hz_utility_v2pub.validate_mandatory (
82: p_create_update_flag => 'C',
83: p_column => 'batch_name',
84: p_column_value => p_batch_name,
85: p_restricted => 'Y',

Line 90: hz_utility_v2pub.validate_mandatory (

86: x_return_status => x_return_status
87: );
88:
89: -- original_system is mandatory
90: hz_utility_v2pub.validate_mandatory (
91: p_create_update_flag => 'C',
92: p_column => 'original_system',
93: p_column_value => p_original_system,
94: p_restricted => 'Y',

Line 103: hz_utility_v2pub.validate_lookup (

99: -- HZ_ORIG_SYSTEMS_B instead of the lookup.
100:
101: -- validate original_system against lookup ORIG_SYSTEM
102: /*
103: hz_utility_v2pub.validate_lookup (
104: p_column => 'original_system',
105: p_lookup_type => 'ORIG_SYSTEM',
106: p_column_value => p_original_system,
107: x_return_status => x_return_status);

Line 156: hz_utility_v2pub.created_by,

152: p_description,
153: p_original_system,
154: p_load_type,
155: p_est_no_of_records,
156: hz_utility_v2pub.created_by,
157: hz_utility_v2pub.creation_date,
158: hz_utility_v2pub.last_updated_by,
159: hz_utility_v2pub.last_update_date,
160: hz_utility_v2pub.last_update_login

Line 157: hz_utility_v2pub.creation_date,

153: p_original_system,
154: p_load_type,
155: p_est_no_of_records,
156: hz_utility_v2pub.created_by,
157: hz_utility_v2pub.creation_date,
158: hz_utility_v2pub.last_updated_by,
159: hz_utility_v2pub.last_update_date,
160: hz_utility_v2pub.last_update_login
161: ) RETURNING

Line 158: hz_utility_v2pub.last_updated_by,

154: p_load_type,
155: p_est_no_of_records,
156: hz_utility_v2pub.created_by,
157: hz_utility_v2pub.creation_date,
158: hz_utility_v2pub.last_updated_by,
159: hz_utility_v2pub.last_update_date,
160: hz_utility_v2pub.last_update_login
161: ) RETURNING
162: batch_id

Line 159: hz_utility_v2pub.last_update_date,

155: p_est_no_of_records,
156: hz_utility_v2pub.created_by,
157: hz_utility_v2pub.creation_date,
158: hz_utility_v2pub.last_updated_by,
159: hz_utility_v2pub.last_update_date,
160: hz_utility_v2pub.last_update_login
161: ) RETURNING
162: batch_id
163: INTO

Line 160: hz_utility_v2pub.last_update_login

156: hz_utility_v2pub.created_by,
157: hz_utility_v2pub.creation_date,
158: hz_utility_v2pub.last_updated_by,
159: hz_utility_v2pub.last_update_date,
160: hz_utility_v2pub.last_update_login
161: ) RETURNING
162: batch_id
163: INTO
164: x_batch_id;

Line 328: hz_utility_v2pub.validate_mandatory (

324: -- do validation
325: ----------------
326:
327: -- batch id is mandatory
328: hz_utility_v2pub.validate_mandatory (
329: p_create_update_flag => 'Y',
330: p_column => 'batch_id',
331: p_column_value => p_batch_id,
332: p_restricted => 'Y',

Line 383: last_updated_by = hz_utility_v2pub.last_updated_by,

379:
380: -- update the batch record
381: UPDATE hz_imp_batch_summary
382: SET batch_status = 'ACTIVE',
383: last_updated_by = hz_utility_v2pub.last_updated_by,
384: last_update_date = hz_utility_v2pub.last_update_date,
385: last_update_login = hz_utility_v2pub.last_update_login
386: WHERE batch_id = p_batch_id;
387:

Line 384: last_update_date = hz_utility_v2pub.last_update_date,

380: -- update the batch record
381: UPDATE hz_imp_batch_summary
382: SET batch_status = 'ACTIVE',
383: last_updated_by = hz_utility_v2pub.last_updated_by,
384: last_update_date = hz_utility_v2pub.last_update_date,
385: last_update_login = hz_utility_v2pub.last_update_login
386: WHERE batch_id = p_batch_id;
387:
388: ------------------------------------

Line 385: last_update_login = hz_utility_v2pub.last_update_login

381: UPDATE hz_imp_batch_summary
382: SET batch_status = 'ACTIVE',
383: last_updated_by = hz_utility_v2pub.last_updated_by,
384: last_update_date = hz_utility_v2pub.last_update_date,
385: last_update_login = hz_utility_v2pub.last_update_login
386: WHERE batch_id = p_batch_id;
387:
388: ------------------------------------
389: -- call the pre import count process