APPS.IGS_AD_OU_STAT_PKG dependencies on IGS_AD_OU_STAT

Line 1: package body IGS_AD_OU_STAT_PKG as

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

Line 5: old_references IGS_AD_OU_STAT%RowType;

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

Line 6: new_references IGS_AD_OU_STAT%RowType;

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

Line 25: FROM IGS_AD_OU_STAT

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

Line 192: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OU_STAT (

188:
189: PROCEDURE Check_Child_Existance as
190: BEGIN
191:
192: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OU_STAT (
193: old_references.adm_outcome_status
194: );
195:
196: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_OU_STAT(

Line 196: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_OU_STAT(

192: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OU_STAT (
193: old_references.adm_outcome_status
194: );
195:
196: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_OU_STAT(
197: old_references.adm_outcome_status
198: );
199:
200: IGS_UC_MAP_OUT_STAT_PKG.GET_FK_IGS_AD_OU_STAT(

Line 200: IGS_UC_MAP_OUT_STAT_PKG.GET_FK_IGS_AD_OU_STAT(

196: IGS_UC_DEFAULTS_PKG.GET_FK_IGS_AD_OU_STAT(
197: old_references.adm_outcome_status
198: );
199:
200: IGS_UC_MAP_OUT_STAT_PKG.GET_FK_IGS_AD_OU_STAT(
201: old_references.adm_outcome_status
202: );
203:
204:

Line 215: FROM IGS_AD_OU_STAT

211: as
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_AD_OU_STAT
216: WHERE adm_outcome_status = x_adm_outcome_status AND
217: closed_ind = NVL(x_closed_ind,closed_ind);
218:
219: lv_rowid cur_rowid%RowType;

Line 241: FROM IGS_AD_OU_STAT

237: ) as
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM IGS_AD_OU_STAT
242: WHERE s_adm_outcome_status = x_s_adm_outcome_status ;
243:
244: lv_rowid cur_rowid%RowType;
245:

Line 348: cursor C is select ROWID from IGS_AD_OU_STAT

344: X_SYSTEM_DEFAULT_IND in VARCHAR2,
345: X_CLOSED_IND in VARCHAR2,
346: X_MODE in VARCHAR2
347: ) as
348: cursor C is select ROWID from IGS_AD_OU_STAT
349: where ADM_OUTCOME_STATUS = X_ADM_OUTCOME_STATUS;
350: X_LAST_UPDATE_DATE DATE;
351: X_LAST_UPDATED_BY NUMBER;
352: X_LAST_UPDATE_LOGIN NUMBER;

Line 388: insert into IGS_AD_OU_STAT (

384: x_last_updated_by=>X_LAST_UPDATED_BY ,
385: x_last_update_login=> X_LAST_UPDATE_LOGIN
386: );
387:
388: insert into IGS_AD_OU_STAT (
389: ADM_OUTCOME_STATUS,
390: DESCRIPTION,
391: S_ADM_OUTCOME_STATUS,
392: SYSTEM_DEFAULT_IND,

Line 442: from IGS_AD_OU_STAT

438: DESCRIPTION,
439: S_ADM_OUTCOME_STATUS,
440: SYSTEM_DEFAULT_IND,
441: CLOSED_IND
442: from IGS_AD_OU_STAT
443: WHERE ROWID = X_ROWID for update nowait ;
444: tlinfo c1%rowtype;
445:
446: begin

Line 520: update IGS_AD_OU_STAT set

516: x_last_updated_by=>X_LAST_UPDATED_BY ,
517: x_last_update_login=> X_LAST_UPDATE_LOGIN
518: );
519:
520: update IGS_AD_OU_STAT set
521: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
522: S_ADM_OUTCOME_STATUS = NEW_REFERENCES.S_ADM_OUTCOME_STATUS,
523: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
524: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 549: cursor c1 is select rowid from IGS_AD_OU_STAT

545: X_SYSTEM_DEFAULT_IND in VARCHAR2,
546: X_CLOSED_IND in VARCHAR2,
547: X_MODE in VARCHAR2
548: ) as
549: cursor c1 is select rowid from IGS_AD_OU_STAT
550: where ADM_OUTCOME_STATUS = X_ADM_OUTCOME_STATUS
551: ;
552:
553: begin

Line 589: delete from IGS_AD_OU_STAT

585: p_action=>'DELETE',
586: x_rowid=> X_ROWID
587: );
588:
589: delete from IGS_AD_OU_STAT
590: where ROWID = X_ROWID;
591: if (sql%notfound) then
592: raise no_data_found;
593: end if;

Line 602: end IGS_AD_OU_STAT_PKG;

598: );
599:
600: end DELETE_ROW;
601:
602: end IGS_AD_OU_STAT_PKG;