30: l_msg_nme VARCHAR2(2000);
31: l_msg_txt fnd_new_messages.message_text%TYPE;
32:
33: BEGIN
34: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',return_status);
35: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',message_count);
36:
37: l_msg_index := igs_ge_msg_stack.count_msg;
38: FND_MESSAGE.SET_NAME('IGS',message_name);
31: l_msg_txt fnd_new_messages.message_text%TYPE;
32:
33: BEGIN
34: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',return_status);
35: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',message_count);
36:
37: l_msg_index := igs_ge_msg_stack.count_msg;
38: FND_MESSAGE.SET_NAME('IGS',message_name);
39: IF message_token IS NOT NULL THEN
46: fnd_message.parse_encoded (l_msg_txt, l_app_nme, l_msg_nme);
47: fnd_message.set_encoded (l_msg_txt);
48: l_msg_txt := fnd_message.get;
49:
50: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_txt);
51: END set_return_message;
52:
53: PROCEDURE call_apl_pre_crt_apis(
54: itemtype in VARCHAR2 ,
114: BEGIN
115:
116: IF funcmode='RUN' THEN
117:
118: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
119: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
115:
116: IF funcmode='RUN' THEN
117:
118: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
119: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
116: IF funcmode='RUN' THEN
117:
118: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
119: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
117:
118: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
119: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
118: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
119: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
119: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
120: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
121: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
122: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
123: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
124: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
125: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
126: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
127: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
128: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
136: l_application_fee_amount := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT');
129: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
136: l_application_fee_amount := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT');
137: l_appl_source_id := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPL_SOURCE_ID');
130: l_entry_status := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS');
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
136: l_application_fee_amount := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT');
137: l_appl_source_id := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPL_SOURCE_ID');
138:
131: l_entry_level := wf_engine.getitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL');
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
136: l_application_fee_amount := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT');
137: l_appl_source_id := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPL_SOURCE_ID');
138:
139: l_admission_cat := NULL;
132: l_spcl_gr1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR1');
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
136: l_application_fee_amount := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT');
137: l_appl_source_id := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPL_SOURCE_ID');
138:
139: l_admission_cat := NULL;
140: l_s_process_type := NULL;
133: l_spcl_gr2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_SPCL_GR2');
134: l_apply_for_finaid := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
135: l_finaid_apply_date := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID');
136: l_application_fee_amount := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT');
137: l_appl_source_id := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPL_SOURCE_ID');
138:
139: l_admission_cat := NULL;
140: l_s_process_type := NULL;
141:
179: );
180:
181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182:
183: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',l_return_status);
184: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',1);
185: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_data);
186: resultout := 'COMPLETE:ERROR';
187: RETURN;
180:
181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182:
183: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',l_return_status);
184: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',1);
185: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_data);
186: resultout := 'COMPLETE:ERROR';
187: RETURN;
188: END IF;
181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182:
183: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',l_return_status);
184: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',1);
185: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_data);
186: resultout := 'COMPLETE:ERROR';
187: RETURN;
188: END IF;
189:
254:
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256:
257: ROLLBACK TO PRE_CREATE_APPLICATION_WF;
258: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',l_return_status);
259: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',1);
260: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_data);
261: resultout := 'COMPLETE:ERROR';
262: RETURN;
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256:
257: ROLLBACK TO PRE_CREATE_APPLICATION_WF;
258: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',l_return_status);
259: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',1);
260: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_data);
261: resultout := 'COMPLETE:ERROR';
262: RETURN;
263: END IF;
256:
257: ROLLBACK TO PRE_CREATE_APPLICATION_WF;
258: wf_engine.setitemattrtext(itemtype,itemkey,'P_RETURN_STATUS',l_return_status);
259: wf_engine.setitemattrnumber(itemtype,itemkey,'P_MSG_COUNT',1);
260: wf_engine.setitemattrtext(itemtype,itemkey,'P_MSG_DATA',l_msg_data);
261: resultout := 'COMPLETE:ERROR';
262: RETURN;
263: END IF;
264:
265: END IF;
266:
267:
268: set_return_message(itemtype,itemkey,null,null,'S');
269: wf_engine.setitemattrtext(itemtype,itemkey,'P_SS_ADM_APPL_ID', l_ss_adm_appl_id);
270:
271: resultout := 'COMPLETE:SUCCESS';
272:
273: END IF;
412: l_appl_date := trunc(SYSDATE);
413:
414: IF funcmode='RUN' THEN
415:
416: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
417: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
413:
414: IF funcmode='RUN' THEN
415:
416: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
417: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
414: IF funcmode='RUN' THEN
415:
416: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
417: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
415:
416: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
417: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
416: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
417: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
417: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
418: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
419: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
420: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
421: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
422: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
423: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
424: l_program_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
425: l_sch_apl_to_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
426: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
427: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
428: l_oo_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_1');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
429: l_oo_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_2');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
430: l_oo_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_3');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
431: l_oo_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_4');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
432: l_oo_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_5');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
433: l_oo_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_6');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
434: l_oo_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_7');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
435: l_oo_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_8');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
436: l_oo_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_9');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
437: l_oo_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_OO_ATTRIBUTE_10');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
438: l_citizenship_residency_ind := wf_engine.getitemattrtext(itemtype,itemkey,'P_CITIZENSHIP_RESIDENCY_IND');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
439: l_cit_res_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_1');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
440: l_cit_res_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_2');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
441: l_cit_res_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_3');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
442: l_cit_res_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_4');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
443: l_cit_res_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_5');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
444: l_cit_res_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_6');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
445: l_cit_res_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_7');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
446: l_cit_res_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_8');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
447: l_cit_res_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_9');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
448: l_cit_res_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_CIT_RES_ATTRIBUTE_10');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
449: l_state_of_res_type_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_STATE_OF_RES_TYPE_CODE');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
450: l_dom_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_1');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
451: l_dom_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_2');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
452: l_dom_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_3');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
453: l_dom_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_4');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
454: l_dom_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_5');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
455: l_dom_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_6');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
456: l_dom_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_7');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
457: l_dom_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_8');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
458: l_dom_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_9');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
459: l_dom_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_DOM_ATTRIBUTE_10');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
460: l_gen_attribute_1 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_1');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
461: l_gen_attribute_2 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_2');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
462: l_gen_attribute_3 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_3');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
463: l_gen_attribute_4 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_4');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
464: l_gen_attribute_5 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_5');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
465: l_gen_attribute_6 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_6');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
466: l_gen_attribute_7 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_7');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
467: l_gen_attribute_8 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_8');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
468: l_gen_attribute_9 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_9');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
469: l_gen_attribute_10 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_10');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
470: l_gen_attribute_11 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_11');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
478: l_gen_attribute_19 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_19');
471: l_gen_attribute_12 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_12');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
478: l_gen_attribute_19 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_19');
479: l_gen_attribute_20 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_20');
472: l_gen_attribute_13 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_13');
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
478: l_gen_attribute_19 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_19');
479: l_gen_attribute_20 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_20');
480:
473: l_gen_attribute_14 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_14');
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
478: l_gen_attribute_19 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_19');
479: l_gen_attribute_20 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_20');
480:
481: IF l_appl_type_uhk_prl.value ='Y' THEN
474: l_gen_attribute_15 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_15');
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
478: l_gen_attribute_19 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_19');
479: l_gen_attribute_20 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_20');
480:
481: IF l_appl_type_uhk_prl.value ='Y' THEN
482:
475: l_gen_attribute_16 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_16');
476: l_gen_attribute_17 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_17');
477: l_gen_attribute_18 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_18');
478: l_gen_attribute_19 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_19');
479: l_gen_attribute_20 := wf_engine.getitemattrtext(itemtype,itemkey,'P_GEN_ATTRIBUTE_20');
480:
481: IF l_appl_type_uhk_prl.value ='Y' THEN
482:
483: igs_ad_uhk_pre_create_appl_pkg.derive_app_type (
747: l_result := 'COMPLETE:SUCCESS';
748: END IF;
749:
750:
751: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE', l_application_type);
752: wf_engine.setitemattrtext(itemtype,itemkey,'P_LOCATION_CODE', l_location_code);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
748: END IF;
749:
750:
751: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE', l_application_type);
752: wf_engine.setitemattrtext(itemtype,itemkey,'P_LOCATION_CODE', l_location_code);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
749:
750:
751: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE', l_application_type);
752: wf_engine.setitemattrtext(itemtype,itemkey,'P_LOCATION_CODE', l_location_code);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
750:
751: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE', l_application_type);
752: wf_engine.setitemattrtext(itemtype,itemkey,'P_LOCATION_CODE', l_location_code);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
751: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE', l_application_type);
752: wf_engine.setitemattrtext(itemtype,itemkey,'P_LOCATION_CODE', l_location_code);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
752: wf_engine.setitemattrtext(itemtype,itemkey,'P_LOCATION_CODE', l_location_code);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
753: wf_engine.setitemattrtext(itemtype,itemkey,'P_PROGRAM_TYPE', l_program_type);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
754: wf_engine.setitemattrnumber(itemtype,itemkey,'P_SCH_APL_TO_ID', l_sch_apl_to_id);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
762: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_finaid_apply_date);
755: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE', l_attendance_type);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
762: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_finaid_apply_date);
763: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT', l_application_fee_amount);
756: wf_engine.setitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE', l_attendance_mode);
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
762: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_finaid_apply_date);
763: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT', l_application_fee_amount);
764:
757: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_STATUS', l_entry_status);
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
762: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_finaid_apply_date);
763: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT', l_application_fee_amount);
764:
765: resultout := l_result;
758: wf_engine.setitemattrtext(itemtype,itemkey,'P_ENTRY_LEVEL', l_entry_level);
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
762: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_finaid_apply_date);
763: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT', l_application_fee_amount);
764:
765: resultout := l_result;
766: END IF;
759: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR1', l_spcl_gr1);
760: wf_engine.setitemattrtext(itemtype,itemkey,'P_SPCL_GR2', l_spcl_gr2);
761: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_apply_for_finaid);
762: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLY_FOR_FINAID', l_finaid_apply_date);
763: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPLICATION_FEE_AMOUNT', l_application_fee_amount);
764:
765: resultout := l_result;
766: END IF;
767:
797: l_appl_source_id := NULL;
798:
799: IF funcmode='RUN' THEN
800:
801: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
802:
803: IF l_login_role = 'ADMIN' THEN
804:
805: l_app_source := 'WEB_STAFF';
831: END IF;
832:
833: END IF;
834:
835: wf_engine.setitemattrtext(itemtype,itemkey,'P_APPL_SOURCE_ID', l_appl_source_id);
836:
837: resultout := 'COMPLETE:SUCCESS';
838: END IF;
839:
902: l_attd_mode_des := NULL;
903: l_application_type_test := NULL;
904:
905: IF funcmode='RUN' THEN
906: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
907: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
903: l_application_type_test := NULL;
904:
905: IF funcmode='RUN' THEN
906: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
907: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
904:
905: IF funcmode='RUN' THEN
906: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
907: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
905: IF funcmode='RUN' THEN
906: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
907: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
906: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
907: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
914: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
907: l_login_role := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOGIN_RESP');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
914: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
915: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
908: l_acad_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_CAL_TYPE');
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
914: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
915: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
916:
909: l_acad_cal_seq_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ACAD_CAL_SEQ_NUMBER');
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
914: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
915: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
916:
917:
910: l_adm_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ADM_CAL_TYPE');
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
914: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
915: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
916:
917:
918: IF l_person_id IS NULL OR l_acad_cal_type IS NULL OR l_acad_cal_seq_number IS NULL OR
911: l_adm_ci_sequence_number := wf_engine.getitemattrnumber(itemtype,itemkey,'P_ADM_CI_SEQUENCE_NUMBER');
912: l_application_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_APPLICATION_TYPE');
913: l_location_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_LOCATION_CODE');
914: l_attendance_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_TYPE');
915: l_attendance_mode := wf_engine.getitemattrtext(itemtype,itemkey,'P_ATTENDANCE_MODE');
916:
917:
918: IF l_person_id IS NULL OR l_acad_cal_type IS NULL OR l_acad_cal_seq_number IS NULL OR
919: l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL OR l_application_type IS NULL THEN