DBA Data[Home] [Help]

APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on WF_EVENT

Line 825: l_event_t wf_event_t;

821: --Change History:
822: --Who When What
823: ----------------------------------------------------------------
824:
825: l_event_t wf_event_t;
826: l_parameter_list_t wf_parameter_list_t;
827: l_itemKey varchar2(100);
828:
829: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment

Line 856: -- initialize the wf_event_t object

852: OPEN c_seq_num;
853: FETCH c_seq_num INTO l_seq_val_screen_int_s ;
854: CLOSE c_seq_num ;
855:
856: -- initialize the wf_event_t object
857: wf_event_t.Initialize(l_event_t);
858:
859: -- Adding the parameters to the parameter list
860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);

Line 857: wf_event_t.Initialize(l_event_t);

853: FETCH c_seq_num INTO l_seq_val_screen_int_s ;
854: CLOSE c_seq_num ;
855:
856: -- initialize the wf_event_t object
857: wf_event_t.Initialize(l_event_t);
858:
859: -- Adding the parameters to the parameter list
860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);
861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);

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

856: -- initialize the wf_event_t object
857: wf_event_t.Initialize(l_event_t);
858:
859: -- Adding the parameters to the parameter list
860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);
861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);
862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);

Line 861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);

857: wf_event_t.Initialize(l_event_t);
858:
859: -- Adding the parameters to the parameter list
860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);
861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);
862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);
865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);

Line 862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);

858:
859: -- Adding the parameters to the parameter list
860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);
861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);
862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);
865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);
866: wf_event.AddParameterToList (p_name => 'P_PANEL_CODE', p_value => p_panel_code, p_parameterlist => l_parameter_list_t);

Line 863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);

859: -- Adding the parameters to the parameter list
860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);
861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);
862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);
865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);
866: wf_event.AddParameterToList (p_name => 'P_PANEL_CODE', p_value => p_panel_code, p_parameterlist => l_parameter_list_t);
867:

Line 864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);

860: wf_event.AddParameterToList (p_name => 'P_PERSON_ID',p_value=> p_person_id ,p_parameterlist => l_parameter_list_t);
861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);
862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);
865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);
866: wf_event.AddParameterToList (p_name => 'P_PANEL_CODE', p_value => p_panel_code, p_parameterlist => l_parameter_list_t);
867:
868: IF p_raised_for = 'SCREENING' THEN

Line 865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);

861: wf_event.AddParameterToList (p_name => 'P_ADMISSION_APPL_NUMBER', p_value => p_admission_appl_number, p_parameterlist => l_parameter_list_t);
862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);
865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);
866: wf_event.AddParameterToList (p_name => 'P_PANEL_CODE', p_value => p_panel_code, p_parameterlist => l_parameter_list_t);
867:
868: IF p_raised_for = 'SCREENING' THEN
869: -- Raise the Event

Line 866: wf_event.AddParameterToList (p_name => 'P_PANEL_CODE', p_value => p_panel_code, p_parameterlist => l_parameter_list_t);

862: wf_event.AddParameterToList (p_name => 'P_NOMINATED_COURSE_CD', p_value => p_nominated_course_cd, p_ParameterList => l_parameter_list_t);
863: wf_event.AddParameterToList (p_name => 'P_SEQUENCE_NUMBER', p_value => p_sequence_number, p_parameterlist => l_parameter_list_t);
864: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DECISION', p_value => p_final_screening_decision, p_parameterlist => l_parameter_list_t);
865: wf_event.AddParameterToList (p_name => 'P_FINAL_SCREENING_DATE', p_value => p_final_screening_date, p_parameterlist => l_parameter_list_t);
866: wf_event.AddParameterToList (p_name => 'P_PANEL_CODE', p_value => p_panel_code, p_parameterlist => l_parameter_list_t);
867:
868: IF p_raised_for = 'SCREENING' THEN
869: -- Raise the Event
870: -- Generate a unique value for the event key by concatenating the event name with a sequence value

Line 872: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.interview.finalscreening',

868: IF p_raised_for = 'SCREENING' THEN
869: -- Raise the Event
870: -- Generate a unique value for the event key by concatenating the event name with a sequence value
871: -- (IGS_AD_SCREEN_INT_S) and Raise the business event
872: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.interview.finalscreening',
873: p_event_key => 'FINALSCREENING' || l_seq_val_screen_int_s,
874: p_parameters => l_parameter_list_t);
875:
876: -- Deleting the Parameter list after the event is raised

Line 880: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.interview.finalinterview',

876: -- Deleting the Parameter list after the event is raised
877: l_parameter_list_t.delete;
878: ELSIF p_raised_for = 'INTERVIEW' THEN
879: -- Raise the Event
880: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.interview.finalinterview',
881: p_event_key => 'FINALINTERVIEW' || l_seq_val_screen_int_s,
882: p_parameters => l_parameter_list_t);
883:
884: -- Deleting the Parameter list after the event is raised