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 2966: from pa_projects_all

2962:
2963: -- Bug 3951947 get the PC and PFC of the project
2964: CURSOR get_proj_currency_code (c_project_id IN NUMBER) IS
2965: select projfunc_currency_code, project_currency_code
2966: from pa_projects_all
2967: where project_id = c_project_id;
2968:
2969: CURSOR get_txn_currency_code (p_resource_assignment_id NUMBER) IS
2970: select txn_currency_code

Line 5604: p_project_id IN pa_projects_all.project_id%TYPE,

5600: -----------------------------------------------------------------
5601:
5602: FUNCTION get_baselined_asgmt_dates(
5603:
5604: p_project_id IN pa_projects_all.project_id%TYPE,
5605:
5606: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5607:
5608: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

Line 5612: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

5608: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5609:
5610: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5611:
5612: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5613:
5614: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5615:
5616: p_code IN VARCHAR2) RETURN DATE IS

Line 5614: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

5610: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5611:
5612: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5613:
5614: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5615:
5616: p_code IN VARCHAR2) RETURN DATE IS
5617:
5618:

Line 5787: p_project_id IN pa_projects_all.project_id%TYPE,

5783: -----------------------------------------------------------------
5784:
5785: FUNCTION get_baselined_asgmt_amounts(
5786:
5787: p_project_id IN pa_projects_all.project_id%TYPE,
5788:
5789: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5790:
5791: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

Line 5795: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,

5791: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5792:
5793: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5794:
5795: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5796:
5797: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5798:
5799: p_code IN VARCHAR2) RETURN NUMBER IS

Line 5797: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

5793: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5794:
5795: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5796:
5797: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
5798:
5799: p_code IN VARCHAR2) RETURN NUMBER IS
5800:
5801:

Line 6092: p_project_id IN pa_projects_all.project_id%TYPE,

6088: FUNCTION get_planned_currency_info (
6089:
6090: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
6091:
6092: p_project_id IN pa_projects_all.project_id%TYPE,
6093:
6094: p_code IN VARCHAR2) RETURN VARCHAR2 IS
6095:
6096: -- Bug 9675606

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

6107: WHERE bl.resource_assignment_id = p_resource_assignment_id
6108: AND rownum = 1;
6109: */
6110:
6111: CURSOR get_proj_currency_info (p_project_id IN pa_projects_all.project_id%TYPE) IS
6112: SELECT proj.project_currency_code as txn_currency_code
6113: FROM pa_projects_all proj
6114: WHERE proj.project_id = p_project_id
6115: AND rownum = 1;

Line 6113: FROM pa_projects_all proj

6109: */
6110:
6111: CURSOR get_proj_currency_info (p_project_id IN pa_projects_all.project_id%TYPE) IS
6112: SELECT proj.project_currency_code as txn_currency_code
6113: FROM pa_projects_all proj
6114: WHERE proj.project_id = p_project_id
6115: AND rownum = 1;
6116:
6117: BEGIN

Line 6151: p_project_id IN pa_projects_all.project_id%TYPE,

6147:
6148:
6149: FUNCTION get_task_level_record(
6150:
6151: p_project_id IN pa_projects_all.project_id%TYPE,
6152:
6153: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE
6154:
6155: ) RETURN NUMBER IS

Line 6772: p_project_id IN pa_projects_all.project_id%TYPE

6768:
6769:
6770: -- Bug 4492493
6771: FUNCTION Is_Progress_Rollup_Required(
6772: p_project_id IN pa_projects_all.project_id%TYPE
6773: ) RETURN VARCHAR2 IS
6774:
6775: -- Bug 4492493:
6776: --Need to do progress rollup if ALL of the following are true:

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

6819: -- b)AssignmentUtils.getPLSMissingMsg in java
6820:
6821: FUNCTION is_uncategorized_res_list
6822: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
6823: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
6824: ) RETURN VARCHAR2 IS
6825:
6826: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
6827: IS