169: l_sql := l_sql || ' WHERE LOOKUP_TYPE = :b1';
170: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
171: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
172:
173: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
174: Ahl_Debug_Pub.debug( 'SQL statement'||l_sql);
175: END IF;
176: debug_message('SQL statement: '||l_sql);
177: BEGIN
170: l_sql := l_sql || ' AND LOOKUP_CODE = :b2';
171: l_sql := l_sql || ' AND ENABLED_FLAG = ''Y'')';
172:
173: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
174: Ahl_Debug_Pub.debug( 'SQL statement'||l_sql);
175: END IF;
176: debug_message('SQL statement: '||l_sql);
177: BEGIN
178: EXECUTE IMMEDIATE l_sql INTO l_count
479: l_dummy NUMBER;
480:
481: BEGIN
482:
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
481: BEGIN
482:
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
482:
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
483: Ahl_Debug_Pub.enable_debug;
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
491:
484: -- Debug info.
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
491:
492: -- get currant system status code
485: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
486: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
487: Ahl_Debug_Pub.debug( 'status TYPE'||p_status_type);
488: Ahl_Debug_Pub.debug('ccode' ||p_current_status);
489: Ahl_Debug_Pub.debug('ncode:' ||p_next_status);
490: END IF;
491:
492: -- get currant system status code
493: OPEN cur_stat_det(p_status_type,