[Home] [Help]
PACKAGE: APPS.CN_QUOTA_CATEGORIES_PKG
Source
1 PACKAGE CN_QUOTA_CATEGORIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntqcats.pls 115.5 2002/01/28 20:05:14 pkm ship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Global Variable Section
6 -- * ------------------------------------------------------------------+
7
8 g_last_update_date DATE := Sysdate;
9 g_last_updated_by NUMBER := fnd_global.user_id;
10 g_creation_date DATE := Sysdate;
11 g_created_by NUMBER := fnd_global.user_id;
12 g_last_update_login NUMBER := fnd_global.login_id;
13
14 -- * ------------------------------------------------------------------+
15 -- Record Type Definition
16 -- * ------------------------------------------------------------------+
17
18 TYPE QUOTA_CATEGORIES_REC_TYPE IS RECORD
19 (
20 QUOTA_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
21 NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22 DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23 TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24 COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25 INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26 QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46 CREATION_DATE DATE := FND_API.G_MISS_DATE,
47 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
49 );
50
51 G_MISS_QUOTA_CATEGORIES_REC QUOTA_CATEGORIES_REC_TYPE;
52
53 -- * -------------------------------------------------------------------------*
54 -- Procedure Name
55 -- Insert_row
56 -- Purpose
57 -- Main insert procedure
58 -- Note
59 -- 1. Primary key should be populated from sequence before call
60 -- this procedure. No refernece to sequence in this procedure.
61 -- 2. All paramaters are IN parameter.
62 -- * -------------------------------------------------------------------------*
63 PROCEDURE insert_row
64 ( p_quota_categories_rec IN QUOTA_CATEGORIES_REC_TYPE);
65
66 -- * -------------------------------------------------------------------------*
67 -- Procedure Name
68 -- update_row
69 -- Purpose
70 -- Main update procedure
71 -- Note
72 -- 1. No object version checking, overwrite may happen
73 -- 2. Calling lock_update for object version checking
74 -- 3. All paramaters are IN parameter.
75 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
76 -- * -------------------------------------------------------------------------*
77 PROCEDURE update_row
78 ( p_quota_categories_rec IN QUOTA_CATEGORIES_REC_TYPE);
79
80 -- * -------------------------------------------------------------------------*
81 -- Procedure Name
82 -- lock_update_row
83 -- Purpose
84 -- Main lcok and update procedure
85 -- Note
86 -- 1. Object version checking is performed before checking
87 -- 2. Calling update_row if you don not want object version checking
88 -- 3. All paramaters are IN parameter.
89 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
90 -- * -------------------------------------------------------------------------*
91 PROCEDURE lock_update_row
92 ( p_quota_categories_rec IN QUOTA_CATEGORIES_REC_TYPE);
93
94 -- * -------------------------------------------------------------------------*
95 -- Procedure Name
96 -- delete_row
97 -- Purpose
98 -- Main lcok and update procedure
99 -- Note
100 -- 1. All paramaters are IN parameter.
101 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
102 -- * -------------------------------------------------------------------------*
103 PROCEDURE delete_row
104 (
105 p_quota_category_id NUMBER
106 );
107
108 END CN_QUOTA_CATEGORIES_PKG;