1 PACKAGE CN_CALC_EXT_TABLES_PVT AUTHID CURRENT_USER AS
2 --$Header: cnvextts.pls 115.6 2003/01/31 08:41:33 hithanki ship $
3
4 TYPE calc_ext_table_rec_type IS RECORD
5 (calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE,
6 name cn_calc_ext_tables.name%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 description cn_calc_ext_tables.description%TYPE,
11 schema cn_calc_ext_tables.schema%TYPE,
12 external_table_name cn_calc_ext_tables.external_table_name%TYPE,
13 alias cn_calc_ext_tables.alias%TYPE,
14 object_version_number NUMBER
15 );
16
17 -- Start of comments
18 -- API name : Create_Calc_Ext_Tables
19 -- Type : Private
20 -- Function : This Private API can be used to create a
21 -- External Table Mapping
22 --
23 -- Pre-reqs : None.
24 -- Parameters :
25 -- IN : p_api_version IN NUMBER Required
26 -- p_init_msg_list IN VARCHAR2 Optional
27 -- Default = FND_API.G_FALSE
28 -- p_commit IN VARCHAR2 Optional
29 -- Default = FND_API.G_FALSE
30 -- p_validation_level IN NUMBER Optional
31 -- Default = FND_API.G_VALID_LEVEL_FULL
32
33 --
34 -- OUT : x_return_status OUT VARCHAR2(1)
35 -- x_msg_count OUT NUMBER
36 -- x_msg_data OUT VARCHAR2(2000)
37 --
38 -- Version : Current version 1.0
39 -- previous version y.y
40 -- Changed....
41 -- Initial version 1.0
42 --
43 -- Notes : Note text
44 --
45 -- End of comments
46
47 PROCEDURE create_calc_ext_table
48 ( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 x_loading_status OUT NOCOPY VARCHAR2,
56 x_calc_ext_table_id OUT NOCOPY NUMBER,
57 p_calc_ext_table_rec IN CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
58 );
59
60 -- Start of comments
61 -- API name : Update_calc_ext_table
62 -- Type : Public
63 -- Function : This Private API can be used to update a external,
64 -- table Mapping in Oracle Sales
65 -- Compensation.
66 -- Pre-reqs : None.
67 -- Parameters :
68 -- IN : p_api_version IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_commit IN VARCHAR2 Optional
72 -- Default = FND_API.G_FALSE
73 -- p_validation_level IN NUMBER Optional
74 -- Default = FND_API.G_VALID_LEVEL_FULL
75 -- p_calc_ext_table_rec_type IN
76 -- CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
77 --
78 -- OUT : x_return_status OUT VARCHAR2(1)
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2(2000)
81 --
82 -- Version : Current version 1.0
83 -- previous version y.y
84 -- Changed....
85 -- Initial version 1.0
86 -- Notes : Note text
87 --
88 -- End of comments
89
90
91 PROCEDURE Update_calc_ext_table
92 ( p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 p_commit IN VARCHAR2 := FND_API.G_FALSE,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 x_loading_status OUT NOCOPY VARCHAR2,
100 p_old_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type,
101 p_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
102 );
103
104 -- Start of comments
105 -- API name : Delete_calc_ext_table
106 -- Type : Public
107 -- Function : This Private API can be used to delete a External table Mapping
108 -- Pre-reqs : None.
109 -- Parameters :
110 -- IN : p_api_version IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional
112 -- Default = FND_API.G_FALSE
113 -- p_commit IN VARCHAR2 Optional
114 -- Default = FND_API.G_FALSE
115 -- p_validation_level IN NUMBER Optional
116 -- Default = FND_API.G_VALID_LEVEL_FULL
117 --
118 -- OUT : x_return_status OUT VARCHAR2(1)
119 -- x_msg_count OUT NUMBER
120 -- x_msg_data OUT VARCHAR2(2000)
121 --
122 -- Version : Current version 1.0
123 -- previous version y.y
124 -- Changed....
125 -- Initial version 1.0
126 --
127 -- Notes : Note text
128 --
129 -- End of comments
130
131 PROCEDURE Delete_calc_ext_table
132 ( p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134 p_commit IN VARCHAR2 := FND_API.G_FALSE,
135 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 x_loading_status OUT NOCOPY VARCHAR2,
140 p_calc_ext_table_id IN NUMBER
141 );
142
143 END CN_CALC_EXT_TABLES_PVT;