APPS.IGS_AD_FEE_STAT_PKG dependencies on IGS_AD_FEE_STAT

Line 1: package body IGS_AD_FEE_STAT_PKG as

1: package body IGS_AD_FEE_STAT_PKG as
2: /* $Header: IGSAI25B.pls 115.6 2003/10/30 13:11:44 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_FEE_STAT%RowType;

Line 5: old_references IGS_AD_FEE_STAT%RowType;

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

Line 6: new_references IGS_AD_FEE_STAT%RowType;

2: /* $Header: IGSAI25B.pls 115.6 2003/10/30 13:11:44 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_FEE_STAT%RowType;
6: new_references IGS_AD_FEE_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_FEE_STAT

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

Line 191: IGS_AD_APPL_PKG.GET_FK_IGS_AD_FEE_STAT (

187:
188: PROCEDURE Check_Child_Existance as
189: BEGIN
190:
191: IGS_AD_APPL_PKG.GET_FK_IGS_AD_FEE_STAT (
192: old_references.adm_fee_status
193: );
194:
195: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_FEE_STAT (

Line 195: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_FEE_STAT (

191: IGS_AD_APPL_PKG.GET_FK_IGS_AD_FEE_STAT (
192: old_references.adm_fee_status
193: );
194:
195: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_FEE_STAT (
196: old_references.adm_fee_status
197: );
198:
199: END Check_Child_Existance;

Line 209: FROM IGS_AD_FEE_STAT

205: as
206:
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM IGS_AD_FEE_STAT
210: WHERE adm_fee_status = x_adm_fee_status AND
211: closed_ind = NVL(x_closed_ind,closed_ind);
212:
213: lv_rowid cur_rowid%RowType;

Line 235: FROM IGS_AD_FEE_STAT

231: ) as
232:
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM IGS_AD_FEE_STAT
236: WHERE s_adm_fee_status = x_s_adm_fee_status ;
237:
238: lv_rowid cur_rowid%RowType;
239:

Line 342: cursor C is select ROWID from IGS_AD_FEE_STAT

338: X_SYSTEM_DEFAULT_IND in VARCHAR2,
339: X_CLOSED_IND in VARCHAR2,
340: X_MODE in VARCHAR2 default 'R'
341: ) as
342: cursor C is select ROWID from IGS_AD_FEE_STAT
343: where ADM_FEE_STATUS = X_ADM_FEE_STATUS;
344: X_LAST_UPDATE_DATE DATE;
345: X_LAST_UPDATED_BY NUMBER;
346: X_LAST_UPDATE_LOGIN NUMBER;

Line 382: insert into IGS_AD_FEE_STAT (

378: x_last_updated_by=>X_LAST_UPDATED_BY ,
379: x_last_update_login=> X_LAST_UPDATE_LOGIN
380: );
381:
382: insert into IGS_AD_FEE_STAT (
383: ADM_FEE_STATUS,
384: DESCRIPTION,
385: S_ADM_FEE_STATUS,
386: SYSTEM_DEFAULT_IND,

Line 435: from IGS_AD_FEE_STAT

431: DESCRIPTION,
432: S_ADM_FEE_STATUS,
433: SYSTEM_DEFAULT_IND,
434: CLOSED_IND
435: from IGS_AD_FEE_STAT
436: WHERE ROWID = X_ROWID for update nowait ;
437:
438: tlinfo c1%rowtype;
439:

Line 513: update IGS_AD_FEE_STAT set

509: x_last_updated_by=>X_LAST_UPDATED_BY ,
510: x_last_update_login=> X_LAST_UPDATE_LOGIN
511: );
512:
513: update IGS_AD_FEE_STAT set
514: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
515: S_ADM_FEE_STATUS = NEW_REFERENCES.S_ADM_FEE_STATUS,
516: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
517: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 543: cursor c1 is select rowid from IGS_AD_FEE_STAT

539: X_SYSTEM_DEFAULT_IND in VARCHAR2,
540: X_CLOSED_IND in VARCHAR2,
541: X_MODE in VARCHAR2 default 'R'
542: ) as
543: cursor c1 is select rowid from IGS_AD_FEE_STAT
544: where ADM_FEE_STATUS = X_ADM_FEE_STATUS
545: ;
546:
547: begin

Line 584: delete from IGS_AD_FEE_STAT

580: x_rowid=> X_ROWID
581: );
582:
583:
584: delete from IGS_AD_FEE_STAT
585: where ROWID = X_ROWID;
586: if (sql%notfound) then
587: raise no_data_found;
588: end if;

Line 597: end IGS_AD_FEE_STAT_PKG;

593: );
594:
595: end DELETE_ROW;
596:
597: end IGS_AD_FEE_STAT_PKG;