APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_BATCH_DETAILS

Line 227: FROM hz_imp_batch_details

223: IS
224:
225: CURSOR c1 IS
226: SELECT max(run_number)
227: FROM hz_imp_batch_details
228: WHERE batch_id = p_batch_id;
229:
230: l_run_number NUMBER;
231:

Line 527: from hz_imp_batch_details bs

523: l_pp_error VARCHAR2(1) := 'N';
524:
525: CURSOR c_batch_status(p_batch_id number) IS
526: select bs.import_status
527: from hz_imp_batch_details bs
528: where bs.batch_id = p_batch_id
529: and run_number = (select max(run_number)
530: from hz_imp_batch_details
531: where batch_id = p_batch_id);

Line 530: from hz_imp_batch_details

526: select bs.import_status
527: from hz_imp_batch_details bs
528: where bs.batch_id = p_batch_id
529: and run_number = (select max(run_number)
530: from hz_imp_batch_details
531: where batch_id = p_batch_id);
532:
533: CURSOR c_pp_error(p_batch_id number) IS
534: select 'Y'

Line 667: UPDATE hz_imp_batch_details

663: --------------------------------------------------
664: get_current_run(
665: p_batch_id => p_batch_id,
666: x_run_number => l_current_run);
667: UPDATE hz_imp_batch_details
668: SET import_status = 'ERROR'
669: WHERE batch_id = p_batch_id
670: AND run_number = l_current_run;
671:

Line 721: UPDATE hz_imp_batch_details

717: get_current_run( --
718: p_batch_id => p_batch_id, --
719: x_run_number => l_current_run); --
720: */
721: UPDATE hz_imp_batch_details
722: SET dup_batch_id = l_dup_batch_id
723: WHERE batch_id = p_batch_id
724: AND run_number = l_current_run;
725:

Line 963: from hz_imp_batch_details

959:
960: -- get import_status of last run
961: select import_status
962: into l_last_run_imp_status
963: from hz_imp_batch_details
964: where batch_id = p_batch_id
965: and run_number = l_current_run - 1;
966:
967: IF l_last_run_imp_status <> 'PENDING' THEN

Line 969: INSERT INTO hz_imp_batch_details

965: and run_number = l_current_run - 1;
966:
967: IF l_last_run_imp_status <> 'PENDING' THEN
968: -- create an entry in the batch details table
969: INSERT INTO hz_imp_batch_details
970: (batch_id,
971: run_number,
972: import_status,
973: import_req_id,

Line 999: INSERT INTO hz_imp_batch_details

995:
996: ELSE
997:
998: -- create an entry in the batch details table
999: INSERT INTO hz_imp_batch_details
1000: (batch_id,
1001: run_number,
1002: import_status,
1003: import_req_id,

Line 1454: UPDATE hz_imp_batch_details

1450: get_current_run(
1451: p_batch_id => p_batch_id,
1452: x_run_number => l_current_run);
1453:
1454: UPDATE hz_imp_batch_details
1455: SET dup_batch_id = l_dup_batch_id
1456: WHERE batch_id = p_batch_id
1457: AND run_number = l_current_run;
1458:

Line 1823: UPDATE hz_imp_batch_details

1819: get_current_run(
1820: p_batch_id => p_batch_id,
1821: x_run_number => l_current_run);
1822:
1823: UPDATE hz_imp_batch_details
1824: SET dup_batch_id = l_dup_batch_id
1825: WHERE batch_id = p_batch_id
1826: AND run_number = l_current_run;
1827: