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