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

Line 2851: from pa_projects_all

2847:
2848: -- Bug 3951947 get the PC and PFC of the project
2849: CURSOR get_proj_currency_code (c_project_id IN NUMBER) IS
2850: select projfunc_currency_code, project_currency_code
2851: from pa_projects_all
2852: where project_id = c_project_id;
2853:
2854: CURSOR get_txn_currency_code (p_resource_assignment_id NUMBER) IS
2855: select txn_currency_code

Line 5488: p_project_id IN pa_projects_all.project_id%TYPE,

5484: -----------------------------------------------------------------
5485:
5486: FUNCTION get_baselined_asgmt_dates(
5487:
5488: p_project_id IN pa_projects_all.project_id%TYPE,
5489:
5490: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5491:
5492: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

Line 5496: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

5492: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5493:
5494: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5495:
5496: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5497:
5498: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5499:
5500: p_code IN VARCHAR2) RETURN DATE IS

Line 5498: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

5494: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5495:
5496: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5497:
5498: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5499:
5500: p_code IN VARCHAR2) RETURN DATE IS
5501:
5502:

Line 5671: p_project_id IN pa_projects_all.project_id%TYPE,

5667: -----------------------------------------------------------------
5668:
5669: FUNCTION get_baselined_asgmt_amounts(
5670:
5671: p_project_id IN pa_projects_all.project_id%TYPE,
5672:
5673: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5674:
5675: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

Line 5679: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

5675: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5676:
5677: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5678:
5679: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5680:
5681: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5682:
5683: p_code IN VARCHAR2) RETURN NUMBER IS

Line 5681: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

5677: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5678:
5679: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5680:
5681: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5682:
5683: p_code IN VARCHAR2) RETURN NUMBER IS
5684:
5685:

Line 5976: p_project_id IN pa_projects_all.project_id%TYPE,

5972: FUNCTION get_planned_currency_info (
5973:
5974: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5975:
5976: p_project_id IN pa_projects_all.project_id%TYPE,
5977:
5978: p_code IN VARCHAR2) RETURN VARCHAR2 IS
5979:
5980: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS

Line 5986: CURSOR get_proj_currency_info (p_project_id IN pa_projects_all.project_id%TYPE) IS

5982: FROM pa_budget_lines bl
5983: WHERE bl.resource_assignment_id = p_resource_assignment_id
5984: AND rownum = 1;
5985:
5986: CURSOR get_proj_currency_info (p_project_id IN pa_projects_all.project_id%TYPE) IS
5987: SELECT proj.project_currency_code as txn_currency_code
5988: FROM pa_projects_all proj
5989: WHERE proj.project_id = p_project_id
5990: AND rownum = 1;

Line 5988: FROM pa_projects_all proj

5984: AND rownum = 1;
5985:
5986: CURSOR get_proj_currency_info (p_project_id IN pa_projects_all.project_id%TYPE) IS
5987: SELECT proj.project_currency_code as txn_currency_code
5988: FROM pa_projects_all proj
5989: WHERE proj.project_id = p_project_id
5990: AND rownum = 1;
5991:
5992: BEGIN

Line 6026: p_project_id IN pa_projects_all.project_id%TYPE,

6022:
6023:
6024: FUNCTION get_task_level_record(
6025:
6026: p_project_id IN pa_projects_all.project_id%TYPE,
6027:
6028: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE
6029:
6030: ) RETURN NUMBER IS

Line 6647: p_project_id IN pa_projects_all.project_id%TYPE

6643:
6644:
6645: -- Bug 4492493
6646: FUNCTION Is_Progress_Rollup_Required(
6647: p_project_id IN pa_projects_all.project_id%TYPE
6648: ) RETURN VARCHAR2 IS
6649:
6650: -- Bug 4492493:
6651: --Need to do progress rollup if ALL of the following are true:

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

6694: -- b)AssignmentUtils.getPLSMissingMsg in java
6695:
6696: FUNCTION is_uncategorized_res_list
6697: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
6698: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
6699: ) RETURN VARCHAR2 IS
6700:
6701: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
6702: IS