846: from pa_fp_adj_elements
847: where resource_assignment_id = l_ra_id_pl
848: and adjustment_reason_code = l_adj_reason_code;
849:
850: pa_fp_adj_elements_pkg.
851: update_row(p_adj_element_id => l_adj_element_id_pl,
852: p_adjustment_comments => l_adj_comments,
853: x_return_status => l_return_status );
854:
855: exception
856:
857: WHEN NO_DATA_FOUND THEN
858:
859: pa_fp_adj_elements_pkg.
860: insert_row(px_adj_element_id => l_adj_element_id_pl,
861: p_resource_assignment_id => l_ra_id_pl,
862: p_budget_version_id => l_budget_version_id,
863: p_project_id => l_project_id,
875: from pa_fp_adj_elements
876: where resource_assignment_id = l_ra_id_tl
877: and adjustment_reason_code = l_adj_reason_code;
878:
879: pa_fp_adj_elements_pkg.
880: update_row(p_adj_element_id => l_adj_element_id_tl,
881: p_adjustment_comments => l_adj_comments,
882: x_return_status => l_return_status );
883:
884: exception
885:
886: WHEN NO_DATA_FOUND THEN
887:
888: pa_fp_adj_elements_pkg.
889: insert_row(px_adj_element_id => l_adj_element_id_tl,
890: p_resource_assignment_id => l_ra_id_tl,
891: p_budget_version_id => l_budget_version_id,
892: p_project_id => l_project_id,