APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_PROJECTS_ALL

Line 1984: * passed from pa_projects_all table.

1980: * Description : To derive the default Org ID
1981: * First it will try to derive it from hr_organization_information
1982: * based on the organization_id.
1983: * If the Org_id is still null then we will get it based on the p_project_id
1984: * passed from pa_projects_all table.
1985: * ******************************************************/
1986: PROCEDURE default_ou(p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)
1987: IS
1988: l_proj_ou NUMBER;

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

1982: * based on the organization_id.
1983: * If the Org_id is still null then we will get it based on the p_project_id
1984: * passed from pa_projects_all table.
1985: * ******************************************************/
1986: PROCEDURE default_ou(p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)
1987: IS
1988: l_proj_ou NUMBER;
1989: BEGIN
1990: UPDATE pa_res_members_temp res_temp

Line 2002: FROM pa_projects_all

1998:
1999: BEGIN
2000: SELECT org_id
2001: INTO l_proj_ou
2002: FROM pa_projects_all
2003: WHERE project_id = p_project_id
2004: AND rownum = 1;
2005:
2006: EXCEPTION WHEN NO_DATA_FOUND THEN

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

2244: * ii. Default from bom resource, id planning resource has one.
2245: * iii. Default from item, if planning resource has one
2246: * If we cannot default organization, we will pass back null.
2247: * ******************************************************/
2248: PROCEDURE Default_Organization (p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE)
2249: IS
2250:
2251: l_organization_id NUMBER := NULL;
2252: BEGIN

Line 2323: FROM pa_projects_all proj,

2319:
2320: BEGIN
2321: SELECT proj.carrying_out_organization_id
2322: INTO l_organization_id
2323: FROM pa_projects_all proj,
2324: pa_all_organizations org
2325: WHERE proj.project_id = p_project_id
2326: AND proj.carrying_out_organization_id = org.organization_id
2327: AND org.inactive_date is null

Line 2429: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

2425: * for incur by resource.
2426: **********************************************************/
2427: PROCEDURE get_resource_defaults (
2428: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
2429: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2430: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
2431: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
2432: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
2433: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 5309: ,P_project_id IN pa_projects_all.project_id%type

5305: --
5306: /*----------------------------------------------------------------------------*/
5307: Procedure Get_Resource_Cost_Rate(
5308: P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5309: ,P_project_id IN pa_projects_all.project_id%type
5310: ,p_structure_type IN VARCHAR2
5311: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
5312: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5313: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 5328: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

5324: --End of variables used for debugging
5325:
5326: l_task_id pa_tasks.task_id%TYPE;
5327: l_top_task_id pa_tasks.task_id%TYPE;
5328: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5329: l_project_type pa_projects_all.project_type%TYPE;
5330: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5331: l_org_id pa_projects_all.org_id%TYPE;
5332: l_expenditure_OU pa_projects_all.org_id%TYPE;

Line 5329: l_project_type pa_projects_all.project_type%TYPE;

5325:
5326: l_task_id pa_tasks.task_id%TYPE;
5327: l_top_task_id pa_tasks.task_id%TYPE;
5328: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5329: l_project_type pa_projects_all.project_type%TYPE;
5330: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5331: l_org_id pa_projects_all.org_id%TYPE;
5332: l_expenditure_OU pa_projects_all.org_id%TYPE;
5333: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

Line 5331: l_org_id pa_projects_all.org_id%TYPE;

5327: l_top_task_id pa_tasks.task_id%TYPE;
5328: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5329: l_project_type pa_projects_all.project_type%TYPE;
5330: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5331: l_org_id pa_projects_all.org_id%TYPE;
5332: l_expenditure_OU pa_projects_all.org_id%TYPE;
5333: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
5334: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
5335: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;

Line 5332: l_expenditure_OU pa_projects_all.org_id%TYPE;

5328: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
5329: l_project_type pa_projects_all.project_type%TYPE;
5330: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
5331: l_org_id pa_projects_all.org_id%TYPE;
5332: l_expenditure_OU pa_projects_all.org_id%TYPE;
5333: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
5334: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;
5335: -- l_burden_override_multiplier pa_fp_res_assignments_tmp.b_multiplier_override%TYPE;
5336: l_burden_override_multiplier Number;

Line 5388: FROM pa_projects_all

5384: -- Bug 7457385
5385: CURSOR cur_proj_is_template(c_project_id NUMBER)
5386: IS
5387: SELECT 'Y'
5388: FROM pa_projects_all
5389: WHERE project_id = c_project_id
5390: AND template_flag = 'Y';
5391:
5392: l_template_flag VARCHAR2(1);