APPS.HR_PERSON_DEPLOYMENT_API dependencies on HR_PERSON_DEPLOYMENTS

Line 861: l_object_version_number hr_person_deployments.object_version_number%type;

857: --
858: -- Declare cursors and local variables
859: --
860: l_proc varchar2(72) := g_package||'initiate_deployment';
861: l_object_version_number hr_person_deployments.object_version_number%type;
862: --
863: -- Key data from per and asg
864: l_host_employee_number per_all_people_f.employee_number%type;
865: l_host_applicant_number per_all_people_f.applicant_number%type;

Line 970: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS';

966: cursor csr_get_attached_doc is
967: select null
968: from fnd_attached_documents
969: where PK1_VALUE =p_person_deployment_id
970: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS';
971: --
972: -- fix for bug 6593649
973: --
974: cursor csr_person_deployment(p_person_deployment_id number) is

Line 976: from hr_person_deployments dpl

972: -- fix for bug 6593649
973: --
974: cursor csr_person_deployment(p_person_deployment_id number) is
975: select *
976: from hr_person_deployments dpl
977: where dpl.person_deployment_id = p_person_deployment_id;
978: --
979: l_dpl_rec csr_person_deployment%rowtype;
980: --

Line 983: from hr_person_deployments pdt1

979: l_dpl_rec csr_person_deployment%rowtype;
980: --
981: cursor csr_other_active_dpl(p_person_deployment_id number) is
982: select 1
983: from hr_person_deployments pdt1
984: where pdt1.person_deployment_id = p_person_deployment_id
985: and exists (select 1
986: from hr_person_deployments pdt2
987: where pdt2.person_deployment_id <> pdt1.person_deployment_id

Line 986: from hr_person_deployments pdt2

982: select 1
983: from hr_person_deployments pdt1
984: where pdt1.person_deployment_id = p_person_deployment_id
985: and exists (select 1
986: from hr_person_deployments pdt2
987: where pdt2.person_deployment_id <> pdt1.person_deployment_id
988: and pdt2.from_person_id = pdt1.from_person_id
989: and pdt2.status in ('ACTIVE','COMPLETE')
990: and pdt1.start_date <= nvl(pdt2.end_date,hr_api.g_eot));

Line 2062: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS' ;

2058:
2059: update fnd_attached_documents
2060: set ENTITY_NAME='PER_PEOPLE_F' ,PK1_VALUE =l_host_person_id
2061: WHERE PK1_VALUE=p_person_deployment_id
2062: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS' ;
2063:
2064: else
2065: hr_utility.set_location(l_host_person_id,220);
2066: close csr_get_attached_doc;

Line 2166: from hr_person_deployments dpl

2162: := hr_dflex_utility.l_ignore_dfcode_varray();
2163:
2164: cursor csr_person_deployment(p_person_deployment_id number) is
2165: select *
2166: from hr_person_deployments dpl
2167: where dpl.person_deployment_id = p_person_deployment_id;
2168: --
2169: l_dpl_rec csr_person_deployment%rowtype;
2170: --

Line 2191: hr_person_deployments pdt,

2187: --
2188: cursor csr_host_assignments(p_start_date date) is
2189: select asg.assignment_id,asg.object_version_number,asg.effective_start_date
2190: from per_all_assignments_f asg,
2191: hr_person_deployments pdt,
2192: per_periods_of_service pds
2193: where asg.person_id = pdt.to_person_id
2194: and pdt.person_deployment_id = p_person_deployment_id
2195: and asg.period_of_service_id = pds.period_of_service_id

Line 2498: from hr_person_deployments dpl

2494: l_dod_warning boolean;
2495: --
2496: cursor csr_person_deployment(p_person_deployment_id number) is
2497: select *
2498: from hr_person_deployments dpl
2499: where dpl.person_deployment_id = p_person_deployment_id;
2500: --
2501: l_dpl_rec csr_person_deployment%rowtype;
2502: --