eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_OFFER_CUSTOM dependencies on PER_ASSIGNMENTS_F

Line 110: (p_candidate_assignment_id in per_assignments_f.assignment_id%type

106: -- This procedure retuns the Person Id, Applicant Number and Display Name
107: -- (as first_name||last_name) of the Candidate.
108: --
109: procedure get_candidate_details
110: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
111: ,p_candidate_person_id out nocopy per_people_f.person_id%type
112: ,p_candidate_disp_name out nocopy varchar2
113: ,p_applicant_number out nocopy per_people_f.applicant_number%type) is
114: --

Line 400: (p_candidate_assignment_id in per_assignments_f.assignment_id%type

396: -- if we need to look for the next approver or if the offer is ready to be sent
397: -- to HR for printing/mailing.
398: --
399: function check_final_approver
400: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
401: ,p_fwd_to_mgr_id in per_people_f.person_id%type
402: ,p_person_id in per_people_f.person_id%type)
403: return varchar2 is
404: --

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

447: -- data in update mode. It is used on the web pages.
448: --
449: function check_if_in_approval_chain
450: (p_person_id in per_people_f.person_id%type
451: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type)
452: return boolean is
453: --
454: --1754123 begin
455: --the creator may not be the hiring manager if the

Line 513: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type

509: -- generating the offer letter.
510: --
511: procedure get_signatories_details
512: (p_person_id in per_people_f.person_id%type
513: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
514: ,p_signatory_id1 out nocopy per_people_f.person_id%type
515: ,p_position_title1 out nocopy varchar2
516: ,p_signatory_id2 out nocopy per_people_f.person_id%type
517: ,p_position_title2 out nocopy varchar2

Line 631: per_assignments_f.assignment_id%type

627: -- Private to this package.
628: -- ----------------------------------------------------------------------------
629: procedure set_apl_status
630: (p_candidate_assignment_id in
631: per_assignments_f.assignment_id%type
632: ,p_status_type_id in
633: per_assignments_f.assignment_status_type_id%type default null) is
634: --
635: -- define the pl/sql table types to be used

Line 633: per_assignments_f.assignment_status_type_id%type default null) is

629: procedure set_apl_status
630: (p_candidate_assignment_id in
631: per_assignments_f.assignment_id%type
632: ,p_status_type_id in
633: per_assignments_f.assignment_status_type_id%type default null) is
634: --
635: -- define the pl/sql table types to be used
636: --
637: type l_ed_tab_type is table of date

Line 639: type l_ovn_tab_type is table of per_assignments_f.object_version_number%type

635: -- define the pl/sql table types to be used
636: --
637: type l_ed_tab_type is table of date
638: index by binary_integer;
639: type l_ovn_tab_type is table of per_assignments_f.object_version_number%type
640: index by binary_integer;
641: -- define the local variables to be used
642: l_esd_tab l_ed_tab_type; -- effective start date table
643: l_eed_tab l_ed_tab_type; -- effective end date table

Line 655: l_object_version_number per_assignments_f.object_version_number%type;

651: l_update_override boolean;
652: l_update_change_insert boolean;
653: l_datetrack_update_mode varchar2(30);
654: l_effective_date date := trunc(sysdate);
655: l_object_version_number per_assignments_f.object_version_number%type;
656: l_effective_start_date per_assignments_f.effective_start_date%type;
657: l_effective_end_date per_assignments_f.effective_end_date%type;
658: --
659: cursor csr_paf is

Line 656: l_effective_start_date per_assignments_f.effective_start_date%type;

652: l_update_change_insert boolean;
653: l_datetrack_update_mode varchar2(30);
654: l_effective_date date := trunc(sysdate);
655: l_object_version_number per_assignments_f.object_version_number%type;
656: l_effective_start_date per_assignments_f.effective_start_date%type;
657: l_effective_end_date per_assignments_f.effective_end_date%type;
658: --
659: cursor csr_paf is
660: select paf.effective_start_date

Line 657: l_effective_end_date per_assignments_f.effective_end_date%type;

653: l_datetrack_update_mode varchar2(30);
654: l_effective_date date := trunc(sysdate);
655: l_object_version_number per_assignments_f.object_version_number%type;
656: l_effective_start_date per_assignments_f.effective_start_date%type;
657: l_effective_end_date per_assignments_f.effective_end_date%type;
658: --
659: cursor csr_paf is
660: select paf.effective_start_date
661: ,paf.effective_end_date

Line 798: (p_candidate_assignment_id in per_assignments_f.assignment_id%type) is

794: -- workflow, 'Offer Letter'.
795: --
796: --
797: procedure set_status_to_offer
798: (p_candidate_assignment_id in per_assignments_f.assignment_id%type) is
799: begin
800: -- set applicant to default OFFER status
801: set_apl_status(p_candidate_assignment_id => p_candidate_assignment_id);
802: end set_status_to_offer;

Line 812: (p_candidate_assignment_id in per_assignments_f.assignment_id%type) is

808: -- the offer is mailed to the candidate. It is used in the Web Offer workflow,
809: -- 'Offer Letter'.
810: --
811: procedure set_status_to_sent
812: (p_candidate_assignment_id in per_assignments_f.assignment_id%type) is
813: begin
814: -- [CUSTOMIZE]
815: -- set applicant OFFER SENT status, this status must be set up in
816: -- per_assignment_status_types. As delivered, we have no 'sent'