1: PACKAGE CN_SECURITY_PROFILES_PKG AUTHID CURRENT_USER AS
2: /* $Header: cntsecps.pls 115.6 2001/10/29 17:16:51 pkm ship $ */
3: --
4: -- Package Name
5: -- CN_SECURITY_PROFILES_PKG
1: PACKAGE CN_SECURITY_PROFILES_PKG AUTHID CURRENT_USER AS
2: /* $Header: cntsecps.pls 115.6 2001/10/29 17:16:51 pkm ship $ */
3: --
4: -- Package Name
5: -- CN_SECURITY_PROFILES_PKG
6: -- Purpose
7: -- Table handler for CN_SECURITY_PROFILES
8: -- Form
9: -- CNSPROF
3: --
4: -- Package Name
5: -- CN_SECURITY_PROFILES_PKG
6: -- Purpose
7: -- Table handler for CN_SECURITY_PROFILES
8: -- Form
9: -- CNSPROF
10: -- Block
11: -- SECURITY_PROFILES
18: --
19:
20: TYPE security_profiles_rec_type IS RECORD
21: (
22: security_profile_id cn_security_profiles.security_profile_id%TYPE,
23: profile_user_id cn_security_profiles.profile_user_id%TYPE,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
19:
20: TYPE security_profiles_rec_type IS RECORD
21: (
22: security_profile_id cn_security_profiles.security_profile_id%TYPE,
23: profile_user_id cn_security_profiles.profile_user_id%TYPE,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
20: TYPE security_profiles_rec_type IS RECORD
21: (
22: security_profile_id cn_security_profiles.security_profile_id%TYPE,
23: profile_user_id cn_security_profiles.profile_user_id%TYPE,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
21: (
22: security_profile_id cn_security_profiles.security_profile_id%TYPE,
23: profile_user_id cn_security_profiles.profile_user_id%TYPE,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
22: security_profile_id cn_security_profiles.security_profile_id%TYPE,
23: profile_user_id cn_security_profiles.profile_user_id%TYPE,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
23: profile_user_id cn_security_profiles.profile_user_id%TYPE,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
24: attribute_category cn_security_profiles.attribute_category%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
25: attribute1 cn_security_profiles.attribute1%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
26: attribute2 cn_security_profiles.attribute2%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
27: attribute3 cn_security_profiles.attribute3%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
28: attribute4 cn_security_profiles.attribute4%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
29: attribute5 cn_security_profiles.attribute5%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
30: attribute6 cn_security_profiles.attribute6%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
31: attribute7 cn_security_profiles.attribute7%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
32: attribute8 cn_security_profiles.attribute8%TYPE , -- := FND_API.G_MISS_CHAR,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
33: attribute9 cn_security_profiles.attribute9%TYPE , -- := FND_API.G_MISS_CHAR,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
34: attribute10 cn_security_profiles.attribute10%TYPE , -- := FND_API.G_MISS_CHAR,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
35: attribute11 cn_security_profiles.attribute11%TYPE , -- := FND_API.G_MISS_CHAR,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
43: last_update_date cn_security_profiles.last_update_date%TYPE , -- := FND_API.G_MISS_DATE,
36: attribute12 cn_security_profiles.attribute12%TYPE , -- := FND_API.G_MISS_CHAR,
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
43: last_update_date cn_security_profiles.last_update_date%TYPE , -- := FND_API.G_MISS_DATE,
44: last_updated_by cn_security_profiles.last_updated_by%TYPE -- := CN_API.G_MISS_ID
37: attribute13 cn_security_profiles.attribute13%TYPE , -- := FND_API.G_MISS_CHAR,
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
43: last_update_date cn_security_profiles.last_update_date%TYPE , -- := FND_API.G_MISS_DATE,
44: last_updated_by cn_security_profiles.last_updated_by%TYPE -- := CN_API.G_MISS_ID
45: );
38: attribute14 cn_security_profiles.attribute14%TYPE , -- := FND_API.G_MISS_CHAR,
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
43: last_update_date cn_security_profiles.last_update_date%TYPE , -- := FND_API.G_MISS_DATE,
44: last_updated_by cn_security_profiles.last_updated_by%TYPE -- := CN_API.G_MISS_ID
45: );
46:
39: attribute15 cn_security_profiles.attribute15%TYPE , -- := FND_API.G_MISS_CHAR,
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
43: last_update_date cn_security_profiles.last_update_date%TYPE , -- := FND_API.G_MISS_DATE,
44: last_updated_by cn_security_profiles.last_updated_by%TYPE -- := CN_API.G_MISS_ID
45: );
46:
47: --
40: created_by cn_security_profiles.created_by%TYPE , -- := CN_API.G_MISS_ID,
41: creation_date cn_security_profiles.creation_date%TYPE , -- := FND_API.G_MISS_DATE,
42: last_update_login cn_security_profiles.last_update_login%TYPE , -- := CN_API.G_MISS_ID,
43: last_update_date cn_security_profiles.last_update_date%TYPE , -- := FND_API.G_MISS_DATE,
44: last_updated_by cn_security_profiles.last_updated_by%TYPE -- := CN_API.G_MISS_ID
45: );
46:
47: --
48: -- global variables that represent missing values
85: -- Delete the Service Group Assign
86: -- *--------------------------------------------------------------------------*/
87: PROCEDURE Delete_Row(x_security_profile_id NUMBER);
88:
89: END CN_SECURITY_PROFILES_PKG;