DBA Data[Home] [Help]

APPS.IGS_FI_WAV_DTLS_WF dependencies on WF_EVENT

Line 106: wf_event.AddParameterToList(p_name => 'PERSON_ID',

102: OPEN cur_alt_person_id(c_n_person_id => p_n_person_id);
103: FETCH cur_alt_person_id INTO l_cur_alt_person_id;
104: CLOSE cur_alt_person_id;
105: --Creation of paramter List
106: wf_event.AddParameterToList(p_name => 'PERSON_ID',
107: p_value => p_n_person_id,
108: p_parameterlist=> l_parameter_list);
109:
110: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',

Line 110: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',

106: wf_event.AddParameterToList(p_name => 'PERSON_ID',
107: p_value => p_n_person_id,
108: p_parameterlist=> l_parameter_list);
109:
110: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',
111: p_value => l_cur_person_details.person_number,
112: p_parameterlist=> l_parameter_list);
113:
114: wf_event.AddParameterToList(p_name => 'PERSON_NAME',

Line 114: wf_event.AddParameterToList(p_name => 'PERSON_NAME',

110: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',
111: p_value => l_cur_person_details.person_number,
112: p_parameterlist=> l_parameter_list);
113:
114: wf_event.AddParameterToList(p_name => 'PERSON_NAME',
115: p_value => l_cur_person_details.full_name,
116: p_parameterlist=> l_parameter_list);
117:
118: wf_event.AddParameterToList(p_name => 'PERSON_ID_TYPE',

Line 118: wf_event.AddParameterToList(p_name => 'PERSON_ID_TYPE',

114: wf_event.AddParameterToList(p_name => 'PERSON_NAME',
115: p_value => l_cur_person_details.full_name,
116: p_parameterlist=> l_parameter_list);
117:
118: wf_event.AddParameterToList(p_name => 'PERSON_ID_TYPE',
119: p_value => l_cur_alt_person_id.person_id_type,
120: p_parameterlist=> l_parameter_list);
121:
122: wf_event.AddParameterToList(p_name => 'ALTERNATE_ID',

Line 122: wf_event.AddParameterToList(p_name => 'ALTERNATE_ID',

118: wf_event.AddParameterToList(p_name => 'PERSON_ID_TYPE',
119: p_value => l_cur_alt_person_id.person_id_type,
120: p_parameterlist=> l_parameter_list);
121:
122: wf_event.AddParameterToList(p_name => 'ALTERNATE_ID',
123: p_value => l_cur_alt_person_id.api_person_id,
124: p_parameterlist=> l_parameter_list);
125:
126: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',

Line 126: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',

122: wf_event.AddParameterToList(p_name => 'ALTERNATE_ID',
123: p_value => l_cur_alt_person_id.api_person_id,
124: p_parameterlist=> l_parameter_list);
125:
126: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',
127: p_value => p_v_waiver_name,
128: p_parameterlist=> l_parameter_list);
129:
130: wf_event.AddParameterToList(p_name => 'LOAD_CAL_TYPE',

Line 130: wf_event.AddParameterToList(p_name => 'LOAD_CAL_TYPE',

126: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',
127: p_value => p_v_waiver_name,
128: p_parameterlist=> l_parameter_list);
129:
130: wf_event.AddParameterToList(p_name => 'LOAD_CAL_TYPE',
131: p_value => l_c_load_cal_type,
132: p_parameterlist=> l_parameter_list);
133:
134: wf_event.AddParameterToList(p_name => 'LOAD_CI_SEQUENCE_NUMBER',

Line 134: wf_event.AddParameterToList(p_name => 'LOAD_CI_SEQUENCE_NUMBER',

130: wf_event.AddParameterToList(p_name => 'LOAD_CAL_TYPE',
131: p_value => l_c_load_cal_type,
132: p_parameterlist=> l_parameter_list);
133:
134: wf_event.AddParameterToList(p_name => 'LOAD_CI_SEQUENCE_NUMBER',
135: p_value => l_n_load_ci_seq_number,
136: p_parameterlist=> l_parameter_list);
137:
138: wf_event.AddParameterToList(p_name => 'LOAD_CAL_DESC',

Line 138: wf_event.AddParameterToList(p_name => 'LOAD_CAL_DESC',

134: wf_event.AddParameterToList(p_name => 'LOAD_CI_SEQUENCE_NUMBER',
135: p_value => l_n_load_ci_seq_number,
136: p_parameterlist=> l_parameter_list);
137:
138: wf_event.AddParameterToList(p_name => 'LOAD_CAL_DESC',
139: p_value => l_v_load_description,
140: p_parameterlist=> l_parameter_list);
141:
142: wf_event.AddParameterToList(p_name => 'WAIVER_AMOUNT',

Line 142: wf_event.AddParameterToList(p_name => 'WAIVER_AMOUNT',

138: wf_event.AddParameterToList(p_name => 'LOAD_CAL_DESC',
139: p_value => l_v_load_description,
140: p_parameterlist=> l_parameter_list);
141:
142: wf_event.AddParameterToList(p_name => 'WAIVER_AMOUNT',
143: p_value => igs_fi_gen_gl.get_formatted_amount(p_n_waiver_amount),
144: p_parameterlist=> l_parameter_list);
145:
146: wf_event.AddParameterToList(p_name => 'TRANSACTION_DATE',

Line 146: wf_event.AddParameterToList(p_name => 'TRANSACTION_DATE',

142: wf_event.AddParameterToList(p_name => 'WAIVER_AMOUNT',
143: p_value => igs_fi_gen_gl.get_formatted_amount(p_n_waiver_amount),
144: p_parameterlist=> l_parameter_list);
145:
146: wf_event.AddParameterToList(p_name => 'TRANSACTION_DATE',
147: p_value => TRUNC(sysdate),
148: p_parameterlist=> l_parameter_list);
149:
150: wf_event.AddParameterToList(p_name => 'P_FIN_AID_ADMIN',

Line 150: wf_event.AddParameterToList(p_name => 'P_FIN_AID_ADMIN',

146: wf_event.AddParameterToList(p_name => 'TRANSACTION_DATE',
147: p_value => TRUNC(sysdate),
148: p_parameterlist=> l_parameter_list);
149:
150: wf_event.AddParameterToList(p_name => 'P_FIN_AID_ADMIN',
151: p_value => NVL(FND_PROFILE.VALUE('IGS_FI_WAV_NOTIFY_USER'),'SYSADMIN'),
152: p_parameterlist=> l_parameter_list);
153: --Call out to generate the sequence number
154: OPEN c_seq_num;

Line 158: wf_event.raise( p_event_name => lv_raise_event,

154: OPEN c_seq_num;
155: FETCH c_seq_num INTO ln_seq_val ;
156: CLOSE c_seq_num ;
157: --Raising the Bussiness event
158: wf_event.raise( p_event_name => lv_raise_event,
159: p_event_key => 'WTRANTOFA' || ln_seq_val,
160: p_parameters => l_parameter_list);
161: --Deleting the parameter List
162: l_parameter_list.DELETE;

Line 203: wf_event.AddParameterToList(p_name => 'PERSON_ID',

199: OPEN cur_person_details(c_n_person_id => p_n_person_id);
200: FETCH cur_person_details INTO l_cur_person_details;
201: CLOSE cur_person_details;
202: --Creation of paramter List
203: wf_event.AddParameterToList(p_name => 'PERSON_ID',
204: p_value => p_n_person_id,
205: p_parameterlist=> l_parameter_list);
206:
207: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',

Line 207: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',

203: wf_event.AddParameterToList(p_name => 'PERSON_ID',
204: p_value => p_n_person_id,
205: p_parameterlist=> l_parameter_list);
206:
207: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',
208: p_value => l_cur_person_details.person_number,
209: p_parameterlist=> l_parameter_list);
210:
211: wf_event.AddParameterToList(p_name => 'PERSON_NAME',

Line 211: wf_event.AddParameterToList(p_name => 'PERSON_NAME',

207: wf_event.AddParameterToList(p_name => 'PERSON_NUMBER',
208: p_value => l_cur_person_details.person_number,
209: p_parameterlist=> l_parameter_list);
210:
211: wf_event.AddParameterToList(p_name => 'PERSON_NAME',
212: p_value => l_cur_person_details.full_name,
213: p_parameterlist=> l_parameter_list);
214:
215: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',

Line 215: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',

211: wf_event.AddParameterToList(p_name => 'PERSON_NAME',
212: p_value => l_cur_person_details.full_name,
213: p_parameterlist=> l_parameter_list);
214:
215: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',
216: p_value => p_v_waiver_name,
217: p_parameterlist=> l_parameter_list);
218:
219: wf_event.AddParameterToList(p_name => 'FEE_CAL_TYPE',

Line 219: wf_event.AddParameterToList(p_name => 'FEE_CAL_TYPE',

215: wf_event.AddParameterToList(p_name => 'WAIVER_NAME',
216: p_value => p_v_waiver_name,
217: p_parameterlist=> l_parameter_list);
218:
219: wf_event.AddParameterToList(p_name => 'FEE_CAL_TYPE',
220: p_value => p_c_fee_cal_type,
221: p_parameterlist=> l_parameter_list);
222:
223: wf_event.AddParameterToList(p_name => 'FEE_CI_SEQUENCE_NUMBER',

Line 223: wf_event.AddParameterToList(p_name => 'FEE_CI_SEQUENCE_NUMBER',

219: wf_event.AddParameterToList(p_name => 'FEE_CAL_TYPE',
220: p_value => p_c_fee_cal_type,
221: p_parameterlist=> l_parameter_list);
222:
223: wf_event.AddParameterToList(p_name => 'FEE_CI_SEQUENCE_NUMBER',
224: p_value => p_n_fee_ci_seq_number,
225: p_parameterlist=> l_parameter_list);
226:
227: OPEN c_seq_num;

Line 231: wf_event.raise( p_event_name => lv_raise_event,

227: OPEN c_seq_num;
228: FETCH c_seq_num INTO ln_seq_val ;
229: CLOSE c_seq_num ;
230: --Raising the Bussiness event
231: wf_event.raise( p_event_name => lv_raise_event,
232: p_event_key => 'WAVASSGN' || ln_seq_val,
233: p_parameters => l_parameter_list);
234: --Deleting the parameter List
235: l_parameter_list.DELETE;