APPS.IGS_AD_ADM_UNIT_STAT_PKG dependencies on IGS_AD_ADM_UNIT_STAT_ALL

Line 4: old_references IGS_AD_ADM_UNIT_STAT_ALL%RowType;

1: package body IGS_AD_ADM_UNIT_STAT_PKG AS
2: /* $Header: IGSAI01B.pls 115.12 2003/10/30 13:09:45 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_ADM_UNIT_STAT_ALL%RowType;
5: new_references IGS_AD_ADM_UNIT_STAT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_ADM_UNIT_STAT_ALL%RowType;

1: package body IGS_AD_ADM_UNIT_STAT_PKG AS
2: /* $Header: IGSAI01B.pls 115.12 2003/10/30 13:09:45 akadam ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_ADM_UNIT_STAT_ALL%RowType;
5: new_references IGS_AD_ADM_UNIT_STAT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_AD_ADM_UNIT_STAT_ALL

22: x_last_update_login IN NUMBER DEFAULT NULL
23: ) AS
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AD_ADM_UNIT_STAT_ALL
27: WHERE rowid = x_rowid;
28: BEGIN
29:
30: l_rowid := x_rowid;

Line 187: FROM IGS_AD_ADM_UNIT_STAT_ALL

183: ) RETURN BOOLEAN AS
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_AD_ADM_UNIT_STAT_ALL
188: WHERE administrative_unit_status = x_administrative_unit_status AND
189: closed_ind = NVL(x_closed_ind,closed_ind);
190:
191:

Line 215: FROM IGS_AD_ADM_UNIT_STAT_ALL

211: ) AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_AD_ADM_UNIT_STAT_ALL
216: WHERE unit_attempt_status = x_unit_attempt_status ;
217:
218: lv_rowid cur_rowid%RowType;
219:

Line 321: cursor C is select ROWID from IGS_AD_ADM_UNIT_STAT_ALL

317: X_EFFECTIVE_TIME_ELAPSED_IND in VARCHAR2,
318: X_CLOSED_IND in VARCHAR2,
319: X_MODE in VARCHAR2 default 'R'
320: ) AS
321: cursor C is select ROWID from IGS_AD_ADM_UNIT_STAT_ALL
322: where ADMINISTRATIVE_UNIT_STATUS = X_ADMINISTRATIVE_UNIT_STATUS;
323: X_LAST_UPDATE_DATE DATE;
324: X_LAST_UPDATED_BY NUMBER;
325: X_LAST_UPDATE_LOGIN NUMBER;

Line 364: insert into IGS_AD_ADM_UNIT_STAT_ALL (

360: x_last_updated_by =>X_LAST_UPDATED_BY,
361: x_last_update_login =>X_LAST_UPDATE_LOGIN
362: );
363:
364: insert into IGS_AD_ADM_UNIT_STAT_ALL (
365: ORG_ID,
366: ADMINISTRATIVE_UNIT_STATUS,
367: UNIT_ATTEMPT_STATUS,
368: DESCRIPTION,

Line 424: from IGS_AD_ADM_UNIT_STAT_ALL

420: SHOW_ON_OFFIC_NTFCTN_IND,
421: EFFECTIVE_PROGRESSION_IND,
422: EFFECTIVE_TIME_ELAPSED_IND,
423: CLOSED_IND
424: from IGS_AD_ADM_UNIT_STAT_ALL
425: where ROWID = X_ROWID
426: for update nowait;
427: tlinfo c1%rowtype;
428:

Line 506: update IGS_AD_ADM_UNIT_STAT_ALL set

502: x_last_updated_by =>X_LAST_UPDATED_BY,
503: x_last_update_login =>X_LAST_UPDATE_LOGIN
504: );
505:
506: update IGS_AD_ADM_UNIT_STAT_ALL set
507: UNIT_ATTEMPT_STATUS = NEW_REFERENCES.UNIT_ATTEMPT_STATUS,
508: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
509: SHOW_ON_OFFIC_NTFCTN_IND = NEW_REFERENCES.SHOW_ON_OFFIC_NTFCTN_IND,
510: EFFECTIVE_PROGRESSION_IND = NEW_REFERENCES.EFFECTIVE_PROGRESSION_IND,

Line 539: cursor c1 is select rowid from IGS_AD_ADM_UNIT_STAT_ALL

535: X_EFFECTIVE_TIME_ELAPSED_IND in VARCHAR2,
536: X_CLOSED_IND in VARCHAR2,
537: X_MODE in VARCHAR2 default 'R'
538: ) AS
539: cursor c1 is select rowid from IGS_AD_ADM_UNIT_STAT_ALL
540: where ADMINISTRATIVE_UNIT_STATUS = X_ADMINISTRATIVE_UNIT_STATUS
541: ;
542: begin
543: open c1;