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_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 48: PA_RESOURCE_ASSIGNMENTS ra

44: vw.RESOURCE_ASSIGNMENT_ID,
45: vw.TXN_CURRENCY_CODE
46: FROM PA_PROG_ACT_BY_PERIOD_TEMP vw,
47: PA_BUDGET_VERSIONS bv,
48: PA_RESOURCE_ASSIGNMENTS ra
49: WHERE bv.project_structure_version_id = vw.structure_version_id
50: AND nvl(bv.wp_version_flag,'N') = 'Y' AND
51: vw.RESOURCE_ASSIGNMENT_ID IS NOT NULL AND
52: ra.resource_assignment_id = vw.resource_assignment_id AND

Line 64: PA_RESOURCE_ASSIGNMENTS ra

60: vw.HIDDEN_RES_ASSGN_ID,
61: vw.TXN_CURRENCY_CODE
62: FROM PA_PROG_ACT_BY_PERIOD_TEMP vw,
63: PA_BUDGET_VERSIONS bv,
64: PA_RESOURCE_ASSIGNMENTS ra
65: WHERE bv.project_structure_version_id = vw.structure_version_id
66: AND nvl(bv.wp_version_flag,'N') = 'Y' AND
67: vw.HIDDEN_RES_ASSGN_ID IS NOT NULL AND
68: ra.resource_assignment_id = vw.HIDDEN_RES_ASSGN_ID AND

Line 419: FROM pa_resource_assignments

415: res asg id should be a valid id.
416: SELECT NVL(planning_start_date,trunc(sysdate)),
417: NVL(planning_end_date,trunc(sysdate) ) INTO
418: l_start_date,l_end_date
419: FROM pa_resource_assignments
420: WHERE resource_assignment_id = l_res_asg_id_tab(i);
421: l_amt_dtls_tbl(m).start_date := l_start_date;
422: l_amt_dtls_tbl(m).end_date := l_end_date;
423: END LOOP; */

Line 600: UPDATE pa_resource_assignments

596: WHERE budget_version_id = l_bv_id_tab(kk);
597:
598: IF p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING' THEN
599: FORALL m IN 1..l_res_asg_id_tab.count
600: UPDATE pa_resource_assignments
601: SET unplanned_flag = 'N'
602: WHERE resource_assignment_id = l_res_asg_id_tab(m)
603: AND nvl(unplanned_flag,'N') = 'Y';
604: END IF;

Line 861: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

857: **/
858: PROCEDURE MAINTAIN_ACTUAL_AMT_RA
859: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
860: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
861: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
862: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
863: P_AMT_DTLS_REC_TAB IN PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ,
864: P_CALLING_CONTEXT IN VARCHAR2,
865: P_TXN_AMT_TYPE_CODE IN VARCHAR2,

Line 946: l_unplanned_res_flag PA_RESOURCE_ASSIGNMENTS.UNPLANNED_FLAG%TYPE;

942: l_ins_ind NUMBER := 1;
943:
944: l_ins_flag VARCHAR2(1);
945:
946: l_unplanned_res_flag PA_RESOURCE_ASSIGNMENTS.UNPLANNED_FLAG%TYPE;
947:
948: l_pc_code pa_projects_all.PROJECT_CURRENCY_CODE%TYPE;
949: l_pfc_code pa_projects_all.PROJFUNC_CURRENCY_CODE%TYPE;
950:

Line 951: l_spread_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;

947:
948: l_pc_code pa_projects_all.PROJECT_CURRENCY_CODE%TYPE;
949: l_pfc_code pa_projects_all.PROJFUNC_CURRENCY_CODE%TYPE;
950:
951: l_spread_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;
952: l_multi_bdgt_lines NUMBER;
953:
954: -- Bug 4699248: Replaced l_spread_curve_name with l_spread_curve_code
955: -- throughout this procedure. Also, updated the type accordingly.

Line 1007: FROM pa_resource_assignments

1003: END IF;
1004:
1005: SELECT NVL(UNPLANNED_FLAG,'N')
1006: INTO l_unplanned_res_flag
1007: FROM pa_resource_assignments
1008: WHERE resource_assignment_id = p_resource_assignment_id;
1009:
1010: SELECT project_currency_code,
1011: projfunc_currency_code INTO

Line 2457: FROM pa_resource_assignments ra,pa_spread_curves_b t

2453: -- of the spread curve name for the given resource.
2454:
2455: SELECT ra.spread_curve_id,t.spread_curve_code
2456: INTO l_spread_curve_id,l_spread_curve_code
2457: FROM pa_resource_assignments ra,pa_spread_curves_b t
2458: WHERE ra.resource_assignment_id = p_resource_assignment_id
2459: AND ra.spread_curve_id = t.spread_curve_id;
2460: EXCEPTION
2461: WHEN NO_DATA_FOUND THEN

Line 2478: UPDATE pa_resource_assignments

2474: AND txn_currency_code = p_txn_currency_code;
2475:
2476: --Need to update res asg table if there are multiple budget lines
2477: IF l_multi_bdgt_lines > 1 THEN
2478: UPDATE pa_resource_assignments
2479: SET spread_curve_id = NULL,
2480: sp_fixed_date = NULL
2481: WHERE resource_assignment_id = p_resource_assignment_id;
2482: END IF;

Line 2515: * pa_resource_assignments table based upon the p_calling_context parameter.

2511:
2512:
2513: /**
2514: * This procedure synchs up planning dates for target resources in the
2515: * pa_resource_assignments table based upon the p_calling_context parameter.
2516: *
2517: * Valid P_CALLING_CONTEXT values are
2518: * 'SYNC_VERSION_LEVEL'
2519: * 'COPY_ACTUALS'

Line 2576: FROM pa_resource_assignments ra,

2572: start_pd.start_date,
2573: end_pd.end_date,
2574: min(bl.start_date),
2575: max(bl.end_date)
2576: FROM pa_resource_assignments ra,
2577: pa_budget_versions bv, -- Added for Perf Bug 4469690
2578: pa_budget_lines bl,
2579: pa_periods_all start_pd,
2580: pa_periods_all end_pd

Line 2603: FROM pa_resource_assignments ra,

2599: start_pd.start_date,
2600: end_pd.end_date,
2601: min(bl.start_date),
2602: max(bl.end_date)
2603: FROM pa_resource_assignments ra,
2604: pa_budget_versions bv, -- Added for Perf Bug 4469690
2605: pa_budget_lines bl,
2606: gl_period_statuses start_pd,
2607: gl_period_statuses end_pd

Line 2634: FROM pa_resource_assignments ra,

2630: ra.planning_start_date,
2631: ra.planning_end_date,
2632: min(bl.start_date),
2633: max(bl.end_date)
2634: FROM pa_resource_assignments ra,
2635: pa_budget_versions bv, -- Added for Perf Bug 4469690
2636: pa_budget_lines bl
2637: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2638: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690

Line 2656: FROM pa_resource_assignments ra,

2652: ra.planning_start_date,
2653: ra.planning_end_date,
2654: min(t.start_date),
2655: max(t.finish_date)
2656: FROM pa_resource_assignments ra,
2657: PA_PROG_ACT_BY_PERIOD_TEMP t
2658: WHERE ra.resource_assignment_id =
2659: nvl(t.resource_assignment_id,t.HIDDEN_RES_ASSGN_ID)
2660: AND ra.budget_version_id = p_budget_version_id

Line 2676: FROM pa_resource_assignments ra,

2672: start_pd.start_date,
2673: end_pd.end_date,
2674: min(bl.start_date),
2675: max(bl.end_date)
2676: FROM pa_resource_assignments ra,
2677: pa_budget_versions bv, -- Added for Perf Bug 4469690
2678: pa_budget_lines bl,
2679: pji_fm_xbs_accum_tmp1 pji_tmp,
2680: pa_periods_all start_pd,

Line 2705: FROM pa_resource_assignments ra,

2701: start_pd.start_date,
2702: end_pd.end_date,
2703: min(bl.start_date),
2704: max(bl.end_date)
2705: FROM pa_resource_assignments ra,
2706: pa_budget_versions bv, -- Added for Perf Bug 4469690
2707: pa_budget_lines bl,
2708: pji_fm_xbs_accum_tmp1 pji_tmp,
2709: gl_period_statuses start_pd,

Line 2738: FROM pa_resource_assignments ra,

2734: ra.planning_start_date,
2735: ra.planning_end_date,
2736: min(bl.start_date),
2737: max(bl.end_date)
2738: FROM pa_resource_assignments ra,
2739: pa_budget_versions bv, -- Added for Perf Bug 4469690
2740: pa_budget_lines bl,
2741: pji_fm_xbs_accum_tmp1 pji_tmp
2742: WHERE ra.resource_assignment_id = bl.resource_assignment_id

Line 2761: pa_resource_assignments ra

2757: ra.planning_end_date,
2758: MIN(tmp.txn_planning_start_date),
2759: MAX(tmp.txn_planning_end_date)
2760: FROM pa_res_list_map_tmp4 tmp,
2761: pa_resource_assignments ra
2762: WHERE ra.resource_assignment_id = tmp.txn_resource_assignment_id
2763: AND ra.budget_version_id = p_budget_version_id
2764: GROUP BY ra.resource_assignment_id,
2765: ra.planning_start_date,

Line 3077: UPDATE pa_resource_assignments

3073: END IF; -- end populating update pl/sql tables
3074:
3075: /* Update synched planning dates in the db. */
3076: FORALL m IN 1..l_upd_res_asg_id_tab.count
3077: UPDATE pa_resource_assignments
3078: SET planning_start_date = l_upd_start_date_tab(m),
3079: planning_end_date = l_upd_end_date_tab(m)
3080: WHERE resource_assignment_id = l_upd_res_asg_id_tab(m);
3081:

Line 3588: FROM pa_resource_assignments

3584: BULK COLLECT INTO
3585: l_res_asg_id_tab,
3586: l_planning_start_date_tab,
3587: l_planning_end_date_tab
3588: FROM pa_resource_assignments
3589: WHERE budget_version_id = P_BUDGET_VERSION_ID;
3590:
3591: IF l_res_asg_id_tab.count = 0 THEN
3592: IF p_pa_debug_mode = 'Y' THEN

Line 3656: UPDATE pa_resource_assignments

3652: END IF;
3653: END LOOP;
3654:
3655: FORALL i IN 1..l_upd_res_asg_id_tab.count
3656: UPDATE pa_resource_assignments
3657: SET planning_start_date = l_upd_planning_start_date_tab(i),
3658: planning_end_date = l_upd_planning_end_date_tab(i)
3659: WHERE resource_assignment_id = l_upd_res_asg_id_tab(i);
3660: