APPS.IGS_HE_CODE_ASS_VAL_PKG dependencies on IGS_HE_CODE_ASS_VAL

Line 1: PACKAGE BODY igs_he_code_ass_val_pkg AS

1: PACKAGE BODY igs_he_code_ass_val_pkg AS
2: /* $Header: IGSWI02B.pls 115.4 2002/11/29 04:34:22 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_code_ass_val%ROWTYPE;

Line 5: old_references igs_he_code_ass_val%ROWTYPE;

1: PACKAGE BODY igs_he_code_ass_val_pkg AS
2: /* $Header: IGSWI02B.pls 115.4 2002/11/29 04:34:22 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_code_ass_val%ROWTYPE;
6: new_references igs_he_code_ass_val%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_code_ass_val%ROWTYPE;

2: /* $Header: IGSWI02B.pls 115.4 2002/11/29 04:34:22 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_code_ass_val%ROWTYPE;
6: new_references igs_he_code_ass_val%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM IGS_HE_CODE_ASS_VAL

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_HE_CODE_ASS_VAL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 123: FROM igs_he_code_ass_val

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igs_he_code_ass_val
124: WHERE association_code = x_association_code
125: AND sequence = x_sequence
126: FOR UPDATE NOWAIT;
127:

Line 159: FROM igs_he_code_ass_val

155: || (reverse chronological order - newest change first)
156: */
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM igs_he_code_ass_val
160: WHERE ((association_code = x_association_code));
161:
162: lv_rowid cur_rowid%RowType;
163:

Line 281: FROM igs_he_code_ass_val

277: || (reverse chronological order - newest change first)
278: */
279: CURSOR c IS
280: SELECT rowid
281: FROM igs_he_code_ass_val
282: WHERE association_code = x_association_code
283: AND sequence = x_sequence;
284:
285: x_last_update_date DATE;

Line 328: INSERT INTO igs_he_code_ass_val (

324: x_last_updated_by => x_last_updated_by,
325: x_last_update_login => x_last_update_login
326: );
327:
328: INSERT INTO igs_he_code_ass_val (
329: association_code,
330: sequence,
331: association_type,
332: main_source,

Line 397: FROM igs_he_code_ass_val

393: secondary_source,
394: condition,
395: display_title,
396: system_defined
397: FROM igs_he_code_ass_val
398: WHERE rowid = x_rowid
399: FOR UPDATE NOWAIT;
400:
401: tlinfo c1%ROWTYPE;

Line 500: UPDATE igs_he_code_ass_val

496: x_last_updated_by => x_last_updated_by,
497: x_last_update_login => x_last_update_login
498: );
499:
500: UPDATE igs_he_code_ass_val
501: SET
502: association_type = new_references.association_type,
503: main_source = new_references.main_source,
504: secondary_source = new_references.secondary_source,

Line 543: FROM igs_he_code_ass_val

539: || (reverse chronological order - newest change first)
540: */
541: CURSOR c1 IS
542: SELECT rowid
543: FROM igs_he_code_ass_val
544: WHERE association_code = x_association_code
545: AND sequence = x_sequence;
546:
547: BEGIN

Line 605: DELETE FROM igs_he_code_ass_val

601: p_action => 'DELETE',
602: x_rowid => x_rowid
603: );
604:
605: DELETE FROM igs_he_code_ass_val
606: WHERE rowid = x_rowid;
607:
608: IF (SQL%NOTFOUND) THEN
609: RAISE NO_DATA_FOUND;

Line 615: END igs_he_code_ass_val_pkg;

611:
612: END delete_row;
613:
614:
615: END igs_he_code_ass_val_pkg;