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.IGS_AD_OFFRESP_STATUS_WF dependencies on WF_ENGINE

Line 136: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');

132: BEGIN
133:
134: IF funcmode='RUN' THEN
135:
136: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
137:
138: OPEN get_person_attr;
139: FETCH get_person_attr INTO l_person_number, l_full_name;
140: CLOSE get_person_attr;

Line 146: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);

142: OPEN cur_user_name;
143: FETCH cur_user_name INTO l_wf_role;
144: CLOSE cur_user_name;
145:
146: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
147: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
148: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
149:
150: END IF;

Line 147: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);

143: FETCH cur_user_name INTO l_wf_role;
144: CLOSE cur_user_name;
145:
146: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
147: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
148: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
149:
150: END IF;
151:

Line 148: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);

144: CLOSE cur_user_name;
145:
146: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
147: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
148: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
149:
150: END IF;
151:
152: END wf_get_person_attributes;

Line 238: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');

234:
235: BEGIN
236: IF funcmode='RUN' THEN
237:
238: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
239: l_admission_appl_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADMISSION_APPL_NUMBER');
240: l_nominated_course_cd := wf_engine.getitemattrtext(itemtype,itemkey,'P_NOMINATED_COURSE_CD');
241: l_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SEQUENCE_NUMBER');
242: l_new_offer_resp_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_NEW_OFFER_RESPONSE_STATUS');

Line 239: l_admission_appl_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADMISSION_APPL_NUMBER');

235: BEGIN
236: IF funcmode='RUN' THEN
237:
238: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
239: l_admission_appl_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADMISSION_APPL_NUMBER');
240: l_nominated_course_cd := wf_engine.getitemattrtext(itemtype,itemkey,'P_NOMINATED_COURSE_CD');
241: l_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SEQUENCE_NUMBER');
242: l_new_offer_resp_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_NEW_OFFER_RESPONSE_STATUS');
243:

Line 240: l_nominated_course_cd := wf_engine.getitemattrtext(itemtype,itemkey,'P_NOMINATED_COURSE_CD');

236: IF funcmode='RUN' THEN
237:
238: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
239: l_admission_appl_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADMISSION_APPL_NUMBER');
240: l_nominated_course_cd := wf_engine.getitemattrtext(itemtype,itemkey,'P_NOMINATED_COURSE_CD');
241: l_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SEQUENCE_NUMBER');
242: l_new_offer_resp_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_NEW_OFFER_RESPONSE_STATUS');
243:
244: -- Fetch the Application details of the current application by calling the following standard API.

Line 241: l_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SEQUENCE_NUMBER');

237:
238: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
239: l_admission_appl_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADMISSION_APPL_NUMBER');
240: l_nominated_course_cd := wf_engine.getitemattrtext(itemtype,itemkey,'P_NOMINATED_COURSE_CD');
241: l_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SEQUENCE_NUMBER');
242: l_new_offer_resp_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_NEW_OFFER_RESPONSE_STATUS');
243:
244: -- Fetch the Application details of the current application by calling the following standard API.
245: igs_ad_gen_002.admp_get_aa_dtl(

Line 242: l_new_offer_resp_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_NEW_OFFER_RESPONSE_STATUS');

238: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
239: l_admission_appl_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADMISSION_APPL_NUMBER');
240: l_nominated_course_cd := wf_engine.getitemattrtext(itemtype,itemkey,'P_NOMINATED_COURSE_CD');
241: l_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SEQUENCE_NUMBER');
242: l_new_offer_resp_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_NEW_OFFER_RESPONSE_STATUS');
243:
244: -- Fetch the Application details of the current application by calling the following standard API.
245: igs_ad_gen_002.admp_get_aa_dtl(
246: l_person_id,

Line 285: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);

281: OPEN get_alternate_code(v_aa_adm_cal_type,v_aa_adm_ci_sequence_number);
282: FETCH get_alternate_code INTO l_adm_alt_code;
283: CLOSE get_alternate_code;
284:
285: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
286: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
287: wf_engine.setitemattrtext(itemtype,itemkey,'P_ACAD_ADM_CAL',l_acad_alt_code||'/'||l_adm_alt_code);
288: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
289: resultout := 'COMPLETE:Y';

Line 286: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);

282: FETCH get_alternate_code INTO l_adm_alt_code;
283: CLOSE get_alternate_code;
284:
285: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
286: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
287: wf_engine.setitemattrtext(itemtype,itemkey,'P_ACAD_ADM_CAL',l_acad_alt_code||'/'||l_adm_alt_code);
288: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
289: resultout := 'COMPLETE:Y';
290: ELSE

Line 287: wf_engine.setitemattrtext(itemtype,itemkey,'P_ACAD_ADM_CAL',l_acad_alt_code||'/'||l_adm_alt_code);

283: CLOSE get_alternate_code;
284:
285: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
286: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
287: wf_engine.setitemattrtext(itemtype,itemkey,'P_ACAD_ADM_CAL',l_acad_alt_code||'/'||l_adm_alt_code);
288: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
289: resultout := 'COMPLETE:Y';
290: ELSE
291: resultout := 'COMPLETE:N';

Line 288: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);

284:
285: wf_engine.setitemattrtext(itemtype,itemkey,'P_PERSON_NUMBER',l_person_number);
286: wf_engine.setitemattrtext(itemtype,itemkey,'P_FULL_NAME',l_full_name);
287: wf_engine.setitemattrtext(itemtype,itemkey,'P_ACAD_ADM_CAL',l_acad_alt_code||'/'||l_adm_alt_code);
288: wf_engine.setitemattrtext(itemtype,itemkey,'P_WF_ROLE',l_wf_role);
289: resultout := 'COMPLETE:Y';
290: ELSE
291: resultout := 'COMPLETE:N';
292: END IF;