[Home] [Help]
PACKAGE: APPS.CN_REASONS_PKG
Source
1 PACKAGE CN_REASONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntresns.pls 115.0 2002/04/22 20:53:08 pkm ship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7
8 TYPE REASONS_ALL_REC_TYPE IS RECORD(
9 REASON_ID NUMBER := FND_API.G_MISS_NUM,
10 UPDATED_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
11 UPD_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
12 REASON VARCHAR2(8000) := FND_API.G_MISS_CHAR,
13 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
14 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
30 CREATION_DATE DATE := FND_API.G_MISS_DATE,
31 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
32 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
33 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
34 ORG_ID NUMBER := FND_API.G_MISS_NUM,
35 SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
36 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
37 LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38 REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39 UPDATE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR);
40
41 G_MISS_REASONS_ALL_REC REASONS_ALL_REC_TYPE;
42
43 -- * -------------------------------------------------------------------------*
44 -- Procedure Name
45 -- Insert_row
46 -- Purpose
47 -- Main insert procedure
48 -- Note
49 -- 1. Primary key should be populated from sequence before call
50 -- this procedure. No refernece to sequence in this procedure.
51 -- 2. All paramaters are IN parameter.
52 -- * -------------------------------------------------------------------------*
53 PROCEDURE insert_row
54 ( p_reasons_all_rec IN REASONS_ALL_REC_TYPE);
55
56 -- * -------------------------------------------------------------------------*
57 -- Procedure Name
58 -- update_row
59 -- Purpose
60 -- Main update procedure
61 -- Note
62 -- 1. No object version checking, overwrite may happen
63 -- 2. Calling lock_update for object version checking
64 -- 3. All paramaters are IN parameter.
65 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
66 -- * -------------------------------------------------------------------------*
67 PROCEDURE update_row
68 ( p_reasons_all_rec IN REASONS_ALL_REC_TYPE);
69
70 -- * -------------------------------------------------------------------------*
71 -- Procedure Name
72 -- lock_update_row
73 -- Purpose
74 -- Main lcok and update procedure
75 -- Note
76 -- 1. Object version checking is performed before checking
77 -- 2. Calling update_row if you don not want object version checking
78 -- 3. All paramaters are IN parameter.
79 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
80 -- * -------------------------------------------------------------------------*
81 PROCEDURE lock_update_row
82 ( p_reasons_all_rec IN REASONS_ALL_REC_TYPE);
83
84 -- * -------------------------------------------------------------------------*
85 -- Procedure Name
86 -- delete_row
87 -- Purpose
88 -- Main lcok and update procedure
89 -- Note
90 -- 1. All paramaters are IN parameter.
91 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
92 -- * -------------------------------------------------------------------------*
93 PROCEDURE delete_row(
94 p_reason_id NUMBER);
95
96 END CN_REASONS_PKG;