APPS.IGS_CO_LTR_PARM_TYPE_PKG dependencies on IGS_CO_LTR_PARM_TYPE

Line 1: PACKAGE BODY igs_co_ltr_parm_type_pkg AS

1: PACKAGE BODY igs_co_ltr_parm_type_pkg AS
2: /* $Header: IGSLI09B.pls 115.5 2002/11/29 01:04:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_ltr_parm_type%ROWTYPE;

Line 5: old_references igs_co_ltr_parm_type%ROWTYPE;

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

Line 6: new_references igs_co_ltr_parm_type%ROWTYPE;

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

Line 34: FROM IGS_CO_LTR_PARM_TYPE

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

Line 146: igs_co_ltr_param_pkg.get_fk_igs_co_ltr_parm_type (

142: || (reverse chronological order - newest change first)
143: */
144: BEGIN
145:
146: igs_co_ltr_param_pkg.get_fk_igs_co_ltr_parm_type (
147: old_references.letter_parameter_type
148: );
149:
150: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_ltr_parm_type (

Line 150: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_ltr_parm_type (

146: igs_co_ltr_param_pkg.get_fk_igs_co_ltr_parm_type (
147: old_references.letter_parameter_type
148: );
149:
150: igs_co_ltr_pr_rstcn_pkg.get_fk_igs_co_ltr_parm_type (
151: old_references.letter_parameter_type
152: );
153:
154: END check_child_existance;

Line 171: FROM igs_co_ltr_parm_type

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM igs_co_ltr_parm_type
172: WHERE letter_parameter_type = x_letter_parameter_type
173: FOR UPDATE NOWAIT;
174:
175: lv_rowid cur_rowid%RowType;

Line 206: FROM igs_co_ltr_parm_type

202: || (reverse chronological order - newest change first)
203: */
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igs_co_ltr_parm_type
207: WHERE ((s_letter_parameter_type = x_s_letter_parameter_type));
208:
209: lv_rowid cur_rowid%RowType;
210:

Line 327: FROM igs_co_ltr_parm_type

323: || (reverse chronological order - newest change first)
324: */
325: CURSOR c IS
326: SELECT rowid
327: FROM igs_co_ltr_parm_type
328: WHERE letter_parameter_type = x_letter_parameter_type;
329:
330: x_last_update_date DATE;
331: x_last_updated_by NUMBER;

Line 370: INSERT INTO igs_co_ltr_parm_type (

366: x_last_updated_by => x_last_updated_by,
367: x_last_update_login => x_last_update_login
368: );
369:
370: INSERT INTO igs_co_ltr_parm_type (
371: letter_parameter_type,
372: description,
373: s_letter_parameter_type,
374: letter_text,

Line 428: FROM igs_co_ltr_parm_type

424: description,
425: s_letter_parameter_type,
426: letter_text,
427: closed_ind
428: FROM igs_co_ltr_parm_type
429: WHERE rowid = x_rowid
430: FOR UPDATE NOWAIT;
431:
432: tlinfo c1%ROWTYPE;

Line 523: UPDATE igs_co_ltr_parm_type

519: x_last_updated_by => x_last_updated_by,
520: x_last_update_login => x_last_update_login
521: );
522:
523: UPDATE igs_co_ltr_parm_type
524: SET
525: description = new_references.description,
526: s_letter_parameter_type = new_references.s_letter_parameter_type,
527: letter_text = new_references.letter_text,

Line 561: FROM igs_co_ltr_parm_type

557: || (reverse chronological order - newest change first)
558: */
559: CURSOR c1 IS
560: SELECT rowid
561: FROM igs_co_ltr_parm_type
562: WHERE letter_parameter_type = x_letter_parameter_type;
563:
564: BEGIN
565:

Line 616: DELETE FROM igs_co_ltr_parm_type

612: p_action => 'DELETE',
613: x_rowid => x_rowid
614: );
615:
616: DELETE FROM igs_co_ltr_parm_type
617: WHERE rowid = x_rowid;
618:
619: IF (SQL%NOTFOUND) THEN
620: RAISE NO_DATA_FOUND;

Line 626: END igs_co_ltr_parm_type_pkg;

622:
623: END delete_row;
624:
625:
626: END igs_co_ltr_parm_type_pkg;