APPS.PA_FP_ELEMENTS_PUB dependencies on PA_FP_ROLLUP_TMP

Line 3753: pa_fp_rollup_tmp table(task_id in system_reference1 and resource_list_member_id in

3749:
3750: /*
3751: This API creates resource assignments and elements for a budget version.
3752: The API expects that the necessary data(only) to create the above two are available in
3753: pa_fp_rollup_tmp table(task_id in system_reference1 and resource_list_member_id in
3754: system_reference2). The resource assignment id contains -1 if the RA id doesnot exist.
3755: */
3756: PROCEDURE CREATE_ASSGMT_FROM_ROLLUPTMP
3757: ( p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

Line 3826: from pa_fp_rollup_tmp rollup

3822: -- ,null projfunc_raw_cost
3823: -- ,null projfunc_burd_cost
3824: -- ,null projfunc_revenue
3825: -- ,null quantity
3826: from pa_fp_rollup_tmp rollup
3827: ,pa_proj_element_versions pelm
3828: where not exists
3829: (
3830: select pra.resource_assignment_id

Line 3973: update pa_fp_rollup_tmp rollup

3969: EXIT WHEN nvl(l_task_id_tbl.last,0) < g_plsql_max_array_size;
3970: END LOOP;
3971:
3972: --Update the roll up tmp table with the newly created resource assignment id.
3973: update pa_fp_rollup_tmp rollup
3974: set resource_assignment_id =
3975: (
3976: select resource_assignment_id
3977: from pa_resource_assignments ra