DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJECTS_ALL

Line 337: p_project_id IN pa_projects_all.project_id%TYPE,

333:
334: FUNCTION Get_Assignment_Effort RETURN NUMBER ;
335:
336: FUNCTION get_baselined_asgmt_dates(
337: p_project_id IN pa_projects_all.project_id%TYPE,
338: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
339: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
340: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
341: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

Line 341: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

337: p_project_id IN pa_projects_all.project_id%TYPE,
338: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
339: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
340: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
341: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
342: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
343: p_code IN VARCHAR2) RETURN DATE;
344:
345: FUNCTION get_baselined_asgmt_amounts(

Line 342: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

338: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
339: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
340: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
341: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
342: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
343: p_code IN VARCHAR2) RETURN DATE;
344:
345: FUNCTION get_baselined_asgmt_amounts(
346: p_project_id IN pa_projects_all.project_id%TYPE,

Line 346: p_project_id IN pa_projects_all.project_id%TYPE,

342: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
343: p_code IN VARCHAR2) RETURN DATE;
344:
345: FUNCTION get_baselined_asgmt_amounts(
346: p_project_id IN pa_projects_all.project_id%TYPE,
347: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
348: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
349: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
350: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

Line 350: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

346: p_project_id IN pa_projects_all.project_id%TYPE,
347: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
348: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
349: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
350: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
351: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
352: p_code IN VARCHAR2) RETURN NUMBER;
353:
354: /*Commented for bug#6798529

Line 351: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

347: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
348: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
349: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
350: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
351: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
352: p_code IN VARCHAR2) RETURN NUMBER;
353:
354: /*Commented for bug#6798529
355: FUNCTION get_planned_asgmt_amounts(

Line 362: p_project_id IN pa_projects_all.project_id%TYPE,

358: */
359:
360: FUNCTION get_planned_currency_info(
361: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
362: p_project_id IN pa_projects_all.project_id%TYPE,
363: p_code IN VARCHAR2) RETURN VARCHAR2;
364:
365: FUNCTION get_task_level_record(
366: p_project_id IN pa_projects_all.project_id%TYPE,

Line 366: p_project_id IN pa_projects_all.project_id%TYPE,

362: p_project_id IN pa_projects_all.project_id%TYPE,
363: p_code IN VARCHAR2) RETURN VARCHAR2;
364:
365: FUNCTION get_task_level_record(
366: p_project_id IN pa_projects_all.project_id%TYPE,
367: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE
368: ) RETURN NUMBER;
369:
370: --Internal Utiilities to convert char/num/date to NULL or fnd_api.g_miss_xx depending on p_mode of 'F' or 'B'

Line 393: p_project_id IN pa_projects_all.project_id%TYPE

389: , x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
390:
391: -- Bug 4492493
392: FUNCTION Is_Progress_Rollup_Required(
393: p_project_id IN pa_projects_all.project_id%TYPE
394: ) RETURN VARCHAR2;
395:
396: /* Added for bug 6014706*/
397: FUNCTION is_uncategorized_res_list

Line 399: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL

395:
396: /* Added for bug 6014706*/
397: FUNCTION is_uncategorized_res_list
398: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
399: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
400: ) RETURN VARCHAR2;
401: /* End for bug 6014706*/
402:
403: end PA_TASK_ASSIGNMENT_UTILS;