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_EN_WLST_GEN_PROC dependencies on WF_PARAMETER_LIST_T

Line 22: -- while declaring wiht wf_parameter_list_t();

18: -- rnirwani 01-Dec-2003 Bug# 2829263. Term records build
19: -- Parameters to procedure wf_inform_stud have been modified.
20: -- The parameters passed to the business events too have changed.
21: --kkillams 11-03-2003 Initialized the workflow parameter list variable
22: -- while declaring wiht wf_parameter_list_t();
23: -- w.r.t. but no:2840162
24: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
25: -- added as part of Prevent Dropping Core Units. Enh Bug# 3052432
26: -------------------------------------------------------------------

Line 197: l_wf_parameter_list_t WF_PARAMETER_LIST_T :=wf_parameter_list_t();

193: --Change History:
194: --Who When What
195: -------------------------------------------------------------------
196: IS
197: l_wf_parameter_list_t WF_PARAMETER_LIST_T :=wf_parameter_list_t();
198: l_key NUMBER;
199: l_wf_installed fnd_lookups.lookup_code%TYPE;
200: BEGIN
201: -- get the profile value that is set for checking if workflow is installed

Line 213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);

209: SELECT igs_en_inform_stud_s.NEXTVAL INTO l_key FROM dual;
210: --
211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);

Line 214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);

210: --
211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);

Line 215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);

211: -- now add the parameters to the parameter list
212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);

Line 216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);

212: --
213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);

Line 217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);

213: wf_event.AddParameterToList( p_Name => 'P_ORG_ID', p_Value => p_org_id, p_parameterlist =>l_wf_parameter_list_t);
214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);

Line 218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);

214: wf_event.AddParameterToList( p_Name => 'P_PERSON_ID', p_Value => p_person_id, p_parameterlist =>l_wf_parameter_list_t);
215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --

Line 219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);

215: wf_event.AddParameterToList( p_Name => 'P_KEY_PROGRAM', p_Value => p_program_cd, p_parameterlist =>l_wf_parameter_list_t);
216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event

Line 220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);

216: wf_event.AddParameterToList( p_Name => 'P_VERSION_NUMBER', p_Value => p_version_number, p_parameterlist =>l_wf_parameter_list_t);
217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event
224: --

Line 221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);

217: wf_event.AddParameterToList( p_Name => 'P_PROGRAM_ATTEMPT_STATUS', p_Value => p_program_attempt_status, p_parameterlist =>l_wf_parameter_list_t);
218: wf_event.AddParameterToList( p_Name => 'P_OLD_KEY_PROGRAM', p_Value => p_old_key_program, p_parameterlist =>l_wf_parameter_list_t);
219: wf_event.AddParameterToList( p_Name => 'P_OLD_PRIM_PROGRAM', p_Value => p_old_prim_program, p_parameterlist =>l_wf_parameter_list_t);
220: wf_event.AddParameterToList( p_Name => 'P_LOAD_CAL_TYPE', p_Value => p_load_cal_type, p_parameterlist =>l_wf_parameter_list_t);
221: wf_event.AddParameterToList( p_Name => 'P_LOAD_CA_SEQ_NUM', p_Value => p_load_ci_seq_num, p_parameterlist =>l_wf_parameter_list_t);
222: --
223: -- raise the event
224: --
225: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.keyprim',

Line 228: p_parameters => l_wf_parameter_list_t);

224: --
225: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.prog.keyprim',
226: p_event_key => 'keyprim'||l_key,
227: p_event_data => NULL,
228: p_parameters => l_wf_parameter_list_t);
229: END IF;
230: END wf_inform_stud ;
231:
232:

Line 254: l_param_list wf_parameter_list_t:=wf_parameter_list_t();

250: --Who When What
251: -------------------------------------------------------------------
252: IS
253: l_key NUMBER;
254: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
255: l_wf_installed fnd_lookups.lookup_code%TYPE;
256: BEGIN
257: -- get the profile value that is set for checking if workflow is installed
258: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

Line 324: l_param_list wf_parameter_list_t:=wf_parameter_list_t();

320: AND r.responsibility_key = 'IGS_SS_FACULTY';
321:
322:
323: l_key NUMBER;
324: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
325: l_wf_installed fnd_lookups.lookup_code%TYPE;
326: v_USER_ID c_userid%ROWTYPE ;
327: l_USER_ID fnd_user.USER_ID%TYPE ;
328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;

Line 499: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

495: counter NUMBER;
496:
497: -- Workflow variables
498: l_wf_event_t WF_EVENT_T;
499: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
500: l_key NUMBER;
501: l_tot_stud NUMBER;
502: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
503: l_param_value VARCHAR2(200);

Line 502: l_param_list wf_parameter_list_t:=wf_parameter_list_t();

498: l_wf_event_t WF_EVENT_T;
499: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
500: l_key NUMBER;
501: l_tot_stud NUMBER;
502: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
503: l_param_value VARCHAR2(200);
504: l_param_name VARCHAR2(50);
505: l_pri_pref_def BOOLEAN;
506: