APPS.CS_KB_SETS_PKG dependencies on CS_KB_SETS_B

Line 10: | This contains Table Handlers for CS_KB_SETS_B / _TL

6: +=======================================================================+
7: | FILENAME cskbsb.pls
8: | DESCRIPTION
9: | PL/SQL body for package: CS_KB_SETS_PKG
10: | This contains Table Handlers for CS_KB_SETS_B / _TL
11: |
12: | HISTORY
13: | 10.18.99 A. WONG Created
14: | 01.05.00 HBALA Added LOAD_ROW, TRANSLATE_ROW

Line 77: FROM CS_KB_SETS_B

73: IS
74:
75: CURSOR c IS
76: SELECT rowid
77: FROM CS_KB_SETS_B
78: WHERE set_id = x_set_id;
79: BEGIN
80:
81: INSERT INTO CS_KB_SETS_B (

Line 81: INSERT INTO CS_KB_SETS_B (

77: FROM CS_KB_SETS_B
78: WHERE set_id = x_set_id;
79: BEGIN
80:
81: INSERT INTO CS_KB_SETS_B (
82: set_id,
83: set_number,
84: set_type_id,
85: set_name,

Line 271: FROM CS_KB_SETS_B

267: party_id,
268: start_active_date,
269: end_active_date,
270: priority_code
271: FROM CS_KB_SETS_B
272: WHERE set_id = x_set_id
273: FOR UPDATE OF set_id NOWAIT;
274:
275: recinfo c%ROWTYPE;

Line 422: UPDATE CS_KB_SETS_B SET

418: IS
419:
420: BEGIN
421:
422: UPDATE CS_KB_SETS_B SET
423: set_type_id = x_set_type_id,
424: set_name = x_set_name,
425: group_flag = x_group_flag,
426: status = x_status,

Line 484: FROM CS_KB_SETS_B

480: IS
481:
482: CURSOR c IS
483: SELECT set_id
484: FROM CS_KB_SETS_B
485: WHERE set_number = X_SET_NUMBER;
486:
487: BEGIN
488:

Line 494: DELETE FROM CS_KB_SETS_B

490: DELETE FROM CS_KB_SETS_TL
491: WHERE set_id = rec.set_id;
492: END LOOP;
493:
494: DELETE FROM CS_KB_SETS_B
495: WHERE set_number = x_set_number;
496: IF (SQL%NOTFOUND) THEN
497: RAISE NO_DATA_FOUND;
498: END IF;

Line 511: FROM CS_KB_SETS_B b

507:
508: DELETE FROM CS_KB_SETS_TL t
509: WHERE NOT EXISTS
510: (SELECT NULL
511: FROM CS_KB_SETS_B b
512: WHERE b.set_id = t.set_id );
513:
514: UPDATE CS_KB_SETS_TL T SET (
515: name,