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