DBA Data[Home] [Help]

APPS.HR_OFFER_CUSTOM dependencies on PER_ASSIGNMENTS_F

Line 155: (p_candidate_assignment_id in per_assignments_f.assignment_id%type

151: -- Called from workflow.
152: --
153: -- ----------------------------------------------------------------------------
154: procedure get_candidate_details
155: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
156: ,p_candidate_person_id out nocopy per_people_f.person_id%type
157: ,p_candidate_disp_name out nocopy varchar2
158: ,p_applicant_number out nocopy per_people_f.applicant_number%type);
159: -- ----------------------------------------------------------------------------

Line 354: (p_candidate_assignment_id in per_assignments_f.assignment_id%type

350: -- Called from workflow.
351: --
352: -- ----------------------------------------------------------------------------
353: function check_final_approver
354: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
355: ,p_fwd_to_mgr_id in per_people_f.person_id%type
356: ,p_person_id in per_people_f.person_id%type)
357: return varchar2;
358: -- ----------------------------------------------------------------------------

Line 389: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type)

385: --
386: -- ----------------------------------------------------------------------------
387: function check_if_in_approval_chain
388: (p_person_id in per_people_f.person_id%type
389: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type)
390: return boolean;
391: -- ----------------------------------------------------------------------------
392: -- |--------------------------< get_signatories_details >---------------------|
393: -- ----------------------------------------------------------------------------

Line 422: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type

418: --
419: -- ----------------------------------------------------------------------------
420: procedure get_signatories_details
421: (p_person_id in per_people_f.person_id%type
422: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
423: ,p_signatory_id1 out nocopy per_people_f.person_id%type
424: ,p_position_title1 out nocopy varchar2
425: ,p_signatory_id2 out nocopy per_people_f.person_id%type
426: ,p_position_title2 out nocopy varchar2

Line 459: (p_candidate_assignment_id in per_assignments_f.assignment_id%type);

455: -- Called from workflow.
456: --
457: -- ----------------------------------------------------------------------------
458: procedure set_status_to_offer
459: (p_candidate_assignment_id in per_assignments_f.assignment_id%type);
460: -- ----------------------------------------------------------------------------
461: -- |--------------------------< set_status_to_sent >--------------------------|
462: -- ----------------------------------------------------------------------------
463: --

Line 489: (p_candidate_assignment_id in per_assignments_f.assignment_id%type);

485: -- Called from workflow.
486: --
487: -- ----------------------------------------------------------------------------
488: procedure set_status_to_sent
489: (p_candidate_assignment_id in per_assignments_f.assignment_id%type);
490: --
491: -- ----------------------------------------------------------------------------
492: -- |--------------------------< insert_attachment >----------------------------|
493: -- ----------------------------------------------------------------------------