APPS.HR_PERSON_DEPLOYMENT_API dependencies on HR_PERSON_DEPLOYMENTS

Line 862: l_object_version_number hr_person_deployments.object_version_number%type;

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

Line 972: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS';

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

Line 978: from hr_person_deployments dpl

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

Line 985: from hr_person_deployments pdt1

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

Line 988: from hr_person_deployments pdt2

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

Line 2087: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS' ;

2083:
2084: update fnd_attached_documents
2085: set ENTITY_NAME='PER_PEOPLE_F' ,PK1_VALUE =l_host_person_id
2086: WHERE PK1_VALUE=p_person_deployment_id
2087: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS' ;
2088:
2089: else
2090: hr_utility.set_location(l_host_person_id,220);
2091: close csr_get_attached_doc;

Line 2191: from hr_person_deployments dpl

2187: := hr_dflex_utility.l_ignore_dfcode_varray();
2188:
2189: cursor csr_person_deployment(p_person_deployment_id number) is
2190: select *
2191: from hr_person_deployments dpl
2192: where dpl.person_deployment_id = p_person_deployment_id;
2193: --
2194: l_dpl_rec csr_person_deployment%rowtype;
2195: --

Line 2216: hr_person_deployments pdt,

2212: --
2213: cursor csr_host_assignments(p_start_date date) is
2214: select asg.assignment_id,asg.object_version_number,asg.effective_start_date
2215: from per_all_assignments_f asg,
2216: hr_person_deployments pdt,
2217: per_periods_of_service pds
2218: where asg.person_id = pdt.to_person_id
2219: and pdt.person_deployment_id = p_person_deployment_id
2220: and asg.period_of_service_id = pds.period_of_service_id

Line 2523: from hr_person_deployments dpl

2519: l_dod_warning boolean;
2520: --
2521: cursor csr_person_deployment(p_person_deployment_id number) is
2522: select *
2523: from hr_person_deployments dpl
2524: where dpl.person_deployment_id = p_person_deployment_id;
2525: --
2526: l_dpl_rec csr_person_deployment%rowtype;
2527: --