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 66: l_assignmentId := IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 70: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 74: l_effectiveDate := to_date( IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 82: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 86: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getVacancyId

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

Line 97: || IRC_NOTIFICATION_DATA_PKG.getVacancyDetails

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

Line 101: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 105: l_candidateId := IRC_NOTIFICATION_DATA_PKG.getCandidatePersonId

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

Line 120: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

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

Line 125: || IRC_NOTIFICATION_DATA_PKG.getCandidateAgencyId

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

Line 129: l_managerId := IRC_NOTIFICATION_DATA_PKG.getManagerPersonId

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

Line 139: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

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

Line 144: l_recruiterId := IRC_NOTIFICATION_DATA_PKG.getRecruiterPersonId

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

Line 154: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

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

Line 159: l_referrerId := IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 165: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

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

Line 170: l_actionPerformerId := IRC_NOTIFICATION_DATA_PKG.getParamValue

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

Line 176: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails

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

Line 182: l_assignmentStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue

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

Line 186: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus

182: l_assignmentStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue
183: ( p_param => 'IRC_JOB_APPL_NEW_STATUS_CODE'
184: , p_eventdata => l_eventData);
185: l_eventData := l_eventData
186: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus
187: ( p_assignmentStatusCode => l_assignmentStatusCode);
188:
189: l_eventData := l_eventData
190: || IRC_NOTIFICATION_DATA_PKG.getApplicationExtStatus

Line 190: || IRC_NOTIFICATION_DATA_PKG.getApplicationExtStatus

186: || IRC_NOTIFICATION_DATA_PKG.getApplicationStatus
187: ( p_assignmentStatusCode => l_assignmentStatusCode);
188:
189: l_eventData := l_eventData
190: || IRC_NOTIFICATION_DATA_PKG.getApplicationExtStatus
191: ( p_assignmentStatusCode => l_assignmentStatusCode);
192:
193:
194: l_assignmentOldStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue

Line 194: l_assignmentOldStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue

190: || IRC_NOTIFICATION_DATA_PKG.getApplicationExtStatus
191: ( p_assignmentStatusCode => l_assignmentStatusCode);
192:
193:
194: l_assignmentOldStatusCode := IRC_NOTIFICATION_DATA_PKG.getparamvalue
195: ( p_param => 'IRC_JOB_APPL_OLD_STATUS_CODE'
196: , p_eventdata => l_eventData);
197:
198: l_eventData := l_eventData

Line 199: || IRC_NOTIFICATION_DATA_PKG.getApplicationOldExtStatus

195: ( p_param => 'IRC_JOB_APPL_OLD_STATUS_CODE'
196: , p_eventdata => l_eventData);
197:
198: l_eventData := l_eventData
199: || IRC_NOTIFICATION_DATA_PKG.getApplicationOldExtStatus
200: ( p_assignmentOldStatusCode => l_assignmentOldStatusCode);
201:
202:
203: end if;

Line 205: l_communicationObjectType := IRC_NOTIFICATION_DATA_PKG.getParamValue

201:
202:
203: end if;
204: if l_eventName = 'COMTOPCRE' or l_eventName = 'COMTOPUPD' then
205: l_communicationObjectType := IRC_NOTIFICATION_DATA_PKG.getParamValue
206: ( p_param => 'IRC_COMM_OBJ_TYPE'
207: , p_eventData => l_eventData);
208: if(l_communicationObjectType is null) then
209: l_communicationObjectType := 'TOPIC';

Line 212: l_topicId := IRC_NOTIFICATION_DATA_PKG.getParamValue

208: if(l_communicationObjectType is null) then
209: l_communicationObjectType := 'TOPIC';
210: end if;
211: if(l_communicationObjectType = 'TOPIC') then
212: l_topicId := IRC_NOTIFICATION_DATA_PKG.getParamValue
213: ( p_param => 'IRC_COMM_OBJ_ID'
214: , p_eventData => l_eventData);
215: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue
216: ( p_param => 'IRC_COMM_MSG_ID'

Line 215: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue

211: if(l_communicationObjectType = 'TOPIC') then
212: l_topicId := IRC_NOTIFICATION_DATA_PKG.getParamValue
213: ( p_param => 'IRC_COMM_OBJ_ID'
214: , p_eventData => l_eventData);
215: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue
216: ( p_param => 'IRC_COMM_MSG_ID'
217: , p_eventData => l_eventData);
218: l_eventData := l_eventData
219: || IRC_NOTIFICATION_DATA_PKG.getCommunicationTopicDetails

Line 219: || IRC_NOTIFICATION_DATA_PKG.getCommunicationTopicDetails

215: l_messageId := IRC_NOTIFICATION_DATA_PKG.getParamValue
216: ( p_param => 'IRC_COMM_MSG_ID'
217: , p_eventData => l_eventData);
218: l_eventData := l_eventData
219: || IRC_NOTIFICATION_DATA_PKG.getCommunicationTopicDetails
220: ( p_topicId => l_topicId
221: , p_messageId => l_messageId);
222: end if;
223: end if;

Line 225: l_interviewId := IRC_NOTIFICATION_DATA_PKG.getParamValue

221: , p_messageId => l_messageId);
222: end if;
223: end if;
224: if l_eventName = 'INTVCRE' or l_eventName = 'INTVUPD' then
225: l_interviewId := IRC_NOTIFICATION_DATA_PKG.getParamValue
226: ( p_param => 'IRC_INTVW_ID'
227: , p_eventData => l_eventData);
228: l_eventData := l_eventData
229: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails

Line 229: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails

225: l_interviewId := IRC_NOTIFICATION_DATA_PKG.getParamValue
226: ( p_param => 'IRC_INTVW_ID'
227: , p_eventData => l_eventData);
228: l_eventData := l_eventData
229: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails
230: ( p_interviewId => l_interviewId
231: , p_effectiveDate => l_effectiveDate);
232: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
233: ( p_param => 'IRC_INTVW_NEW_STATUS_CODE'

Line 232: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue

228: l_eventData := l_eventData
229: || IRC_NOTIFICATION_DATA_PKG.getInterviewDetails
230: ( p_interviewId => l_interviewId
231: , p_effectiveDate => l_effectiveDate);
232: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
233: ( p_param => 'IRC_INTVW_NEW_STATUS_CODE'
234: , p_eventData => l_eventData);
235: l_eventData := l_eventData
236: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

Line 236: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

232: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
233: ( p_param => 'IRC_INTVW_NEW_STATUS_CODE'
234: , p_eventData => l_eventData);
235: l_eventData := l_eventData
236: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
237: ( p_interviewstatuscode => l_interviewStatusCode
238: , p_attributename => 'IRC_INTVW_NEW_STATUS');
239: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
240: ( p_param => 'IRC_INTVW_OLD_STATUS_CODE'

Line 239: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue

235: l_eventData := l_eventData
236: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
237: ( p_interviewstatuscode => l_interviewStatusCode
238: , p_attributename => 'IRC_INTVW_NEW_STATUS');
239: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
240: ( p_param => 'IRC_INTVW_OLD_STATUS_CODE'
241: , p_eventData => l_eventData);
242: l_eventData := l_eventData
243: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

Line 243: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning

239: l_interviewStatusCode := IRC_NOTIFICATION_DATA_PKG.getParamValue
240: ( p_param => 'IRC_INTVW_OLD_STATUS_CODE'
241: , p_eventData => l_eventData);
242: l_eventData := l_eventData
243: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
244: ( p_interviewstatuscode => l_interviewStatusCode
245: , p_attributename => 'IRC_INTVW_OLD_STATUS');
246: l_eventData := l_eventData
247: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml

Line 247: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml

243: || IRC_NOTIFICATION_DATA_PKG.getinterviewstatusmeaning
244: ( p_interviewstatuscode => l_interviewStatusCode
245: , p_attributename => 'IRC_INTVW_OLD_STATUS');
246: l_eventData := l_eventData
247: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml
248: ( p_interviewid => l_interviewId
249: , p_effectivedate => l_effectiveDate);
250: end if;
251: hr_utility.set_location('Populated all data:Create Workflow', 110);