[Home] [Help]
PACKAGE: APPS.CN_REASON_HISTORY_PKG
Source
1 PACKAGE CN_REASON_HISTORY_PKG AUTHID CURRENT_USER AS
2 /* $Header: cnthists.pls 115.0 2002/04/22 20:52:35 pkm ship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7
8 TYPE REASON_HISTORY_ALL_REC_TYPE IS RECORD (
9 REASON_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
10 REASON_ID NUMBER := FND_API.G_MISS_NUM,
11 UPDATED_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12 UPD_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
13 REASON VARCHAR2(8000) := FND_API.G_MISS_CHAR,
14 REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
15 DML_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
16 LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
17 UPDATE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR,
18 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19 ATTRIBUTE1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 ATTRIBUTE2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
21 ATTRIBUTE3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
22 ATTRIBUTE4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE11 VARCHAR2(30) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE12 VARCHAR2(30) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE13 VARCHAR2(30) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE14 VARCHAR2(30) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE15 VARCHAR2(30) := FND_API.G_MISS_CHAR,
34 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
35 CREATION_DATE DATE := FND_API.G_MISS_DATE,
36 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
37 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
39 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
40 SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41 ORG_ID NUMBER := FND_API.G_MISS_NUM);
42 G_MISS_REASON_HISTORY_ALL_REC REASON_HISTORY_ALL_REC_TYPE;
43
44 -- * -------------------------------------------------------------------------*
45 -- Procedure Name
46 -- Insert_row
47 -- Purpose
48 -- Main insert procedure
49 -- Note
50 -- 1. Primary key should be populated from sequence before call
51 -- this procedure. No refernece to sequence in this procedure.
52 -- 2. All paramaters are IN parameter.
53 -- * -------------------------------------------------------------------------*
54 PROCEDURE insert_row
55 ( p_reason_history_all_rec IN REASON_HISTORY_ALL_REC_TYPE);
56
57 -- * -------------------------------------------------------------------------*
58 -- Procedure Name
59 -- delete_row
60 -- Purpose
61 -- Main lcok and update procedure
62 -- Note
63 -- 1. All paramaters are IN parameter.
64 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
65 -- * -------------------------------------------------------------------------*
66 PROCEDURE delete_row(
67 p_reason_history_id NUMBER);
68 END CN_REASON_HISTORY_PKG;