[Home] [Help]
74: CURSOR C_COA_SPEC_TEXT IS
75: SELECT
76: count(*)
77: FROM
78: GMD_COA_SPEC_TEXT;
79: CURSOR C_COA_RSLT_TEXT IS
80: SELECT
81: count(*)
82: FROM
106: FETCH C_COA_SPEC_TEXT
107: INTO L_COUNT;
108: CLOSE C_COA_SPEC_TEXT;
109: IF (L_COUNT > 0) THEN
110: DELETE FROM GMD_COA_SPEC_TEXT;
111: END IF;
112: OPEN C_COA_RSLT_TEXT;
113: FETCH C_COA_RSLT_TEXT
114: INTO L_COUNT;