[Home] [Help]
PACKAGE: APPS.CN_IMP_MAP_FIELDS_PKG
Source
1 PACKAGE CN_IMP_MAP_FIELDS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntimfds.pls 115.2 2002/02/05 00:25:53 pkm ship $*/
3
4 -- * ------------------------------------------------------------------+
5 -- Record Type Definition
6 -- * ------------------------------------------------------------------+
7
8 TYPE IMP_MAP_FIELDS_REC_TYPE IS RECORD
9 (
10 IMP_MAP_FIELD_ID NUMBER := FND_API.G_MISS_NUM,
11 IMP_MAP_ID NUMBER := FND_API.G_MISS_NUM,
12 SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
13 SOURCE_USER_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR,
14 TARGET_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
15 TARGET_COLUMN_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
16 TARGET_TABLE_ID NUMBER := FND_API.G_MISS_NUM,
17 TARGET_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
18 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
19 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 CREATION_DATE DATE := FND_API.G_MISS_DATE,
36 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
37 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
38 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
39 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40 );
41
42 G_MISS_IMP_MAP_FIELDS_REC IMP_MAP_FIELDS_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_imp_map_fields_rec IN IMP_MAP_FIELDS_REC_TYPE);
56
57 -- * -------------------------------------------------------------------------*
58 -- Procedure Name
59 -- update_row
60 -- Purpose
61 -- Main update procedure
62 -- Note
63 -- 1. No object version checking, overwrite may happen
64 -- 2. Calling lock_update for object version checking
65 -- 3. All paramaters are IN parameter.
66 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
67 -- * -------------------------------------------------------------------------*
68 PROCEDURE update_row
69 ( p_imp_map_fields_rec IN IMP_MAP_FIELDS_REC_TYPE);
70
71 -- * -------------------------------------------------------------------------*
72 -- Procedure Name
73 -- lock_update_row
74 -- Purpose
75 -- Main lcok and update procedure
76 -- Note
77 -- 1. Object version checking is performed before checking
78 -- 2. Calling update_row if you don not want object version checking
79 -- 3. All paramaters are IN parameter.
80 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
81 -- * -------------------------------------------------------------------------*
82 PROCEDURE lock_update_row
83 ( p_imp_map_fields_rec IN IMP_MAP_FIELDS_REC_TYPE);
84
85 -- * -------------------------------------------------------------------------*
86 -- Procedure Name
87 -- delete_row
88 -- Purpose
89 -- Main lcok and update procedure
90 -- Note
91 -- 1. All paramaters are IN parameter.
92 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
93 -- * -------------------------------------------------------------------------*
94 PROCEDURE delete_row
95 (
96 p_imp_map_field_id NUMBER
97 );
98
99 END CN_IMP_MAP_FIELDS_PKG;