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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 6: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

2: /* $Header: PAFPWPGB.pls 120.17.12020000.2 2013/05/23 07:44:33 bpottipa ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE GENERATE_WP_BUDGET_AMT
6: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
9: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
10: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 9: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,

5: PROCEDURE GENERATE_WP_BUDGET_AMT
6: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
9: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
10: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
11: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
13: P_CALLED_MODE IN VARCHAR2,

Line 10: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

6: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
9: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
10: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
11: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
13: P_CALLED_MODE IN VARCHAR2,
14: P_INC_CHG_DOC_FLAG IN VARCHAR2,

Line 21: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,

17: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
18: P_INIT_MSG_FLAG IN VARCHAR2,
19: P_COMMIT_FLAG IN VARCHAR2,
20: P_CALLING_CONTEXT IN VARCHAR2,
21: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
22: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
23: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
24: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
25: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 22: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,

18: P_INIT_MSG_FLAG IN VARCHAR2,
19: P_COMMIT_FLAG IN VARCHAR2,
20: P_CALLING_CONTEXT IN VARCHAR2,
21: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
22: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
23: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
24: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
25: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
26: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 43: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE

39: l_gen_src_plan_ver_code VARCHAR2(100);
40: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
41:
42: /* Source Code constants */
43: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
44: := 'WORKPLAN_RESOURCES';
45: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
46: := 'FINANCIAL_PLAN';
47:

Line 45: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE

41:
42: /* Source Code constants */
43: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
44: := 'WORKPLAN_RESOURCES';
45: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
46: := 'FINANCIAL_PLAN';
47:
48: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
49: l_gen_src_plan_ver_cod VARCHAR2(100);

Line 48: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

44: := 'WORKPLAN_RESOURCES';
45: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
46: := 'FINANCIAL_PLAN';
47:
48: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
49: l_gen_src_plan_ver_cod VARCHAR2(100);
50: l_msg_count NUMBER;
51: l_msg_data VARCHAR2(2000);
52: l_data VARCHAR2(2000);

Line 253: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS

249: * data with starting date after the forecast's actuals through period. */
250: CURSOR fcst_budget_line_src_to_cal
251: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
252: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
253: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
254: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
255: ra.resource_assignment_id,
256: ra.rate_based_flag,
257: decode(l_txn_currency_flag,

Line 324: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS

320: -- please see the other cursor.
321: CURSOR fcst_bdgt_line_src_to_cal_none
322: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
323: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
324: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
325: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
326: ra.resource_assignment_id,
327: ra.rate_based_flag,
328: decode(l_txn_currency_flag,

Line 674: * Now, we need to update back to pa_proj_fp_options*/

670:
671: l_version_type := l_fp_cols_rec_target.x_version_type;
672: /*As of now, we have the l_wp_id as wp struct version id
673: * l_source_id as wp fin version id
674: * Now, we need to update back to pa_proj_fp_options*/
675: IF l_version_type = 'COST' THEN
676: UPDATE PA_PROJ_FP_OPTIONS
677: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
678: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;

Line 676: UPDATE PA_PROJ_FP_OPTIONS

672: /*As of now, we have the l_wp_id as wp struct version id
673: * l_source_id as wp fin version id
674: * Now, we need to update back to pa_proj_fp_options*/
675: IF l_version_type = 'COST' THEN
676: UPDATE PA_PROJ_FP_OPTIONS
677: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
678: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
679: ELSIF l_version_type = 'ALL' THEN
680: UPDATE PA_PROJ_FP_OPTIONS

Line 680: UPDATE PA_PROJ_FP_OPTIONS

676: UPDATE PA_PROJ_FP_OPTIONS
677: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
678: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
679: ELSIF l_version_type = 'ALL' THEN
680: UPDATE PA_PROJ_FP_OPTIONS
681: SET GEN_SRC_ALL_WP_VERSION_ID = l_source_id
682: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
683: ELSIF l_version_type = 'REVENUE' THEN
684: UPDATE PA_PROJ_FP_OPTIONS

Line 684: UPDATE PA_PROJ_FP_OPTIONS

680: UPDATE PA_PROJ_FP_OPTIONS
681: SET GEN_SRC_ALL_WP_VERSION_ID = l_source_id
682: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
683: ELSIF l_version_type = 'REVENUE' THEN
684: UPDATE PA_PROJ_FP_OPTIONS
685: SET GEN_SRC_REV_WP_VERSION_ID = l_source_id
686: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
687: END IF;
688:

Line 777: * Now, we need to update back to pa_proj_fp_options*/

773: --dbms_output.put_line('==l_source_id:'||l_source_id);
774:
775: l_version_type := l_fp_cols_rec_target.x_version_type;
776: /*As of now, we have l_source_id as fin version id
777: * Now, we need to update back to pa_proj_fp_options*/
778: IF l_version_type = 'COST' THEN
779: UPDATE PA_PROJ_FP_OPTIONS
780: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
781: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;

Line 779: UPDATE PA_PROJ_FP_OPTIONS

775: l_version_type := l_fp_cols_rec_target.x_version_type;
776: /*As of now, we have l_source_id as fin version id
777: * Now, we need to update back to pa_proj_fp_options*/
778: IF l_version_type = 'COST' THEN
779: UPDATE PA_PROJ_FP_OPTIONS
780: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
781: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
782: ELSIF l_version_type = 'ALL' THEN
783: UPDATE PA_PROJ_FP_OPTIONS

Line 783: UPDATE PA_PROJ_FP_OPTIONS

779: UPDATE PA_PROJ_FP_OPTIONS
780: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
781: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
782: ELSIF l_version_type = 'ALL' THEN
783: UPDATE PA_PROJ_FP_OPTIONS
784: SET GEN_SRC_ALL_PLAN_VERSION_ID = l_source_id
785: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
786: ELSIF l_version_type = 'REVENUE' THEN
787: UPDATE PA_PROJ_FP_OPTIONS

Line 787: UPDATE PA_PROJ_FP_OPTIONS

783: UPDATE PA_PROJ_FP_OPTIONS
784: SET GEN_SRC_ALL_PLAN_VERSION_ID = l_source_id
785: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
786: ELSIF l_version_type = 'REVENUE' THEN
787: UPDATE PA_PROJ_FP_OPTIONS
788: SET GEN_SRC_REV_PLAN_VERSION_ID = l_source_id
789: WHERE fin_plan_version_id = P_BUDGET_VERSION_ID;
790: END IF;
791: END IF; -- end gen_src_code-based logic

Line 2764: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

2760: END GENERATE_WP_BUDGET_AMT;
2761:
2762:
2763: PROCEDURE MAINTAIN_BUDGET_LINES
2764: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2765: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2766: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2767: P_CALLING_CONTEXT IN VARCHAR2,
2768: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 2782: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE

2778: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';
2779: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
2780:
2781: /* Source Code constants */
2782: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
2783: := 'WORKPLAN_RESOURCES';
2784: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
2785: := 'FINANCIAL_PLAN';
2786:

Line 2784: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE

2780:
2781: /* Source Code constants */
2782: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
2783: := 'WORKPLAN_RESOURCES';
2784: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
2785: := 'FINANCIAL_PLAN';
2786:
2787: /* Local copy of the Calling Context that will be checked instead of p_calling_context */
2788: l_calling_context VARCHAR2(30);

Line 3027: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS

3023: * data with starting date after the forecast's actuals through period. */
3024: CURSOR fcst_budget_line_src_tgt
3025: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3026: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3027: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3028: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3029: ra.resource_assignment_id,
3030: ra.rate_based_flag,
3031: sbl.start_date,

Line 3124: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS

3120:
3121: CURSOR fcst_budget_line_src_tgt_none
3122: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3123: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3124: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3125: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3126: ra.resource_assignment_id,
3127: ra.rate_based_flag,
3128: sbl.start_date,

Line 3271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

3267: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3268: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3269:
3270: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3272: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3273: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3274: l_same_planning_options_flag VARCHAR2(1);
3275:

Line 5682: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE

5678: /* Time-phase determines if budget lines have been populated by generation code */
5679: l_same_time_phase_flag VARCHAR2(1);
5680:
5681: /* Source Code constants */
5682: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
5683: := 'WORKPLAN_RESOURCES';
5684: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
5685: := 'FINANCIAL_PLAN';
5686:

Line 5684: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE

5680:
5681: /* Source Code constants */
5682: lc_WorkPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
5683: := 'WORKPLAN_RESOURCES';
5684: lc_FinancialPlanSrcCode CONSTANT PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE
5685: := 'FINANCIAL_PLAN';
5686:
5687: /* String constants for valid Calling Context values */
5688: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';

Line 5691: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

5687: /* String constants for valid Calling Context values */
5688: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';
5689: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
5690:
5691: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
5692: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5693: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5694: l_rev_gen_method VARCHAR2(1);
5695: