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_GEN_FCST_PG_PKG dependencies on PA_BUDGET_VERSIONS

Line 63: FUNCTION GET_ACTUALS_THRU_PERIOD_DTLS(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

59: END IF;
60: RETURN NULL;
61: END;
62:
63: FUNCTION GET_ACTUALS_THRU_PERIOD_DTLS(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
64: P_CONTEXT IN VARCHAR2)
65: RETURN VARCHAR2 IS
66:
67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;

Line 287: FUNCTION GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

283: RETURN to_char(trunc(sysdate),'RRRRMMDD');
284: END IF;
285: END;
286:
287: FUNCTION GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
288: RETURN VARCHAR2 IS
289: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_FRM_PERIOD';
290:
291:

Line 379: FUNCTION GET_ACT_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

375: END IF;
376: RETURN null;
377: END;
378:
379: FUNCTION GET_ACT_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
380: RETURN VARCHAR2 IS
381: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_TO_PERIOD';
382: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
383: l_return_status VARCHAR2(10);

Line 496: FUNCTION GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

492: END IF;
493: RETURN null;
494: END;
495:
496: FUNCTION GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
497: RETURN VARCHAR2 IS
498: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_FRM_PERIOD';
499: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
500: l_return_status VARCHAR2(10);

Line 615: FUNCTION GET_ETC_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

611: END IF;
612: RETURN null;
613: END;
614:
615: FUNCTION GET_ETC_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
616: RETURN VARCHAR2 IS
617: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_TO_PERIOD';
618:
619: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 720: FUNCTION GET_UNSPENT_AMT_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

716: END;
717:
718:
719:
720: FUNCTION GET_UNSPENT_AMT_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
721: RETURN VARCHAR2 IS
722: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_UNSPENT_AMT_PERIOD';
723: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
724: BEGIN

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

727: END;
728:
729:
730: PROCEDURE GET_VERSION_DETAILS
731: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
732: X_VERSION_TYPE OUT NOCOPY PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
733: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
734: X_MSG_COUNT OUT NOCOPY NUMBER,
735: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 732: X_VERSION_TYPE OUT NOCOPY PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,

728:
729:
730: PROCEDURE GET_VERSION_DETAILS
731: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
732: X_VERSION_TYPE OUT NOCOPY PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
733: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
734: X_MSG_COUNT OUT NOCOPY NUMBER,
735: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
736:

Line 755: FROM PA_BUDGET_VERSIONS

751: END IF;
752:
753: SELECT VERSION_TYPE
754: INTO X_VERSION_TYPE
755: FROM PA_BUDGET_VERSIONS
756: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
757: --dbms_output.put_line('Version type from get_version_dtls api:'||X_VERSION_TYPE);
758:
759: IF P_PA_DEBUG_MODE = 'Y' THEN

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

811: * Please check body of VALIDATE_SUPPORT_CASES in PAFPGAUB.pls
812: * for list of valid parameter values.
813: **/
814: PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
815: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
816: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

Line 816: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,

812: * for list of valid parameter values.
813: **/
814: PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
815: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
816: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
817: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
818: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
819: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
820: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

Line 825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

821: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
822: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
823: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
828: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
829: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 828: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

824: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
825: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
826: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
827: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
828: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
829: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
830: P_ACTUALS_TO_PERIOD IN VARCHAR2,
831: P_ETC_FROM_PERIOD IN VARCHAR2,
832: P_ETC_TO_PERIOD IN VARCHAR2,

Line 833: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,

829: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
830: P_ACTUALS_TO_PERIOD IN VARCHAR2,
831: P_ETC_FROM_PERIOD IN VARCHAR2,
832: P_ETC_TO_PERIOD IN VARCHAR2,
833: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,
834: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
835: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
836: P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2,
837: X_WARNING_MESSAGE OUT NOCOPY VARCHAR2,

Line 856: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

852: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
853: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
854: l_sysdate DATE;
855:
856: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
857: l_wp_version_id number;
858: l_res_asg_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
859: BEGIN
860: --Setting initial values

Line 899: FROM pa_budget_versions

895: --acquire version lock
896:
897: SELECT record_version_number
898: INTO l_record_version_number
899: FROM pa_budget_versions
900: WHERE budget_version_id = p_budget_version_id;
901: IF p_pa_debug_mode = 'Y' THEN
902: pa_fp_gen_amount_utils.fp_debug
903: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',

Line 1277: UPDATE PA_BUDGET_VERSIONS

1273: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1274: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for all:'||sql%rowcount);
1275: END IF;
1276:
1277: UPDATE PA_BUDGET_VERSIONS
1278: SET ACTUAL_AMTS_THRU_PERIOD = P_ACTUALS_THRU_PERIOD
1279: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
1280:
1281: /* We need to get version details again after validation logic and

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

1465: END UPD_VER_DTLS_AND_GEN_AMT;
1466:
1467:
1468: PROCEDURE VALIDATE_PERIODS
1469: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1470: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1471: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1472: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1473: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 1965: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

1961: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
1962: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1963: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1964: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1965: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1966: P_CALLING_CONTEXT IN VARCHAR2,
1967: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1968: X_MSG_COUNT OUT NOCOPY NUMBER,
1969: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 1972: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;

1968: X_MSG_COUNT OUT NOCOPY NUMBER,
1969: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1970:
1971: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version';
1972: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;
1973: l_msg_count NUMBER;
1974: l_msg_data VARCHAR2(2000);
1975: l_data VARCHAR2(2000);
1976: l_msg_index_out NUMBER:=0;

Line 2016: FROM pa_budget_versions bv

2012: END IF;
2013:
2014: SELECT bv.budget_version_id
2015: INTO l_plan_version_id
2016: FROM pa_budget_versions bv
2017: WHERE bv.project_id = p_project_id
2018: AND bv.fin_plan_type_id = p_plan_type_id
2019: AND bv.version_name = p_plan_version_name
2020: AND bv.version_type in ('COST','ALL');