eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMS_TRIGGER_PKG

Source


1 PACKAGE AMS_TRIGGER_PKG AUTHID CURRENT_USER AS
2 /* $Header: amsttrgs.pls 115.2 2002/11/16 01:45:06 dbiswas ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --      AMS_TRIGGER_PKG
7 -- Purpose
8 --      Table api for Triggers.
9 -- History
10 --      16-apr-2002    soagrawa     Created
11 --      16-apr-2002    soagrawa     Added add_language for bug# 2323843
12 --      12-jun-2002    soagrawa     Added insert_row, update_row, delete_row, lock_row
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 
18 
19  PROCEDURE Insert_Row(
20            px_trigger_id   IN OUT NOCOPY NUMBER,
21            p_last_update_date    DATE,
22            p_last_updated_by    NUMBER,
23            p_creation_date    DATE,
24            p_created_by    NUMBER,
25            p_last_update_login    NUMBER,
26            px_object_version_number   IN OUT NOCOPY NUMBER,
27            p_process_id    NUMBER,
28            p_trigger_created_for_id    NUMBER,
29            p_arc_trigger_created_for    VARCHAR2,
30            p_triggering_type    VARCHAR2,
31            p_trigger_name    VARCHAR2,
32            p_view_application_id    NUMBER,
33            p_start_date_time    DATE,
34            p_last_run_date_time    DATE,
35            p_next_run_date_time    DATE,
36            p_repeat_daily_start_time    DATE,
37            p_repeat_daily_end_time    DATE,
38            p_repeat_frequency_type    VARCHAR2,
39            p_repeat_every_x_frequency    NUMBER,
40            p_repeat_stop_date_time    DATE,
41            p_metrics_refresh_type    VARCHAR2,
42            p_description    VARCHAR2,
43            p_timezone_id    NUMBER,
44            p_user_start_date_time    DATE,
45            p_user_last_run_date_time    DATE,
46            p_user_next_run_date_time    DATE,
47            p_user_repeat_daily_start_time    DATE,
48            p_user_repeat_daily_end_time    DATE,
49            p_user_repeat_stop_date_time    DATE,
50            p_security_group_id    NUMBER);
51 
52  PROCEDURE Update_Row(
53            p_trigger_id    NUMBER,
54            p_last_update_date    DATE,
55            p_last_updated_by    NUMBER,
56            p_creation_date    DATE,
57            p_created_by    NUMBER,
58            p_last_update_login    NUMBER,
59            p_object_version_number    NUMBER,
60            p_process_id    NUMBER,
61            p_trigger_created_for_id    NUMBER,
62            p_arc_trigger_created_for    VARCHAR2,
63            p_triggering_type    VARCHAR2,
64            p_trigger_name    VARCHAR2,
65            p_view_application_id    NUMBER,
66            p_start_date_time    DATE,
67            p_last_run_date_time    DATE,
68            p_next_run_date_time    DATE,
69            p_repeat_daily_start_time    DATE,
70            p_repeat_daily_end_time    DATE,
71            p_repeat_frequency_type    VARCHAR2,
72            p_repeat_every_x_frequency    NUMBER,
73            p_repeat_stop_date_time    DATE,
74            p_metrics_refresh_type    VARCHAR2,
75            p_description    VARCHAR2,
76            p_timezone_id    NUMBER,
77            p_user_start_date_time    DATE,
78            p_user_last_run_date_time    DATE,
79            p_user_next_run_date_time    DATE,
80            p_user_repeat_daily_start_time    DATE,
81            p_user_repeat_daily_end_time    DATE,
82            p_user_repeat_stop_date_time    DATE,
83            p_security_group_id    NUMBER);
84 
85  PROCEDURE Delete_Row(
86      p_TRIGGER_ID  NUMBER);
87 
88  PROCEDURE Lock_Row(
89            p_trigger_id    NUMBER,
90            p_last_update_date    DATE,
91            p_last_updated_by    NUMBER,
92            p_creation_date    DATE,
93            p_created_by    NUMBER,
94            p_last_update_login    NUMBER,
95            p_object_version_number    NUMBER,
96            p_process_id    NUMBER,
97            p_trigger_created_for_id    NUMBER,
98            p_arc_trigger_created_for    VARCHAR2,
99            p_triggering_type    VARCHAR2,
100            p_trigger_name    VARCHAR2,
101            p_view_application_id    NUMBER,
102            p_start_date_time    DATE,
103            p_last_run_date_time    DATE,
104            p_next_run_date_time    DATE,
105            p_repeat_daily_start_time    DATE,
106            p_repeat_daily_end_time    DATE,
107            p_repeat_frequency_type    VARCHAR2,
108            p_repeat_every_x_frequency    NUMBER,
109            p_repeat_stop_date_time    DATE,
110            p_metrics_refresh_type    VARCHAR2,
111            p_description    VARCHAR2,
112            p_timezone_id    NUMBER,
113            p_user_start_date_time    DATE,
114            p_user_last_run_date_time    DATE,
115            p_user_next_run_date_time    DATE,
116            p_user_repeat_daily_start_time    DATE,
117            p_user_repeat_daily_end_time    DATE,
118            p_user_repeat_stop_date_time    DATE,
119            p_security_group_id    NUMBER);
120 
121 
122 
123 
124 
125 -- ===============================================================
126 -- Start of Comments
127 -- Procedure name
128 --      ADD_LANGUAGE
129 -- Purpose
130 --
131 -- History
132 --      16-apr-2002    soagrawa     Created. Refer to bug# 2323843.
133 -- NOTE
134 --
135 -- End of Comments
136 -- ===============================================================
137 
138 PROCEDURE ADD_LANGUAGE;
139 
140 
141 END AMS_TRIGGER_PKG;