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

Line 1944: * passed from pa_projects_all table.

1940: * Description : To derive the default Org ID
1941: * First it will try to derive it from hr_organization_information
1942: * based on the organization_id.
1943: * If the Org_id is still null then we will get it based on the p_project_id
1944: * passed from pa_projects_all table.
1945: * ******************************************************/
1946: PROCEDURE default_ou(p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)
1947: IS
1948: l_proj_ou NUMBER;

Line 1946: PROCEDURE default_ou(p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)

1942: * based on the organization_id.
1943: * If the Org_id is still null then we will get it based on the p_project_id
1944: * passed from pa_projects_all table.
1945: * ******************************************************/
1946: PROCEDURE default_ou(p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)
1947: IS
1948: l_proj_ou NUMBER;
1949: BEGIN
1950: UPDATE pa_res_members_temp res_temp

Line 1962: FROM pa_projects_all

1958:
1959: BEGIN
1960: SELECT org_id
1961: INTO l_proj_ou
1962: FROM pa_projects_all
1963: WHERE project_id = p_project_id
1964: AND rownum = 1;
1965:
1966: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2208: PROCEDURE Default_Organization (p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)

2204: * ii. Default from bom resource, id planning resource has one.
2205: * iii. Default from item, if planning resource has one
2206: * If we cannot default organization, we will pass back null.
2207: * ******************************************************/
2208: PROCEDURE Default_Organization (p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)
2209: IS
2210:
2211: l_organization_id NUMBER := NULL;
2212: BEGIN

Line 2283: FROM pa_projects_all proj,

2279:
2280: BEGIN
2281: SELECT proj.carrying_out_organization_id
2282: INTO l_organization_id
2283: FROM pa_projects_all proj,
2284: pa_all_organizations org
2285: WHERE proj.project_id = p_project_id
2286: AND proj.carrying_out_organization_id = org.organization_id
2287: AND org.inactive_date is null

Line 2388: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

2384: * for incur by resource.
2385: **********************************************************/
2386: PROCEDURE get_resource_defaults (
2387: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
2388: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2389: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2390: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2391: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2392: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 5249: ,P_project_id IN pa_projects_all.project_id%type

5245: --
5246: /*----------------------------------------------------------------------------*/
5247: Procedure Get_Resource_Cost_Rate(
5248: P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5249: ,P_project_id IN pa_projects_all.project_id%type
5250: ,p_structure_type IN VARCHAR2
5251: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5252: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5253: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 5268: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

5264: --End of variables used for debugging
5265:
5266: l_task_id pa_tasks.task_id%TYPE;
5267: l_top_task_id pa_tasks.task_id%TYPE;
5268: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5269: l_project_type pa_projects_all.project_type%TYPE;
5270: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5271: l_org_id pa_projects_all.org_id%TYPE;
5272: l_expenditure_OU pa_projects_all.org_id%TYPE;

Line 5269: l_project_type pa_projects_all.project_type%TYPE;

5265:
5266: l_task_id pa_tasks.task_id%TYPE;
5267: l_top_task_id pa_tasks.task_id%TYPE;
5268: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5269: l_project_type pa_projects_all.project_type%TYPE;
5270: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5271: l_org_id pa_projects_all.org_id%TYPE;
5272: l_expenditure_OU pa_projects_all.org_id%TYPE;
5273: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

Line 5271: l_org_id pa_projects_all.org_id%TYPE;

5267: l_top_task_id pa_tasks.task_id%TYPE;
5268: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5269: l_project_type pa_projects_all.project_type%TYPE;
5270: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5271: l_org_id pa_projects_all.org_id%TYPE;
5272: l_expenditure_OU pa_projects_all.org_id%TYPE;
5273: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
5274: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
5275: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;

Line 5272: l_expenditure_OU pa_projects_all.org_id%TYPE;

5268: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5269: l_project_type pa_projects_all.project_type%TYPE;
5270: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5271: l_org_id pa_projects_all.org_id%TYPE;
5272: l_expenditure_OU pa_projects_all.org_id%TYPE;
5273: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
5274: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
5275: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;
5276: l_burden_override_multiplier Number;