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 BODY: APPS.JTF_SE_AUTHPR

Source


1 package body JTF_SE_AUTHPR as
2 procedure INSERT_ROW (
3   X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
4   X_PRINCIPAL_DESC_ID in NUMBER,
5   X_OBJECT_VERSION_NUMBER in NUMBER,
6   X_PRINCIPAL_NAME in VARCHAR2,
7   X_APPLICATION_ID in NUMBER,
8   X_USER_ID in NUMBER,
9   X_IS_USER_FLAG in NUMBER,
10   X_DAC_ROLE_FLAG in NUMBER,
11   X_PRINCIPAL_DESC in VARCHAR2,
12   X_DESCRIPTION in VARCHAR2,
13   X_CREATION_DATE in DATE,
14   X_CREATED_BY in NUMBER,
15   X_LAST_UPDATE_DATE in DATE,
16   X_LAST_UPDATED_BY in NUMBER,
17   X_LAST_UPDATE_LOGIN in NUMBER
18 ) is
19 begin
20   JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW (
21   X_JTF_AUTH_PRINCIPAL_ID,
22   X_PRINCIPAL_DESC_ID,
23   X_OBJECT_VERSION_NUMBER,
24   X_PRINCIPAL_NAME,
25   X_APPLICATION_ID,
26   X_USER_ID,
27   X_IS_USER_FLAG,
28   X_DAC_ROLE_FLAG,
29   X_PRINCIPAL_DESC,
30   X_DESCRIPTION,
31   X_CREATION_DATE,
32   X_CREATED_BY,
33   X_LAST_UPDATE_DATE,
34   X_LAST_UPDATED_BY,
35   X_LAST_UPDATE_LOGIN
36 );
37 end INSERT_ROW;
38 
39 procedure LOCK_ROW (
40   X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
41   X_PRINCIPAL_DESC_ID in NUMBER,
42   X_OBJECT_VERSION_NUMBER in NUMBER,
43   X_PRINCIPAL_NAME in VARCHAR2,
44   X_APPLICATION_ID in NUMBER,
45   X_USER_ID in NUMBER,
46   X_IS_USER_FLAG in NUMBER,
47   X_DAC_ROLE_FLAG in NUMBER,
48   X_PRINCIPAL_DESC in VARCHAR2,
49   X_DESCRIPTION in VARCHAR2
50 ) is
51 begin
52   JTF_AUTH_PRINCIPALS_PKG.LOCK_ROW (
53   X_JTF_AUTH_PRINCIPAL_ID,
54   X_PRINCIPAL_DESC_ID,
55   X_OBJECT_VERSION_NUMBER,
56   X_PRINCIPAL_NAME,
57   X_APPLICATION_ID,
58   X_USER_ID,
59   X_IS_USER_FLAG,
60   X_DAC_ROLE_FLAG,
61   X_PRINCIPAL_DESC,
62   X_DESCRIPTION
63 );
64 end LOCK_ROW;
65 
66 procedure UPDATE_ROW (
67   X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
68   X_PRINCIPAL_DESC_ID in NUMBER,
69   X_OBJECT_VERSION_NUMBER in NUMBER,
70   X_PRINCIPAL_NAME in VARCHAR2,
71   X_APPLICATION_ID in NUMBER,
72   X_USER_ID in NUMBER,
73   X_IS_USER_FLAG in NUMBER,
74   X_DAC_ROLE_FLAG in NUMBER,
75   X_PRINCIPAL_DESC in VARCHAR2,
76   X_DESCRIPTION in VARCHAR2,
77   X_LAST_UPDATE_DATE in DATE,
78   X_LAST_UPDATED_BY in NUMBER,
79   X_LAST_UPDATE_LOGIN in NUMBER
80 ) is
81 begin
82   JTF_AUTH_PRINCIPALS_PKG.UPDATE_ROW (
83   X_JTF_AUTH_PRINCIPAL_ID,
84   X_PRINCIPAL_DESC_ID,
85   X_OBJECT_VERSION_NUMBER,
86   X_PRINCIPAL_NAME,
87   X_APPLICATION_ID,
88   X_USER_ID,
89   X_IS_USER_FLAG,
90   X_DAC_ROLE_FLAG,
91   X_PRINCIPAL_DESC,
92   X_DESCRIPTION,
93   X_LAST_UPDATE_DATE,
94   X_LAST_UPDATED_BY,
95   X_LAST_UPDATE_LOGIN
96 );
97 end UPDATE_ROW;
98 
99 procedure DELETE_ROW (
100   X_JTF_AUTH_PRINCIPAL_ID in NUMBER
101 ) is
102 begin
103   JTF_AUTH_PRINCIPALS_PKG.DELETE_ROW (
104   X_JTF_AUTH_PRINCIPAL_ID
105 );
106 end DELETE_ROW;
107 
108 PROCEDURE delete_row (
109   p_principal_name IN VARCHAR2,
110   p_is_user_flag IN VARCHAR2,
111   x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112   x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
113   x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 ) IS
115 
116   BEGIN
117 
118     jtf_auth_principals_pkg.delete_row(
119 	p_principal_name,
120 	p_is_user_flag,
121 	x_return_status,
122 	x_msg_count,
123 	x_msg_data);
124 
125   END delete_row;
126 
127 procedure ADD_LANGUAGE
128  is
129 begin
130   JTF_AUTH_PRINCIPALS_PKG.ADD_LANGUAGE;
131 end ADD_LANGUAGE;
132 
133 procedure TRANSLATE_ROW (
134   X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
135   X_PRINCIPAL_DESC in VARCHAR2,
136   X_DESCRIPTION in VARCHAR2,
137   X_OWNER in VARCHAR2
138 ) is
139 begin
140   JTF_AUTH_PRINCIPALS_PKG.TRANSLATE_ROW (
141   X_JTF_AUTH_PRINCIPAL_ID,
142   X_PRINCIPAL_DESC,
143   X_DESCRIPTION,
144   X_OWNER
145 );
146 end TRANSLATE_ROW;
147 
148 procedure LOAD_ROW (
149   X_JTF_AUTH_PRINCIPAL_ID in NUMBER,
150   X_PRINCIPAL_DESC_ID in NUMBER,
151   X_OBJECT_VERSION_NUMBER in NUMBER,
152   X_PRINCIPAL_NAME in VARCHAR2,
153   X_APPLICATION_ID in NUMBER,
154   X_USER_ID in NUMBER,
155   X_IS_USER_FLAG in NUMBER,
156   X_DAC_ROLE_FLAG in NUMBER,
157   X_PRINCIPAL_DESC in VARCHAR2,
158   X_DESCRIPTION in VARCHAR2,
159   X_OWNER in VARCHAR2
160 ) is
161 begin
162   JTF_AUTH_PRINCIPALS_PKG.LOAD_ROW (
163   X_JTF_AUTH_PRINCIPAL_ID,
164   X_PRINCIPAL_DESC_ID,
165   X_OBJECT_VERSION_NUMBER,
166   X_PRINCIPAL_NAME,
167   X_APPLICATION_ID,
168   X_USER_ID,
169   X_IS_USER_FLAG,
170   X_DAC_ROLE_FLAG,
171   X_PRINCIPAL_DESC,
172   X_DESCRIPTION,
173   X_OWNER
174 );
175 end LOAD_ROW;
176 
177 end JTF_SE_AUTHPR;
178