221: p_quantity_used => l_quantity_used + cdl.quantity,
222: p_actual_times_used => l_actual_times_used,
223: p_rollup_quantity_used => l_rollup_quantity_used + cdl.quantity,
224: p_rollup_times_used => l_rollup_times_used + l_rollup_increment,
225: p_substitute_item => fnd_api.g_miss_num);
226:
227: handle_substitutes(
228: p_product_task_id => l_product_task_id,
229: p_task_part_id => l_task_part_id,
318: CLOSE debrief_line;
319: IF l_debrief_line_id IS NULL THEN
320: update_task_part(
321: p_task_part_id => l_task_part_id,
322: p_quantity_used => fnd_api.g_miss_num,
323: p_actual_times_used => fnd_api.g_miss_num,
324: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
325: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
326: p_substitute_item => fnd_api.g_miss_num);
319: IF l_debrief_line_id IS NULL THEN
320: update_task_part(
321: p_task_part_id => l_task_part_id,
322: p_quantity_used => fnd_api.g_miss_num,
323: p_actual_times_used => fnd_api.g_miss_num,
324: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
325: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
326: p_substitute_item => fnd_api.g_miss_num);
327: ELSE
322: p_quantity_used => fnd_api.g_miss_num,
323: p_actual_times_used => fnd_api.g_miss_num,
324: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
325: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
326: p_substitute_item => fnd_api.g_miss_num);
327: ELSE
328: update_task_part(
329: p_task_part_id => l_task_part_id,
330: p_quantity_used => fnd_api.g_miss_num,
326: p_substitute_item => fnd_api.g_miss_num);
327: ELSE
328: update_task_part(
329: p_task_part_id => l_task_part_id,
330: p_quantity_used => fnd_api.g_miss_num,
331: p_actual_times_used => fnd_api.g_miss_num,
332: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
333: p_rollup_times_used => fnd_api.g_miss_num,
334: p_substitute_item => fnd_api.g_miss_num);
327: ELSE
328: update_task_part(
329: p_task_part_id => l_task_part_id,
330: p_quantity_used => fnd_api.g_miss_num,
331: p_actual_times_used => fnd_api.g_miss_num,
332: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
333: p_rollup_times_used => fnd_api.g_miss_num,
334: p_substitute_item => fnd_api.g_miss_num);
335: END IF;
329: p_task_part_id => l_task_part_id,
330: p_quantity_used => fnd_api.g_miss_num,
331: p_actual_times_used => fnd_api.g_miss_num,
332: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
333: p_rollup_times_used => fnd_api.g_miss_num,
334: p_substitute_item => fnd_api.g_miss_num);
335: END IF;
336:
337: update_task_part(
330: p_quantity_used => fnd_api.g_miss_num,
331: p_actual_times_used => fnd_api.g_miss_num,
332: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
333: p_rollup_times_used => fnd_api.g_miss_num,
334: p_substitute_item => fnd_api.g_miss_num);
335: END IF;
336:
337: update_task_part(
338: p_task_part_id => p_task_part_id,
335: END IF;
336:
337: update_task_part(
338: p_task_part_id => p_task_part_id,
339: p_quantity_used => fnd_api.g_miss_num,
340: p_actual_times_used => fnd_api.g_miss_num,
341: p_rollup_quantity_used => null,
342: p_rollup_times_used => null,
343: p_substitute_item => l_inventory_item_id);
336:
337: update_task_part(
338: p_task_part_id => p_task_part_id,
339: p_quantity_used => fnd_api.g_miss_num,
340: p_actual_times_used => fnd_api.g_miss_num,
341: p_rollup_quantity_used => null,
342: p_rollup_times_used => null,
343: p_substitute_item => l_inventory_item_id);
344:
349: CLOSE debrief_line;
350: IF l_debrief_line_id IS NULL THEN
351: update_task_part(
352: p_task_part_id => l_task_part_id,
353: p_quantity_used => fnd_api.g_miss_num,
354: p_actual_times_used => fnd_api.g_miss_num,
355: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
356: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
357: p_substitute_item => fnd_api.g_miss_num);
350: IF l_debrief_line_id IS NULL THEN
351: update_task_part(
352: p_task_part_id => l_task_part_id,
353: p_quantity_used => fnd_api.g_miss_num,
354: p_actual_times_used => fnd_api.g_miss_num,
355: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
356: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
357: p_substitute_item => fnd_api.g_miss_num);
358: ELSE
353: p_quantity_used => fnd_api.g_miss_num,
354: p_actual_times_used => fnd_api.g_miss_num,
355: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
356: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
357: p_substitute_item => fnd_api.g_miss_num);
358: ELSE
359: update_task_part(
360: p_task_part_id => l_task_part_id,
361: p_quantity_used => fnd_api.g_miss_num,
357: p_substitute_item => fnd_api.g_miss_num);
358: ELSE
359: update_task_part(
360: p_task_part_id => l_task_part_id,
361: p_quantity_used => fnd_api.g_miss_num,
362: p_actual_times_used => fnd_api.g_miss_num,
363: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
364: p_rollup_times_used => fnd_api.g_miss_num,
365: p_substitute_item => fnd_api.g_miss_num);
358: ELSE
359: update_task_part(
360: p_task_part_id => l_task_part_id,
361: p_quantity_used => fnd_api.g_miss_num,
362: p_actual_times_used => fnd_api.g_miss_num,
363: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
364: p_rollup_times_used => fnd_api.g_miss_num,
365: p_substitute_item => fnd_api.g_miss_num);
366: END IF;
360: p_task_part_id => l_task_part_id,
361: p_quantity_used => fnd_api.g_miss_num,
362: p_actual_times_used => fnd_api.g_miss_num,
363: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
364: p_rollup_times_used => fnd_api.g_miss_num,
365: p_substitute_item => fnd_api.g_miss_num);
366: END IF;
367:
368:
361: p_quantity_used => fnd_api.g_miss_num,
362: p_actual_times_used => fnd_api.g_miss_num,
363: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
364: p_rollup_times_used => fnd_api.g_miss_num,
365: p_substitute_item => fnd_api.g_miss_num);
366: END IF;
367:
368:
369: update_task_part(
367:
368:
369: update_task_part(
370: p_task_part_id => p_task_part_id,
371: p_quantity_used => fnd_api.g_miss_num,
372: p_actual_times_used => fnd_api.g_miss_num,
373: p_rollup_quantity_used => null,
374: p_rollup_times_used => null,
375: p_substitute_item => l_inventory_item_id);
368:
369: update_task_part(
370: p_task_part_id => p_task_part_id,
371: p_quantity_used => fnd_api.g_miss_num,
372: p_actual_times_used => fnd_api.g_miss_num,
373: p_rollup_quantity_used => null,
374: p_rollup_times_used => null,
375: p_substitute_item => l_inventory_item_id);
376:
458: CLOSE l_cur;
459: IF l_debrief_line_id IS NOT NULL THEN
460: update_task_part(
461: p_task_part_id => l_task_part_id,
462: p_quantity_used => fnd_api.g_miss_num,
463: p_actual_times_used => fnd_api.g_miss_num,
464: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
465: p_rollup_times_used => fnd_api.g_miss_num,
466: p_substitute_item => fnd_api.g_miss_num);
459: IF l_debrief_line_id IS NOT NULL THEN
460: update_task_part(
461: p_task_part_id => l_task_part_id,
462: p_quantity_used => fnd_api.g_miss_num,
463: p_actual_times_used => fnd_api.g_miss_num,
464: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
465: p_rollup_times_used => fnd_api.g_miss_num,
466: p_substitute_item => fnd_api.g_miss_num);
467: ELSE
461: p_task_part_id => l_task_part_id,
462: p_quantity_used => fnd_api.g_miss_num,
463: p_actual_times_used => fnd_api.g_miss_num,
464: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
465: p_rollup_times_used => fnd_api.g_miss_num,
466: p_substitute_item => fnd_api.g_miss_num);
467: ELSE
468: update_task_part(
469: p_task_part_id => l_task_part_id,
462: p_quantity_used => fnd_api.g_miss_num,
463: p_actual_times_used => fnd_api.g_miss_num,
464: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
465: p_rollup_times_used => fnd_api.g_miss_num,
466: p_substitute_item => fnd_api.g_miss_num);
467: ELSE
468: update_task_part(
469: p_task_part_id => l_task_part_id,
470: p_quantity_used => fnd_api.g_miss_num,
466: p_substitute_item => fnd_api.g_miss_num);
467: ELSE
468: update_task_part(
469: p_task_part_id => l_task_part_id,
470: p_quantity_used => fnd_api.g_miss_num,
471: p_actual_times_used => fnd_api.g_miss_num,
472: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
473: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
474: p_substitute_item => fnd_api.g_miss_num);
467: ELSE
468: update_task_part(
469: p_task_part_id => l_task_part_id,
470: p_quantity_used => fnd_api.g_miss_num,
471: p_actual_times_used => fnd_api.g_miss_num,
472: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
473: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
474: p_substitute_item => fnd_api.g_miss_num);
475: END IF;
470: p_quantity_used => fnd_api.g_miss_num,
471: p_actual_times_used => fnd_api.g_miss_num,
472: p_rollup_quantity_used => nvl(l_rollup_quantity_used,0) + p_rollup_quantity_used,
473: p_rollup_times_used => nvl(l_rollup_times_used,0) + p_rollup_times_used, --new
474: p_substitute_item => fnd_api.g_miss_num);
475: END IF;
476:
477: update_task_part(
478: p_task_part_id => p_task_part_id,
475: END IF;
476:
477: update_task_part(
478: p_task_part_id => p_task_part_id,
479: p_quantity_used => fnd_api.g_miss_num,
480: p_actual_times_used => fnd_api.g_miss_num,
481: p_rollup_quantity_used => null,
482: p_rollup_times_used => null,
483: p_substitute_item => l_supersede_item);
476:
477: update_task_part(
478: p_task_part_id => p_task_part_id,
479: p_quantity_used => fnd_api.g_miss_num,
480: p_actual_times_used => fnd_api.g_miss_num,
481: p_rollup_quantity_used => null,
482: p_rollup_times_used => null,
483: p_substitute_item => l_supersede_item);
484: ELSE
491: p_actual_times_used => null,
492: x_task_part_id => l_task_part_id);
493: update_task_part(
494: p_task_part_id => l_task_part_id,
495: p_quantity_used => fnd_api.g_miss_num,
496: p_actual_times_used => fnd_api.g_miss_num,
497: p_rollup_quantity_used => p_rollup_quantity_used,
498: p_rollup_times_used => p_rollup_times_used,
499: p_substitute_item => fnd_api.g_miss_num);
492: x_task_part_id => l_task_part_id);
493: update_task_part(
494: p_task_part_id => l_task_part_id,
495: p_quantity_used => fnd_api.g_miss_num,
496: p_actual_times_used => fnd_api.g_miss_num,
497: p_rollup_quantity_used => p_rollup_quantity_used,
498: p_rollup_times_used => p_rollup_times_used,
499: p_substitute_item => fnd_api.g_miss_num);
500: update_task_part(
495: p_quantity_used => fnd_api.g_miss_num,
496: p_actual_times_used => fnd_api.g_miss_num,
497: p_rollup_quantity_used => p_rollup_quantity_used,
498: p_rollup_times_used => p_rollup_times_used,
499: p_substitute_item => fnd_api.g_miss_num);
500: update_task_part(
501: p_task_part_id => p_task_part_id,
502: p_quantity_used => fnd_api.g_miss_num,
503: p_actual_times_used => fnd_api.g_miss_num,
498: p_rollup_times_used => p_rollup_times_used,
499: p_substitute_item => fnd_api.g_miss_num);
500: update_task_part(
501: p_task_part_id => p_task_part_id,
502: p_quantity_used => fnd_api.g_miss_num,
503: p_actual_times_used => fnd_api.g_miss_num,
504: p_rollup_quantity_used => null,
505: p_rollup_times_used => null,
506: p_substitute_item => l_supersede_item);
499: p_substitute_item => fnd_api.g_miss_num);
500: update_task_part(
501: p_task_part_id => p_task_part_id,
502: p_quantity_used => fnd_api.g_miss_num,
503: p_actual_times_used => fnd_api.g_miss_num,
504: p_rollup_quantity_used => null,
505: p_rollup_times_used => null,
506: p_substitute_item => l_supersede_item);
507:
569: p_actual_times_used in number) is
570: BEGIN
571: CSP_PRODUCT_TASKS_PKG.Update_Row(
572: p_PRODUCT_TASK_ID => p_product_task_id,
573: p_PRODUCT_ID => fnd_api.g_miss_num,
574: p_TASK_TEMPLATE_ID => fnd_api.g_miss_num,
575: p_AUTO_MANUAL => 'A',
576: p_ACTUAL_TIMES_USED => p_actual_times_used,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
570: BEGIN
571: CSP_PRODUCT_TASKS_PKG.Update_Row(
572: p_PRODUCT_TASK_ID => p_product_task_id,
573: p_PRODUCT_ID => fnd_api.g_miss_num,
574: p_TASK_TEMPLATE_ID => fnd_api.g_miss_num,
575: p_AUTO_MANUAL => 'A',
576: p_ACTUAL_TIMES_USED => p_actual_times_used,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
573: p_PRODUCT_ID => fnd_api.g_miss_num,
574: p_TASK_TEMPLATE_ID => fnd_api.g_miss_num,
575: p_AUTO_MANUAL => 'A',
576: p_ACTUAL_TIMES_USED => p_actual_times_used,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
574: p_TASK_TEMPLATE_ID => fnd_api.g_miss_num,
575: p_AUTO_MANUAL => 'A',
576: p_ACTUAL_TIMES_USED => p_actual_times_used,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
575: p_AUTO_MANUAL => 'A',
576: p_ACTUAL_TIMES_USED => p_actual_times_used,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
576: p_ACTUAL_TIMES_USED => p_actual_times_used,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
577: p_TASK_PERCENTAGE => fnd_api.g_miss_num,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
578: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
579: p_ATTRIBUTE1 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
580: p_ATTRIBUTE2 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
581: p_ATTRIBUTE3 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
582: p_ATTRIBUTE4 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
583: p_ATTRIBUTE5 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
584: p_ATTRIBUTE6 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
585: p_ATTRIBUTE7 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
586: p_ATTRIBUTE8 => fnd_api.g_miss_char,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
594: p_CREATED_BY => FND_API.G_MISS_NUM,
587: p_ATTRIBUTE9 => fnd_api.g_miss_char,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
594: p_CREATED_BY => FND_API.G_MISS_NUM,
595: p_CREATION_DATE => FND_API.G_MISS_DATE,
588: p_ATTRIBUTE10 => fnd_api.g_miss_char,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
594: p_CREATED_BY => FND_API.G_MISS_NUM,
595: p_CREATION_DATE => FND_API.G_MISS_DATE,
596: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
589: p_ATTRIBUTE11 => fnd_api.g_miss_char,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
594: p_CREATED_BY => FND_API.G_MISS_NUM,
595: p_CREATION_DATE => FND_API.G_MISS_DATE,
596: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
597: p_LAST_UPDATE_DATE => SYSDATE,
590: p_ATTRIBUTE12 => fnd_api.g_miss_char,
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
594: p_CREATED_BY => FND_API.G_MISS_NUM,
595: p_CREATION_DATE => FND_API.G_MISS_DATE,
596: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
597: p_LAST_UPDATE_DATE => SYSDATE,
598: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num);
591: p_ATTRIBUTE13 => fnd_api.g_miss_char,
592: p_ATTRIBUTE14 => fnd_api.g_miss_char,
593: p_ATTRIBUTE15 => fnd_api.g_miss_char,
594: p_CREATED_BY => FND_API.G_MISS_NUM,
595: p_CREATION_DATE => FND_API.G_MISS_DATE,
596: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
597: p_LAST_UPDATE_DATE => SYSDATE,
598: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num);
599:
594: p_CREATED_BY => FND_API.G_MISS_NUM,
595: p_CREATION_DATE => FND_API.G_MISS_DATE,
596: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
597: p_LAST_UPDATE_DATE => SYSDATE,
598: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num);
599:
600: End Update_product_task;
601:
602: PROCEDURE Create_task_part(
663: BEGIN
664:
665: csp_task_parts_pkg.Update_Row(
666: p_TASK_PART_ID => p_task_part_id,
667: p_PRODUCT_TASK_ID => fnd_api.g_miss_num,
668: p_INVENTORY_ITEM_ID => fnd_api.g_miss_num,
669: p_MANUAL_QUANTITY => fnd_api.g_miss_num,
670: p_MANUAL_PERCENTAGE => fnd_api.g_miss_num,
671: p_QUANTITY_USED => p_quantity_used,
664:
665: csp_task_parts_pkg.Update_Row(
666: p_TASK_PART_ID => p_task_part_id,
667: p_PRODUCT_TASK_ID => fnd_api.g_miss_num,
668: p_INVENTORY_ITEM_ID => fnd_api.g_miss_num,
669: p_MANUAL_QUANTITY => fnd_api.g_miss_num,
670: p_MANUAL_PERCENTAGE => fnd_api.g_miss_num,
671: p_QUANTITY_USED => p_quantity_used,
672: p_ACTUAL_TIMES_USED => p_actual_times_used,
665: csp_task_parts_pkg.Update_Row(
666: p_TASK_PART_ID => p_task_part_id,
667: p_PRODUCT_TASK_ID => fnd_api.g_miss_num,
668: p_INVENTORY_ITEM_ID => fnd_api.g_miss_num,
669: p_MANUAL_QUANTITY => fnd_api.g_miss_num,
670: p_MANUAL_PERCENTAGE => fnd_api.g_miss_num,
671: p_QUANTITY_USED => p_quantity_used,
672: p_ACTUAL_TIMES_USED => p_actual_times_used,
673: p_CREATED_BY => fnd_api.g_miss_num,
666: p_TASK_PART_ID => p_task_part_id,
667: p_PRODUCT_TASK_ID => fnd_api.g_miss_num,
668: p_INVENTORY_ITEM_ID => fnd_api.g_miss_num,
669: p_MANUAL_QUANTITY => fnd_api.g_miss_num,
670: p_MANUAL_PERCENTAGE => fnd_api.g_miss_num,
671: p_QUANTITY_USED => p_quantity_used,
672: p_ACTUAL_TIMES_USED => p_actual_times_used,
673: p_CREATED_BY => fnd_api.g_miss_num,
674: p_CREATION_DATE => fnd_api.g_miss_date,
669: p_MANUAL_QUANTITY => fnd_api.g_miss_num,
670: p_MANUAL_PERCENTAGE => fnd_api.g_miss_num,
671: p_QUANTITY_USED => p_quantity_used,
672: p_ACTUAL_TIMES_USED => p_actual_times_used,
673: p_CREATED_BY => fnd_api.g_miss_num,
674: p_CREATION_DATE => fnd_api.g_miss_date,
675: p_LAST_UPDATED_BY => fnd_global.user_id,
676: p_LAST_UPDATE_DATE => sysdate,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
670: p_MANUAL_PERCENTAGE => fnd_api.g_miss_num,
671: p_QUANTITY_USED => p_quantity_used,
672: p_ACTUAL_TIMES_USED => p_actual_times_used,
673: p_CREATED_BY => fnd_api.g_miss_num,
674: p_CREATION_DATE => fnd_api.g_miss_date,
675: p_LAST_UPDATED_BY => fnd_global.user_id,
676: p_LAST_UPDATE_DATE => sysdate,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
673: p_CREATED_BY => fnd_api.g_miss_num,
674: p_CREATION_DATE => fnd_api.g_miss_date,
675: p_LAST_UPDATED_BY => fnd_global.user_id,
676: p_LAST_UPDATE_DATE => sysdate,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
674: p_CREATION_DATE => fnd_api.g_miss_date,
675: p_LAST_UPDATED_BY => fnd_global.user_id,
676: p_LAST_UPDATE_DATE => sysdate,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
675: p_LAST_UPDATED_BY => fnd_global.user_id,
676: p_LAST_UPDATE_DATE => sysdate,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
676: p_LAST_UPDATE_DATE => sysdate,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
677: p_LAST_UPDATE_LOGIN => fnd_api.g_miss_num,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
678: p_ATTRIBUTE_CATEGORY => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
679: p_ATTRIBUTE1 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
680: p_ATTRIBUTE2 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
681: p_ATTRIBUTE3 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
682: p_ATTRIBUTE4 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
683: p_ATTRIBUTE5 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
684: p_ATTRIBUTE6 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
685: p_ATTRIBUTE7 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
686: p_ATTRIBUTE8 => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
687: p_ATTRIBUTE9 => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
688: p_ATTRIBUTE10 => fnd_api.g_miss_char,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
696: p_START_DATE => fnd_api.g_miss_date,
689: p_ATTRIBUTE11 => fnd_api.g_miss_char,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
696: p_START_DATE => fnd_api.g_miss_date,
697: p_END_DATE => fnd_api.g_miss_date,
690: p_ATTRIBUTE12 => fnd_api.g_miss_char,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
696: p_START_DATE => fnd_api.g_miss_date,
697: p_END_DATE => fnd_api.g_miss_date,
698: P_ROLLUP_QUANTITY_USED => p_rollup_quantity_used,
691: p_ATTRIBUTE13 => fnd_api.g_miss_char,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
696: p_START_DATE => fnd_api.g_miss_date,
697: p_END_DATE => fnd_api.g_miss_date,
698: P_ROLLUP_QUANTITY_USED => p_rollup_quantity_used,
699: P_ROLLUP_TIMES_USED => p_rollup_times_used,
692: p_ATTRIBUTE14 => fnd_api.g_miss_char,
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
696: p_START_DATE => fnd_api.g_miss_date,
697: p_END_DATE => fnd_api.g_miss_date,
698: P_ROLLUP_QUANTITY_USED => p_rollup_quantity_used,
699: P_ROLLUP_TIMES_USED => p_rollup_times_used,
700: P_SUBSTITUTE_ITEM => p_substitute_item);
693: p_ATTRIBUTE15 => fnd_api.g_miss_char,
694: p_PRIMARY_UOM_CODE => fnd_api.g_miss_char,
695: p_REVISION => fnd_api.g_miss_char,
696: p_START_DATE => fnd_api.g_miss_date,
697: p_END_DATE => fnd_api.g_miss_date,
698: P_ROLLUP_QUANTITY_USED => p_rollup_quantity_used,
699: P_ROLLUP_TIMES_USED => p_rollup_times_used,
700: P_SUBSTITUTE_ITEM => p_substitute_item);
701: