APPS.IGS_CO_LTR_PHR_PKG dependencies on IGS_CO_LTR_PHR

Line 1: PACKAGE BODY igs_co_ltr_phr_pkg AS

1: PACKAGE BODY igs_co_ltr_phr_pkg AS
2: /* $Header: IGSLI10B.pls 115.4 2002/11/29 01:04:40 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_phr%ROWTYPE;

Line 5: old_references igs_co_ltr_phr%ROWTYPE;

1: PACKAGE BODY igs_co_ltr_phr_pkg AS
2: /* $Header: IGSLI10B.pls 115.4 2002/11/29 01:04:40 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_phr%ROWTYPE;
6: new_references igs_co_ltr_phr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_co_ltr_phr%ROWTYPE;

2: /* $Header: IGSLI10B.pls 115.4 2002/11/29 01:04:40 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_phr%ROWTYPE;
6: new_references igs_co_ltr_phr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_CO_LTR_PHR

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_CO_LTR_PHR
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 120: FROM igs_co_ltr_phr

116: || (reverse chronological order - newest change first)
117: */
118: CURSOR cur_rowid IS
119: SELECT rowid
120: FROM igs_co_ltr_phr
121: WHERE phrase_cd = x_phrase_cd
122: FOR UPDATE NOWAIT;
123:
124: lv_rowid cur_rowid%RowType;

Line 231: FROM igs_co_ltr_phr

227: || (reverse chronological order - newest change first)
228: */
229: CURSOR c IS
230: SELECT rowid
231: FROM igs_co_ltr_phr
232: WHERE phrase_cd = x_phrase_cd;
233:
234: x_last_update_date DATE;
235: x_last_updated_by NUMBER;

Line 273: INSERT INTO igs_co_ltr_phr (

269: x_last_updated_by => x_last_updated_by,
270: x_last_update_login => x_last_update_login
271: );
272:
273: INSERT INTO igs_co_ltr_phr (
274: phrase_cd,
275: description,
276: phrase_text,
277: closed_ind,

Line 327: FROM igs_co_ltr_phr

323: SELECT
324: description,
325: phrase_text,
326: closed_ind
327: FROM igs_co_ltr_phr
328: WHERE rowid = x_rowid
329: FOR UPDATE NOWAIT;
330:
331: tlinfo c1%ROWTYPE;

Line 419: UPDATE igs_co_ltr_phr

415: x_last_updated_by => x_last_updated_by,
416: x_last_update_login => x_last_update_login
417: );
418:
419: UPDATE igs_co_ltr_phr
420: SET
421: description = new_references.description,
422: phrase_text = new_references.phrase_text,
423: closed_ind = new_references.closed_ind,

Line 455: FROM igs_co_ltr_phr

451: || (reverse chronological order - newest change first)
452: */
453: CURSOR c1 IS
454: SELECT rowid
455: FROM igs_co_ltr_phr
456: WHERE phrase_cd = x_phrase_cd;
457:
458: BEGIN
459:

Line 508: DELETE FROM igs_co_ltr_phr

504: p_action => 'DELETE',
505: x_rowid => x_rowid
506: );
507:
508: DELETE FROM igs_co_ltr_phr
509: WHERE rowid = x_rowid;
510:
511: IF (SQL%NOTFOUND) THEN
512: RAISE NO_DATA_FOUND;

Line 518: END igs_co_ltr_phr_pkg;

514:
515: END delete_row;
516:
517:
518: END igs_co_ltr_phr_pkg;