APPS.IGS_EN_CAT_MAPPING_PKG dependencies on IGS_EN_CAT_MAPPING

Line 1: package body IGS_EN_CAT_MAPPING_PKG AS

1: package body IGS_EN_CAT_MAPPING_PKG AS
2: /* $Header: IGSEI23B.pls 115.6 2003/10/30 13:28:24 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_CAT_MAPPING%RowType;
5: new_references IGS_EN_CAT_MAPPING%RowType;

Line 4: old_references IGS_EN_CAT_MAPPING%RowType;

1: package body IGS_EN_CAT_MAPPING_PKG AS
2: /* $Header: IGSEI23B.pls 115.6 2003/10/30 13:28:24 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_CAT_MAPPING%RowType;
5: new_references IGS_EN_CAT_MAPPING%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_CAT_MAPPING%RowType;

1: package body IGS_EN_CAT_MAPPING_PKG AS
2: /* $Header: IGSEI23B.pls 115.6 2003/10/30 13:28:24 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_CAT_MAPPING%RowType;
5: new_references IGS_EN_CAT_MAPPING%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_EN_CAT_MAPPING

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

Line 62: -- ON IGS_EN_CAT_MAPPING

58:
59: -- Trigger description :-
60: -- "OSS_TST".trg_ecm_br_iud
61: -- BEFORE INSERT OR DELETE OR UPDATE
62: -- ON IGS_EN_CAT_MAPPING
63: -- FOR EACH ROW
64:
65: PROCEDURE BeforeRowInsertUpdateDelete1(
66: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 70: v_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE;

66: p_inserting IN BOOLEAN DEFAULT FALSE,
67: p_updating IN BOOLEAN DEFAULT FALSE,
68: p_deleting IN BOOLEAN DEFAULT FALSE
69: ) AS
70: v_admission_cat IGS_EN_CAT_MAPPING.admission_cat%TYPE;
71: v_message_name varchar2(30);
72: BEGIN
73: IF p_inserting THEN
74: -- Validate the enrolment category closed indicator.

Line 182: FROM IGS_EN_CAT_MAPPING

178: ) RETURN BOOLEAN AS
179:
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM IGS_EN_CAT_MAPPING
183: WHERE enrolment_cat = x_enrolment_cat
184: AND admission_cat = x_admission_cat
185: FOR UPDATE NOWAIT;
186:

Line 209: FROM IGS_EN_CAT_MAPPING

205: ) AS
206:
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM IGS_EN_CAT_MAPPING
210: WHERE admission_cat = x_admission_cat ;
211:
212: lv_rowid cur_rowid%RowType;
213:

Line 235: FROM IGS_EN_CAT_MAPPING

231: ) AS
232:
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM IGS_EN_CAT_MAPPING
236: WHERE enrolment_cat = x_enrolment_cat ;
237:
238: lv_rowid cur_rowid%RowType;
239:

Line 350: cursor C is select ROWID from IGS_EN_CAT_MAPPING

346: X_ADMISSION_CAT in VARCHAR2,
347: X_DFLT_CAT_IND in VARCHAR2,
348: X_MODE in VARCHAR2 default 'R'
349: ) AS
350: cursor C is select ROWID from IGS_EN_CAT_MAPPING
351: where ENROLMENT_CAT = X_ENROLMENT_CAT
352: and ADMISSION_CAT = X_ADMISSION_CAT;
353: X_LAST_UPDATE_DATE DATE;
354: X_LAST_UPDATED_BY NUMBER;

Line 387: insert into IGS_EN_CAT_MAPPING (

383: x_last_update_date => X_LAST_UPDATE_DATE,
384: x_last_updated_by => X_LAST_UPDATED_BY,
385: x_last_update_login => X_LAST_UPDATE_LOGIN
386: );
387: insert into IGS_EN_CAT_MAPPING (
388: ENROLMENT_CAT,
389: ADMISSION_CAT,
390: DFLT_CAT_IND,
391: CREATION_DATE,

Line 429: from IGS_EN_CAT_MAPPING

425: X_DFLT_CAT_IND in VARCHAR2
426: ) AS
427: cursor c1 is select
428: DFLT_CAT_IND
429: from IGS_EN_CAT_MAPPING
430: where ROWID = X_ROWID for update nowait;
431: tlinfo c1%rowtype;
432:
433: begin

Line 497: update IGS_EN_CAT_MAPPING set

493: x_last_update_date => X_LAST_UPDATE_DATE,
494: x_last_updated_by => X_LAST_UPDATED_BY,
495: x_last_update_login => X_LAST_UPDATE_LOGIN
496: );
497: update IGS_EN_CAT_MAPPING set
498: DFLT_CAT_IND = NEW_REFERENCES.DFLT_CAT_IND,
499: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
500: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
501: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 520: cursor c1 is select rowid from IGS_EN_CAT_MAPPING

516: X_ADMISSION_CAT in VARCHAR2,
517: X_DFLT_CAT_IND in VARCHAR2,
518: X_MODE in VARCHAR2 default 'R'
519: ) AS
520: cursor c1 is select rowid from IGS_EN_CAT_MAPPING
521: where ENROLMENT_CAT = X_ENROLMENT_CAT
522: and ADMISSION_CAT = X_ADMISSION_CAT
523: ;
524:

Line 555: delete from IGS_EN_CAT_MAPPING

551: Before_DML (
552: p_action => 'DELETE',
553: x_rowid => X_ROWID
554: );
555: delete from IGS_EN_CAT_MAPPING
556: where ROWID = X_ROWID;
557: if (sql%notfound) then
558: raise no_data_found;
559: end if;

Line 566: end IGS_EN_CAT_MAPPING_PKG;

562: x_rowid => X_ROWID
563: );
564: end DELETE_ROW;
565:
566: end IGS_EN_CAT_MAPPING_PKG;