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.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on IRC_NOTIFICATION_DATA_PKG

Line 65: l_assignmentId := IRC_NOTIFICATION_DATA_PKG.getParamValue

61: l_proc constant varchar2(50) := 'launchNotificationsWorkflow';
62: begin
63: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
64: l_eventData := p_event.event_data;
65: l_assignmentId := IRC_NOTIFICATION_DATA_PKG.getParamValue
66: ( p_param => 'IRC_ASSIGNMENT_ID'
67: , p_eventData => l_eventData);
68: hr_utility.set_location('Assignment Id : ' || l_assignmentId, 20);
69: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue

Line 69: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue

65: l_assignmentId := IRC_NOTIFICATION_DATA_PKG.getParamValue
66: ( p_param => 'IRC_ASSIGNMENT_ID'
67: , p_eventData => l_eventData);
68: hr_utility.set_location('Assignment Id : ' || l_assignmentId, 20);
69: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue
70: ( p_param => 'IRC_EVENT_NAME'
71: , p_eventData => l_eventData);
72: hr_utility.set_location('Event Name : ' || l_eventName, 30);
73: l_effectiveDate := to_date( IRC_NOTIFICATION_DATA_PKG.getParamValue

Line 73: l_effectiveDate := to_date( IRC_NOTIFICATION_DATA_PKG.getParamValue

69: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue
70: ( p_param => 'IRC_EVENT_NAME'
71: , p_eventData => l_eventData);
72: hr_utility.set_location('Event Name : ' || l_eventName, 30);
73: l_effectiveDate := to_date( IRC_NOTIFICATION_DATA_PKG.getParamValue
74: ( p_param => 'IRC_EFFECTIVE_DATE'
75: , p_eventData => l_eventData)
76: , 'DD-MM-RRRR');
77: if l_effectiveDate is null then

Line 81: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getParamValue

77: if l_effectiveDate is null then
78: l_effectiveDate := sysdate;
79: end if;
80: hr_utility.set_location('Effective Date : ' || l_effectiveDate, 40);
81: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getParamValue
82: ( p_param => 'IRC_VACANCY_ID'
83: , p_eventData => l_eventData);
84: if l_vacancyId is null then
85: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getVacancyId

Line 85: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getVacancyId

81: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getParamValue
82: ( p_param => 'IRC_VACANCY_ID'
83: , p_eventData => l_eventData);
84: if l_vacancyId is null then
85: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getVacancyId
86: ( p_assignmentId => l_assignmentId
87: , p_effectiveDate => l_effectiveDate);
88: l_eventData := l_eventData
89: || 'IRC_VACANCY_ID:'

Line 96: || IRC_NOTIFICATION_DATA_PKG.getVacancyDetails

92: end if;
93: hr_utility.set_location('Vacancy Id : ' || l_vacancyId, 50);
94: if l_vacancyId is not null then
95: l_eventData := l_eventData
96: || IRC_NOTIFICATION_DATA_PKG.getVacancyDetails
97: ( p_vacancyId => l_vacancyId
98: , p_effectiveDate => l_effectiveDate);
99: end if;
100: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getParamValue

Line 100: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getParamValue

96: || IRC_NOTIFICATION_DATA_PKG.getVacancyDetails
97: ( p_vacancyId => l_vacancyId
98: , p_effectiveDate => l_effectiveDate);
99: end if;
100: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getParamValue
101: ( p_param => 'IRC_CAND_PER_ID'
102: , p_eventData => l_eventData);
103: if l_candidateId is null then
104: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getCandidatePersonId

Line 104: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getCandidatePersonId

100: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getParamValue
101: ( p_param => 'IRC_CAND_PER_ID'
102: , p_eventData => l_eventData);
103: if l_candidateId is null then
104: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getCandidatePersonId
105: ( p_assignmentId => l_assignmentId
106: , p_effectiveDate => l_effectiveDate);
107: l_candidateId := irc_utilities_pkg.GET_RECRUITMENT_PERSON_ID
108: ( p_person_id => l_candidateId

Line 118: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

114: || 'IRC_CAND_PER_ID:'
115: || l_candidateId
116: ||';';
117: l_eventData := l_eventData
118: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
119: ( p_personId => l_candidateId
120: , p_role => 'CAND'
121: , p_effectiveDate => l_effectiveDate);
122: l_eventData := l_eventData

Line 123: || IRC_NOTIFICATION_DATA_PKG.getCandidateAgencyId

119: ( p_personId => l_candidateId
120: , p_role => 'CAND'
121: , p_effectiveDate => l_effectiveDate);
122: l_eventData := l_eventData
123: || IRC_NOTIFICATION_DATA_PKG.getCandidateAgencyId
124: (p_candidateId => l_candidateId
125: , p_effectiveDate => l_effectiveDate);
126: end if;
127: l_managerId := IRC_NOTIFICATION_DATA_PKG.getManagerPersonId

Line 127: l_managerId := IRC_NOTIFICATION_DATA_PKG.getManagerPersonId

123: || IRC_NOTIFICATION_DATA_PKG.getCandidateAgencyId
124: (p_candidateId => l_candidateId
125: , p_effectiveDate => l_effectiveDate);
126: end if;
127: l_managerId := IRC_NOTIFICATION_DATA_PKG.getManagerPersonId
128: ( p_vacancyId => l_vacancyId
129: , p_effectiveDate => l_effectiveDate);
130: hr_utility.set_location('Manager Id : ' || l_managerId, 70);
131: if l_managerId IS NOT null then

Line 137: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

133: || 'IRC_MGR_PER_ID:'
134: || l_managerId
135: ||';';
136: l_eventData := l_eventData
137: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
138: ( p_personId => l_managerId
139: , p_role => 'MGR'
140: , p_effectiveDate => l_effectiveDate);
141: end if;

Line 142: l_recruiterId := IRC_NOTIFICATION_DATA_PKG.getRecruiterPersonId

138: ( p_personId => l_managerId
139: , p_role => 'MGR'
140: , p_effectiveDate => l_effectiveDate);
141: end if;
142: l_recruiterId := IRC_NOTIFICATION_DATA_PKG.getRecruiterPersonId
143: ( p_assignmentId => l_assignmentId
144: , p_effectiveDate => l_effectiveDate);
145: hr_utility.set_location('Recruiter Id : ' || l_recruiterId, 80);
146: if l_recruiterId IS NOT null then

Line 152: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

148: || 'IRC_REC_PER_ID:'
149: || l_recruiterId
150: ||';';
151: l_eventData := l_eventData
152: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
153: ( p_personId => l_recruiterId
154: , p_role => 'REC'
155: , p_effectiveDate => l_effectiveDate);
156: end if;

Line 157: l_referrerId := IRC_NOTIFICATION_DATA_PKG.getParamValue

153: ( p_personId => l_recruiterId
154: , p_role => 'REC'
155: , p_effectiveDate => l_effectiveDate);
156: end if;
157: l_referrerId := IRC_NOTIFICATION_DATA_PKG.getParamValue
158: ( p_param => 'IRC_REFR_PER_ID'
159: , p_eventData => l_eventData);
160: hr_utility.set_location('Referrer Id : ' || l_referrerId, 90);
161: if l_referrerId IS NOT null then

Line 163: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

159: , p_eventData => l_eventData);
160: hr_utility.set_location('Referrer Id : ' || l_referrerId, 90);
161: if l_referrerId IS NOT null then
162: l_eventData := l_eventData
163: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
164: ( p_personId => l_referrerId
165: , p_role => 'REFR'
166: , p_effectiveDate => l_effectiveDate);
167: end if;

Line 168: l_actionPerformerId := IRC_NOTIFICATION_DATA_PKG.getParamValue

164: ( p_personId => l_referrerId
165: , p_role => 'REFR'
166: , p_effectiveDate => l_effectiveDate);
167: end if;
168: l_actionPerformerId := IRC_NOTIFICATION_DATA_PKG.getParamValue
169: ( p_param => 'IRC_ACT_PERF_PER_ID'
170: , p_eventData => l_eventData);
171: hr_utility.set_location('Action Performer Id : ' || l_actionPerformerId, 100);
172: if l_actionPerformerId is not null then

Line 174: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

170: , p_eventData => l_eventData);
171: hr_utility.set_location('Action Performer Id : ' || l_actionPerformerId, 100);
172: if l_actionPerformerId is not null then
173: l_eventData := l_eventData
174: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
175: ( p_personId => l_actionPerformerId
176: , p_role => 'ACT_PERF'
177: , p_effectiveDate => l_effectiveDate);
178: end if;

Line 180: l_assignmentStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue

176: , p_role => 'ACT_PERF'
177: , p_effectiveDate => l_effectiveDate);
178: end if;
179: if l_eventName = 'APLSTACHG' then
180: l_assignmentStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue
181: ( p_param => 'IRC_JOB_APPL_NEW_STATUS_CODE'
182: , p_eventdata => l_eventData);
183: l_eventData := l_eventData
184: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus

Line 184: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus

180: l_assignmentStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue
181: ( p_param => 'IRC_JOB_APPL_NEW_STATUS_CODE'
182: , p_eventdata => l_eventData);
183: l_eventData := l_eventData
184: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus
185: ( p_assignmentStatusCode => l_assignmentStatusCode);
186: end if;
187: if l_eventName = 'COMTOPCRE' or l_eventName = 'COMTOPUPD' then
188: l_communicationObjectType := IRC_NOTIFICATION_DATA_PKG.getParamValue

Line 188: l_communicationObjectType := IRC_NOTIFICATION_DATA_PKG.getParamValue

184: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus
185: ( p_assignmentStatusCode => l_assignmentStatusCode);
186: end if;
187: if l_eventName = 'COMTOPCRE' or l_eventName = 'COMTOPUPD' then
188: l_communicationObjectType := IRC_NOTIFICATION_DATA_PKG.getParamValue
189: ( p_param => 'IRC_COMM_OBJ_TYPE'
190: , p_eventData => l_eventData);
191: if(l_communicationObjectType is null) then
192: l_communicationObjectType := 'TOPIC';

Line 195: l_topicId := IRC_NOTIFICATION_DATA_PKG.getParamValue

191: if(l_communicationObjectType is null) then
192: l_communicationObjectType := 'TOPIC';
193: end if;
194: if(l_communicationObjectType = 'TOPIC') then
195: l_topicId := IRC_NOTIFICATION_DATA_PKG.getParamValue
196: ( p_param => 'IRC_COMM_OBJ_ID'
197: , p_eventData => l_eventData);
198: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue
199: ( p_param => 'IRC_COMM_MSG_ID'

Line 198: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue

194: if(l_communicationObjectType = 'TOPIC') then
195: l_topicId := IRC_NOTIFICATION_DATA_PKG.getParamValue
196: ( p_param => 'IRC_COMM_OBJ_ID'
197: , p_eventData => l_eventData);
198: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue
199: ( p_param => 'IRC_COMM_MSG_ID'
200: , p_eventData => l_eventData);
201: l_eventData := l_eventData
202: || IRC_NOTIFICATION_DATA_PKG.getCommunicationTopicDetails

Line 202: || IRC_NOTIFICATION_DATA_PKG.getCommunicationTopicDetails

198: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue
199: ( p_param => 'IRC_COMM_MSG_ID'
200: , p_eventData => l_eventData);
201: l_eventData := l_eventData
202: || IRC_NOTIFICATION_DATA_PKG.getCommunicationTopicDetails
203: ( p_topicId => l_topicId
204: , p_messageId => l_messageId);
205: end if;
206: end if;

Line 208: l_interviewId := IRC_NOTIFICATION_DATA_PKG.getParamValue

204: , p_messageId => l_messageId);
205: end if;
206: end if;
207: if l_eventName = 'INTVCRE' or l_eventName = 'INTVUPD' then
208: l_interviewId := IRC_NOTIFICATION_DATA_PKG.getParamValue
209: ( p_param => 'IRC_INTVW_ID'
210: , p_eventData => l_eventData);
211: l_eventData := l_eventData
212: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails

Line 212: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails

208: l_interviewId := IRC_NOTIFICATION_DATA_PKG.getParamValue
209: ( p_param => 'IRC_INTVW_ID'
210: , p_eventData => l_eventData);
211: l_eventData := l_eventData
212: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails
213: ( p_interviewId => l_interviewId
214: , p_effectiveDate => l_effectiveDate);
215: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
216: ( p_param => 'IRC_INTVW_NEW_STATUS_CODE'

Line 215: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue

211: l_eventData := l_eventData
212: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails
213: ( p_interviewId => l_interviewId
214: , p_effectiveDate => l_effectiveDate);
215: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
216: ( p_param => 'IRC_INTVW_NEW_STATUS_CODE'
217: , p_eventData => l_eventData);
218: l_eventData := l_eventData
219: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

Line 219: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

215: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
216: ( p_param => 'IRC_INTVW_NEW_STATUS_CODE'
217: , p_eventData => l_eventData);
218: l_eventData := l_eventData
219: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
220: ( p_interviewstatuscode => l_interviewStatusCode
221: , p_attributename => 'IRC_INTVW_NEW_STATUS');
222: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
223: ( p_param => 'IRC_INTVW_OLD_STATUS_CODE'

Line 222: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue

218: l_eventData := l_eventData
219: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
220: ( p_interviewstatuscode => l_interviewStatusCode
221: , p_attributename => 'IRC_INTVW_NEW_STATUS');
222: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
223: ( p_param => 'IRC_INTVW_OLD_STATUS_CODE'
224: , p_eventData => l_eventData);
225: l_eventData := l_eventData
226: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

Line 226: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

222: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
223: ( p_param => 'IRC_INTVW_OLD_STATUS_CODE'
224: , p_eventData => l_eventData);
225: l_eventData := l_eventData
226: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
227: ( p_interviewstatuscode => l_interviewStatusCode
228: , p_attributename => 'IRC_INTVW_OLD_STATUS');
229: l_eventData := l_eventData
230: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml

Line 230: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml

226: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
227: ( p_interviewstatuscode => l_interviewStatusCode
228: , p_attributename => 'IRC_INTVW_OLD_STATUS');
229: l_eventData := l_eventData
230: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml
231: ( p_interviewid => l_interviewId
232: , p_effectivedate => l_effectiveDate);
233: end if;
234: hr_utility.set_location('Populated all data:Create Workflow', 110);