APPS.IGS_AD_OFRDFRMT_STAT_PKG dependencies on IGS_AD_OFRDFRMT_STAT

Line 1: package body IGS_AD_OFRDFRMT_STAT_PKG as

1: package body IGS_AD_OFRDFRMT_STAT_PKG as
2: /* $Header: IGSAI26B.pls 115.6 2003/10/30 13:11:48 akadam ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_AD_OFRDFRMT_STAT%RowType;

2: /* $Header: IGSAI26B.pls 115.6 2003/10/30 13:11:48 akadam ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AD_OFRDFRMT_STAT%RowType;
7: new_references IGS_AD_OFRDFRMT_STAT%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_AD_OFRDFRMT_STAT%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AD_OFRDFRMT_STAT%RowType;
7: new_references IGS_AD_OFRDFRMT_STAT%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_AD_OFRDFRMT_STAT

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

Line 190: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OFRDFRMT_STAT (

186:
187: PROCEDURE Check_Child_Existance as
188: BEGIN
189:
190: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OFRDFRMT_STAT (
191: old_references.adm_offer_dfrmnt_status
192: );
193:
194: END Check_Child_Existance;

Line 204: FROM IGS_AD_OFRDFRMT_STAT

200: as
201:
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM IGS_AD_OFRDFRMT_STAT
205: WHERE adm_offer_dfrmnt_status = x_adm_offer_dfrmnt_status AND
206: closed_ind = NVL(x_closed_ind,closed_ind);
207:
208: lv_rowid cur_rowid%RowType;

Line 230: FROM IGS_AD_OFRDFRMT_STAT

226: ) as
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM IGS_AD_OFRDFRMT_STAT
231: WHERE s_adm_offer_dfrmnt_status = x_s_adm_offer_dfrmnt_status ;
232:
233: lv_rowid cur_rowid%RowType;
234:

Line 336: cursor C is select ROWID from IGS_AD_OFRDFRMT_STAT

332: X_SYSTEM_DEFAULT_IND in VARCHAR2,
333: X_CLOSED_IND in VARCHAR2,
334: X_MODE in VARCHAR2 default 'R'
335: ) as
336: cursor C is select ROWID from IGS_AD_OFRDFRMT_STAT
337: where ADM_OFFER_DFRMNT_STATUS = X_ADM_OFFER_DFRMNT_STATUS;
338: X_LAST_UPDATE_DATE DATE;
339: X_LAST_UPDATED_BY NUMBER;
340: X_LAST_UPDATE_LOGIN NUMBER;

Line 376: insert into IGS_AD_OFRDFRMT_STAT (

372: x_last_updated_by=>X_LAST_UPDATED_BY ,
373: x_last_update_login=> X_LAST_UPDATE_LOGIN
374: );
375:
376: insert into IGS_AD_OFRDFRMT_STAT (
377: ADM_OFFER_DFRMNT_STATUS,
378: DESCRIPTION,
379: S_ADM_OFFER_DFRMNT_STATUS,
380: SYSTEM_DEFAULT_IND,

Line 429: from IGS_AD_OFRDFRMT_STAT

425: DESCRIPTION,
426: S_ADM_OFFER_DFRMNT_STATUS,
427: SYSTEM_DEFAULT_IND,
428: CLOSED_IND
429: from IGS_AD_OFRDFRMT_STAT
430: WHERE ROWID = X_ROWID for update nowait ;
431: tlinfo c1%rowtype;
432:
433: begin

Line 507: update IGS_AD_OFRDFRMT_STAT set

503: x_last_update_login=> X_LAST_UPDATE_LOGIN
504: );
505:
506:
507: update IGS_AD_OFRDFRMT_STAT set
508: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
509: S_ADM_OFFER_DFRMNT_STATUS = NEW_REFERENCES.S_ADM_OFFER_DFRMNT_STATUS,
510: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
511: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 537: cursor c1 is select rowid from IGS_AD_OFRDFRMT_STAT

533: X_SYSTEM_DEFAULT_IND in VARCHAR2,
534: X_CLOSED_IND in VARCHAR2,
535: X_MODE in VARCHAR2 default 'R'
536: ) as
537: cursor c1 is select rowid from IGS_AD_OFRDFRMT_STAT
538: where ADM_OFFER_DFRMNT_STATUS = X_ADM_OFFER_DFRMNT_STATUS
539: ;
540:
541: begin

Line 577: delete from IGS_AD_OFRDFRMT_STAT

573: p_action=>'DELETE',
574: x_rowid=> X_ROWID
575: );
576:
577: delete from IGS_AD_OFRDFRMT_STAT
578: where ROWID = X_ROWID;
579: if (sql%notfound) then
580: raise no_data_found;
581: end if;

Line 592: end IGS_AD_OFRDFRMT_STAT_PKG;

588:
589:
590: end DELETE_ROW;
591:
592: end IGS_AD_OFRDFRMT_STAT_PKG;