DBA Data[Home] [Help]

PACKAGE: APPS.IRC_OFFER_NOTIFICATIONS_PKG

Source


1 Package irc_offer_notifications_pkg AUTHID CURRENT_USER as
2 /* $Header: irofrnotif.pkh 120.6.12020000.1 2012/06/27 19:07:01 appldev ship $ */
3 
4 
5 -- ----------------------------------------------------------------------------
6 -- FUNCTIONS
7 -- ----------------------------------------------------------------------------
8 
9 --
10 -- -------------------------------------------------------------------------
11 -- |--------------------< get_view_offer_url >----------------------------|
12 -- -------------------------------------------------------------------------
13 --
14 FUNCTION get_view_offer_url
15   ( p_person_id          number
16    ,p_apl_asg_id         number)
17 RETURN varchar2;
18 --
19 -- -------------------------------------------------------------------------
20 -- |------------------< get_manager_view_offer_url >--------------------|
21 -- -------------------------------------------------------------------------
22 --
23 FUNCTION get_manager_view_offer_url
24   ( p_person_id          number
25    ,p_apl_asg_id         number)
26 RETURN varchar2;
27 --
28 -- -------------------------------------------------------------------------
29 -- |------------------< get_extend_offer_duration_url >--------------------|
30 -- -------------------------------------------------------------------------
31 --
32 FUNCTION get_extend_offer_duration_url
33   ( p_person_id          number
34   , p_offer_id           number)
35 RETURN varchar2;
36 --
37 -- ----------------------------------------------------------------------------
38 --  send_rcvd_wf_notification                                                --
39 --     called internally to send offer received notification :               --
40 --     - retrieve the offer received message.                                --
41 --     - set the VACANCY_NAME & JOB_TITLE token.                             --
42 --     - build the offer details in HTML and TEXT format.                    --
43 -- ----------------------------------------------------------------------------
44 --
45 PROCEDURE send_rcvd_wf_notification(itemtype in varchar2,
46                             itemkey in varchar2,
47                             actid in number,
48                             funcmode in varchar2,
49                             resultout out nocopy varchar2);
50 --
51 --
52 -- ----------------------------------------------------------------------------
53 --  send_expiry_notification                                           --
54 --     called from concurrent process to send offer expiry notification :    --
55 -- ----------------------------------------------------------------------------
56 --
57 PROCEDURE send_expiry_notification
58             (  errbuf    out nocopy varchar2
59              , retcode   out nocopy number
60              , p_number_of_days  in number);
61 --
62 --
63 --
64 -- ----------------------------------------------------------------------------
65 --  send_expired_notification                                          --
66 --     called from concurrent process to send offer expired notification :   --
67 -- ----------------------------------------------------------------------------
68 --
69 PROCEDURE send_expired_notification
70             (  errbuf    out nocopy varchar2
71              , retcode   out nocopy number);
72 --
73 --
74 -- ----------------------------------------------------------------------------
75 --  send_applicant_response                                                  --
76 --     called internally to send offer acceptance notification :             --
77 -- ----------------------------------------------------------------------------
78 --
79 PROCEDURE send_applicant_response(itemtype in varchar2,
80                             itemkey in varchar2,
81                             actid in number,
82                             funcmode in varchar2,
83                             resultout out nocopy varchar2);
84 
85 -- ----------------------------------------------------------------------------
86 --  send_applicant_response                                                  --
87 --     called internally to send notification about applicant response  :    --
88 --     sends the notification to applicant and manager                       --
89 -- ----------------------------------------------------------------------------
90 --
91 PROCEDURE send_onhold_notification(itemtype in varchar2,
92                             itemkey in varchar2,
93                             actid in number,
94                             funcmode in varchar2,
95                             resultout out nocopy varchar2);
96 
97 -- ----------------------------------------------------------------------------
98 --  send_withdrawal_notification                                             --
99 --  called internally to send notification about offer withdrawal  :         --
100 --  sends the notification to applicant and manager/recruiter                --
101 -- ----------------------------------------------------------------------------
102 --
103 PROCEDURE send_withdrawal_notification(itemtype in varchar2,
104                             itemkey in varchar2,
105                             actid in number,
106                             funcmode in varchar2,
107                             resultout out nocopy varchar2);
108 
109 -- ----------------------------------------------------------------------------
110 --  send_dcln_acptd_offer_notif                                             --
111 --  called internally to send notification about the applicant declining     --
112 --  offer after acceptance :
113 --  sends the notification to applicant and manager/recruiter                --
114 -- ----------------------------------------------------------------------------
115 --
116 PROCEDURE send_dcln_acptd_offer_notif(itemtype in varchar2,
117                             itemkey in varchar2,
118                             actid in number,
119                             funcmode in varchar2,
120                             resultout out nocopy varchar2);
121 
122 END irc_offer_notifications_pkg;