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

Line 25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895

21: ,x_succeeding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
22: ,x_period_profile_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_period_profile_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

Line 26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

22: ,x_period_profile_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_period_profile_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

Line 27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895

23: ,x_period_profile_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

Line 294: l_time_phased_code PA_PROJ_FP_OPTIONS.all_time_phased_code%TYPE;

290: l_dummy_pd_name VARCHAR2(30);
291:
292: l_project_id PA_PROJECTS_ALL.project_id%TYPE;
293: l_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
294: l_time_phased_code PA_PROJ_FP_OPTIONS.all_time_phased_code%TYPE;
295: l_project_start_date DATE;
296: l_project_end_date DATE;
297: l_proj_start_prd_start_dt DATE;
298: l_proj_end_prd_end_dt DATE;

Line 684: FROM pa_proj_fp_options pfo

680: ,pfo.PROJFUNC_REV_RATE_TYPE
681: ,decode(pfo.PROJFUNC_REV_RATE_TYPE,'User',pftc.PROJFUNC_REV_EXCHANGE_RATE,null) PROJFUNC_REV_EXCHANGE_RATE
682: ,pfo.PROJFUNC_REV_RATE_DATE_TYPE
683: ,pfo.PROJFUNC_REV_RATE_DATE
684: FROM pa_proj_fp_options pfo
685: ,pa_fp_txn_currencies pftc
686: WHERE pfo.proj_fp_options_id = pftc.proj_fp_options_id(+)
687: AND pfo.fin_plan_version_id = p_fin_plan_version_id
688: AND pftc.txn_currency_code(+) = p_txn_currency_code;

Line 697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

693: l_succeeding_prd_end_date pa_budget_lines.start_date%TYPE;
694: l_period_profile_start_date pa_budget_lines.start_date%TYPE;
695: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
696: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;

Line 698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;

694: l_period_profile_start_date pa_budget_lines.start_date%TYPE;
695: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
696: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;
702: l_task_start_date pa_projects_all.start_date%TYPE;

Line 699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

695: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
696: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;
702: l_task_start_date pa_projects_all.start_date%TYPE;
703: l_task_end_date pa_projects_all.start_date%TYPE;

Line 1557: ,pa_proj_fp_options pfo

1553: ,pbl.REVENUE_SOURCE
1554: ,pbl.PM_PRODUCT_CODE
1555: FROM pa_resource_assignments pra
1556: ,pa_budget_lines pbl
1557: ,pa_proj_fp_options pfo
1558: -- ,pa_fp_txn_currencies pftc -- Bug # 2615998
1559: WHERE pra.resource_assignment_id = p_resource_assignment_id
1560: AND pbl.txn_currency_code = p_txn_currency_code
1561: AND pbl.resource_assignment_id = pra.resource_assignment_id

Line 2457: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

2453: l_succeeding_prd_start_date pa_budget_lines.start_date%TYPE;
2454: l_succeeding_prd_end_date pa_budget_lines.start_date%TYPE;
2455: l_period_profile_start_date pa_budget_lines.start_date%TYPE;
2456: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
2457: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;
2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;

Line 2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;

2454: l_succeeding_prd_end_date pa_budget_lines.start_date%TYPE;
2455: l_period_profile_start_date pa_budget_lines.start_date%TYPE;
2456: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
2457: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;
2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;
2462: l_task_start_date pa_projects_all.start_date%TYPE;

Line 2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;

2455: l_period_profile_start_date pa_budget_lines.start_date%TYPE;
2456: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
2457: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;
2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;
2462: l_task_start_date pa_projects_all.start_date%TYPE;
2463: l_task_end_date pa_projects_all.start_date%TYPE;

Line 2468: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2467: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2468: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2469: l_dummy_project_id pa_projects_all.project_id%TYPE;
2470:
2471: BEGIN
2472: -- Set the error stack.

Line 2595: FROM pa_proj_fp_options

2591: BEGIN
2592:
2593: SELECT margin_derived_from_code
2594: INTO l_margin_derived_from_code
2595: FROM pa_proj_fp_options
2596: WHERE fin_plan_version_id = l_fin_plan_version_id;
2597: EXCEPTION
2598: WHEN NO_DATA_FOUND THEN
2599: NULL;

Line 2916: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913: END CALL_CLIENT_EXTENSIONS;
2914:
2915: PROCEDURE POPULATE_ELIGIBLE_PERIODS
2916: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
2917: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE
2918: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE
2919: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE
2920: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE

Line 2931: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2927: l_data VARCHAR2(160) ;
2928: l_msg_data VARCHAR2(160) ;
2929: l_msg_index_out NUMBER;
2930: l_debug_mode VARCHAR2(30);
2931: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2932:
2933: BEGIN
2934: -- Set the error stack.
2935: pa_debug.set_err_stack('PA_FP_EDIT_LINE_PKG.POPULATE_ELIGIBLE_PERIODS');

Line 3401: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

3397: RAISE;
3398: END GET_PD_SD_AMT_IN_PC_PFC;
3399:
3400: PROCEDURE GET_PRECEDING_SUCCEEDING_AMT(
3401: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
3402: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3420: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

3416:
3417:
3418: IS
3419:
3420: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3421:
3422: CURSOR period_denorm_cur IS
3423: SELECT amount_type_code
3424: ,amount_subtype_code

Line 3453: FROM pa_proj_fp_options pfo

3449: END IF;
3450:
3451: SELECT fin_plan_preference_code
3452: INTO l_fin_plan_preference_code
3453: FROM pa_proj_fp_options pfo
3454: ,pa_resource_assignments pra
3455: WHERE pra.resource_assignment_id = p_resource_assignment_id
3456: AND pra.budget_version_id = pfo.fin_plan_version_id;
3457:

Line 3544: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

3540: l_msg_data VARCHAR2(160) ;
3541: l_msg_index_out NUMBER;
3542:
3543: l_expected_error BOOLEAN ;
3544: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3545:
3546: BEGIN
3547: x_msg_count := 0;
3548: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3588: FROM pa_proj_fp_options

3584: END IF;
3585:
3586: SELECT fin_plan_preference_code
3587: INTO l_fp_preference_code
3588: FROM pa_proj_fp_options
3589: WHERE fin_plan_version_id = p_budget_version_id;
3590:
3591: IF l_debug_mode = 'Y' THEN
3592: pa_debug.g_err_stage := 'after getting preference code l_fp_preference_code = ' || l_fp_preference_code;