1392: , 9);
1393: l_total := l_total + NVL(l_qty,0);
1394:
1395: --
1396: -- WIP_JOB_SCHEDULE_INTERFACE, processed immediately, hence not included
1397: --
1398: -- Supply FROM Flow to be included in org level only
1399: --
1400: IF p_level = 1
2952: print_debug('Item either not build_in_wip or has pick components flag checked'
2953: , 're_wip', 9);
2954: RAISE wip_exc;
2955: ELSE
2956: print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);
2957: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
2958: LAST_UPDATE_DATE,
2959: LAST_UPDATED_BY,
2960: CREATION_DATE,
2953: , 're_wip', 9);
2954: RAISE wip_exc;
2955: ELSE
2956: print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);
2957: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
2958: LAST_UPDATE_DATE,
2959: LAST_UPDATED_BY,
2960: CREATION_DATE,
2961: CREATED_BY,