APPS.CS_KB_ELEMENTS_PKG dependencies on CS_KB_ELEMENTS_B

Line 75: l_access_level CS_KB_ELEMENTS_B.ACCESS_LEVEL%TYPE;

71: X_CONTENT_TYPE IN VARCHAR2 )
72:
73: IS
74:
75: l_access_level CS_KB_ELEMENTS_B.ACCESS_LEVEL%TYPE;
76: l_content_type CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE;
77:
78: l_srclen INTEGER :=0;
79: l_clob CLOB;

Line 76: l_content_type CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE;

72:
73: IS
74:
75: l_access_level CS_KB_ELEMENTS_B.ACCESS_LEVEL%TYPE;
76: l_content_type CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE;
77:
78: l_srclen INTEGER :=0;
79: l_clob CLOB;
80:

Line 83: FROM CS_KB_ELEMENTS_B

79: l_clob CLOB;
80:
81: CURSOR c IS
82: SELECT rowid
83: FROM CS_KB_ELEMENTS_B
84: WHERE element_id = x_element_id;
85:
86: CURSOR c_tl(c_id IN NUMBER) IS
87: SELECT element_id,

Line 117: INSERT INTO CS_KB_ELEMENTS_B (

113: ELSE
114: l_content_type := x_content_type;
115: END IF;
116:
117: INSERT INTO CS_KB_ELEMENTS_B (
118: element_id,
119: element_number,
120: element_type_id,
121: element_name,

Line 303: FROM CS_KB_ELEMENTS_B

299: attribute15,
300: start_active_date,
301: end_active_date,
302: content_type
303: FROM CS_KB_ELEMENTS_B
304: WHERE element_id = x_element_id
305: FOR UPDATE OF element_id NOWAIT;
306:
307: recinfo c%ROWTYPE;

Line 448: l_access_level CS_KB_ELEMENTS_B.ACCESS_LEVEL%TYPE;

444: X_END_ACTIVE_DATE IN DATE,
445: X_CONTENT_TYPE IN VARCHAR2 )
446: IS
447:
448: l_access_level CS_KB_ELEMENTS_B.ACCESS_LEVEL%TYPE;
449: l_content_type CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE;
450:
451: l_srclen INTEGER :=0;
452: l_destlen INTEGER :=0;

Line 449: l_content_type CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE;

445: X_CONTENT_TYPE IN VARCHAR2 )
446: IS
447:
448: l_access_level CS_KB_ELEMENTS_B.ACCESS_LEVEL%TYPE;
449: l_content_type CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE;
450:
451: l_srclen INTEGER :=0;
452: l_destlen INTEGER :=0;
453:

Line 485: UPDATE CS_KB_ELEMENTS_B SET

481: ELSE
482: l_content_type := x_content_type;
483: END IF;
484:
485: UPDATE CS_KB_ELEMENTS_B SET
486: element_type_id = x_element_type_id,
487: element_name = x_element_name,
488: group_flag = x_group_flag,
489: status = x_status,

Line 553: FROM CS_KB_ELEMENTS_B

549: IS
550:
551: CURSOR c IS
552: SELECT element_id
553: FROM CS_KB_ELEMENTS_B
554: WHERE element_number = x_element_number;
555:
556: BEGIN
557:

Line 565: DELETE FROM CS_KB_ELEMENTS_B

561: WHERE element_id = rec.element_id;
562:
563: END LOOP;
564:
565: DELETE FROM CS_KB_ELEMENTS_B
566: WHERE element_number = x_element_number;
567:
568: END Delete_Row;
569:

Line 576: FROM CS_KB_ELEMENTS_B b

572: BEGIN
573:
574: DELETE FROM CS_KB_ELEMENTS_TL t
575: WHERE NOT EXISTS (SELECT NULL
576: FROM CS_KB_ELEMENTS_B b
577: WHERE b.element_id = t.element_id );
578:
579: UPDATE CS_KB_ELEMENTS_TL t
580: SET ( name,