APPS.IGS_UC_REF_KEYWORDS_PKG dependencies on IGS_UC_REF_KEYWORDS

Line 1: PACKAGE BODY igs_uc_ref_keywords_pkg AS

1: PACKAGE BODY igs_uc_ref_keywords_pkg AS
2: /* $Header: IGSXI29B.pls 115.5 2003/02/28 07:49:11 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_keywords%ROWTYPE;

Line 5: old_references igs_uc_ref_keywords%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_keywords_pkg AS
2: /* $Header: IGSXI29B.pls 115.5 2003/02/28 07:49:11 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_keywords%ROWTYPE;
6: new_references igs_uc_ref_keywords%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_keywords%ROWTYPE;

2: /* $Header: IGSXI29B.pls 115.5 2003/02/28 07:49:11 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_keywords%ROWTYPE;
6: new_references igs_uc_ref_keywords%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 31: FROM IGS_UC_REF_KEYWORDS

27: */
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_UC_REF_KEYWORDS
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 82: igs_uc_crse_keywrds_pkg.get_fk_igs_uc_ref_keywords (

78: || (reverse chronological order - newest change first)
79: */
80: BEGIN
81:
82: igs_uc_crse_keywrds_pkg.get_fk_igs_uc_ref_keywords (
83: old_references.keyword
84: );
85:
86: END check_child_existance;

Line 103: FROM igs_uc_ref_keywords

99: || (reverse chronological order - newest change first)
100: */
101: CURSOR cur_rowid IS
102: SELECT rowid
103: FROM igs_uc_ref_keywords
104: WHERE keyword = x_keyword ;
105:
106: lv_rowid cur_rowid%RowType;
107:

Line 205: FROM igs_uc_ref_keywords

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR c IS
204: SELECT rowid
205: FROM igs_uc_ref_keywords
206: WHERE keyword = x_keyword;
207:
208: x_last_update_date DATE;
209: x_last_updated_by NUMBER;

Line 233: /* SELECT igs_uc_ref_keywords_s.NEXTVAL

229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232:
233: /* SELECT igs_uc_ref_keywords_s.NEXTVAL
234: INTO x_keyword
235: FROM dual;
236: */
237: before_dml(

Line 249: INSERT INTO igs_uc_ref_keywords (

245: x_last_updated_by => x_last_updated_by,
246: x_last_update_login => x_last_update_login
247: );
248:
249: INSERT INTO igs_uc_ref_keywords (
250: keyword,
251: imported,
252: creation_date,
253: created_by,

Line 295: FROM igs_uc_ref_keywords

291: */
292: CURSOR c1 IS
293: SELECT
294: imported
295: FROM igs_uc_ref_keywords
296: WHERE rowid = x_rowid
297: FOR UPDATE NOWAIT;
298:
299: tlinfo c1%ROWTYPE;

Line 381: UPDATE igs_uc_ref_keywords

377: x_last_updated_by => x_last_updated_by,
378: x_last_update_login => x_last_update_login
379: );
380:
381: UPDATE igs_uc_ref_keywords
382: SET
383: imported = new_references.imported,
384: last_update_date = x_last_update_date,
385: last_updated_by = x_last_updated_by,

Line 413: FROM igs_uc_ref_keywords

409: || (reverse chronological order - newest change first)
410: */
411: CURSOR c1 IS
412: SELECT rowid
413: FROM igs_uc_ref_keywords
414: WHERE keyword = x_keyword;
415:
416: BEGIN
417:

Line 462: DELETE FROM igs_uc_ref_keywords

458: p_action => 'DELETE',
459: x_rowid => x_rowid
460: );
461:
462: DELETE FROM igs_uc_ref_keywords
463: WHERE rowid = x_rowid;
464:
465: IF (SQL%NOTFOUND) THEN
466: RAISE NO_DATA_FOUND;

Line 472: END igs_uc_ref_keywords_pkg;

468:
469: END delete_row;
470:
471:
472: END igs_uc_ref_keywords_pkg;