1 PACKAGE AMS_Trigger_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvtgrs.pls 120.1 2006/02/21 22:21:36 srivikri noship $*/
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AMS_Trigger_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API Wrapper to Call the Three Trigger APIs
11 -- It Also calls the engine API to Cancel or Start Workflow Process
12 --
13 -- Procedures:
14 --
15 -- ams_trigger_checks:
16 --
17 -- Create_Trigger (see below for specification)
18 -- Update_Trigger (see below for specification)
19 --
20 -- NOTES
21 --
22 -- HISTORY
23 -- 12/27/1999 ptendulk created
24 -- 02/17/2006 srivikri added procedure activate_trigger
25 -- End of Comments
26 --
27 -- ams_triggers
28 --
29 /*************************** PRIVATE ROUTINES *********************************/
30
31 -- Start of Comments
32 --
33 -- NAME
34 -- Create_Trigger
35 --
36 -- PURPOSE
37 -- This procedure is to create a row in ams_triggers,ams_trigger_checks,ams_trigger_actions
38 -- table that satisfy caller needs
39 --
40 -- NOTES
41 --
42 --
43 -- HISTORY
44 -- 07/26/1999 ptendulk Created
45 -- 10/25/1999 ptendulk Modified according to new standards
46 -- 15-Feb-2001 ptendulk Modified as trigger actions table will not be used anymore.
47 -- End of Comments
48
49 PROCEDURE Create_Trigger
50 ( p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58
59 -- p_create_type IN VARCHAR2 := 'ALL' ,
60 p_trig_Rec IN Ams_Trig_pvt.trig_rec_type,
61 p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,
62 p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type ,
63
64 x_trigger_check_id OUT NOCOPY NUMBER,
65 x_trigger_action_id OUT NOCOPY NUMBER,
66 x_trigger_id OUT NOCOPY NUMBER
67 );
68
69 /*****************************************************************************************/
70 -- Start of Comments
71 --
72 -- NAME
73 -- Update_Trigger
74 --
75 -- PURPOSE
76 -- This procedure is to update a ams_triggers,ams_trigger_checks,ams_trigger_actions table
77 -- that satisfy caller needs . It will also Call the Cancel Workflow Process
78 --
79 -- NOTES
80 --
81 --
82 -- HISTORY
83 -- 12/27/1999 ptendulk created
84 -- End of Comments
85
86 PROCEDURE Update_Trigger
87 ( p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95
96 p_trig_rec IN Ams_Trig_pvt.trig_rec_type,
97 p_thldchk_rec IN Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,
98 p_thldact_rec IN Ams_Thldact_pvt.thldact_rec_type
99 -- p_updt_type IN VARCHAR2
100
101 ) ;
102
103
104 -- Start of Comments
105 --
106 -- NAME
107 -- Activate_Trigger
108 --
109 -- PURPOSE
110 -- This procedure is to activate the monitor and kick off the workflow process for monitoring the
111 -- performance of initiative
112 --
113 -- HISTORY
114 -- srivikri 17-Feb-2006 Created
115 --
116 -- End of Comments
117
118 PROCEDURE Activate_Trigger
119 ( p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121 p_commit IN VARCHAR2 := FND_API.G_FALSE,
122
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126
127 p_trigger_id IN NUMBER
128 );
129
130 END AMS_Trigger_PVT;