APPS.IGS_GE_S_GEN_CAL_CON_PKG dependencies on IGS_GE_S_GEN_CAL_CON

Line 1: package body IGS_GE_S_GEN_CAL_CON_PKG as

1: package body IGS_GE_S_GEN_CAL_CON_PKG as
2: /* $Header: IGSMI08B.pls 115.3 2002/11/29 01:10:59 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GE_S_GEN_CAL_CON%RowType;
5: new_references IGS_GE_S_GEN_CAL_CON%RowType;

Line 4: old_references IGS_GE_S_GEN_CAL_CON%RowType;

1: package body IGS_GE_S_GEN_CAL_CON_PKG as
2: /* $Header: IGSMI08B.pls 115.3 2002/11/29 01:10:59 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GE_S_GEN_CAL_CON%RowType;
5: new_references IGS_GE_S_GEN_CAL_CON%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GE_S_GEN_CAL_CON%RowType;

1: package body IGS_GE_S_GEN_CAL_CON_PKG as
2: /* $Header: IGSMI08B.pls 115.3 2002/11/29 01:10:59 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GE_S_GEN_CAL_CON%RowType;
5: new_references IGS_GE_S_GEN_CAL_CON%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_GE_S_GEN_CAL_CON

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

Line 158: FROM IGS_GE_S_GEN_CAL_CON

154: ) RETURN BOOLEAN as
155:
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM IGS_GE_S_GEN_CAL_CON
159: WHERE s_control_num = x_s_control_num
160: FOR UPDATE NOWAIT;
161:
162: lv_rowid cur_rowid%RowType;

Line 184: FROM IGS_GE_S_GEN_CAL_CON

180: ) as
181:
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM IGS_GE_S_GEN_CAL_CON
185: WHERE census_dt_alias = x_dt_alias
186: OR crs_completion_cutoff_dt_alias = x_dt_alias ;
187:
188: lv_rowid cur_rowid%RowType;

Line 295: cursor C is select ROWID from IGS_GE_S_GEN_CAL_CON

291: X_CENSUS_DT_ALIAS in VARCHAR2,
292: CRS_COMPLETION_CUTOFF_DT_ALI in VARCHAR2,
293: X_MODE in VARCHAR2 default 'R'
294: ) as
295: cursor C is select ROWID from IGS_GE_S_GEN_CAL_CON
296: where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM;
297: X_LAST_UPDATE_DATE DATE;
298: X_LAST_UPDATED_BY NUMBER;
299: X_LAST_UPDATE_LOGIN NUMBER;

Line 332: insert into IGS_GE_S_GEN_CAL_CON (

328: x_last_update_date => X_LAST_UPDATE_DATE,
329: x_last_update_login => X_LAST_UPDATE_LOGIN
330: );
331:
332: insert into IGS_GE_S_GEN_CAL_CON (
333: S_CONTROL_NUM,
334: CENSUS_DT_ALIAS,
335: CRS_COMPLETION_CUTOFF_DT_ALIAS,
336: CREATION_DATE,

Line 375: from IGS_GE_S_GEN_CAL_CON

371: ) as
372: cursor c1 is select
373: CENSUS_DT_ALIAS,
374: CRS_COMPLETION_CUTOFF_DT_ALIAS
375: from IGS_GE_S_GEN_CAL_CON
376: where ROWID = X_ROWID
377: for update nowait;
378: tlinfo c1%rowtype;
379:

Line 447: update IGS_GE_S_GEN_CAL_CON set

443: x_last_updated_by => X_LAST_UPDATED_BY,
444: x_last_update_date => X_LAST_UPDATE_DATE,
445: x_last_update_login => X_LAST_UPDATE_LOGIN
446: );
447: update IGS_GE_S_GEN_CAL_CON set
448: CENSUS_DT_ALIAS = NEW_REFERENCES.CENSUS_DT_ALIAS,
449: CRS_COMPLETION_CUTOFF_DT_ALIAS = NEW_REFERENCES.CRS_COMPLETION_CUTOFF_DT_ALIAS,
450: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
451: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 471: cursor c1 is select rowid from IGS_GE_S_GEN_CAL_CON

467: X_CENSUS_DT_ALIAS in VARCHAR2,
468: X_CRS_COMPLETION_CUTOFF_DT_ALI in VARCHAR2,
469: X_MODE in VARCHAR2 default 'R'
470: ) as
471: cursor c1 is select rowid from IGS_GE_S_GEN_CAL_CON
472: where S_CONTROL_NUM = NVL(X_S_CONTROL_NUM,1)
473: ;
474:
475: begin

Line 505: delete from IGS_GE_S_GEN_CAL_CON

501: Before_DML (
502: p_action => 'DELETE',
503: x_rowid => X_ROWID
504: );
505: delete from IGS_GE_S_GEN_CAL_CON
506: where ROWID = X_ROWID;
507: if (sql%notfound) then
508: raise no_data_found;
509: end if;

Line 517: end IGS_GE_S_GEN_CAL_CON_PKG;

513: );
514:
515: end DELETE_ROW;
516:
517: end IGS_GE_S_GEN_CAL_CON_PKG;