1: PACKAGE PA_FP_FCST_GEN_AMT_UTILS as
2: /* $Header: PAFPGFUS.pls 120.3 2007/02/06 09:59:37 dthakker noship $ */
3: PROCEDURE COMPARE_ETC_SRC_TARGET_FP_OPT
4: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: P_WP_SRC_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: P_FP_SRC_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7: P_FP_TARGET_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: X_SAME_PLANNING_OPTION_FLAG OUT NOCOPY VARCHAR2,
9: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2: /* $Header: PAFPGFUS.pls 120.3 2007/02/06 09:59:37 dthakker noship $ */
3: PROCEDURE COMPARE_ETC_SRC_TARGET_FP_OPT
4: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: P_WP_SRC_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: P_FP_SRC_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7: P_FP_TARGET_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: X_SAME_PLANNING_OPTION_FLAG OUT NOCOPY VARCHAR2,
9: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
10: X_MSG_COUNT OUT NOCOPY NUMBER,
3: PROCEDURE COMPARE_ETC_SRC_TARGET_FP_OPT
4: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5: P_WP_SRC_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6: P_FP_SRC_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7: P_FP_TARGET_PLAN_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: X_SAME_PLANNING_OPTION_FLAG OUT NOCOPY VARCHAR2,
9: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
10: X_MSG_COUNT OUT NOCOPY NUMBER,
11: X_MSG_DATA OUT NOCOPY VARCHAR2);