APPS.IGS_AD_UNIT_OU_STAT_PKG dependencies on IGS_AD_UNIT_OU_STAT

Line 1: package body IGS_AD_UNIT_OU_STAT_PKG as

1: package body IGS_AD_UNIT_OU_STAT_PKG as
2: /* $Header: IGSAI38B.pls 115.5 2003/10/30 13:12:47 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_UNIT_OU_STAT%RowType;

Line 5: old_references IGS_AD_UNIT_OU_STAT%RowType;

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

Line 6: new_references IGS_AD_UNIT_OU_STAT%RowType;

2: /* $Header: IGSAI38B.pls 115.5 2003/10/30 13:12:47 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_UNIT_OU_STAT%RowType;
6: new_references IGS_AD_UNIT_OU_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_UNIT_OU_STAT

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

Line 178: IGS_AD_PS_APLINSTUNT_PKG.GET_FK_IGS_AD_UNIT_OU_STAT (

174:
175: PROCEDURE Check_Child_Existance as
176: BEGIN
177:
178: IGS_AD_PS_APLINSTUNT_PKG.GET_FK_IGS_AD_UNIT_OU_STAT (
179: old_references.adm_unit_outcome_status
180: );
181:
182: END Check_Child_Existance;

Line 191: FROM IGS_AD_UNIT_OU_STAT

187: )return BOOLEAN AS
188:
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM IGS_AD_UNIT_OU_STAT
192: WHERE adm_unit_outcome_status = x_adm_unit_outcome_status AND
193: closed_ind = NVL(x_closed_ind,closed_ind)
194: FOR UPDATE NOWAIT;
195:

Line 218: FROM IGS_AD_UNIT_OU_STAT

214: ) AS
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_AD_UNIT_OU_STAT
219: WHERE s_adm_outcome_status = x_s_adm_outcome_status ;
220:
221: lv_rowid cur_rowid%RowType;
222:

Line 325: cursor C is select ROWID from IGS_AD_UNIT_OU_STAT

321: X_SYSTEM_DEFAULT_IND in VARCHAR2,
322: X_CLOSED_IND in VARCHAR2,
323: X_MODE in VARCHAR2 default 'R'
324: ) as
325: cursor C is select ROWID from IGS_AD_UNIT_OU_STAT
326: where ADM_UNIT_OUTCOME_STATUS = X_ADM_UNIT_OUTCOME_STATUS;
327: X_LAST_UPDATE_DATE DATE;
328: X_LAST_UPDATED_BY NUMBER;
329: X_LAST_UPDATE_LOGIN NUMBER;

Line 363: insert into IGS_AD_UNIT_OU_STAT (

359: x_last_update_date => X_LAST_UPDATE_DATE,
360: x_last_updated_by => X_LAST_UPDATED_BY,
361: x_last_update_login => X_LAST_UPDATE_LOGIN
362: );
363: insert into IGS_AD_UNIT_OU_STAT (
364: ADM_UNIT_OUTCOME_STATUS,
365: DESCRIPTION,
366: S_ADM_OUTCOME_STATUS,
367: SYSTEM_DEFAULT_IND,

Line 415: from IGS_AD_UNIT_OU_STAT

411: DESCRIPTION,
412: S_ADM_OUTCOME_STATUS,
413: SYSTEM_DEFAULT_IND,
414: CLOSED_IND
415: from IGS_AD_UNIT_OU_STAT
416: where ROWID = X_ROWID for update nowait;
417: tlinfo c1%rowtype;
418:
419: begin

Line 490: update IGS_AD_UNIT_OU_STAT set

486: x_last_update_date => X_LAST_UPDATE_DATE,
487: x_last_updated_by => X_LAST_UPDATED_BY,
488: x_last_update_login => X_LAST_UPDATE_LOGIN
489: );
490: update IGS_AD_UNIT_OU_STAT set
491: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
492: S_ADM_OUTCOME_STATUS = NEW_REFERENCES.S_ADM_OUTCOME_STATUS,
493: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
494: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 518: cursor c1 is select rowid from IGS_AD_UNIT_OU_STAT

514: X_SYSTEM_DEFAULT_IND in VARCHAR2,
515: X_CLOSED_IND in VARCHAR2,
516: X_MODE in VARCHAR2 default 'R'
517: ) as
518: cursor c1 is select rowid from IGS_AD_UNIT_OU_STAT
519: where ADM_UNIT_OUTCOME_STATUS = X_ADM_UNIT_OUTCOME_STATUS
520: ;
521: begin
522: open c1;

Line 557: delete from IGS_AD_UNIT_OU_STAT

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

Line 570: end IGS_AD_UNIT_OU_STAT_PKG;

566: );
567:
568: end DELETE_ROW;
569:
570: end IGS_AD_UNIT_OU_STAT_PKG;