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_PE_GEN_003 dependencies on WF_EVENT

Line 100: l_event_t wf_event_t;

96: FROM DUAL;
97:
98: l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE;
99: ln_seq_val NUMBER;
100: l_event_t wf_event_t;
101: l_parameter_list_t wf_parameter_list_t := wf_parameter_list_t();
102: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_gen_003.raise_person_type_event';
103: l_label VARCHAR2(500);
104: l_debug_str VARCHAR2(3200);

Line 113: wf_event_t.Initialize(l_event_t);

109: FETCH get_sys_person_id INTO l_system_type ;
110: CLOSE get_sys_person_id ;
111:
112: -- initialize the parameter list.
113: wf_event_t.Initialize(l_event_t);
114:
115: -- set the parameters.
116: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
117: wf_event.AddParameterToList ( p_name => 'S_PERSON_TYPE', p_value => l_system_type, p_parameterlist => l_parameter_list_t);

Line 116: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);

112: -- initialize the parameter list.
113: wf_event_t.Initialize(l_event_t);
114:
115: -- set the parameters.
116: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
117: wf_event.AddParameterToList ( p_name => 'S_PERSON_TYPE', p_value => l_system_type, p_parameterlist => l_parameter_list_t);
118: wf_event.AddParameterToList ( p_name => 'ACTION', p_value => p_action, p_parameterList => l_parameter_list_t);
119: wf_event.AddParameterToList ( p_name => 'END_DATE', p_value => p_end_date, p_parameterList => l_parameter_list_t);
120:

Line 117: wf_event.AddParameterToList ( p_name => 'S_PERSON_TYPE', p_value => l_system_type, p_parameterlist => l_parameter_list_t);

113: wf_event_t.Initialize(l_event_t);
114:
115: -- set the parameters.
116: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
117: wf_event.AddParameterToList ( p_name => 'S_PERSON_TYPE', p_value => l_system_type, p_parameterlist => l_parameter_list_t);
118: wf_event.AddParameterToList ( p_name => 'ACTION', p_value => p_action, p_parameterList => l_parameter_list_t);
119: wf_event.AddParameterToList ( p_name => 'END_DATE', p_value => p_end_date, p_parameterList => l_parameter_list_t);
120:
121:

Line 118: wf_event.AddParameterToList ( p_name => 'ACTION', p_value => p_action, p_parameterList => l_parameter_list_t);

114:
115: -- set the parameters.
116: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
117: wf_event.AddParameterToList ( p_name => 'S_PERSON_TYPE', p_value => l_system_type, p_parameterlist => l_parameter_list_t);
118: wf_event.AddParameterToList ( p_name => 'ACTION', p_value => p_action, p_parameterList => l_parameter_list_t);
119: wf_event.AddParameterToList ( p_name => 'END_DATE', p_value => p_end_date, p_parameterList => l_parameter_list_t);
120:
121:
122: -- get the sequence value to be added to EVENT KEY to make it unique.

Line 119: wf_event.AddParameterToList ( p_name => 'END_DATE', p_value => p_end_date, p_parameterList => l_parameter_list_t);

115: -- set the parameters.
116: wf_event.AddParameterToList ( p_name => 'PERSON_ID', p_value => p_person_id, p_parameterlist => l_parameter_list_t);
117: wf_event.AddParameterToList ( p_name => 'S_PERSON_TYPE', p_value => l_system_type, p_parameterlist => l_parameter_list_t);
118: wf_event.AddParameterToList ( p_name => 'ACTION', p_value => p_action, p_parameterList => l_parameter_list_t);
119: wf_event.AddParameterToList ( p_name => 'END_DATE', p_value => p_end_date, p_parameterList => l_parameter_list_t);
120:
121:
122: -- get the sequence value to be added to EVENT KEY to make it unique.
123: OPEN c_seq_num;

Line 135: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pe.person_type_change',

131: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
132: END IF;
133:
134: -- raise event
135: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pe.person_type_change',
136: p_event_key => 'RESP_ASSIGNMENT'||ln_seq_val,
137: p_parameters => l_parameter_list_t
138: );
139:

Line 161: p_event in out NOCOPY wf_event_t

157:
158:
159: FUNCTION RESP_ASSIGNMENT(
160: p_subscription_guid in raw,
161: p_event in out NOCOPY wf_event_t
162: ) RETURN VARCHAR2 AS
163: /*
164: || Created By : skpandey
165: || Created On : 2-aug-2005

Line 256: l_person_id := TO_NUMBER(wf_event.getvalueforparameter('PERSON_ID',l_parameter_list_t));

252: ---------Main Start-------------------------------------------------
253: BEGIN
254:
255: l_parameter_list_t := p_event.getparameterlist;
256: l_person_id := TO_NUMBER(wf_event.getvalueforparameter('PERSON_ID',l_parameter_list_t));
257: l_system_person_type := wf_event.getvalueforparameter('S_PERSON_TYPE',l_parameter_list_t);
258: l_action := wf_event.getvalueforparameter('ACTION',l_parameter_list_t);
259: l_end_date := igs_ge_date.igsdate(igs_ge_date.igschar(wf_event.getvalueforparameter('END_DATE',l_parameter_list_t))) ;
260:

Line 257: l_system_person_type := wf_event.getvalueforparameter('S_PERSON_TYPE',l_parameter_list_t);

253: BEGIN
254:
255: l_parameter_list_t := p_event.getparameterlist;
256: l_person_id := TO_NUMBER(wf_event.getvalueforparameter('PERSON_ID',l_parameter_list_t));
257: l_system_person_type := wf_event.getvalueforparameter('S_PERSON_TYPE',l_parameter_list_t);
258: l_action := wf_event.getvalueforparameter('ACTION',l_parameter_list_t);
259: l_end_date := igs_ge_date.igsdate(igs_ge_date.igschar(wf_event.getvalueforparameter('END_DATE',l_parameter_list_t))) ;
260:
261:

Line 258: l_action := wf_event.getvalueforparameter('ACTION',l_parameter_list_t);

254:
255: l_parameter_list_t := p_event.getparameterlist;
256: l_person_id := TO_NUMBER(wf_event.getvalueforparameter('PERSON_ID',l_parameter_list_t));
257: l_system_person_type := wf_event.getvalueforparameter('S_PERSON_TYPE',l_parameter_list_t);
258: l_action := wf_event.getvalueforparameter('ACTION',l_parameter_list_t);
259: l_end_date := igs_ge_date.igsdate(igs_ge_date.igschar(wf_event.getvalueforparameter('END_DATE',l_parameter_list_t))) ;
260:
261:
262: --Get User id

Line 259: l_end_date := igs_ge_date.igsdate(igs_ge_date.igschar(wf_event.getvalueforparameter('END_DATE',l_parameter_list_t))) ;

255: l_parameter_list_t := p_event.getparameterlist;
256: l_person_id := TO_NUMBER(wf_event.getvalueforparameter('PERSON_ID',l_parameter_list_t));
257: l_system_person_type := wf_event.getvalueforparameter('S_PERSON_TYPE',l_parameter_list_t);
258: l_action := wf_event.getvalueforparameter('ACTION',l_parameter_list_t);
259: l_end_date := igs_ge_date.igsdate(igs_ge_date.igschar(wf_event.getvalueforparameter('END_DATE',l_parameter_list_t))) ;
260:
261:
262: --Get User id
263: OPEN get_user_id_cur(l_person_id);

Line 384: wf_event.setErrorInfo(p_event,'ERROR');

380: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
381: END IF;
382:
383: WF_CORE.CONTEXT('IGS_PE_ELEARNING_PKG','RESP_ASSIGNMENT',1, p_subscription_guid);
384: wf_event.setErrorInfo(p_event,'ERROR');
385:
386: END RESP_ASSIGNMENT;
387:
388: PROCEDURE TURNOFF_TCA_BE(