[Home] [Help]
PACKAGE: APPS.CN_SEC_PROF_ASSIGNS_PKG
Source
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
10 -- Block
11 -- SEC_PROF_ASSIGNS
12 --
13 -- History
14 -- 28-Jul-99 Yonghong Mao Created
15
16 --
17 -- User defined record type
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,
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,
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,
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
52 --
53 g_last_update_date DATE := Sysdate;
54 g_last_updated_by NUMBER := fnd_global.user_id;
55 g_creation_date DATE := Sysdate;
56 g_created_by NUMBER := fnd_global.user_id;
57 g_last_update_login NUMBER := fnd_global.login_id;
58
59 --/*--------------------------------------------------------------------------*
60 -- Prodedure Name
61 -- Insert_Row
62 -- Purpose
63 -- Main insert procedure
64 -- *--------------------------------------------------------------------------*/
65 PROCEDURE Insert_Row( x_new_rec IN OUT sec_prof_assign_rec_type);
66
67 --/*--------------------------------------------------------------------------*
68 -- Prodedure Name
69 -- Update_Row
70 -- Purpose
71 -- Update the Service Group Assign
72 -- *--------------------------------------------------------------------------*/
73 PROCEDURE Update_Row( x_new_rec sec_prof_assign_rec_type);
74
75 --/*--------------------------------------------------------------------------*
76 -- Prodedure Name
77 -- Lock_Row
78 -- Purpose
79 -- Lock DB row after form record is changed
80 -- *--------------------------------------------------------------------------*/
81 PROCEDURE Lock_Row(x_rec sec_prof_assign_rec_type);
82
83 --/*--------------------------------------------------------------------------*
84 -- Prodedure Name
85 -- Delete_Row
86 -- Purpose
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;