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