APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 236: l_resource_code pa_resource_assignments.res_type_code%TYPE := NULL;

232: *******************************************************************/
233: FUNCTION Get_resource_Code(p_resource_assignment_id IN NUMBER) return VARCHAR2
234: IS
235: -- Decl of local variables
236: l_resource_code pa_resource_assignments.res_type_code%TYPE := NULL;
237: BEGIN
238: /* The purpose of this function is to return the resource code for a given resource assignment.*/
239: IF p_resource_assignment_id IS NOT NULL THEN
240: Select DECODE(incurred_by_res_flag, 'Y','',

Line 252: FROM pa_resource_assignments

248: 'BOM_EQUIPMENT',to_char(bom_resource_id),
249: 'INVENTORY_ITEM',to_char(inventory_item_id),
250: 'ITEM_CATEGORY',to_char(item_category_id)))
251: INTO l_resource_code
252: FROM pa_resource_assignments
253: WHERE resource_assignment_id = p_resource_assignment_id;
254:
255: Return l_resource_code;
256: ELSE

Line 287: FROM pa_resource_assignments

283: nvl(to_char(person_id),nvl(to_char(job_id), nvl(person_type_code,
284: nvl(to_char(incur_by_role_id),
285: nvl(incur_by_res_class_code, NULL))))))
286: INTO l_incur_by_res_code
287: FROM pa_resource_assignments
288: WHERE resource_assignment_id = p_resource_assignment_id;
289:
290: Return l_incur_by_res_code;
291: ELSE

Line 313: l_fin_category_code pa_resource_assignments.FC_RES_TYPE_CODE%TYPE := NULL;

309: *******************************************************************/
310: FUNCTION Get_Fin_Category_Code(p_resource_assignment_id IN NUMBER) return
311: VARCHAR2
312: IS
313: l_fin_category_code pa_resource_assignments.FC_RES_TYPE_CODE%TYPE := NULL;
314: BEGIN
315: IF p_resource_assignment_id IS NOT NULL THEN
316: SELECT DECODE(fc_res_type_code,
317: 'EXPENDITURE_TYPE',expenditure_type,

Line 322: FROM pa_resource_assignments

318: 'EXPENDITURE_CATEGORY',expenditure_category,
319: 'EVENT_TYPE',event_type,
320: 'REVENUE_CATEGORY',revenue_category_code)
321: INTO l_fin_category_code
322: FROM pa_resource_assignments
323: WHERE resource_assignment_id = p_resource_assignment_id;
324:
325: Return l_fin_category_code;
326: ELSE

Line 3072: Pa_Resource_Assignments a

3068: a.Non_Labor_Resource Non_Labor_Resource,
3069: a.incurred_by_res_flag incurred_by_res_flag,
3070: c.Resource_Class_Id
3071: From
3072: Pa_Resource_Assignments a
3073: ,Pa_Resource_Classes_b c
3074: Where
3075: c.Resource_Class_Code = a.Resource_Class_Code
3076: And a.Resource_Assignment_Id = P_Res_Assignment_Id;

Line 3588: Pa_Resource_Assignments

3584: Expenditure_Category,
3585: Event_Type,
3586: Revenue_Category_Code
3587: From
3588: Pa_Resource_Assignments
3589: Where
3590: Resource_Assignment_Id = P_Res_Assignment_Id;
3591:
3592: l_Res_Attributes c_Res_Attributes%RowType;

Line 4321: Pa_Resource_Assignments

4317: Incur_By_Role_Id,
4318: Person_Type_Code,
4319: Incur_By_Res_Class_Code
4320: From
4321: Pa_Resource_Assignments
4322: Where
4323: Resource_Assignment_Id = P_Res_Assignment_Id;
4324:
4325: l_Res_Attributes c_Res_Attributes%RowType;

Line 4331: Pa_Resource_Assignments

4327: Cursor Get_Inc_By_Flag Is
4328: Select
4329: Incurred_By_Res_Flag
4330: From
4331: Pa_Resource_Assignments
4332: Where
4333: Resource_Assignment_Id = P_Res_Assignment_Id;
4334:
4335: l_Person_Id Number;

Line 5330: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;

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;
5334: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;

Line 5341: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;

5337: l_cost_override_rate pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
5338: l_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
5339: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
5340: l_burden_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
5341: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
5342: l_mfc_cost_source CONSTANT NUMBER := 2;
5343:
5344: --Out variables
5345: l_txn_raw_cost number;