APPS.PA_FIN_PLAN_VIEW_GLOBAL dependencies on PA_FP_ADJ_ELEMENTS

Line 142: from pa_fp_adj_elements pe,

138:
139: begin
140: select pe.adjustment_comments
141: into x_adj_comments
142: from pa_fp_adj_elements pe,
143: pa_resource_assignments pra
144: where pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
145: and resource_assignment_type = 'OWN'
146: and pe.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()

Line 841: /*Update pa_fp_adj_elements*/

837: l_amount_type_code := p_amount_type_code;
838: l_amount_subtype_code:= p_amount_subtype_code;
839:
840: /****************************************************************************************/
841: /*Update pa_fp_adj_elements*/
842: /***************************************************************************************/
843: begin
844: select adj_element_id
845: into l_adj_element_id_pl

Line 846: from pa_fp_adj_elements

842: /***************************************************************************************/
843: begin
844: select adj_element_id
845: into l_adj_element_id_pl
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.

Line 850: pa_fp_adj_elements_pkg.

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:

Line 859: pa_fp_adj_elements_pkg.

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,

Line 875: from pa_fp_adj_elements

871:
872: begin
873: select adj_element_id
874: into l_adj_element_id_tl
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.

Line 879: pa_fp_adj_elements_pkg.

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:

Line 888: pa_fp_adj_elements_pkg.

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,

Line 903: /*End of Update pa_fp_adj_elements*/

899: end;
900:
901:
902: /****************************************************************************************/
903: /*End of Update pa_fp_adj_elements*/
904: /***************************************************************************************/
905:
906:
907: /****************************************************************************************/