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 961: from hz_imp_batch_details

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

Line 967: INSERT INTO hz_imp_batch_details

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

Line 997: INSERT INTO hz_imp_batch_details

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

Line 1452: UPDATE hz_imp_batch_details

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

Line 1819: UPDATE hz_imp_batch_details

1815: get_current_run(
1816: p_batch_id => p_batch_id,
1817: x_run_number => l_current_run);
1818:
1819: UPDATE hz_imp_batch_details
1820: SET dup_batch_id = l_dup_batch_id
1821: WHERE batch_id = p_batch_id
1822: AND run_number = l_current_run;
1823: