1623: */
1624:
1625: l_new_item_key := l_sch_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
1626: l_parameter_list := WF_PARAMETER_LIST_T();
1627: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
1628: p_value => l_sch_id,
1629: p_parameterlist => l_parameter_list);
1630:
1631: OPEN c_sch_det(l_sch_id);
1652: l_sys_start_time := SYSDATE;
1653: END IF;
1654:
1655: --AMS_Utility_PVT.debug_message('Raise Business event for schedule execution');
1656: WF_EVENT.Raise
1657: ( p_event_name => 'oracle.apps.ams.campaign.ExecuteSchedule',
1658: p_event_key => l_new_item_key,
1659: p_parameters => l_parameter_list,
1660: p_send_date => l_sys_start_time);
3147: -- NOTES
3148: --
3149: --
3150: -- HISTORY
3151: -- 07-may-2003 soagrawa Added to programatically raise a WF event for custom action
3152: --
3153: -- End of Comments
3154:
3155: PROCEDURE Event_Custom_action (itemtype IN VARCHAR2,
3170: aname => 'AMS_TRIGGER_ID');
3171:
3172: l_parameter_list := WF_PARAMETER_LIST_T();
3173:
3174: wf_event.AddParameterToList(p_name => 'AMS_TRIGGER_ID',
3175: p_value => l_trigger_id,
3176: p_parameterlist => l_parameter_list);
3177:
3178:
3175: p_value => l_trigger_id,
3176: p_parameterlist => l_parameter_list);
3177:
3178:
3179: Wf_Event.Raise
3180: ( p_event_name => 'oracle.apps.ams.trigger.TriggerCustomActionEvent',
3181: p_event_key => l_trigger_id || 'CUST' || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS'),
3182: p_parameters => l_parameter_list
3183: );
3229: -- NOTES
3230: --
3231: --
3232: -- HISTORY
3233: -- 07-may-2003 soagrawa Added to programatically raise a WF event for custom action
3234: --
3235: -- End of Comments
3236:
3237: PROCEDURE Event_trig_next(itemtype IN VARCHAR2,
3255: aname => 'AMS_TRIGGER_ID');
3256:
3257: l_parameter_list := WF_PARAMETER_LIST_T();
3258:
3259: wf_event.AddParameterToList(p_name => 'AMS_TRIGGER_ID',
3260: p_value => l_trigger_id,
3261: p_parameterlist => l_parameter_list);
3262:
3263: l_sch_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,
3266: );
3267:
3268: l_new_item_key := l_trigger_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
3269:
3270: Wf_Event.Raise
3271: ( p_event_name => 'oracle.apps.ams.trigger.TriggerEvent',
3272: p_event_key => l_new_item_key,
3273: p_parameters => l_parameter_list,
3274: p_send_date => l_sch_date
3326: -- NOTES
3327: --
3328: --
3329: -- HISTORY
3330: -- 07-may-2003 soagrawa Added to programatically raise a WF event for custom action
3331: -- 09 Nov-2004 anchaudh Fixed setting of WF owner for triggers WF
3332: -- 26 aug-2005 soagrawa Modified to add flexibility around initiative being monitored for R12
3333: -- End of Comments
3334: