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,
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,
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,
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,
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,
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,
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
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: );
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:
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
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
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)
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
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
139: x_loading_status OUT NOCOPY VARCHAR2,
140: p_calc_ext_table_id IN NUMBER
141: );
142:
143: END CN_CALC_EXT_TABLES_PVT;