[Home] [Help]
PACKAGE: APPS.CN_EXT_TBL_MAP_PVT
Source
1 PACKAGE cn_ext_tbl_map_pvt AUTHID CURRENT_USER AS
2 /* $Header: cnvextbs.pls 115.6 2002/11/21 21:13:08 hlchen ship $ */
3
4 TYPE table_mapping_rec_type IS RECORD
5 (name cn_calc_ext_tables.name%TYPE,
6 description cn_calc_ext_tables.description%TYPE,
7 internal_table_id cn_calc_ext_tables.internal_table_id%TYPE,
8 external_table_id cn_calc_ext_tables.external_table_id%TYPE,
9 used_flag cn_calc_ext_tables.used_flag%TYPE,
10 external_table_name cn_calc_ext_tables.external_table_name%TYPE,
11 alias cn_calc_ext_tables.alias%TYPE,
12 schema cn_calc_ext_tables.schema%TYPE,
13 attribute_category cn_calc_ext_tables.attribute_category%TYPE,
14 attribute1 cn_calc_ext_tables.attribute1%TYPE,
15 attribute2 cn_calc_ext_tables.attribute2%TYPE,
16 attribute3 cn_calc_ext_tables.attribute3%TYPE,
17 attribute4 cn_calc_ext_tables.attribute4%TYPE,
18 attribute5 cn_calc_ext_tables.attribute5%TYPE,
19 attribute6 cn_calc_ext_tables.attribute6%TYPE,
20 attribute7 cn_calc_ext_tables.attribute7%TYPE,
21 attribute8 cn_calc_ext_tables.attribute8%TYPE,
22 attribute9 cn_calc_ext_tables.attribute9%TYPE,
23 attribute10 cn_calc_ext_tables.attribute10%TYPE,
24 attribute11 cn_calc_ext_tables.attribute11%TYPE,
25 attribute12 cn_calc_ext_tables.attribute12%TYPE,
26 attribute13 cn_calc_ext_tables.attribute13%TYPE,
27 attribute14 cn_calc_ext_tables.attribute14%TYPE,
28 attribute15 cn_calc_ext_tables.attribute15%TYPE
29 );
30
31 TYPE column_mapping_rec IS RECORD(
32 calc_ext_table_id cn_calc_ext_tbl_dtls.calc_ext_table_id%TYPE ,
33 external_column_id cn_calc_ext_tbl_dtls.external_column_id%TYPE ,
34 internal_column_id cn_calc_ext_tbl_dtls.internal_column_id%TYPE ,
35 attribute_category cn_calc_ext_tbl_dtls.attribute_category%TYPE ,
36 attribute1 cn_calc_ext_tbl_dtls.attribute1%TYPE ,
37 attribute2 cn_calc_ext_tbl_dtls.attribute2%TYPE ,
38 attribute3 cn_calc_ext_tbl_dtls.attribute3%TYPE ,
39 attribute4 cn_calc_ext_tbl_dtls.attribute4%TYPE ,
40 attribute5 cn_calc_ext_tbl_dtls.attribute5%TYPE ,
41 attribute6 cn_calc_ext_tbl_dtls.attribute6%TYPE ,
42 attribute7 cn_calc_ext_tbl_dtls.attribute7%TYPE ,
43 attribute8 cn_calc_ext_tbl_dtls.attribute8%TYPE ,
44 attribute9 cn_calc_ext_tbl_dtls.attribute9%TYPE ,
45 attribute10 cn_calc_ext_tbl_dtls.attribute10%TYPE ,
46 attribute11 cn_calc_ext_tbl_dtls.attribute11%TYPE ,
47 attribute12 cn_calc_ext_tbl_dtls.attribute12%TYPE ,
48 attribute13 cn_calc_ext_tbl_dtls.attribute13%TYPE ,
49 attribute14 cn_calc_ext_tbl_dtls.attribute14%TYPE ,
50 attribute15 cn_calc_ext_tbl_dtls.attribute15%TYPE
51 );
52
53 TYPE column_mapping_tbl_type IS TABLE OF column_mapping_rec
54 INDEX BY BINARY_INTEGER;
55
56 table_mapping_rec table_mapping_rec_type ;
57 column_mapping_tbl column_mapping_tbl_type;
58
59 PROCEDURE create_external_mapping(
60 x_return_status OUT NOCOPY VARCHAR2 ,
61 x_msg_count OUT NOCOPY NUMBER ,
62 x_msg_data OUT NOCOPY VARCHAR2 ,
63 x_loading_status OUT NOCOPY VARCHAR2 ,
64 p_api_version IN NUMBER ,
65 p_init_msg_list IN VARCHAR2 ,
66 p_commit IN VARCHAR2 ,
67 p_validation_level IN VARCHAR2 ,
68 p_table_mapping_rec IN table_mapping_rec_type ,
69 p_column_mapping_tbl IN column_mapping_tbl_type ,
70 x_calc_ext_table_id OUT NOCOPY NUMBER
71 );
72 END cn_ext_tbl_map_pvt;