APPS.CN_EXT_TBL_MAP_PVT dependencies on CN_CALC_EXT_TABLES

Line 17: SELECT cn_calc_ext_tables_s.NEXTVAL

13: FUNCTION get_calc_ext_table_id RETURN NUMBER
14: IS
15: l_id NUMBER;
16: BEGIN
17: SELECT cn_calc_ext_tables_s.NEXTVAL
18: INTO l_id
19: FROM dual;
20: RETURN (l_id);
21: END;

Line 29: FROM cn_calc_ext_tables

25: l_mapping_id NUMBER;
26: BEGIN
27: SELECT calc_ext_table_id
28: INTO l_mapping_id
29: FROM cn_calc_ext_tables
30: WHERE name = Ltrim(Rtrim(p_mapping_name));
31: RETURN(l_mapping_id);
32: EXCEPTION
33: WHEN no_data_found THEN

Line 87: cn_calc_ext_tables_pkg.insert_row(x_rowid => l_rowid,

83: -- +
84: x_status := get_mapping_status ( p_table_mapping_rec.name);
85: IF ( x_status = 0 ) THEN
86: l_calc_ext_table_id := get_calc_ext_table_id ;
87: cn_calc_ext_tables_pkg.insert_row(x_rowid => l_rowid,
88: x_calc_ext_table_id => l_calc_ext_table_id ,
89: x_schema => p_table_mapping_rec.schema ,
90: x_name => p_table_mapping_rec.name ,
91: x_description => p_table_mapping_rec.description ,