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 521: from csp_product_tasks cpt

517:
518: cursor times_used is
519: select product_id,
520: sum(cpt.actual_times_used) sum_times_used
521: from csp_product_tasks cpt
522: group by cpt.product_id;
523:
524: begin
525: for tu in times_used loop

Line 526: update csp_product_tasks

522: group by cpt.product_id;
523:
524: begin
525: for tu in times_used loop
526: update csp_product_tasks
527: set task_percentage = actual_times_used / tu.sum_times_used * 100
528: where product_id = tu.product_id;
529: end loop;
530: end;

Line 540: csp_product_tasks_pkg.insert_row(

536:
537: l_product_task_id number;
538:
539: begin
540: csp_product_tasks_pkg.insert_row(
541: px_product_task_id => x_product_task_id,
542: p_product_id => p_product_id,
543: p_task_template_id => p_template_id,
544: p_auto_manual => 'A',

Line 575: CSP_PRODUCT_TASKS_PKG.Update_Row(

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