APPS.HZ_IMP_BATCH_SUMMARY_V2PUB dependencies on HZ_IMP_BATCH_SUMMARY

Line 1: PACKAGE BODY HZ_IMP_BATCH_SUMMARY_V2PUB AS

1: PACKAGE BODY HZ_IMP_BATCH_SUMMARY_V2PUB AS
2: /*$Header: ARH2BSSB.pls 120.2 2005/10/30 03:49:20 appldev noship $ */
3:
4: ----------------------------------
5: -- public procedures and functions

Line 136: INSERT INTO hz_imp_batch_summary (

132: -- insert the record with generated batch id
133: --------------------------------------------
134: WHILE l_success = 'N' LOOP
135: BEGIN
136: INSERT INTO hz_imp_batch_summary (
137: batch_id,
138: batch_name,
139: description,
140: original_system,

Line 150: hz_imp_batch_summary_s.nextval,

146: last_update_date,
147: last_update_login
148: )
149: VALUES (
150: hz_imp_batch_summary_s.nextval,
151: p_batch_name,
152: p_description,
153: p_original_system,
154: p_load_type,

Line 170: IF INSTRB(SQLERRM, 'HZ_IMP_BATCH_SUMMARY_U1') <> 0 OR

166: l_success := 'Y';
167:
168: EXCEPTION
169: WHEN DUP_VAL_ON_INDEX THEN
170: IF INSTRB(SQLERRM, 'HZ_IMP_BATCH_SUMMARY_U1') <> 0 OR
171: INSTRB(SQLERRM, 'HZ_IMP_BATCH_SUMMARY_PK') <> 0 THEN
172: DECLARE
173: l_count NUMBER;
174: l_dummy VARCHAR2(1);

Line 171: INSTRB(SQLERRM, 'HZ_IMP_BATCH_SUMMARY_PK') <> 0 THEN

167:
168: EXCEPTION
169: WHEN DUP_VAL_ON_INDEX THEN
170: IF INSTRB(SQLERRM, 'HZ_IMP_BATCH_SUMMARY_U1') <> 0 OR
171: INSTRB(SQLERRM, 'HZ_IMP_BATCH_SUMMARY_PK') <> 0 THEN
172: DECLARE
173: l_count NUMBER;
174: l_dummy VARCHAR2(1);
175: BEGIN

Line 178: SELECT hz_imp_batch_summary_s.NEXTVAL

174: l_dummy VARCHAR2(1);
175: BEGIN
176: l_count := 1;
177: WHILE l_count > 0 LOOP
178: SELECT hz_imp_batch_summary_s.NEXTVAL
179: INTO x_batch_id
180: FROM dual;
181:
182: BEGIN

Line 185: FROM hz_imp_batch_summary hl

181:
182: BEGIN
183: SELECT 'Y'
184: INTO l_dummy
185: FROM hz_imp_batch_summary hl
186: WHERE hl.batch_id = x_batch_id;
187: l_count := 1;
188: EXCEPTION
189: WHEN NO_DATA_FOUND THEN

Line 336: -- batch id must be a valid batch id in hz_imp_batch_summary table

332: p_restricted => 'Y',
333: x_return_status => x_return_status
334: );
335:
336: -- batch id must be a valid batch id in hz_imp_batch_summary table
337: BEGIN
338: SELECT batch_id, original_system
339: INTO l_batch_id, l_original_system
340: FROM hz_imp_batch_summary

Line 340: FROM hz_imp_batch_summary

336: -- batch id must be a valid batch id in hz_imp_batch_summary table
337: BEGIN
338: SELECT batch_id, original_system
339: INTO l_batch_id, l_original_system
340: FROM hz_imp_batch_summary
341: WHERE batch_id = p_batch_id;
342:
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN

Line 348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');

344: WHEN NO_DATA_FOUND THEN
345: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
346: fnd_message.set_token('FK', 'p_batch_id');
347: fnd_message.set_token('COLUMN', 'batch_id');
348: fnd_message.set_token('TABLE', 'hz_imp_batch_summary');
349: fnd_msg_pub.add;
350: x_return_status := fnd_api.g_ret_sts_error;
351: END;
352:

Line 361: FROM hz_imp_batch_summary

357: -- batch id must be a valid batch for processing
358: BEGIN
359: SELECT batch_id
360: INTO l_batch_id
361: FROM hz_imp_batch_summary
362: WHERE batch_id = p_batch_id
363: AND NVL(batch_status,'ACTIVE') NOT IN ('PURGED', 'REJECTED', 'PROCESSING', 'COMPLETED', 'ACTION_REQUIRED');
364:
365: EXCEPTION

Line 381: UPDATE hz_imp_batch_summary

377: -- update the batch summary table
378: ---------------------------------
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

Line 452: END HZ_IMP_BATCH_SUMMARY_V2PUB;

448:
449: END activate_batch;
450:
451:
452: END HZ_IMP_BATCH_SUMMARY_V2PUB;