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 3829: from pa_fp_rollup_tmp rollup

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

Line 3980: update pa_fp_rollup_tmp rollup

3976: EXIT WHEN nvl(l_task_id_tbl.last,0) < g_plsql_max_array_size;
3977: END LOOP;
3978:
3979: --Update the roll up tmp table with the newly created resource assignment id.
3980: update pa_fp_rollup_tmp rollup
3981: set resource_assignment_id =
3982: (
3983: select resource_assignment_id
3984: from pa_resource_assignments ra