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

Line 16: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

12: */
13:
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

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 48: l_dummy_pd_name pa_budget_lines.period_name%TYPE; /* webadi */

44: l_number_of_periods pa_proj_period_profiles.number_of_periods%TYPE;
45:
46: l_task_id pa_tasks.task_id%TYPE;
47:
48: l_dummy_pd_name pa_budget_lines.period_name%TYPE; /* webadi */
49:
50: l_msg_count NUMBER := 0;
51: l_data VARCHAR2(2000);
52: l_msg_data VARCHAR2(2000);

Line 263: /* This API first looks into pa_budget_lines to see if PD/SD records for the resource assignment id

259:
260: raise FND_API.G_EXC_UNEXPECTED_ERROR;
261: END POPULATE_LOCAL_VARIABLES;
262:
263: /* This API first looks into pa_budget_lines to see if PD/SD records for the resource assignment id
264: and txn currency code can be found. If found it returns these values (done in
265: PA_FIN_PLAN_UTILS.GET_PECEDING_SUCEEDING_PD_INFO). If these values cannot be found in pa_budget_lines
266: then if context is not view then this API derives the PD/SD dates based upon the business rules.
267: */

Line 265: PA_FIN_PLAN_UTILS.GET_PECEDING_SUCEEDING_PD_INFO). If these values cannot be found in pa_budget_lines

261: END POPULATE_LOCAL_VARIABLES;
262:
263: /* This API first looks into pa_budget_lines to see if PD/SD records for the resource assignment id
264: and txn currency code can be found. If found it returns these values (done in
265: PA_FIN_PLAN_UTILS.GET_PECEDING_SUCEEDING_PD_INFO). If these values cannot be found in pa_budget_lines
266: then if context is not view then this API derives the PD/SD dates based upon the business rules.
267: */
268:
269: PROCEDURE DERIVE_PD_SD_START_END_DATES

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 275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE

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
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

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 278: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --File.Sql.39 bug 4440895

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
282: ,x_return_status OUT NOCOPY VARCHAR2 --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 281: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE /* webadi */ --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
285:

Line 481: /* Derive PD dates when these could not be found in pa_budget_lines. */

477: END IF;
478:
479: END IF;
480:
481: /* Derive PD dates when these could not be found in pa_budget_lines. */
482:
483: IF x_pd_st_dt IS NULL THEN /* i.e. PD record could not be found in budget lines */
484:
485: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 500: UPDATE PA_BUDGET_LINES

496: we are sure there would be no budget lines and hence the following update need not
497: be done */
498:
499: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
500: UPDATE PA_BUDGET_LINES
501: SET BUCKETING_PERIOD_CODE = NULL
502: WHERE TXN_CURRENCY_CODE = p_transaction_currency_code
503: AND RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id
504: AND BUDGET_VERSION_ID = l_budget_version_id

Line 541: /* Derive SD dates when these could not be found in pa_budget_lines. */

537: END IF; /* l_proj_start_prd_start_dt IS NULL OR p_pp_st_dt > l_proj_start_prd_start_dt */
538:
539: END IF; /* IF x_pd_st_dt IS NULL THEN */
540:
541: /* Derive SD dates when these could not be found in pa_budget_lines. */
542:
543: IF x_sd_st_dt IS NULL THEN
544:
545: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 560: UPDATE PA_BUDGET_LINES

556: we are sure there would be no budget lines and hence the following update need not
557: be done */
558:
559: IF p_calling_context <> PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_OTHER_CURR THEN
560: UPDATE PA_BUDGET_LINES
561: SET BUCKETING_PERIOD_CODE = NULL
562: WHERE TXN_CURRENCY_CODE = p_transaction_currency_code
563: AND RESOURCE_ASSIGNMENT_ID = p_resource_assignment_id
564: AND BUDGET_VERSION_ID = l_budget_version_id

Line 658: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

654: END DERIVE_PD_SD_START_END_DATES;
655:
656: PROCEDURE POPULATE_ROLLUP_TMP(
657: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
658: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
659: ,p_calling_context IN VARCHAR2
660: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
661: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
662: ,x_msg_data OUT NOCOPY VARCHAR2 ) --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 1069: pa_budget_lines */

1065: /* Fix for enhancement bug # 2604957 starts */
1066:
1067: /* In the context of view, we need to show only the records that are present in the
1068: budget lines and that from first avaiable period to the last available period in
1069: pa_budget_lines */
1070:
1071: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN
1072:
1073: SELECT MIN(start_date), MAX(start_date)

Line 1075: FROM pa_budget_lines

1071: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_CALLING_CONTEXT_VIEW THEN
1072:
1073: SELECT MIN(start_date), MAX(start_date)
1074: INTO l_min_start_date,l_max_start_date
1075: FROM pa_budget_lines
1076: WHERE budget_version_id = l_fin_plan_version_id
1077: AND resource_assignment_id = p_resource_assignment_id
1078: AND txn_currency_code = p_txn_currency_code
1079: AND start_date >= l_period_profile_start_date

Line 1356: ,pa_budget_lines pbl

1352: ,pbl.QUANTITY_SOURCE
1353: ,pbl.REVENUE_SOURCE
1354: ,pbl.PM_PRODUCT_CODE
1355: FROM pa_resource_assignments pra
1356: ,pa_budget_lines pbl
1357: ,pa_fp_cpy_periods_tmp tmp
1358: WHERE pra.resource_assignment_id = p_resource_assignment_id
1359: AND pbl.resource_assignment_id(+) = p_resource_assignment_id
1360: AND pbl.start_date(+) = tmp.start_date

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 1380: l_end_date pa_budget_lines.end_Date%type;

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
1384: 1. in case time phasing is none and no record exists in budget lines then

Line 1556: ,pa_budget_lines pbl

1552: ,pbl.QUANTITY_SOURCE
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

Line 1682: -- l_budget_line_tmp pa_budget_lines.budget_line_id%TYPE;

1678: -- Bug Fix: 4569365. Removed MRC code.
1679: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
1680: l_calling_context VARCHAR2(30);
1681:
1682: -- l_budget_line_tmp pa_budget_lines.budget_line_id%TYPE;
1683:
1684: l_res_assignment_tbl pa_fp_copy_from_pkg.l_res_assignment_tbl_typ ;
1685:
1686: l_disabled_resource_entered VARCHAR2(10);

Line 1740: pa_budget_lines and also marked for delete by user.

1736: l_calling_context := p_calling_context; /* Bug# 2674353 */
1737:
1738: /*
1739: Delete all such lines from rollup_tmp table that are not existing in
1740: pa_budget_lines and also marked for delete by user.
1741: */
1742: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Deleting records from pa_fp_rollup_tmp that are not present in the budget lines table ';
1743: IF P_PA_DEBUG_MODE = 'Y' THEN
1744: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);

Line 1865: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Deleting from pa_budget_lines table ';

1861:
1862: -- Delete the lines which have delete_flag = 'Y'
1863: -- in the temp table
1864:
1865: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Deleting from pa_budget_lines table ';
1866: IF P_PA_DEBUG_MODE = 'Y' THEN
1867: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1868: END IF;
1869:

Line 1875: DELETE FROM pa_budget_lines bl

1871: A corresponding row from base table can be identified based upon
1872: budget line id now
1873: */
1874: /*
1875: DELETE FROM pa_budget_lines bl
1876: WHERE (bl.resource_assignment_id
1877: ,bl.txn_currency_code
1878: ,bl.start_date ) IN (SELECT tmp.resource_assignment_id
1879: ,tmp.txn_currency_code

Line 1885: DELETE /+ INDEX( bl PA_BUDGET_LINES_U2 )/ FROM pa_budget_lines bl --Bug 2782166

1881: FROM pa_fp_rollup_tmp tmp
1882: WHERE nvl(tmp.delete_flag,'N') = 'Y') ;
1883: */
1884:
1885: DELETE /*+ INDEX( bl PA_BUDGET_LINES_U2 )*/ FROM pa_budget_lines bl --Bug 2782166
1886: WHERE (budget_line_id) IN (SELECT budget_line_id
1887: FROM pa_fp_rollup_tmp tmp
1888: WHERE nvl(tmp.delete_flag,'N') = 'Y');
1889:

Line 1899: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Updating the pa_budget_lines table ';

1895: -- Update the budget line table with the values
1896: -- in the temp table for the records that exist
1897: -- in budget line table
1898:
1899: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Updating the pa_budget_lines table ';
1900: IF P_PA_DEBUG_MODE = 'Y' THEN
1901: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1902: END IF;
1903:

Line 1904: UPDATE /+ INDEX( bl PA_BUDGET_LINES_U2 )/ PA_BUDGET_LINES bl --Bug 2782166

1900: IF P_PA_DEBUG_MODE = 'Y' THEN
1901: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1902: END IF;
1903:
1904: UPDATE /*+ INDEX( bl PA_BUDGET_LINES_U2 )*/ PA_BUDGET_LINES bl --Bug 2782166
1905: SET (
1906: START_DATE
1907: ,END_DATE
1908: ,QUANTITY

Line 2100: INSERT INTO pa_budget_lines

2096: -- insert into budget lines table those
2097: -- records which are present in tmp table
2098: -- but does not exist in budget line table
2099:
2100: INSERT INTO pa_budget_lines
2101: ( RESOURCE_ASSIGNMENT_ID
2102: ,BUDGET_LINE_ID
2103: ,BUDGET_VERSION_ID
2104: ,START_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 2266: /* Bug# 2641475 - MRC call moved here from before the insert/update of pa_budget_lines */

2262: WHERE budget_version_id = l_budget_version_id;
2263: END IF;
2264:
2265: -- Bug Fix: 4569365. Removed MRC code.
2266: /* Bug# 2641475 - MRC call moved here from before the insert/update of pa_budget_lines */
2267:
2268: /* Call MRC API */
2269: /*
2270: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Calling MRC API ';

Line 2390: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

2386: END PROCESS_MODIFIED_LINES;
2387:
2388: PROCEDURE GET_ELEMENT_AMOUNT_INFO
2389: ( p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
2390: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2391: ,p_calling_context IN VARCHAR2
2392: ,x_quantity_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_qty_flag%TYPE --File.Sql.39 bug 4440895
2393: ,x_raw_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.raw_cost_flag%TYPE --File.Sql.39 bug 4440895
2394: ,x_burdened_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.burdened_cost_flag%TYPE --File.Sql.39 bug 4440895

Line 2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895

2401: ,x_burden_multiplier_flag OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE --File.Sql.39 bug 4440895
2402: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
2403: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895

Line 2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895

2402: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
2403: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895

Line 2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895

2403: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2411: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895

Line 2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895

2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2411: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2412: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895

2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2411: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2412: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2413: ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895

2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2411: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2412: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2413: ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2414: ,x_proj_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2411: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895

2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2409: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2410: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2411: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
2412: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2413: ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2414: ,x_proj_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2415: ,x_proj_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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 2752: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

2748: ,p_task_id IN pa_tasks.TASK_ID%TYPE
2749: ,p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE
2750: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
2751: ,p_resource_id IN pa_resources.RESOURCE_ID%TYPE
2752: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
2753: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
2754: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
2755: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
2756: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_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 2918: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE

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
2922: ,x_msg_count OUT NOCOPY NUMBER --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

Line 3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

3218: */
3219:
3220: PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
3221: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3304: FROM pa_budget_lines

3300: x_pd_pfc_revenue,
3301: x_pd_pc_raw_cost,
3302: x_pd_pc_burdened_cost,
3303: x_pd_pc_revenue
3304: FROM pa_budget_lines
3305: WHERE resource_assignment_id = p_resource_assignment_id
3306: AND txn_currency_code = p_txn_currency_code
3307: AND bucketing_period_code in
3308: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_PE);

Line 3332: FROM pa_budget_lines

3328: x_sd_pfc_revenue,
3329: x_sd_pc_raw_cost,
3330: x_sd_pc_burdened_cost,
3331: x_sd_pc_revenue
3332: FROM pa_budget_lines
3333: WHERE resource_assignment_id = p_resource_assignment_id
3334: AND txn_currency_code = p_txn_currency_code
3335: AND bucketing_period_code in
3336: (PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SD,PA_FP_CONSTANTS_PKG.G_BUCKETING_PERIOD_CODE_SE);

Line 3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

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
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895