APPS.IGS_AD_APPL_STAT_PKG dependencies on IGS_AD_APPL_STAT

Line 1: package body IGS_AD_APPL_STAT_PKG as

1: package body IGS_AD_APPL_STAT_PKG as
2: /* $Header: IGSAI12B.pls 115.8 2003/10/30 13:11:12 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_APPL_STAT%RowType;

Line 5: old_references IGS_AD_APPL_STAT%RowType;

1: package body IGS_AD_APPL_STAT_PKG as
2: /* $Header: IGSAI12B.pls 115.8 2003/10/30 13:11:12 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_APPL_STAT%RowType;
6: new_references IGS_AD_APPL_STAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_APPL_STAT%RowType;

2: /* $Header: IGSAI12B.pls 115.8 2003/10/30 13:11:12 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_APPL_STAT%RowType;
6: new_references IGS_AD_APPL_STAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_AD_APPL_STAT

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_AD_APPL_STAT
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 170: IGS_AD_APPL_PKG.GET_FK_IGS_AD_APPL_STAT (

166:
167: PROCEDURE Check_Child_Existance AS
168: BEGIN
169:
170: IGS_AD_APPL_PKG.GET_FK_IGS_AD_APPL_STAT (
171: old_references.adm_appl_status
172: );
173:
174: END Check_Child_Existance;

Line 182: FROM IGS_AD_APPL_STAT

178: x_closed_ind IN VARCHAR2 )
179: RETURN BOOLEAN AS
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM IGS_AD_APPL_STAT
183: WHERE adm_appl_status = x_adm_appl_status AND
184: closed_ind = NVL(x_closed_ind,closed_ind);
185:
186: lv_rowid cur_rowid%RowType;

Line 205: FROM IGS_AD_APPL_STAT

201: ) AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_AD_APPL_STAT
206: WHERE s_adm_appl_status = x_s_adm_appl_status ;
207:
208: lv_rowid cur_rowid%RowType;
209:

Line 317: cursor C is select ROWID from IGS_AD_APPL_STAT

313: X_SYSTEM_DEFAULT_IND in VARCHAR2,
314: X_CLOSED_IND in VARCHAR2,
315: X_MODE in VARCHAR2 default 'R'
316: ) AS
317: cursor C is select ROWID from IGS_AD_APPL_STAT
318: where ADM_APPL_STATUS = X_ADM_APPL_STATUS;
319: X_LAST_UPDATE_DATE DATE;
320: X_LAST_UPDATED_BY NUMBER;
321: X_LAST_UPDATE_LOGIN NUMBER;

Line 357: insert into IGS_AD_APPL_STAT (

353: x_last_updated_by=>X_LAST_UPDATED_BY,
354: x_last_update_login=>X_LAST_UPDATE_LOGIN
355: );
356:
357: insert into IGS_AD_APPL_STAT (
358: ADM_APPL_STATUS,
359: DESCRIPTION,
360: S_ADM_APPL_STATUS,
361: SYSTEM_DEFAULT_IND,

Line 408: from IGS_AD_APPL_STAT

404: DESCRIPTION,
405: S_ADM_APPL_STATUS,
406: SYSTEM_DEFAULT_IND,
407: CLOSED_IND
408: from IGS_AD_APPL_STAT
409: where ROWID = X_ROWID for update nowait;
410: tlinfo c1%rowtype;
411:
412: begin

Line 485: update IGS_AD_APPL_STAT set

481: x_last_updated_by=>X_LAST_UPDATED_BY,
482: x_last_update_login=>X_LAST_UPDATE_LOGIN
483: );
484:
485: update IGS_AD_APPL_STAT set
486: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
487: S_ADM_APPL_STATUS = NEW_REFERENCES.S_ADM_APPL_STATUS,
488: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
489: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 514: cursor c1 is select rowid from IGS_AD_APPL_STAT

510: X_SYSTEM_DEFAULT_IND in VARCHAR2,
511: X_CLOSED_IND in VARCHAR2,
512: X_MODE in VARCHAR2 default 'R'
513: ) AS
514: cursor c1 is select rowid from IGS_AD_APPL_STAT
515: where ADM_APPL_STATUS = X_ADM_APPL_STATUS
516: ;
517: begin
518: open c1;

Line 552: delete from IGS_AD_APPL_STAT

548: Before_DML (
549: p_action => 'DELETE',
550: x_rowid => X_ROWID);
551:
552: delete from IGS_AD_APPL_STAT
553: where ROWID = X_ROWID;
554: if (sql%notfound) then
555: raise no_data_found;
556: end if;

Line 564: end IGS_AD_APPL_STAT_PKG;

560: x_rowid => X_ROWID);
561:
562: end DELETE_ROW;
563:
564: end IGS_AD_APPL_STAT_PKG;