[Home] [Help]
88: AND (a.assignment_type = 'E' OR a.assignment_type = 'C')
89: AND a.primary_flag = 'Y'
90: AND trunc(ex.expenditure_ending_date)
91: BETWEEN a.effective_start_date AND
92: pa_utils.GetWeekEnding(a.effective_end_date);
93:
94: RETURN Job_ID;
95: END Get_Job_ID;
96:
507: CLOSE get_proj_id;
508: End if;
509: -- if the work type profile is installed
510: -- get the assignment details and work type details for the given project and tasks
511: IF PA_UTILS4.is_exp_work_type_enabled = 'Y' then
512: PA_UTILS4.get_work_assignment
513: (p_person_id => R_Person_Id
514: ,p_project_id => x_project_id
515: ,p_task_id => temp_task
508: End if;
509: -- if the work type profile is installed
510: -- get the assignment details and work type details for the given project and tasks
511: IF PA_UTILS4.is_exp_work_type_enabled = 'Y' then
512: PA_UTILS4.get_work_assignment
513: (p_person_id => R_Person_Id
514: ,p_project_id => x_project_id
515: ,p_task_id => temp_task
516: ,p_ei_date => R_Expenditure_End_Date
663: , X_project_currency_code => OProjCurrCode
664: , X_project_rate_date => NULL
665: , X_project_rate_type => NULL
666: , X_project_exchange_rate => NULL
667: , X_recv_operating_unit => PA_UTILS2.GetPrjOrgId(NULL,temp_task)
668: /** added EPP and project currency changes **/
669: , p_assignment_id => x_assignment_id
670: , p_work_type_id => NULL /* Changed for labor costing enhancements */
671: , p_projfunc_currency_code => x_projfunc_currency_code
875:
876: -- Added by Sandeep Bharathan. We noticed that
877: -- org_id was not populated while inserting exp items.
878:
879: if pa_utils.pa_morg_implemented = 'Y' then
880: FND_PROFILE.GET ('ORG_ID', G_Org_Id);
881: end if;
882:
883: -- End