APPS.CSK_SETUP_UTILITY_PKG dependencies on DBMS_OUTPUT

Line 544: dbms_output.put_line('Before Delete');

540: b NUMBER;
541: i2 pls_integer;
542:
543: BEGIN
544: dbms_output.put_line('Before Delete');
545: DELETE FROM CS_KB_SETS_B WHERE SET_ID = P_SOLN_REC.Set_id;
546: DELETE FROM CS_KB_SETS_TL WHERE SET_ID = P_SOLN_REC.Set_id;
547: DELETE FROM CS_KB_SET_CATEGORIES WHERE SET_ID = P_SOLN_REC.Set_id;
548: DELETE FROM CS_KB_SET_ELES WHERE SET_ID = P_SOLN_REC.Set_id;

Line 561: dbms_output.put_line('After Delete');

557:
558: a := P_STMT_TBL.NEXT(a);
559:
560: END LOOP;
561: dbms_output.put_line('After Delete');
562: IF P_PUBLISH = true THEN
563: l_status := 'PUB';
564: l_locked_by := null;
565: l_fdi := null;

Line 639: dbms_output.put_line('After Insert Solution');

635: WHERE t.set_id = P_SOLN_REC.set_id
636: AND t.language = l.language_code);
637:
638:
639: dbms_output.put_line('After Insert Solution');
640: IF P_PUBLISH = true THEN
641: l_status := 'PUBLISHED';
642: ELSE
643: l_status := 'DRAFT';

Line 726: dbms_output.put_line('Add Cat'||p_CAT_TBL(i2) );

722: end loop;
723:
724: i2 := p_CAT_TBL.FIRST;
725: while i2 is not null loop
726: dbms_output.put_line('Add Cat'||p_CAT_TBL(i2) );
727: INSERT INTO CS_KB_SET_CATEGORIES (SET_ID,
728: CATEGORY_ID,
729: CREATION_DATE,
730: CREATED_BY,

Line 871: dbms_output.put_line(substr(l_text_content,0,200));

867: l_offset := l_offset + 100;
868: l_len := l_len - 100;
869: end loop;
870: l_text_content := l_text_content || dbms_lob.substr(l_lob,l_len,l_offset);
871: dbms_output.put_line(substr(l_text_content,0,200));
872: return l_text_content;
873: end;
874:
875: