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_PLANNING_ELEMENT_UTILS dependencies on PA_PROJECTS_ALL

Line 70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,

66:
67: PROCEDURE get_common_budget_version_info
68: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
69: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
73: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
74: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

Line 71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

67: PROCEDURE get_common_budget_version_info
68: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
69: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
73: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
74: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
75: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,

107:
108: PROCEDURE get_common_bv_info_fcst
109: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
110: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
114: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
115: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),

Line 112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

108: PROCEDURE get_common_bv_info_fcst
109: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
110: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
114: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
115: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
116: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 238: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,

234: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2;
235:
236: --Created for bug 3546208. This function will return the financial structure version id for the project
237: --id passed.
238: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,
239: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)
240: RETURN NUMBER;
241:
242: -- This function returns the wbs element name, either from the wbs_element_version_id

Line 246: (p_project_id IN pa_projects_all.project_id%TYPE,

242: -- This function returns the wbs element name, either from the wbs_element_version_id
243: -- or from the proj_element_id. If using proj_element_id, then p_use_element_version_id_flag
244: -- must be set to 'N'
245: FUNCTION get_wbs_element_name_from_id
246: (p_project_id IN pa_projects_all.project_id%TYPE,
247: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
248: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
249: p_use_element_version_flag IN VARCHAR2) return VARCHAR2;
250:

Line 258: (p_project_id IN pa_projects_all.project_id%TYPE,

254: FUNCTION get_rbs_element_name_from_id
255: (p_rbs_element_version_id IN pa_rbs_elements.rbs_element_id%TYPE) return VARCHAR2;
256:
257: FUNCTION get_task_percent_complete
258: (p_project_id IN pa_projects_all.project_id%TYPE,
259: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
260: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
261: p_calling_context IN VARCHAR2) return NUMBER;
262:

Line 268: p_project_id IN pa_projects_all.project_id%TYPE

264: * to be used by PJI.
265: */
266: FUNCTION get_prior_forecast_version_id
267: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,
268: p_project_id IN pa_projects_all.project_id%TYPE
269: ) RETURN NUMBER;
270:
271: end pa_planning_element_utils;