APPS.CSP_PROD_TASK_PARTS_HISTORY dependencies on CSP_PRODUCT_TASKS

Line 54: from csp_product_tasks cpt

50: cursor c_product_task(p_template_id number,
51: p_product_id number) is
52: select product_task_id,
53: actual_times_used
54: from csp_product_tasks cpt
55: where cpt.task_template_id = p_template_id
56: and cpt.product_id = p_product_id;
57:
58: cursor c_existing_line(p_debrief_header_id number,

Line 517: from csp_product_tasks cpt

513:
514: cursor times_used is
515: select product_id,
516: sum(cpt.actual_times_used) sum_times_used
517: from csp_product_tasks cpt
518: group by cpt.product_id;
519:
520: begin
521: for tu in times_used loop

Line 522: update csp_product_tasks

518: group by cpt.product_id;
519:
520: begin
521: for tu in times_used loop
522: update csp_product_tasks
523: set task_percentage = actual_times_used / tu.sum_times_used * 100
524: where product_id = tu.product_id;
525: end loop;
526: end;

Line 536: csp_product_tasks_pkg.insert_row(

532:
533: l_product_task_id number;
534:
535: begin
536: csp_product_tasks_pkg.insert_row(
537: px_product_task_id => x_product_task_id,
538: p_product_id => p_product_id,
539: p_task_template_id => p_template_id,
540: p_auto_manual => 'A',

Line 571: CSP_PRODUCT_TASKS_PKG.Update_Row(

567: PROCEDURE Update_product_task(
568: p_product_task_id in number,
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',