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.

[Home] [Help]

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 288: FUNCTION GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 756: FROM PA_BUDGET_VERSIONS

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

Line 824: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;

820: X_MSG_COUNT OUT NOCOPY NUMBER,
821: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
822:
823: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag';
824: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;
825: l_msg_count NUMBER;
826: l_msg_data VARCHAR2(2000);
827: l_data VARCHAR2(2000);
828: l_msg_index_out NUMBER:=0;

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

996: * Please check body of VALIDATE_SUPPORT_CASES in PAFPGAUB.pls
997: * for list of valid parameter values.
998: **/
999: PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
1000: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1001: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,

Line 1001: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,

997: * for list of valid parameter values.
998: **/
999: PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
1000: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1001: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
1002: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1003: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1004: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
1005: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

Line 1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

1006: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
1007: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
1008: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1013: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1014: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 1013: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

1009: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1010: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1011: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
1012: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
1013: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
1014: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1015: P_ACTUALS_TO_PERIOD IN VARCHAR2,
1016: P_ETC_FROM_PERIOD IN VARCHAR2,
1017: P_ETC_TO_PERIOD IN VARCHAR2,

Line 1018: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,

1014: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1015: P_ACTUALS_TO_PERIOD IN VARCHAR2,
1016: P_ETC_FROM_PERIOD IN VARCHAR2,
1017: P_ETC_TO_PERIOD IN VARCHAR2,
1018: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,
1019: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1020: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1021: P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2,
1022: X_WARNING_MESSAGE OUT NOCOPY VARCHAR2,

Line 1041: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

1037: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE;
1038: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE;
1039: l_sysdate DATE;
1040:
1041: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1042: l_wp_version_id number;
1043: l_res_asg_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
1044:
1045: -- gboomina added for AAI requirement 8318932 - start

Line 1108: FROM pa_budget_versions

1104: --acquire version lock
1105:
1106: SELECT record_version_number
1107: INTO l_record_version_number
1108: FROM pa_budget_versions
1109: WHERE budget_version_id = p_budget_version_id;
1110: IF p_pa_debug_mode = 'Y' THEN
1111: pa_fp_gen_amount_utils.fp_debug
1112: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',

Line 1558: UPDATE PA_BUDGET_VERSIONS

1554: WHERE FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID;
1555: --dbms_output.put_line('No. of rows updated in pa_proj_fp_options for all:'||sql%rowcount);
1556: END IF;
1557:
1558: UPDATE PA_BUDGET_VERSIONS
1559: SET ACTUAL_AMTS_THRU_PERIOD = P_ACTUALS_THRU_PERIOD
1560: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
1561:
1562: /* We need to get version details again after validation logic and

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

1746: END UPD_VER_DTLS_AND_GEN_AMT;
1747:
1748:
1749: PROCEDURE VALIDATE_PERIODS
1750: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1751: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1752: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1753: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1754: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 2246: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

2242: PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
2243: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2244: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
2245: PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
2246: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
2247: P_CALLING_CONTEXT IN VARCHAR2,
2248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2249: X_MSG_COUNT OUT NOCOPY NUMBER,
2250: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 2253: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;

2249: X_MSG_COUNT OUT NOCOPY NUMBER,
2250: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2251:
2252: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version';
2253: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;
2254: l_msg_count NUMBER;
2255: l_msg_data VARCHAR2(2000);
2256: l_data VARCHAR2(2000);
2257: l_msg_index_out NUMBER:=0;

Line 2297: FROM pa_budget_versions bv

2293: END IF;
2294:
2295: SELECT bv.budget_version_id
2296: INTO l_plan_version_id
2297: FROM pa_budget_versions bv
2298: WHERE bv.project_id = p_project_id
2299: AND bv.fin_plan_type_id = p_plan_type_id
2300: AND bv.version_name = p_plan_version_name
2301: AND bv.version_type in ('COST','ALL');