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_BUDGET_LINES_S

Line 18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

14: PROCEDURE POPULATE_LOCAL_VARIABLES(
15: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
16: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
17: ,p_calling_context IN VARCHAR2
18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%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

Line 19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

15: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
16: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
17: ,p_calling_context IN VARCHAR2
18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%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

Line 20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

16: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
17: ,p_calling_context IN VARCHAR2
18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%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

Line 21: ,x_succeeding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

17: ,p_calling_context IN VARCHAR2
18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%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

Line 22: ,x_period_profile_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

18: ,x_preceding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%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

Line 23: ,x_period_profile_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

19: ,x_preceding_prd_end_date OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
20: ,x_succeeding_prd_start_date OUT NOCOPY pa_budget_lines.start_date%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

Line 271: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE

267: */
268:
269: PROCEDURE DERIVE_PD_SD_START_END_DATES
270: (p_calling_context IN VARCHAR2
271: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
272: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE

Line 272: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE

268:
269: PROCEDURE DERIVE_PD_SD_START_END_DATES
270: (p_calling_context IN VARCHAR2
271: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
272: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

Line 276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

272: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
278: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895
279: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
280: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

Line 277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
278: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895
279: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
280: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
281: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895

Line 279: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
278: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895
279: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
280: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
281: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895
282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 280: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
278: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895
279: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
280: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
281: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895
282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
284: ,x_msg_data OUT NOCOPY VARCHAR2) AS --File.Sql.39 bug 4440895

Line 690: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;

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;
689:
690: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;
692: l_succeeding_prd_start_date pa_budget_lines.start_date%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;

Line 691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;

687: AND pfo.fin_plan_version_id = p_fin_plan_version_id
688: AND pftc.txn_currency_code(+) = p_txn_currency_code;
689:
690: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;
692: l_succeeding_prd_start_date pa_budget_lines.start_date%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;

Line 692: l_succeeding_prd_start_date pa_budget_lines.start_date%TYPE;

688: AND pftc.txn_currency_code(+) = p_txn_currency_code;
689:
690: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;
692: l_succeeding_prd_start_date pa_budget_lines.start_date%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;

Line 693: l_succeeding_prd_end_date pa_budget_lines.start_date%TYPE;

689:
690: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;
692: l_succeeding_prd_start_date pa_budget_lines.start_date%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;

Line 694: l_period_profile_start_date pa_budget_lines.start_date%TYPE;

690: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;
692: l_succeeding_prd_start_date pa_budget_lines.start_date%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;

Line 695: l_period_profile_end_date pa_budget_lines.start_date%TYPE;

691: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;
692: l_succeeding_prd_start_date pa_budget_lines.start_date%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;

Line 749: l_min_start_date pa_budget_lines.start_date%TYPE;

745: l_count NUMBER;
746: mc_cur_rec MC_CUR%ROWTYPE;
747:
748: /* Added for enhancement # 2604957 */
749: l_min_start_date pa_budget_lines.start_date%TYPE;
750: l_max_start_date pa_budget_lines.start_date%TYPE;
751:
752: /* Added for enhancement # 2593167 */
753: l_proj_start_prd_start_dt pa_budget_lines.start_date%TYPE;

Line 750: l_max_start_date pa_budget_lines.start_date%TYPE;

746: mc_cur_rec MC_CUR%ROWTYPE;
747:
748: /* Added for enhancement # 2604957 */
749: l_min_start_date pa_budget_lines.start_date%TYPE;
750: l_max_start_date pa_budget_lines.start_date%TYPE;
751:
752: /* Added for enhancement # 2593167 */
753: l_proj_start_prd_start_dt pa_budget_lines.start_date%TYPE;
754: l_proj_end_prd_end_dt pa_budget_lines.start_date%TYPE;

Line 753: l_proj_start_prd_start_dt pa_budget_lines.start_date%TYPE;

749: l_min_start_date pa_budget_lines.start_date%TYPE;
750: l_max_start_date pa_budget_lines.start_date%TYPE;
751:
752: /* Added for enhancement # 2593167 */
753: l_proj_start_prd_start_dt pa_budget_lines.start_date%TYPE;
754: l_proj_end_prd_end_dt pa_budget_lines.start_date%TYPE;
755:
756: PROCEDURE insert_dummy_record_pvt (mc_rec IN mc_cur_rec%TYPE)
757: IS

Line 754: l_proj_end_prd_end_dt pa_budget_lines.start_date%TYPE;

750: l_max_start_date pa_budget_lines.start_date%TYPE;
751:
752: /* Added for enhancement # 2593167 */
753: l_proj_start_prd_start_dt pa_budget_lines.start_date%TYPE;
754: l_proj_end_prd_end_dt pa_budget_lines.start_date%TYPE;
755:
756: PROCEDURE insert_dummy_record_pvt (mc_rec IN mc_cur_rec%TYPE)
757: IS
758: BEGIN

Line 1379: l_start_date pa_budget_lines.start_Date%type;

1375: END IF;
1376: /* bvarnasi added case for timephasing NONE */
1377:
1378: DECLARE
1379: l_start_date pa_budget_lines.start_Date%type;
1380: l_end_date pa_budget_lines.end_Date%type;
1381: BEGIN
1382:
1383: /* following is the logic of getting start date and end date

Line 2168: ,pa_budget_lines_s.nextval

2164: ,PM_PRODUCT_CODE
2165: ,PM_BUDGET_LINE_REFERENCE ) -- Added for bug 3858543
2166: (SELECT
2167: RESOURCE_ASSIGNMENT_ID
2168: ,pa_budget_lines_s.nextval
2169: ,l_budget_version_id
2170: ,START_DATE
2171: ,SYSDATE
2172: ,FND_GLOBAL.USER_ID

Line 2451: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;

2447: -- l_plan_period_type VARCHAR2(30) := null;
2448: -- l_number_of_periods NUMBER ;
2449:
2450:
2451: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
2452: l_preceding_prd_end_date pa_budget_lines.start_date%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;

Line 2452: l_preceding_prd_end_date pa_budget_lines.start_date%TYPE;

2448: -- l_number_of_periods NUMBER ;
2449:
2450:
2451: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
2452: l_preceding_prd_end_date pa_budget_lines.start_date%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;

Line 2453: l_succeeding_prd_start_date pa_budget_lines.start_date%TYPE;

2449:
2450:
2451: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
2452: l_preceding_prd_end_date pa_budget_lines.start_date%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 ;

Line 2454: l_succeeding_prd_end_date pa_budget_lines.start_date%TYPE;

2450:
2451: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
2452: l_preceding_prd_end_date pa_budget_lines.start_date%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 ;

Line 2455: l_period_profile_start_date pa_budget_lines.start_date%TYPE;

2451: l_preceding_prd_start_date pa_budget_lines.start_date%TYPE;
2452: l_preceding_prd_end_date pa_budget_lines.start_date%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 ;

Line 2456: l_period_profile_end_date pa_budget_lines.start_date%TYPE;

2452: l_preceding_prd_end_date pa_budget_lines.start_date%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 ;

Line 2917: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE

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
2921: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2919: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE

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
2921: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2922: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2923: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 2920: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE

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
2921: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2922: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2923: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2924: IS