APPS.IGS_EN_DCNT_REASONCD_PKG dependencies on IGS_EN_DCNT_REASONCD_ALL

Line 4: old_references IGS_EN_DCNT_REASONCD_ALL%RowType;

1: package body IGS_EN_DCNT_REASONCD_PKG AS
2: /* $Header: IGSEI20B.pls 115.8 2003/02/20 08:55:14 prraj ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_DCNT_REASONCD_ALL%RowType;
5: new_references IGS_EN_DCNT_REASONCD_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_DCNT_REASONCD_ALL%RowType;

1: package body IGS_EN_DCNT_REASONCD_PKG AS
2: /* $Header: IGSEI20B.pls 115.8 2003/02/20 08:55:14 prraj ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_DCNT_REASONCD_ALL%RowType;
5: new_references IGS_EN_DCNT_REASONCD_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_EN_DCNT_REASONCD_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_EN_DCNT_REASONCD_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 212: FROM IGS_EN_DCNT_REASONCD_ALL

208: ) RETURN BOOLEAN AS
209:
210: CURSOR cur_rowid IS
211: SELECT rowid
212: FROM IGS_EN_DCNT_REASONCD_ALL
213: WHERE discontinuation_reason_cd = x_dcnt_reason_cd;
214:
215: lv_rowid cur_rowid%RowType;
216:

Line 257: FROM IGS_EN_DCNT_REASONCD_ALL

253: ) AS
254:
255: CURSOR cur_rowid IS
256: SELECT rowid
257: FROM IGS_EN_DCNT_REASONCD_ALL
258: WHERE s_discontinuation_reason_type = x_s_dcnt_reason_type ;
259:
260: lv_rowid cur_rowid%RowType;
261:

Line 384: cursor C is select ROWID from IGS_EN_DCNT_REASONCD_ALL

380: X_CLOSED_IND in VARCHAR2,
381: X_COMMENTS in VARCHAR2,
382: X_MODE in VARCHAR2 default 'R'
383: ) AS
384: cursor C is select ROWID from IGS_EN_DCNT_REASONCD_ALL
385: where DISCONTINUATION_REASON_CD = X_DISCONTINUATION_REASON_CD;
386: X_LAST_UPDATE_DATE DATE;
387: X_LAST_UPDATED_BY NUMBER;
388: X_LAST_UPDATE_LOGIN NUMBER;

Line 427: insert into IGS_EN_DCNT_REASONCD_ALL (

423: x_last_update_date => X_LAST_UPDATE_DATE,
424: x_last_updated_by => X_LAST_UPDATED_BY,
425: x_last_update_login => X_LAST_UPDATE_LOGIN
426: );
427: insert into IGS_EN_DCNT_REASONCD_ALL (
428: org_id,
429: DISCONTINUATION_REASON_CD,
430: DESCRIPTION,
431: DFLT_IND,

Line 498: from IGS_EN_DCNT_REASONCD_ALL

494: S_DISCONTINUATION_REASON_TYPE,
495: SYS_DFLT_IND,
496: CLOSED_IND,
497: COMMENTS
498: from IGS_EN_DCNT_REASONCD_ALL
499: where ROWID = X_ROWID for update nowait;
500: tlinfo c1%rowtype;
501:
502: begin

Line 593: update IGS_EN_DCNT_REASONCD_ALL set

589: x_last_update_date => X_LAST_UPDATE_DATE,
590: x_last_updated_by => X_LAST_UPDATED_BY,
591: x_last_update_login => X_LAST_UPDATE_LOGIN
592: );
593: update IGS_EN_DCNT_REASONCD_ALL set
594: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
595: DFLT_IND = NEW_REFERENCES.DFLT_IND,
596: DCNT_PROGRAM_IND = NEW_REFERENCES.DCNT_PROGRAM_IND,
597: DCNT_UNIT_IND = NEW_REFERENCES.DCNT_UNIT_IND,

Line 630: cursor c1 is select rowid from IGS_EN_DCNT_REASONCD_ALL

626: X_CLOSED_IND in VARCHAR2,
627: X_COMMENTS in VARCHAR2,
628: X_MODE in VARCHAR2 default 'R'
629: ) AS
630: cursor c1 is select rowid from IGS_EN_DCNT_REASONCD_ALL
631: where DISCONTINUATION_REASON_CD = X_DISCONTINUATION_REASON_CD;
632:
633: begin
634: open c1;