726: WHERE project_id = p_trf_pa_attr_rec.to_project_id;
727:
728: SELECT task_number
729: INTO l_task_number
730: FROM pa_tasks
731: WHERE task_id = p_trf_pa_attr_rec.to_task_id;
732:
733: l_proj_itm_trf_qty := p_trf_pa_attr_rec.quantity;
734: i := 0;
895: WHERE project_id = p_trf_pa_attr_rec.project_id;
896:
897: SELECT task_number
898: INTO l_nl_pa_interface_tbl(i).task_number
899: FROM pa_tasks
900: WHERE task_id = p_trf_pa_attr_rec.task_id;
901:
902: l_nl_pa_interface_tbl(i).orig_transaction_reference := p_trf_pa_attr_rec.transaction_id;
903: l_nl_pa_interface_tbl(i).attribute8 := null;
927:
928: BEGIN
929: SELECT task_number
930: INTO l_from_task_number
931: FROM pa_tasks
932: WHERE task_id = p_trf_pa_attr_rec.task_id;
933: EXCEPTION
934: WHEN NO_DATA_FOUND THEN
935: NULL;
1036: WHERE project_id = p_trf_pa_attr_rec.to_project_id;
1037:
1038: SELECT task_number
1039: INTO l_nl_pa_interface_tbl(i).task_number
1040: FROM pa_tasks
1041: WHERE task_id = p_trf_pa_attr_rec.to_task_id;
1042:
1043: l_nl_pa_interface_tbl(i).orig_transaction_reference := p_trf_pa_attr_rec.transaction_id||'-'||l_ref_sufix;
1044: l_nl_pa_interface_tbl(i).attribute8 := null;