APPS.IGS_AD_OFR_RESP_STAT_PKG dependencies on IGS_AD_OFR_RESP_STAT

Line 1: package body IGS_AD_OFR_RESP_STAT_PKG as

1: package body IGS_AD_OFR_RESP_STAT_PKG as
2: /* $Header: IGSAI27B.pls 115.7 2003/10/30 13:11:51 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_OFR_RESP_STAT%RowType;

Line 5: old_references IGS_AD_OFR_RESP_STAT%RowType;

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

Line 6: new_references IGS_AD_OFR_RESP_STAT%RowType;

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

Line 25: FROM IGS_AD_OFR_RESP_STAT

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

Line 187: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OFR_RESP_STAT (

183:
184: PROCEDURE Check_Child_Existance as
185: BEGIN
186:
187: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_OFR_RESP_STAT (
188: old_references.adm_offer_resp_status
189: );
190:
191: END Check_Child_Existance;

Line 201: FROM IGS_AD_OFR_RESP_STAT

197: as
198:
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_AD_OFR_RESP_STAT
202: WHERE adm_offer_resp_status = x_adm_offer_resp_status AND
203: closed_ind = NVL(x_closed_ind,closed_ind);
204:
205: lv_rowid cur_rowid%RowType;

Line 227: FROM IGS_AD_OFR_RESP_STAT

223: ) as
224:
225: CURSOR cur_rowid IS
226: SELECT rowid
227: FROM IGS_AD_OFR_RESP_STAT
228: WHERE s_adm_offer_resp_status = x_s_adm_offer_resp_status ;
229:
230: lv_rowid cur_rowid%RowType;
231:

Line 336: cursor C is select ROWID from IGS_AD_OFR_RESP_STAT

332: X_SYSTEM_DEFAULT_IND in VARCHAR2,
333: X_CLOSED_IND in VARCHAR2,
334: X_MODE in VARCHAR2
335: ) as
336: cursor C is select ROWID from IGS_AD_OFR_RESP_STAT
337: where ADM_OFFER_RESP_STATUS = X_ADM_OFFER_RESP_STATUS;
338: X_LAST_UPDATE_DATE DATE;
339: X_LAST_UPDATED_BY NUMBER;
340: X_LAST_UPDATE_LOGIN NUMBER;

Line 377: insert into IGS_AD_OFR_RESP_STAT (

373: x_last_update_login=> X_LAST_UPDATE_LOGIN
374: );
375:
376:
377: insert into IGS_AD_OFR_RESP_STAT (
378: ADM_OFFER_RESP_STATUS,
379: DESCRIPTION,
380: S_ADM_OFFER_RESP_STATUS,
381: SYSTEM_DEFAULT_IND,

Line 430: from IGS_AD_OFR_RESP_STAT

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

Line 509: update IGS_AD_OFR_RESP_STAT set

505: x_last_update_login=> X_LAST_UPDATE_LOGIN
506: );
507:
508:
509: update IGS_AD_OFR_RESP_STAT set
510: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
511: S_ADM_OFFER_RESP_STATUS = NEW_REFERENCES.S_ADM_OFFER_RESP_STATUS,
512: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
513: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 538: cursor c1 is select rowid from IGS_AD_OFR_RESP_STAT

534: X_SYSTEM_DEFAULT_IND in VARCHAR2,
535: X_CLOSED_IND in VARCHAR2,
536: X_MODE in VARCHAR2
537: ) as
538: cursor c1 is select rowid from IGS_AD_OFR_RESP_STAT
539: where ADM_OFFER_RESP_STATUS = X_ADM_OFFER_RESP_STATUS
540: ;
541:
542: begin

Line 578: delete from IGS_AD_OFR_RESP_STAT

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

Line 592: end IGS_AD_OFR_RESP_STAT_PKG;

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