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_RESOURCE_ASSIGNMENTS

Line 8: p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

4: /* Variable used for setting function security of current user */
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

Line 20: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

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

Line 37: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

33:
34: PROCEDURE PROCESS_MODIFIED_LINES
35: ( --Bug Fix: 4569365. Removed MRC code.
36: p_calling_context IN VARCHAR2 --pa_mrc_finplan.g_calling_module%TYPE DEFAULT NULL
37: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
38: ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE DEFAULT NULL
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

Line 38: ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE DEFAULT NULL

34: PROCEDURE PROCESS_MODIFIED_LINES
35: ( --Bug Fix: 4569365. Removed MRC code.
36: p_calling_context IN VARCHAR2 --pa_mrc_finplan.g_calling_module%TYPE DEFAULT NULL
37: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
38: ,p_fin_plan_version_id IN pa_resource_assignments.budget_version_id%TYPE DEFAULT NULL
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
42:

Line 45: ( p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

41: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
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

Line 108: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE

104: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
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

Line 152: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

148: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
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