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