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.AMW_SETUP_RISK_TYPES_PKG

Source


1 PACKAGE AMW_SETUP_RISK_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: amwtrtps.pls 120.2 2006/08/23 19:05:46 npanandi noship $ */
3 
4 
5 -- ===============================================================
6 -- Package name
7 --          AMW_SETUP_RISK_TYPES_PKG
8 -- Purpose
9 --
10 -- History
11 -- 		  	07/06/2004    tsho     Creates
12 -- ===============================================================
13 
14 
15 -- ===============================================================
16 -- Procedure name
17 --          INSERT_ROW
18 -- Purpose
19 -- 		  	create new compliance environment
20 --          in AMW_SETUP_RISK_TYPES_B and AMW_SETUP_RISK_TYPES_TL
21 -- ===============================================================
22 procedure INSERT_ROW (
23   X_ROWID in out nocopy VARCHAR2,
24   X_SETUP_RISK_TYPE_ID in NUMBER,
25   X_RISK_TYPE_CODE in VARCHAR2,
26   X_PARENT_SETUP_RISK_TYPE_ID in NUMBER,
27   X_START_DATE in DATE,
28   X_END_DATE in DATE,
29   X_LAST_UPDATED_BY in NUMBER,
30   X_LAST_UPDATE_DATE in DATE,
31   X_CREATED_BY in NUMBER,
32   X_CREATION_DATE in DATE,
33   X_LAST_UPDATE_LOGIN in NUMBER,
34   X_SECURITY_GROUP_ID in NUMBER,
35   X_OBJECT_VERSION_NUMBER in NUMBER,
36   X_TAG in VARCHAR2,
37   X_SETUP_RISK_TYPE_NAME in VARCHAR2,
38   X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2);
39 
40 
41 
42 -- ===============================================================
43 -- Procedure name
44 --          LOCK_ROW
45 -- Purpose
46 --
47 -- ===============================================================
48 procedure LOCK_ROW (
49   X_SETUP_RISK_TYPE_ID in NUMBER,
50   X_RISK_TYPE_CODE in VARCHAR2,
51   X_PARENT_SETUP_RISK_TYPE_ID in NUMBER,
52   X_START_DATE in DATE,
53   X_END_DATE in DATE,
54   X_SECURITY_GROUP_ID in NUMBER,
55   X_OBJECT_VERSION_NUMBER in NUMBER,
56   X_TAG in VARCHAR2,
57   X_SETUP_RISK_TYPE_NAME in VARCHAR2,
58   X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2);
59 
60 
61 
62 -- ===============================================================
63 -- Procedure name
64 --          UPDATE_ROW
65 -- Purpose
66 --          update AMW_SETUP_RISK_TYPES_B and AMW_SETUP_RISK_TYPES_TL
67 -- ===============================================================
68 procedure UPDATE_ROW (
69   X_SETUP_RISK_TYPE_ID in NUMBER,
70   X_RISK_TYPE_CODE in VARCHAR2,
71   X_PARENT_SETUP_RISK_TYPE_ID in NUMBER,
72   X_START_DATE in DATE,
73   X_END_DATE in DATE,
74   X_LAST_UPDATED_BY in NUMBER,
75   X_LAST_UPDATE_DATE in DATE,
76   X_LAST_UPDATE_LOGIN in NUMBER,
77   X_SECURITY_GROUP_ID in NUMBER,
78   X_OBJECT_VERSION_NUMBER in NUMBER,
79   X_TAG in VARCHAR2,
80   X_SETUP_RISK_TYPE_NAME in VARCHAR2,
81   X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2);
82 
83 
84 -- ===============================================================
85 -- Procedure name
86 --          LOAD_ROW
87 -- Purpose
88 --          load AMW_SETUP_RISK_TYPE to AMW_SETUP_RISK_TYPES_B(_TL)
89 -- ===============================================================
90 procedure LOAD_ROW (
91   X_SETUP_RISK_TYPE_ID in NUMBER,
92   X_RISK_TYPE_CODE in VARCHAR2,
93   X_PARENT_SETUP_RISK_TYPE_ID in NUMBER,
94   X_START_DATE in DATE,
95   X_END_DATE in DATE,
96   X_SECURITY_GROUP_ID in NUMBER,
97   X_OBJECT_VERSION_NUMBER in NUMBER,
98   X_TAG in VARCHAR2,
99   X_SETUP_RISK_TYPE_NAME in VARCHAR2,
100   X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2,
101   X_OWNER in VARCHAR2,
102   /** 08.23.2006 npanandi: bug 5486153 fix -- no need to pass
103       X_PARENT_SETUP_RISK_TYPE_NAME, as it creates translation issues
104   X_PARENT_SETUP_RISK_TYPE_NAME in VARCHAR2,
105   **/
106   X_COMPLIANCE_ENV_ID in NUMBER);
107 
108 
109 -- ===============================================================
110 -- Procedure name
111 --          DELETE_ROW
112 -- Purpose
113 --
114 -- ===============================================================
115 procedure DELETE_ROW (
116   X_SETUP_RISK_TYPE_ID in NUMBER,
117   X_PARENT_SETUP_RISK_TYPE_ID  in NUMBER);
118 
119 
120 
121 -- ===============================================================
122 -- Procedure name
123 --          ADD_LANGUAGE
124 -- Purpose
125 --
126 -- ===============================================================
127 procedure ADD_LANGUAGE;
128 
129 /**05.31.2006 npanandi: bug 5259681 fix, added translate row***/
130 -- ===============================================================
131 -- Procedure name
132 --          TRANSLATE_ROW
133 -- Purpose
134 --          translate a row for MLS enabled DB environments
135 -- ===============================================================
136 procedure TRANSLATE_ROW(
137 	X_SETUP_RISK_TYPE_ID		  in NUMBER,
138 	X_SETUP_RISK_TYPE_NAME        in VARCHAR2,
139     X_SETUP_RISK_TYPE_DESCRIPTION in VARCHAR2,
140 	X_LAST_UPDATE_DATE    	      in VARCHAR2,
141 	X_OWNER			              in VARCHAR2,
142 	X_CUSTOM_MODE		          in VARCHAR2);
143 /**05.31.2006 npanandi: bug 5259681 fix ends***/
144 
145 -- ----------------------------------------------------------------------
146 end AMW_SETUP_RISK_TYPES_PKG;