eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FIN_PLAN_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 949: pa_resource_assignments

945: cursor l_resource_assignments_csr is
946: select unique
947: resource_assignment_id
948: from
949: pa_resource_assignments
950: where
951: budget_version_id=p_budget_version_id;
952: l_resource_assignments_rec l_resource_assignments_csr%ROWTYPE;
953:

Line 1467: pa_resource_assignments

1463: cursor l_resource_assignments_csr is
1464: select unique
1465: resource_assignment_id
1466: from
1467: pa_resource_assignments
1468: where
1469: budget_version_id=p_budget_version_id;
1470: l_resource_assignments_rec l_resource_assignments_csr%ROWTYPE;
1471: */

Line 1662: -- PA_BUDGET_LINES: delete row (keyed on PA_RESOURCE_ASSIGNMENTS.resource_assignment_id)

1658: ---- start of changes for bug 2779637 ----
1659: /* for performance its better to use budget_version_id for the deletion of budget lines*/
1660:
1661: /*
1662: -- PA_BUDGET_LINES: delete row (keyed on PA_RESOURCE_ASSIGNMENTS.resource_assignment_id)
1663: open l_resource_assignments_csr;
1664: loop
1665: fetch l_resource_assignments_csr into l_resource_assignments_rec;
1666: exit when l_resource_assignments_csr%NOTFOUND;

Line 1684: /* PA_RESOURCE_ASSIGNMENTS: delete row (keyed on budget_version_id) */

1680: budget_version_id=l_budget_Version_id_tbl(i);
1681: ---- end of changes for bug 2779637 ----
1682:
1683: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1684: /* PA_RESOURCE_ASSIGNMENTS: delete row (keyed on budget_version_id) */
1685: delete
1686: from
1687: pa_resource_assignments
1688: where

Line 1687: pa_resource_assignments

1683: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1684: /* PA_RESOURCE_ASSIGNMENTS: delete row (keyed on budget_version_id) */
1685: delete
1686: from
1687: pa_resource_assignments
1688: where
1689: budget_version_id=l_budget_Version_id_tbl(i);
1690: -- Bug Fix: 4569365. Removed MRC code.
1691: /*

Line 1938: When p_copy_mode is B, pa_fp_elements and pa_resource_assignments will be copied

1934: pa_fp_copy_from_pkg.copy_plan.Hence this api takes care of copying one verion to
1935: an already existing version also.
1936:
1937: Bug No. 2920954
1938: When p_copy_mode is B, pa_fp_elements and pa_resource_assignments will be copied
1939: to have only planning elements and ras with plan amounts. Calls to
1940: pa_fp_elements_pub.copy_elements and pa_fp_copy_from_pkg.create_res_tasks_maps
1941: modified to include new parameters.
1942:

Line 2346: --Calling copy_resource_assignments to insert records in pa_resource_assignments using

2342: ,x_msg_data => l_msg_data );
2343: /* END IF; Commented for bug 2706430 */
2344: END IF;
2345:
2346: --Calling copy_resource_assignments to insert records in pa_resource_assignments using
2347: --pa_fp_ra_map_tmp.
2348:
2349:
2350: --If the calling module is Financial Planning then its not required to go thru te route of

Line 4481: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

4477: l_error_msg_code VARCHAR2(30);
4478: l_msg_index_out NUMBER;
4479:
4480:
4481: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4482: l_forecast_element_id pa_org_forecast_lines.forecast_element_id%TYPE;
4483: l_adj_element_id pa_fp_adj_elements.adj_element_id%TYPE;
4484:
4485: cursor l_ra_csr is

Line 4489: pa_resource_assignments

4485: cursor l_ra_csr is
4486: select
4487: resource_assignment_id
4488: from
4489: pa_resource_assignments
4490: where
4491: budget_version_id=p_source_version_id;
4492:
4493: l_ra_rec l_ra_csr%ROWTYPE;

Line 5135: pa_proj_fp_options , pa_resource_assignments,

5131: /*=====================================================================
5132: Bug No. 2331201 For finplan this api has been added
5133: This api Creates a working fin plan version.The version inherits its
5134: properties from plan type.This api creates records in
5135: pa_proj_fp_options , pa_resource_assignments,
5136: pa_fp_txn_currencies and pa_budget_versions.
5137: If px_budget_version_id is passed it is assumed that new version
5138: id is created and passed to the api, else new value is created.
5139:

Line 5171: -- do not create records in pa_resource_assignments

5167:
5168: -- 21-SEP-2004 rravipat - bug 3867302
5169: -- For ci versions reporting data is not maintained
5170: -- 06-DEC-2004 dlai - bug 3831449
5171: -- do not create records in pa_resource_assignments
5172: -- if p_calling_context is GENERATE
5173:
5174: -- 07-Nov-2005 dbora Bug 4724017: Redone the fix done for bug 4534591
5175: -- in 11.5 as CDM Enhancement.

Line 6528: /* 3831449: do not create records in pa_resource_assignments if p_calling_context is GENERATE */

6524: -- If calling context is create_draft or automatic baseline this api need not
6525: -- create resource assignments for the budget version
6526:
6527: /* Did null handing for bug 2663313 */
6528: /* 3831449: do not create records in pa_resource_assignments if p_calling_context is GENERATE */
6529: IF nvl(p_calling_context,'-99') NOT IN (PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT,
6530: -- Bug Fix: 4569365. Removed MRC code.
6531: -- PA_MRC_FINPLAN.G_AUTOMATIC_BASELINE,
6532: 'AUTOMATIC_BASELINE', --Bug 5700400: Autobaseline case was commented earlier by mistake.

Line 6632: UPDATE pa_resource_assignments

6628: -- Check if out table has any records first
6629: IF nvl(l_txn_source_id_tbl.last,0) >= 1 THEN
6630: -- Update resource assignments data for the version
6631: FORALL j IN l_txn_source_id_tbl.first .. l_txn_source_id_tbl.last
6632: UPDATE pa_resource_assignments
6633: SET rbs_element_id = l_rbs_element_id_tbl(j)
6634: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
6635: ,record_version_number = record_version_number + 1
6636: ,last_update_date = SYSDATE

Line 6645: UPDATE pa_resource_assignments

6641: END IF;
6642: ELSE -- rbs version id is null
6643:
6644: -- Update all the resource assigments with null for rbs _element_id
6645: UPDATE pa_resource_assignments
6646: SET rbs_element_id = null
6647: ,txn_accum_header_id = null
6648: ,record_version_number = record_version_number + 1
6649: ,last_update_date = SYSDATE

Line 7203: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra

7199: SELECT MIN (pbl.start_date)
7200: ,MAX(pbl.end_date)
7201: INTO l_start_date
7202: ,l_end_date
7203: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7204: ,pa_budget_lines pbl
7205: WHERE pbv.project_id = p_project_id
7206: AND pbl.budget_version_id = pbv.budget_version_id
7207: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)

Line 7792: FROM pa_resource_assignments pra, pa_budget_lines pbl

7788: ,null old_projfunc_margin_percent
7789: ,bucketing_period_code
7790: ,pra.parent_assignment_id
7791: ,null delete_flag
7792: FROM pa_resource_assignments pra, pa_budget_lines pbl
7793: WHERE pra.budget_version_id = p_budget_version_id
7794: AND pra.resource_assignment_id = pbl.resource_assignment_id;
7795:
7796: CURSOR rollup_tmp_cur IS

Line 7855: FROM pa_resource_assignments pra, pa_fp_rollup_tmp frt

7851: old_projfunc_margin_percentage
7852: ,bucketing_period_code
7853: ,pra.parent_assignment_id
7854: ,delete_flag
7855: FROM pa_resource_assignments pra, pa_fp_rollup_tmp frt
7856: WHERE pra.budget_version_id = p_budget_version_id
7857: AND pra.resource_assignment_id = frt.resource_assignment_id;
7858:
7859: BEGIN

Line 8502: FROM pa_resource_assignments ra

8498:
8499: CURSOR def_plan_txn_to_ins_csr
8500: IS
8501: SELECT ra.resource_assignment_id
8502: FROM pa_resource_assignments ra
8503: WHERE ra.budget_version_id = p_budget_version_id
8504: AND NOT EXISTS (SELECT 'X'
8505: FROM pa_resource_asgn_curr rac
8506: WHERE rac.resource_assignment_id = ra.resource_assignment_id