[Home] [Help]
41: -- NAME
42: -- Create_Trigger
43: --
44: -- PURPOSE
45: -- This procedure is to create a row in ams_triggers,ams_trigger_checks,ams_trigger_actions
46: -- table that satisfy caller needs
47: --
48: -- NOTES
49: -- As soon as the Trigger is created Start the Workflow Process
59: -- 3. Commented workflow call.
60: -- 04/04/2001 soagrawa Now calling create_trigger instead of update_trigger.
61: -- Also, the API now returns trigger_id of the trigger created
62: -- 13/jun/03 cgoyal modified create trigger method to create a row in the table
63: -- ams_trigger_actions for 11.5.8 backport
64: -- End of Comments
65:
66: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
422: -- NAME
423: -- Update_Trigger
424: --
425: -- PURPOSE
426: -- This procedure is to update a ams_triggers,ams_trigger_checks,ams_trigger_actions table
427: -- that satisfy caller needs . It will also Call the Cancel Workflow Process
428: --
429: -- NOTES
430: -- As soon as the Trigger is modied Abort the Workflow Process and Submit the new one
436: -- 15-Feb-2001 ptendulk Modified 1. trigger action table won't be used since Hornet
437: -- 2. Check will be mandatory so removed p_create_type para.
438: -- 3. Commented workflow call to abort and start.
439: -- 22/apr/03 cgoyal modified update trigger method to update the table
440: -- ams_trigger_actions for 11.5.8 backport
441: -- End of Comments
442:
443: PROCEDURE Update_Trigger
444: ( p_api_version IN NUMBER,
477: WHERE trigger_id = l_my_trig_id;
478:
479: CURSOR c_actions_det (p_my_trig_id IN number, p_action_type IN VARCHAR2) IS
480: SELECT trigger_action_id, object_version_number
481: FROM ams_trigger_Actions
482: WHERE trigger_id = p_my_trig_id
483: AND execute_Action_type = p_action_type;
484:
485: l_notify_flag VARCHAR2(1);