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

Line 27: l_event_t wf_event_t;

23: Who When What
24: ******************************************************************/
25:
26:
27: l_event_t wf_event_t;
28: l_parameter_list_t wf_parameter_list_t;
29: l_itemKey varchar2(100);
30: ln_seq_val NUMBER;
31:

Line 52: -- initialize the wf_event_t object

48: CLOSE c_seq_num ;
49:
50:
51: --
52: -- initialize the wf_event_t object
53: --
54:
55: wf_event_t.Initialize(l_event_t);
56:

Line 55: wf_event_t.Initialize(l_event_t);

51: --
52: -- initialize the wf_event_t object
53: --
54:
55: wf_event_t.Initialize(l_event_t);
56:
57:
58:
59: --

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

60: -- Adding the parameters to the parameter list
61: --
62:
63:
64: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

Line 65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);

61: --
62:
63:
64: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

Line 66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);

62:
63:
64: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

Line 67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);

63:
64: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);

Line 68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

64: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);

Line 69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

65: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
73: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.approve_otcm', p_parameterlist => l_parameter_list_t);

Line 70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

66: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
73: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.approve_otcm', p_parameterlist => l_parameter_list_t);
74:

Line 71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);

67: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
73: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.approve_otcm', p_parameterlist => l_parameter_list_t);
74:
75: -- Raise the Event

Line 72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);

68: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
73: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.approve_otcm', p_parameterlist => l_parameter_list_t);
74:
75: -- Raise the Event
76:

Line 73: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.approve_otcm', p_parameterlist => l_parameter_list_t);

69: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
70: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
71: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
72: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
73: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.approve_otcm', p_parameterlist => l_parameter_list_t);
74:
75: -- Raise the Event
76:
77:

Line 78: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.approve_otcm' ,

74:
75: -- Raise the Event
76:
77:
78: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.approve_otcm' ,
79: p_event_key => 'PR001'||ln_seq_val,
80: p_parameters => l_parameter_list_t);
81:
82: --

Line 111: l_event_t wf_event_t;

107: Who When What
108: ******************************************************************/
109:
110:
111: l_event_t wf_event_t;
112: l_parameter_list_t wf_parameter_list_t;
113: l_itemKey varchar2(100);
114: ln_seq_val NUMBER;
115:

Line 137: -- initialize the wf_event_t object

133: CLOSE c_seq_num ;
134:
135:
136: --
137: -- initialize the wf_event_t object
138: --
139:
140: wf_event_t.Initialize(l_event_t);
141:

Line 140: wf_event_t.Initialize(l_event_t);

136: --
137: -- initialize the wf_event_t object
138: --
139:
140: wf_event_t.Initialize(l_event_t);
141:
142:
143:
144: --

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

144: --
145: -- Adding the parameters to the parameter list
146: --
147:
148: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

Line 149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);

145: -- Adding the parameters to the parameter list
146: --
147:
148: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

Line 150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);

146: --
147:
148: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

Line 151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);

147:
148: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);

Line 152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

148: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);
156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

Line 153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

149: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);
156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
157: -- Raise the Event

Line 154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

150: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);
156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
157: -- Raise the Event
158:

Line 155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);

151: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);
156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
157: -- Raise the Event
158:
159:

Line 156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

152: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
153: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
154: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
155: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_positive_otcm', p_parameterlist => l_parameter_list_t);
156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
157: -- Raise the Event
158:
159:
160: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.apply_positive_otcm' ,

Line 160: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.apply_positive_otcm' ,

156: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
157: -- Raise the Event
158:
159:
160: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.apply_positive_otcm' ,
161: p_event_key => 'PR001'||ln_seq_val,
162: p_parameters => l_parameter_list_t);
163:
164:

Line 197: l_event_t wf_event_t;

193: Who When What
194: ******************************************************************/
195:
196:
197: l_event_t wf_event_t;
198: l_parameter_list_t wf_parameter_list_t;
199: l_itemKey varchar2(100);
200: ln_seq_val NUMBER;
201:

Line 223: -- initialize the wf_event_t object

219: CLOSE c_seq_num ;
220:
221:
222: --
223: -- initialize the wf_event_t object
224: --
225:
226: wf_event_t.Initialize(l_event_t);
227:

Line 226: wf_event_t.Initialize(l_event_t);

222: --
223: -- initialize the wf_event_t object
224: --
225:
226: wf_event_t.Initialize(l_event_t);
227:
228:
229:
230: --

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

230: --
231: -- Adding the parameters to the parameter list
232: --
233:
234: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

Line 235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);

231: -- Adding the parameters to the parameter list
232: --
233:
234: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

Line 236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);

232: --
233:
234: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);

Line 237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);

233:
234: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);

Line 238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

234: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

Line 239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

235: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);

Line 240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);

236: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);
244: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

Line 241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);

237: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);
244: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
245:

Line 242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

238: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);
244: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
245:
246: -- Raise the Event

Line 243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);

239: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);
244: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
245:
246: -- Raise the Event
247:

Line 244: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

240: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_EXPIRY_DT', p_Value => p_appeal_expiry_dt, p_parameterlist => l_parameter_list_t);
241: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_EXPIRY_DT', p_Value => p_show_cause_expiry_dt, p_parameterlist => l_parameter_list_t);
242: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
243: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.apply_otcm', p_parameterlist => l_parameter_list_t);
244: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
245:
246: -- Raise the Event
247:
248:

Line 249: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.apply_otcm' ,

245:
246: -- Raise the Event
247:
248:
249: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.apply_otcm' ,
250: p_event_key => 'PR001'||ln_seq_val,
251: p_parameters => l_parameter_list_t);
252:
253:

Line 287: l_event_t wf_event_t;

283: Who When What
284: ******************************************************************/
285:
286:
287: l_event_t wf_event_t;
288: l_parameter_list_t wf_parameter_list_t;
289: l_itemKey varchar2(100);
290: ln_seq_val NUMBER;
291:

Line 313: -- initialize the wf_event_t object

309: CLOSE c_seq_num ;
310:
311:
312: --
313: -- initialize the wf_event_t object
314: --
315:
316: wf_event_t.Initialize(l_event_t);
317:

Line 316: wf_event_t.Initialize(l_event_t);

312: --
313: -- initialize the wf_event_t object
314: --
315:
316: wf_event_t.Initialize(l_event_t);
317:
318:
319:
320: --

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

320: --
321: -- Adding the parameters to the parameter list
322: --
323:
324: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

Line 325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);

321: -- Adding the parameters to the parameter list
322: --
323:
324: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

Line 326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);

322: --
323:
324: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

Line 327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);

323:
324: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

Line 328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

324: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);

Line 329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

325: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);

Line 330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

326: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);
334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);

Line 331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

327: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);
334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);
335: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.showcause_uph_dsm', p_parameterlist => l_parameter_list_t);

Line 332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);

328: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);
334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);
335: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.showcause_uph_dsm', p_parameterlist => l_parameter_list_t);
336:

Line 333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);

329: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);
334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);
335: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.showcause_uph_dsm', p_parameterlist => l_parameter_list_t);
336:
337: -- Raise the Event

Line 334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);

330: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);
334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);
335: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.showcause_uph_dsm', p_parameterlist => l_parameter_list_t);
336:
337: -- Raise the Event
338:

Line 335: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.showcause_uph_dsm', p_parameterlist => l_parameter_list_t);

331: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
332: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_DT', p_Value => p_show_cause_dt, p_parameterlist => l_parameter_list_t);
333: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_DT', p_Value => p_show_cause_outcome_dt, p_parameterlist => l_parameter_list_t);
334: wf_event.AddParameterToList ( p_Name => 'IA_SHOW_CAUSE_OUTCOME_TYPE', p_Value => p_show_cause_outcome_type, p_parameterlist => l_parameter_list_t);
335: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.showcause_uph_dsm', p_parameterlist => l_parameter_list_t);
336:
337: -- Raise the Event
338:
339:

Line 340: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.showcause_uph_dsm' ,

336:
337: -- Raise the Event
338:
339:
340: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.showcause_uph_dsm' ,
341: p_event_key => 'PR001'||ln_seq_val,
342: p_parameters => l_parameter_list_t);
343:
344:

Line 378: l_event_t wf_event_t;

374: Who When What
375: ******************************************************************/
376:
377:
378: l_event_t wf_event_t;
379: l_parameter_list_t wf_parameter_list_t;
380: l_itemKey varchar2(100);
381: ln_seq_val NUMBER;
382:

Line 404: -- initialize the wf_event_t object

400: CLOSE c_seq_num ;
401:
402:
403: --
404: -- initialize the wf_event_t object
405: --
406:
407: wf_event_t.Initialize(l_event_t);
408:

Line 407: wf_event_t.Initialize(l_event_t);

403: --
404: -- initialize the wf_event_t object
405: --
406:
407: wf_event_t.Initialize(l_event_t);
408:
409:
410:
411: --

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

411: --
412: -- Adding the parameters to the parameter list
413: --
414:
415: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

Line 416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);

412: -- Adding the parameters to the parameter list
413: --
414:
415: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

Line 417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);

413: --
414:
415: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

Line 418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);

414:
415: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

Line 419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

415: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);

Line 420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

416: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);

Line 421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

417: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);

Line 422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

418: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);

Line 423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);

419: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);
427: -- Raise the Event

Line 424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);

420: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);
427: -- Raise the Event
428:

Line 425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);

421: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);
427: -- Raise the Event
428:
429:

Line 426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);

422: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
423: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_DT', p_Value => p_appeal_dt, p_parameterlist => l_parameter_list_t);
424: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_DT', p_Value => p_appeal_outcome_dt, p_parameterlist => l_parameter_list_t);
425: wf_event.AddParameterToList ( p_Name => 'IA_APPEAL_OUTCOME_TYPE', p_Value => p_appeal_outcome_type, p_parameterlist => l_parameter_list_t);
426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);
427: -- Raise the Event
428:
429:
430: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.appeal_uph_dsm' ,

Line 430: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.appeal_uph_dsm' ,

426: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.appeal_uph_dsm', p_parameterlist => l_parameter_list_t);
427: -- Raise the Event
428:
429:
430: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.appeal_uph_dsm' ,
431: p_event_key => 'PR001'||ln_seq_val,
432: p_parameters => l_parameter_list_t);
433:
434:

Line 464: l_event_t wf_event_t;

460: Who When What
461: ******************************************************************/
462:
463:
464: l_event_t wf_event_t;
465: l_parameter_list_t wf_parameter_list_t;
466: l_itemKey varchar2(100);
467: ln_seq_val NUMBER;
468:

Line 490: -- initialize the wf_event_t object

486: CLOSE c_seq_num ;
487:
488:
489: --
490: -- initialize the wf_event_t object
491: --
492:
493: wf_event_t.Initialize(l_event_t);
494:

Line 493: wf_event_t.Initialize(l_event_t);

489: --
490: -- initialize the wf_event_t object
491: --
492:
493: wf_event_t.Initialize(l_event_t);
494:
495:
496:
497: --

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

497: --
498: -- Adding the parameters to the parameter list
499: --
500:
501: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

Line 502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);

498: -- Adding the parameters to the parameter list
499: --
500:
501: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

Line 503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);

499: --
500:
501: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

Line 504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);

500:
501: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);

Line 505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);

501: wf_event.AddParameterToList ( p_name => 'IA_PERSON_ID',p_value=>p_person_id,p_parameterlist=>l_parameter_list_t);
502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);
509: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

Line 506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);

502: wf_event.AddParameterToList ( p_Name => 'IA_COURSE_CD', p_Value => p_course_cd, p_parameterlist => l_parameter_list_t);
503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);
509: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
510:

Line 507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);

503: wf_event.AddParameterToList ( p_Name => 'IA_SEQUENCE_NUMBER', p_Value => p_sequence_number, p_parameterlist => l_parameter_list_t);
504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);
509: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
510:
511:

Line 508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);

504: wf_event.AddParameterToList ( p_Name => 'IA_DECISION_STATUS', p_Value => p_decision_status, p_parameterlist => l_parameter_list_t);
505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);
509: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
510:
511:
512: -- Raise the Event

Line 509: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);

505: wf_event.AddParameterToList ( p_name => 'IA_DECISION_DT',p_value=>p_decision_dt,p_parameterlist=>l_parameter_list_t);
506: wf_event.AddParameterToList ( p_Name => 'IA_PROGRESSION_OUTCOME_TYPE', p_Value => p_progression_outcome_type, p_parameterlist => l_parameter_list_t);
507: wf_event.AddParameterToList ( p_Name => 'IA_APPLIED_DT', p_Value => p_applied_dt, p_parameterlist => l_parameter_list_t);
508: wf_event.AddParameterToList ( p_Name => 'IA_EVENT_NAME', p_Value => 'oracle.apps.igs.pr.remove_waive_cancel_otcm', p_parameterlist => l_parameter_list_t);
509: wf_event.AddParameterToList ( p_Name => 'IA_DESCRIPTION', p_Value => p_description, p_parameterlist => l_parameter_list_t);
510:
511:
512: -- Raise the Event
513:

Line 515: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.remove_waive_cancel_otcm' ,

511:
512: -- Raise the Event
513:
514:
515: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.remove_waive_cancel_otcm' ,
516: p_event_key => 'PR001'||ln_seq_val,
517: p_parameters => l_parameter_list_t);
518:
519: