APPS.IGS_CO_S_LTR_PR_RSTN_PKG dependencies on IGS_CO_S_LTR_PR_RSTN

Line 1: PACKAGE BODY igs_co_s_ltr_pr_rstn_pkg AS

1: PACKAGE BODY igs_co_s_ltr_pr_rstn_pkg AS
2: /* $Header: IGSLI20B.pls 115.5 2002/11/29 01:07:10 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_co_s_ltr_pr_rstn%ROWTYPE;

Line 5: old_references igs_co_s_ltr_pr_rstn%ROWTYPE;

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

Line 6: new_references igs_co_s_ltr_pr_rstn%ROWTYPE;

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

Line 31: FROM IGS_CO_S_LTR_PR_RSTN

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

Line 122: FROM igs_co_s_ltr_pr_rstn

118: || (reverse chronological order - newest change first)
119: */
120: CURSOR cur_rowid IS
121: SELECT rowid
122: FROM igs_co_s_ltr_pr_rstn
123: WHERE s_letter_parameter_type = x_s_letter_parameter_type
124: AND correspondence_type = x_correspondence_type
125: FOR UPDATE NOWAIT;
126:

Line 158: FROM igs_co_s_ltr_pr_rstn

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

Line 193: FROM igs_co_s_ltr_pr_rstn

189: || (reverse chronological order - newest change first)
190: */
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM igs_co_s_ltr_pr_rstn
194: WHERE ((s_letter_parameter_type = x_s_letter_parameter_type));
195:
196: lv_rowid cur_rowid%RowType;
197:

Line 297: FROM igs_co_s_ltr_pr_rstn

293: || (reverse chronological order - newest change first)
294: */
295: CURSOR c IS
296: SELECT rowid
297: FROM igs_co_s_ltr_pr_rstn
298: WHERE s_letter_parameter_type = x_s_letter_parameter_type
299: AND correspondence_type = x_correspondence_type;
300:
301: x_last_update_date DATE;

Line 338: INSERT INTO igs_co_s_ltr_pr_rstn (

334: x_last_updated_by => x_last_updated_by,
335: x_last_update_login => x_last_update_login
336: );
337:
338: INSERT INTO igs_co_s_ltr_pr_rstn (
339: s_letter_parameter_type,
340: correspondence_type,
341: creation_date,
342: created_by,

Line 384: FROM igs_co_s_ltr_pr_rstn

380: */
381: CURSOR c1 IS
382: SELECT
383: rowid
384: FROM igs_co_s_ltr_pr_rstn
385: WHERE rowid = x_rowid
386: FOR UPDATE NOWAIT;
387:
388: tlinfo c1%ROWTYPE;

Line 428: DELETE FROM igs_co_s_ltr_pr_rstn

424: p_action => 'DELETE',
425: x_rowid => x_rowid
426: );
427:
428: DELETE FROM igs_co_s_ltr_pr_rstn
429: WHERE rowid = x_rowid;
430:
431: IF (SQL%NOTFOUND) THEN
432: RAISE NO_DATA_FOUND;

Line 438: END igs_co_s_ltr_pr_rstn_pkg;

434:
435: END delete_row;
436:
437:
438: END igs_co_s_ltr_pr_rstn_pkg;