PACKAGE: APPS.IRC_NOTIFICATION_DATA_PKG

Source

1 PACKAGE IRC_NOTIFICATION_DATA_PKG as
2   /* $Header: irntfdat.pkh 120.5.12010000.1 2008/07/28 12:48:25 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) return number;
20 --+
21 --+
22 --+
23   function getCandidateAgencyId(p_candidateId    in number
24                                 ,p_effectiveDate in date) return varchar2;
25 --+
26 --+ getManagerId
27 --+
28   function getManagerPersonId ( p_vacancyId     in number
29                               , p_effectiveDate in date) return number;
30 --+
31 --+ getRecruiterId
32 --+
33   function getRecruiterPersonId ( p_assignmentId     in number
34                                 , p_effectiveDate in date) return number;
35 --+
36 --+ getVacancyDetails
37 --+
38   function getVacancyDetails ( p_vacancyId     in number
39                              , p_effectiveDate in date) return varchar2;
40 --+
41 --+ getCommunicationTopicDetails
42 --+
43   function getCommunicationTopicDetails ( p_topicId   in number
44                                          , p_messageId in number) return varchar2;
45 --+
46 --+ getInterviewDetails
47 --+
48   function getInterviewDetails ( p_interviewId   in number
49                                , p_effectiveDate in date) return varchar2;
50 --+
51 --+ getPersonDetails
52 --+
53   function getPersonDetails ( p_personId      in number
54                             , p_role          in varchar2
55                             , p_effectiveDate in date) return varchar2;
56 --+
57 --+ getApplicationStatus
58 --+
59   function getApplicationStatus( p_assignmentStatusCode in number ) return varchar2;
60 --+
61 --+getInterviewStatusMeaning
62 --+
63   function getInterviewStatusMeaning (p_interviewStatusCode in varchar2
64                                      ,p_attributeName       in varchar2) return varchar2;
65 --+
66 --+
67 --+
68   function getInterviersNamesHTML( p_interviewId  in number
69                                 , p_effectiveDate in date)
70            return varchar2;
71 --+
72 end IRC_NOTIFICATION_DATA_PKG;