APPS.AMS_DISCOVERERSQL_PVT dependencies on AMS_DISCOVERER_SQL_S

Line 59: SELECT ams_discoverer_sql_s.NEXTVAL

55: l_sqlerrm varchar2(600);
56: l_sqlcode varchar2(100);
57:
58: CURSOR c_get_seq IS
59: SELECT ams_discoverer_sql_s.NEXTVAL
60: FROM DUAL;
61:
62: l_discoverer_sql_id NUMBER;
63:

Line 76: l_source_type_code ams_discoverer_sql.source_type_code%TYPE;

72: WHERE workbook_name = p_workbook_name
73: AND worksheet_name = p_worksheet_name
74: ;
75:
76: l_source_type_code ams_discoverer_sql.source_type_code%TYPE;
77: BEGIN
78: OPEN c_disco (p_workbookname, p_worksheetname);
79: FETCH c_disco INTO l_discoverer_sql_id, l_max_sequence_number, l_source_type_code;
80: CLOSE c_disco;