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

Line 13: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

9: -----------------------------------------------------------------------
10:
11: PROCEDURE UPD_REV_CALCULATION_ERR
12: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
13: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
14: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_ETC_START_DATE IN DATE,
16: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
17: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 30: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

26: *which was called directly from forecast generation page.
27: **/
28: PROCEDURE GENERATE_FCST_AMT_WRP
29: ( P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
30: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
31: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_CALLED_MODE IN VARCHAR2,
33: P_COMMIT_FLAG IN VARCHAR2,
34: P_INIT_MSG_FLAG IN VARCHAR2,

Line 35: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,

31: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_CALLED_MODE IN VARCHAR2,
33: P_COMMIT_FLAG IN VARCHAR2,
34: P_INIT_MSG_FLAG IN VARCHAR2,
35: P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
36: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
37: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
38: P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
39: P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,

Line 44: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

40: P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
41: P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
42: P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
43: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
44: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
45: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
46: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
47: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
48: P_ACTUALS_FROM_PERIOD IN VARCHAR2,

Line 47: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

43: P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
44: P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
45: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
46: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
47: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
48: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
49: P_ACTUALS_TO_PERIOD IN VARCHAR2,
50: P_ETC_FROM_PERIOD IN VARCHAR2,
51: P_ETC_TO_PERIOD IN VARCHAR2,

Line 52: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,

48: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
49: P_ACTUALS_TO_PERIOD IN VARCHAR2,
50: P_ETC_FROM_PERIOD IN VARCHAR2,
51: P_ETC_TO_PERIOD IN VARCHAR2,
52: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,
53: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
54: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 60: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

56: X_MSG_COUNT OUT NOCOPY NUMBER,
57: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
58:
59: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp';
60: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
61: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
62: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
63: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
64:

Line 77: l_src_version_type pa_budget_versions.version_type%type;

73: l_dummy NUMBER;
74: l_task_count NUMBER;
75:
76: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%type;
77: l_src_version_type pa_budget_versions.version_type%type;
78: lx_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: lx_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
80:
81: -- Bug 4592564: Removed variables for Unspent Amounts option.

Line 166: FROM pa_budget_versions

162: WHERE fin_plan_type_id = P_ETC_PLAN_TYPE_ID;
163:
164: SELECT version_type
165: INTO l_src_version_type
166: FROM pa_budget_versions
167: WHERE budget_version_id = P_ETC_PLAN_VERSION_ID;
168:
169: END IF;
170:

Line 906: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

902: END GENERATE_FCST_AMT_WRP;
903:
904: PROCEDURE GEN_FCST_TASK_LEVEL_AMT
905: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
906: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
908: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
909: P_ETC_FP_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
910: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 1590: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

1586: * a planning transaction within a loop */
1587: continue_loop EXCEPTION;
1588:
1589: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1590: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
1591:
1592: BEGIN
1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1594: X_MSG_COUNT := 0;

Line 4576: pa_budget_versions where budget_version_id = P_BUDGET_VERSION_ID;

4572: P_MSG => 'Before calling PA_FP_CALC_PLAN_PKG.calculate',
4573: P_MODULE_NAME => l_module_name);
4574: END IF;
4575: /* select etc_start_date into l_date from
4576: pa_budget_versions where budget_version_id = P_BUDGET_VERSION_ID;
4577:
4578: hr_utility.trace('==before calculate=== etc start date '||
4579: to_char(l_date,'dd-mon-yyyy') );
4580: hr_utility.trace('==Entering Calculate=================='); */

Line 4693: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

4689: END GEN_FCST_TASK_LEVEL_AMT;
4690:
4691: PROCEDURE MAINTAIN_RES_ASG(
4692: P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4693: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4694: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4695: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4696: X_MSG_COUNT OUT NOCOPY NUMBER,
4697: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 4883: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

4879: * Also worth noting is that this procedure is package-private.
4880: */
4881: PROCEDURE UPD_REV_CALCULATION_ERR
4882: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4883: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4884: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4885: P_ETC_START_DATE IN DATE,
4886: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
4887: X_RETURN_STATUS OUT NOCOPY VARCHAR2,