APPS.CN_CALC_EXT_TABLES_PVT dependencies on CN_CALC_EXT_TABLES

Line 1: PACKAGE BODY CN_CALC_EXT_TABLES_PVT AS

1: PACKAGE BODY CN_CALC_EXT_TABLES_PVT AS
2: --$Header: cnvexttb.pls 115.9 2002/11/21 21:13:14 hlchen ship $
3:
4: --Global Variables
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_EXT_TABLES_PVT';

2: --$Header: cnvexttb.pls 115.9 2002/11/21 21:13:14 hlchen ship $
3:
4: --Global Variables
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_EXT_TABLES_PVT';
7: G_LAST_UPDATE_DATE DATE := Sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := Sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;

Line 52: p_calc_ext_table_rec IN CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type

48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: x_loading_status OUT NOCOPY VARCHAR2,
51: x_calc_ext_table_id OUT NOCOPY NUMBER,
52: p_calc_ext_table_rec IN CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
53: )
54: IS
55:
56: l_api_name CONSTANT VARCHAR2(30) := 'Create_Calc_Ext_Table';

Line 66: l_alias cn_calc_ext_tables.alias%TYPE;

62: l_sequence_number NUMBER;
63: l_count NUMBER;
64: l_calc_ext_table_id NUMBER;
65:
66: l_alias cn_calc_ext_tables.alias%TYPE;
67:
68: cursor unique_alias is
69: Select count(*)
70: from cn_calc_ext_tables

Line 70: from cn_calc_ext_tables

66: l_alias cn_calc_ext_tables.alias%TYPE;
67:
68: cursor unique_alias is
69: Select count(*)
70: from cn_calc_ext_tables
71: Where external_table_id = p_calc_ext_table_rec.external_table_id
72: and calc_ext_table_id <> nvl( p_calc_ext_table_rec.calc_ext_table_id, -99);
73:
74: l_table_id NUMBER;

Line 306: p_old_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type,

302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,
306: p_old_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type,
307: p_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
308: ) IS
309:
310: /* CURSOR l_ovn_csr IS

Line 307: p_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type

303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,
306: p_old_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type,
307: p_calc_ext_table_rec IN OUT NOCOPY CN_CALC_EXT_TABLES_PVT.calc_ext_table_rec_type
308: ) IS
309:
310: /* CURSOR l_ovn_csr IS
311: SELECT nvl(object_version_number,1)

Line 312: FROM cn_calc_ext_tables

308: ) IS
309:
310: /* CURSOR l_ovn_csr IS
311: SELECT nvl(object_version_number,1)
312: FROM cn_calc_ext_tables
313: WHERE calc_ext_table_id = p_old_calc_ext_table_rec.calc_ext_table_id;
314: */
315:
316: cursor unique_alias is

Line 318: from cn_calc_ext_tables

314: */
315:
316: cursor unique_alias is
317: Select count(*)
318: from cn_calc_ext_tables
319: Where external_table_id = p_calc_ext_table_rec.external_table_id
320: and calc_ext_table_id <> nvl( p_calc_ext_table_rec.calc_ext_table_id, -99);
321:
322: l_api_name CONSTANT VARCHAR2(30) := 'Update_Calc_Ext_Table';

Line 331: l_alias cn_calc_ext_tables.alias%TYPE;

327: l_ruleset_status VARCHAR2(100);
328: l_request_id NUMBER;
329: l_object_version_number NUMBER;
330:
331: l_alias cn_calc_ext_tables.alias%TYPE;
332:
333:
334: cursor table_name_curs ( p_object_id NUMBER ) is
335: select name from cn_objects

Line 344: from cn_calc_ext_tables

340:
341:
342: cursor get_tbl_curs ( p_calc_ext_table_id NUMBER ) is
343: Select external_table_id, internal_table_id
344: from cn_calc_ext_tables
345: where calc_ext_table_id = p_calc_ext_table_id;
346:
347:
348: cursor get_dtl_curs ( p_calc_ext_table_id NUMBER ) is

Line 732: END CN_CALC_EXT_TABLES_PVT;

728:
729: END;
730:
731:
732: END CN_CALC_EXT_TABLES_PVT;