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 1451: pa_resource_assignments

1447: cursor l_resource_assignments_csr is
1448: select unique
1449: resource_assignment_id
1450: from
1451: pa_resource_assignments
1452: where
1453: budget_version_id=p_budget_version_id;
1454: l_resource_assignments_rec l_resource_assignments_csr%ROWTYPE;
1455: */

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

1642: ---- start of changes for bug 2779637 ----
1643: /* for performance its better to use budget_version_id for the deletion of budget lines*/
1644:
1645: /*
1646: -- PA_BUDGET_LINES: delete row (keyed on PA_RESOURCE_ASSIGNMENTS.resource_assignment_id)
1647: open l_resource_assignments_csr;
1648: loop
1649: fetch l_resource_assignments_csr into l_resource_assignments_rec;
1650: exit when l_resource_assignments_csr%NOTFOUND;

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

1664: budget_version_id=l_budget_Version_id_tbl(i);
1665: ---- end of changes for bug 2779637 ----
1666:
1667: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1668: /* PA_RESOURCE_ASSIGNMENTS: delete row (keyed on budget_version_id) */
1669: delete
1670: from
1671: pa_resource_assignments
1672: where

Line 1671: pa_resource_assignments

1667: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1668: /* PA_RESOURCE_ASSIGNMENTS: delete row (keyed on budget_version_id) */
1669: delete
1670: from
1671: pa_resource_assignments
1672: where
1673: budget_version_id=l_budget_Version_id_tbl(i);
1674: -- Bug Fix: 4569365. Removed MRC code.
1675: /*

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

1918: pa_fp_copy_from_pkg.copy_plan.Hence this api takes care of copying one verion to
1919: an already existing version also.
1920:
1921: Bug No. 2920954
1922: When p_copy_mode is B, pa_fp_elements and pa_resource_assignments will be copied
1923: to have only planning elements and ras with plan amounts. Calls to
1924: pa_fp_elements_pub.copy_elements and pa_fp_copy_from_pkg.create_res_tasks_maps
1925: modified to include new parameters.
1926:

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

2326: ,x_msg_data => l_msg_data );
2327: /* END IF; Commented for bug 2706430 */
2328: END IF;
2329:
2330: --Calling copy_resource_assignments to insert records in pa_resource_assignments using
2331: --pa_fp_ra_map_tmp.
2332:
2333:
2334: --If the calling module is Financial Planning then its not required to go thru te route of

Line 4465: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

4461: l_error_msg_code VARCHAR2(30);
4462: l_msg_index_out NUMBER;
4463:
4464:
4465: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4466: l_forecast_element_id pa_org_forecast_lines.forecast_element_id%TYPE;
4467: l_adj_element_id pa_fp_adj_elements.adj_element_id%TYPE;
4468:
4469: cursor l_ra_csr is

Line 4473: pa_resource_assignments

4469: cursor l_ra_csr is
4470: select
4471: resource_assignment_id
4472: from
4473: pa_resource_assignments
4474: where
4475: budget_version_id=p_source_version_id;
4476:
4477: l_ra_rec l_ra_csr%ROWTYPE;

Line 5119: pa_proj_fp_options , pa_resource_assignments,

5115: /*=====================================================================
5116: Bug No. 2331201 For finplan this api has been added
5117: This api Creates a working fin plan version.The version inherits its
5118: properties from plan type.This api creates records in
5119: pa_proj_fp_options , pa_resource_assignments,
5120: pa_fp_txn_currencies and pa_budget_versions.
5121: If px_budget_version_id is passed it is assumed that new version
5122: id is created and passed to the api, else new value is created.
5123:

Line 5155: -- do not create records in pa_resource_assignments

5151:
5152: -- 21-SEP-2004 rravipat - bug 3867302
5153: -- For ci versions reporting data is not maintained
5154: -- 06-DEC-2004 dlai - bug 3831449
5155: -- do not create records in pa_resource_assignments
5156: -- if p_calling_context is GENERATE
5157:
5158: -- 07-Nov-2005 dbora Bug 4724017: Redone the fix done for bug 4534591
5159: -- in 11.5 as CDM Enhancement.

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

6504: -- If calling context is create_draft or automatic baseline this api need not
6505: -- create resource assignments for the budget version
6506:
6507: /* Did null handing for bug 2663313 */
6508: /* 3831449: do not create records in pa_resource_assignments if p_calling_context is GENERATE */
6509: IF nvl(p_calling_context,'-99') NOT IN (PA_FP_CONSTANTS_PKG.G_CREATE_DRAFT,
6510: -- Bug Fix: 4569365. Removed MRC code.
6511: -- PA_MRC_FINPLAN.G_AUTOMATIC_BASELINE,
6512: 'AUTOMATIC_BASELINE', --Bug 5700400: Autobaseline case was commented earlier by mistake.

Line 6612: UPDATE pa_resource_assignments

6608: -- Check if out table has any records first
6609: IF nvl(l_txn_source_id_tbl.last,0) >= 1 THEN
6610: -- Update resource assignments data for the version
6611: FORALL j IN l_txn_source_id_tbl.first .. l_txn_source_id_tbl.last
6612: UPDATE pa_resource_assignments
6613: SET rbs_element_id = l_rbs_element_id_tbl(j)
6614: ,txn_accum_header_id = l_txn_accum_header_id_tbl(j)
6615: ,record_version_number = record_version_number + 1
6616: ,last_update_date = SYSDATE

Line 6625: UPDATE pa_resource_assignments

6621: END IF;
6622: ELSE -- rbs version id is null
6623:
6624: -- Update all the resource assigments with null for rbs _element_id
6625: UPDATE pa_resource_assignments
6626: SET rbs_element_id = null
6627: ,txn_accum_header_id = null
6628: ,record_version_number = record_version_number + 1
6629: ,last_update_date = SYSDATE

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

7179: SELECT MIN (pbl.start_date)
7180: ,MAX(pbl.end_date)
7181: INTO l_start_date
7182: ,l_end_date
7183: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7184: ,pa_budget_lines pbl
7185: WHERE pbv.project_id = p_project_id
7186: AND pbl.budget_version_id = pbv.budget_version_id
7187: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)

Line 7772: FROM pa_resource_assignments pra, pa_budget_lines pbl

7768: ,null old_projfunc_margin_percent
7769: ,bucketing_period_code
7770: ,pra.parent_assignment_id
7771: ,null delete_flag
7772: FROM pa_resource_assignments pra, pa_budget_lines pbl
7773: WHERE pra.budget_version_id = p_budget_version_id
7774: AND pra.resource_assignment_id = pbl.resource_assignment_id;
7775:
7776: CURSOR rollup_tmp_cur IS

Line 7835: FROM pa_resource_assignments pra, pa_fp_rollup_tmp frt

7831: old_projfunc_margin_percentage
7832: ,bucketing_period_code
7833: ,pra.parent_assignment_id
7834: ,delete_flag
7835: FROM pa_resource_assignments pra, pa_fp_rollup_tmp frt
7836: WHERE pra.budget_version_id = p_budget_version_id
7837: AND pra.resource_assignment_id = frt.resource_assignment_id;
7838:
7839: BEGIN

Line 8481: FROM pa_resource_assignments ra

8477:
8478: CURSOR def_plan_txn_to_ins_csr
8479: IS
8480: SELECT ra.resource_assignment_id
8481: FROM pa_resource_assignments ra
8482: WHERE ra.budget_version_id = p_budget_version_id
8483: AND NOT EXISTS (SELECT 'X'
8484: FROM pa_resource_asgn_curr rac
8485: WHERE rac.resource_assignment_id = ra.resource_assignment_id