DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 4636: /* UPDATE pa_resource_assignments

4632:
4633: else
4634: /* Added for bug 13030627 */
4635:
4636: /* UPDATE pa_resource_assignments
4637: SET txn_accum_header_id = NULL; */
4638:
4639: FOR l_curr_rbs_vers IN c_current_rbs_versions LOOP
4640:

Line 4644: UPDATE pa_resource_assignments

4640:
4641:
4642: FOR l_plan_versions in c_plan_versions(l_curr_rbs_vers.RBS_VERSION_ID) LOOP
4643:
4644: UPDATE pa_resource_assignments
4645: SET txn_accum_header_id = NULL
4646: where budget_version_id = l_plan_versions.budget_version_id
4647: and project_id =l_plan_versions.project_id
4648: and txn_accum_header_id is not null;

Line 4669: UPDATE pa_resource_assignments

4665: ,x_msg_data => x_msg_data);
4666:
4667:
4668: FORALL i IN l_txn_source_id_tbl.FIRST..l_txn_source_id_tbl.LAST
4669: UPDATE pa_resource_assignments
4670: SET TXN_ACCUM_HEADER_ID = l_txn_accum_header_id_tbl(i),
4671: RBS_ELEMENT_ID = l_rbs_element_id_tbl(i)
4672: WHERE
4673: RESOURCE_ASSIGNMENT_ID = l_txn_source_id_tbl(i);