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_BUDGET_VERSIONS

Line 47: PA_BUDGET_VERSIONS bv,

43: vw.STRUCTURE_VERSION_ID,
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

Line 63: PA_BUDGET_VERSIONS bv,

59: vw.STRUCTURE_VERSION_ID,
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

Line 123: l_bv_id pa_budget_versions.budget_version_id%type;

119: l_txn_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
122:
123: l_bv_id pa_budget_versions.budget_version_id%type;
124: l_bv_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
125: l_ra_id_upd_reprt_tab pa_plsql_datatypes.IdTabTyp;
126:
127: /* Additional parameters for MAINTAIN_ACTUAL_AMT_RA */

Line 174: FROM PA_BUDGET_VERSIONS

170:
171: FOR ss1 IN 1 .. P_PROJECT_ID_TAB.COUNT LOOP
172: BEGIN
173: SELECT budget_version_id into l_bv_id
174: FROM PA_BUDGET_VERSIONS
175: WHERE project_id = P_PROJECT_ID_tab(ss1)
176: AND project_structure_version_id = P_WP_STR_VERSION_ID_TAB(ss1)
177: AND nvl(wp_version_flag,'N') = 'Y';
178: EXCEPTION

Line 594: UPDATE pa_budget_versions

590:
591: END LOOP; /* end loop for p_project_id_tab.count */
592:
593: FORALL kk IN 1..P_ACTUALS_THRU_DATE.count
594: UPDATE pa_budget_versions
595: SET etc_start_date = p_actuals_thru_date(kk)+1
596: WHERE budget_version_id = l_bv_id_tab(kk);
597:
598: IF p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING' THEN

Line 860: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

856: *
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,

Line 917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1062: FROM PA_BUDGET_VERSIONS

1058: END LOOP;
1059: END IF;
1060:
1061: SELECT version_type INTO l_version_type
1062: FROM PA_BUDGET_VERSIONS
1063: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1064:
1065: SELECT decode(l_version_type,
1066: 'COST', opt.cost_time_phased_code,

Line 2556: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2552: * exception that only target resources with billing
2553: * events are considered for synching.
2554: */
2555: PROCEDURE SYNC_UP_PLANNING_DATES
2556: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2557: P_CALLING_CONTEXT IN VARCHAR2,
2558: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2559: X_MSG_COUNT OUT NOCOPY NUMBER,
2560: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 2577: pa_budget_versions bv, -- Added for Perf Bug 4469690

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
2581: WHERE ra.resource_assignment_id = bl.resource_assignment_id

Line 2604: pa_budget_versions bv, -- Added for Perf Bug 4469690

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
2608: WHERE ra.resource_assignment_id = bl.resource_assignment_id

Line 2635: pa_budget_versions bv, -- Added for Perf Bug 4469690

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
2639: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690

Line 2677: pa_budget_versions bv, -- Added for Perf Bug 4469690

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,
2681: pa_periods_all end_pd

Line 2706: pa_budget_versions bv, -- Added for Perf Bug 4469690

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,
2710: gl_period_statuses end_pd

Line 2739: pa_budget_versions bv, -- Added for Perf Bug 4469690

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
2743: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690

Line 2793: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

2789: lc_Commitments CONSTANT VARCHAR2(30) := 'GEN_COMMITMENTS';
2790: lc_BillingEvents CONSTANT VARCHAR2(30) := 'GEN_BILLING_EVENTS';
2791:
2792: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
2793: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
2794: l_etc_start_period_end_date DATE;
2795:
2796: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
2797:

Line 2796: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

2792: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
2793: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
2794: l_etc_start_period_end_date DATE;
2795:
2796: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
2797:
2798: BEGIN
2799: /* Setting initial values */
2800: X_MSG_COUNT := 0;

Line 2836: pa_budget_versions WHERE budget_version_id = p_budget_version_id;

2832: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2833: END IF;
2834:
2835: SELECT NVL(wp_version_flag,'N') INTO l_wp_version_flag FROM
2836: pa_budget_versions WHERE budget_version_id = p_budget_version_id;
2837:
2838:
2839: /* Fetch the planning dates and min/max dates for planning resources
2840: * based on p_calling_context and target time phase. */

Line 3132: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3128: * 'UPDATE': update reporting lines *
3129: * 'DELETE': delete reporting lines *
3130: **/
3131: PROCEDURE BLK_UPD_REPORTING_LINES_WRP
3132: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3133: P_ENTIRE_VERSION_FLAG IN VARCHAR2,
3134: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IDTABTYP,
3135: P_ACTIVITY_CODE IN VARCHAR2,
3136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 3540: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3536:
3537: END BLK_UPD_REPORTING_LINES_WRP;
3538:
3539: PROCEDURE SYNC_UP_PLANNING_DATES_NONE_TP
3540: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3541: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
3542: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3543: X_MSG_COUNT OUT NOCOPY NUMBER,
3544: X_MSG_DATA OUT NOCOPY VARCHAR2) IS