APPS.IGS_EN_ENCMB_EFCTTYP_PKG dependencies on IGS_EN_ENCMB_EFCTTYP

Line 1: package body IGS_EN_ENCMB_EFCTTYP_PKG AS

1: package body IGS_EN_ENCMB_EFCTTYP_PKG AS
2: /* $Header: IGSEI32B.pls 115.5 2003/02/17 12:31:08 adhawan ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ENCMB_EFCTTYP%RowType;

Line 5: old_references IGS_EN_ENCMB_EFCTTYP%RowType;

1: package body IGS_EN_ENCMB_EFCTTYP_PKG AS
2: /* $Header: IGSEI32B.pls 115.5 2003/02/17 12:31:08 adhawan ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ENCMB_EFCTTYP%RowType;
6: new_references IGS_EN_ENCMB_EFCTTYP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_EN_ENCMB_EFCTTYP%RowType;

2: /* $Header: IGSEI32B.pls 115.5 2003/02/17 12:31:08 adhawan ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_ENCMB_EFCTTYP%RowType;
6: new_references IGS_EN_ENCMB_EFCTTYP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_EN_ENCMB_EFCTTYP

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_EN_ENCMB_EFCTTYP
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 111: FROM IGS_EN_ENCMB_EFCTTYP

107: ) RETURN BOOLEAN AS
108:
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_EN_ENCMB_EFCTTYP
112: WHERE s_encmb_effect_type = x_s_encmb_effect_type;
113:
114:
115: lv_rowid cur_rowid%RowType;

Line 214: cursor C is select ROWID from IGS_EN_ENCMB_EFCTTYP

210: X_APPLY_TO_COURSE_IND in VARCHAR2,
211: X_CLOSED_IND in VARCHAR2,
212: X_MODE in VARCHAR2 default 'R'
213: ) AS
214: cursor C is select ROWID from IGS_EN_ENCMB_EFCTTYP
215: where S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE;
216: X_LAST_UPDATE_DATE DATE;
217: X_LAST_UPDATED_BY NUMBER;
218: X_LAST_UPDATE_LOGIN NUMBER;

Line 250: insert into IGS_EN_ENCMB_EFCTTYP (

246: x_last_update_date => x_last_update_date,
247: x_last_updated_by => x_last_updated_by,
248: x_last_update_login => x_last_update_login
249: );
250: insert into IGS_EN_ENCMB_EFCTTYP (
251: S_ENCMB_EFFECT_TYPE,
252: APPLY_TO_COURSE_IND,
253: CLOSED_IND,
254: CREATION_DATE,

Line 291: from IGS_EN_ENCMB_EFCTTYP

287: ) AS
288: cursor c1 is select
289: APPLY_TO_COURSE_IND,
290: CLOSED_IND
291: from IGS_EN_ENCMB_EFCTTYP
292: where ROWID = X_ROWID for update nowait;
293: tlinfo c1%rowtype;
294:
295: begin

Line 361: update IGS_EN_ENCMB_EFCTTYP set

357: x_last_update_date => x_last_update_date,
358: x_last_updated_by => x_last_updated_by,
359: x_last_update_login => x_last_update_login
360: );
361: update IGS_EN_ENCMB_EFCTTYP set
362: APPLY_TO_COURSE_IND = X_APPLY_TO_COURSE_IND,
363: CLOSED_IND = X_CLOSED_IND,
364: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
365: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 384: cursor c1 is select rowid from IGS_EN_ENCMB_EFCTTYP

380: X_APPLY_TO_COURSE_IND in VARCHAR2,
381: X_CLOSED_IND in VARCHAR2,
382: X_MODE in VARCHAR2 default 'R'
383: ) AS
384: cursor c1 is select rowid from IGS_EN_ENCMB_EFCTTYP
385: where S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE;
386:
387: begin
388: open c1;

Line 410: END igs_en_encmb_efcttyp_pkg;

406: X_MODE);
407: end ADD_ROW;
408:
409:
410: END igs_en_encmb_efcttyp_pkg;