PACKAGE: APPS.IRC_NOTIFICATION_DATA_PKG

Source

1 PACKAGE IRC_NOTIFICATION_DATA_PKG AUTHID CURRENT_USER as
2   /* $Header: irntfdat.pkh 120.8.12020000.1 2012/06/27 19:06:53 appldev ship $ */
3 --+ Global variables
4   g_package    constant varchar2(50) := 'IRC_NOTIFICATION_DATA_PKG';
5 --+
6 --+ getParamValue
7 --+
8   function getParamValue ( p_param     in varchar2
9                          , p_eventData in varchar2) return varchar2;
10 --+
11 --+
12 --+
13   function getVacancyId ( p_assignmentId  in number
14                         , p_effectiveDate in date) return number;
15 --+
16 --+ getCandidatePersonId
17 --+
18   function getCandidatePersonId ( p_assignmentId      in number
19                                 , p_effectiveDate in date
20                                 , p_event_name        in  varchar2 default null) return number;
21 --+
22 --+
23 --+
24   function getCandidateAgencyId(p_candidateId    in number
25                                 ,p_effectiveDate in date) return varchar2;
26 --+
27 --+ getManagerId
28 --+
29   function getManagerPersonId ( p_vacancyId     in number
30                               , p_effectiveDate in date) return number;
31 --+
32 --+ getRecruiterId
33 --+
34   function getRecruiterPersonId ( p_assignmentId     in number
35                                 , p_effectiveDate in date) return number;
36 --+
37 --+ getVacancyDetails
38 --+
39   function getVacancyDetails ( p_vacancyId     in number
40                              , p_effectiveDate in date) return varchar2;
41 --+
42 --+ getCommunicationTopicDetails
43 --+
44   function getCommunicationTopicDetails ( p_topicId   in number
45                                          , p_messageId in number) return varchar2;
46 --+
47 --+ getInterviewDetails
48 --+
49   function getInterviewDetails ( p_interviewId   in number
50                                , p_effectiveDate in date) return varchar2;
51 --+
52 --+ getPersonDetails
53 --+
54   function getPersonDetails ( p_personId      in number
55                             , p_role          in varchar2
56                             , p_effectiveDate in date) return varchar2;
57 --+
58 --+ getApplicationExtStatus
59 --+
60   function getApplicationExtStatus ( p_assignmentStatusCode in number) return varchar2;
61 --+
62 --+
63 --+
64 --+ getApplicationExtStatus
65 --+
66   function getApplicationOldExtStatus ( p_AssignmentOldStatusCode in number) return varchar2;
67 --+
68 --+ getApplicationStatus
69 --+
70   function getApplicationStatus( p_assignmentStatusCode in number ) return varchar2;
71 --+
72 --+getInterviewStatusMeaning
73 --+
74   function getInterviewStatusMeaning (p_interviewStatusCode in varchar2
75                                      ,p_attributeName       in varchar2) return varchar2;
76 --+
77 --+
78 --+
79   function getInterviersNamesHTML( p_interviewId  in number
80                                 , p_effectiveDate in date)
81            return varchar2;
82 --+
83 end IRC_NOTIFICATION_DATA_PKG;