APPS.POS_BATCH_IMPORT_PKG dependencies on POS_SUPP_PROF_EXT_INTF

Line 10530: FROM POS_SUPP_PROF_EXT_INTF

10526: retcode := 1;
10527: ELSE
10528: SELECT COUNT(1)
10529: INTO l_error_count
10530: FROM POS_SUPP_PROF_EXT_INTF
10531: WHERE BATCH_ID = P_BATCH_ID
10532: AND nvl(PROCESS_STATUS, 1) = 3;
10533:
10534: SELECT COUNT(1)

Line 10536: FROM POS_SUPP_PROF_EXT_INTF

10532: AND nvl(PROCESS_STATUS, 1) = 3;
10533:
10534: SELECT COUNT(1)
10535: INTO l_uda_imported_count
10536: FROM POS_SUPP_PROF_EXT_INTF
10537: WHERE BATCH_ID = P_BATCH_ID
10538: AND NVL(PROCESS_STATUS, 1) = 4;
10539:
10540: l_tot_err_count := l_tot_err_count + l_error_count;

Line 10605: FROM POS_SUPP_PROF_EXT_INTF

10601: ELSE
10602:
10603: SELECT COUNT(1)
10604: INTO l_error_count
10605: FROM POS_SUPP_PROF_EXT_INTF
10606: WHERE BATCH_ID = P_BATCH_ID
10607: AND nvl(PROCESS_STATUS, 1) = 3;
10608:
10609: SELECT COUNT(1)

Line 10611: FROM POS_SUPP_PROF_EXT_INTF

10607: AND nvl(PROCESS_STATUS, 1) = 3;
10608:
10609: SELECT COUNT(1)
10610: INTO l_uda_imported_count
10611: FROM POS_SUPP_PROF_EXT_INTF
10612: WHERE BATCH_ID = P_BATCH_ID
10613: AND NVL(PROCESS_STATUS, 1) = 4;
10614:
10615: l_tot_err_count := l_tot_err_count + l_error_count;