608: l_application_name igf_ap_appl_setup_all.application_name%TYPE;
609:
610: l_seq_val NUMBER;
611:
612: l_wf_event_t WF_EVENT_T;
613: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
614: lv_event_name VARCHAR2(4000);
615:
616: BEGIN
629: CLOSE c_application_name;
630:
631: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val FROM DUAL;
632:
633: -- Initialize the wf_event_t object
634: WF_EVENT_T.Initialize(l_wf_event_t);
635: -- Set the event name
636: lv_event_name := 'oracle.apps.igf.ap.InstAppSubmitted';
637:
630:
631: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val FROM DUAL;
632:
633: -- Initialize the wf_event_t object
634: WF_EVENT_T.Initialize(l_wf_event_t);
635: -- Set the event name
636: lv_event_name := 'oracle.apps.igf.ap.InstAppSubmitted';
637:
638: l_wf_event_t.setEventName(pEventName => lv_event_name);
634: WF_EVENT_T.Initialize(l_wf_event_t);
635: -- Set the event name
636: lv_event_name := 'oracle.apps.igf.ap.InstAppSubmitted';
637:
638: l_wf_event_t.setEventName(pEventName => lv_event_name);
639:
640: -- Set the event key
641: l_wf_event_t.setEventKey(
642: pEventKey => lv_event_name || l_seq_val
637:
638: l_wf_event_t.setEventName(pEventName => lv_event_name);
639:
640: -- Set the event key
641: l_wf_event_t.setEventKey(
642: pEventKey => lv_event_name || l_seq_val
643: );
644:
645: -- Set the parameter list
642: pEventKey => lv_event_name || l_seq_val
643: );
644:
645: -- Set the parameter list
646: l_wf_event_t.setParameterList(
647: pParameterList => l_wf_parameter_list_t
648: );
649:
650: -- Set the message's subject
649:
650: -- Set the message's subject
651: fnd_message.set_name('IGF','IGF_AP_INSTAPPSUBMITTED_SUBJ');
652:
653: wf_event.addparametertolist(
654: p_name => 'SUBJECT',
655: p_value => 'IGF_AP_INSTAPPSUBMITTED_SUBJ', --fnd_message.get,
656: p_parameterlist => l_wf_parameter_list_t
657: );
656: p_parameterlist => l_wf_parameter_list_t
657: );
658:
659: -- Set the person number
660: wf_event.addparametertolist(
661: p_name => 'STUDENT_NUMBER',
662: p_value => l_person_number,
663: p_parameterlist => l_wf_parameter_list_t
664: );
663: p_parameterlist => l_wf_parameter_list_t
664: );
665:
666: -- Set the to do item description
667: wf_event.addparametertolist(
668: p_name => 'APPLICATION_NAME',
669: p_value => l_application_name,
670: p_parameterlist => l_wf_parameter_list_t
671: );
670: p_parameterlist => l_wf_parameter_list_t
671: );
672:
673: -- Set the award year alternate code
674: wf_event.addparametertolist(
675: p_name => 'AWARD_YEAR',
676: p_value => l_alternate_code,
677: p_parameterlist => l_wf_parameter_list_t
678: );
676: p_value => l_alternate_code,
677: p_parameterlist => l_wf_parameter_list_t
678: );
679:
680: wf_Event.raise(
681: p_event_name => lv_event_name,
682: p_event_key => lv_event_name || l_seq_val,
683: p_parameters => l_wf_parameter_list_t
684: );