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

5: G_IS_FN_SECURITY_AVAILABLE varchar2(1);
6:
7: PROCEDURE POPULATE_ROLLUP_TMP(
8: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
9: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
10: ,p_calling_context IN VARCHAR2
11: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

Line 17: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE

13: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
14:
15: PROCEDURE DERIVE_PD_SD_START_END_DATES
16: (p_calling_context IN VARCHAR2
17: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
18: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
19: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE

Line 18: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE

14:
15: PROCEDURE DERIVE_PD_SD_START_END_DATES
16: (p_calling_context IN VARCHAR2
17: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
18: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
19: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

Line 21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE

17: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
18: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
19: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

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

18: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
19: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

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

19: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
27: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895

Line 24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895

20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
27: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
28: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

21: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
27: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
28: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

22: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
27: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
28: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
30: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 27: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895

23: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
24: ,x_pd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
25: ,x_sd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
26: ,x_sd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
27: ,x_sd_period_name OUT NOCOPY pa_budget_lines.period_name%TYPE --File.Sql.39 bug 4440895
28: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
30: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
31:

Line 46: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

42:
43:
44: PROCEDURE GET_ELEMENT_AMOUNT_INFO
45: ( p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
46: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
47: ,p_calling_context IN VARCHAR2
48: ,x_quantity_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_qty_flag%TYPE --File.Sql.39 bug 4440895
49: ,x_raw_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.raw_cost_flag%TYPE --File.Sql.39 bug 4440895
50: ,x_burdened_cost_flag OUT NOCOPY pa_fin_plan_amount_sets.burdened_cost_flag%TYPE --File.Sql.39 bug 4440895

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

57: ,x_burden_multiplier_flag OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE --File.Sql.39 bug 4440895
58: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
59: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
60: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
61: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895

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

58: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
59: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
60: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
61: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895

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

59: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
60: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
61: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
67: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895

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

60: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
61: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
67: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
68: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

61: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
67: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
68: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
69: ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
67: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
68: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
69: ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70: ,x_proj_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
64: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
65: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
66: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
67: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895
68: ,x_projfunc_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
69: ,x_projfunc_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70: ,x_proj_margin OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
71: ,x_proj_margin_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 83: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

79: ,p_task_id IN pa_tasks.TASK_ID%TYPE
80: ,p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE
81: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
82: ,p_resource_id IN pa_resources.RESOURCE_ID%TYPE
83: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
84: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
85: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
86: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
87: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 98: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE

94: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
95:
96: PROCEDURE POPULATE_ELIGIBLE_PERIODS
97: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
98: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE
99: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE
100: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE
101: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 99: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE

95:
96: PROCEDURE POPULATE_ELIGIBLE_PERIODS
97: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
98: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE
99: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE
100: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE
101: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 100: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE

96: PROCEDURE POPULATE_ELIGIBLE_PERIODS
97: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
98: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE
99: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE
100: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE
101: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
104: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

Line 101: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE

97: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
98: ,p_period_profile_start_date IN pa_budget_lines.start_date%TYPE
99: ,p_period_profile_end_date IN pa_budget_lines.end_date%TYPE
100: ,p_preceding_prd_start_date IN pa_budget_lines.start_Date%TYPE
101: ,p_succeeding_prd_start_date IN pa_budget_lines.start_Date%TYPE
102: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
104: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
105:

Line 109: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

105:
106: PROCEDURE GET_PRECEDING_SUCCEEDING_AMT(
107: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE -- Added for #2839138
108: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
109: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
110: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
111: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 153: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

149: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
150:
151: PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
152: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
153: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
154: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
155: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895