APPS.IGS_AD_CNDNL_OFRSTAT_PKG dependencies on IGS_AD_CNDNL_OFRSTAT

Line 1: package body IGS_AD_CNDNL_OFRSTAT_PKG AS

1: package body IGS_AD_CNDNL_OFRSTAT_PKG AS
2: /* $Header: IGSAI15B.pls 115.7 2003/10/30 13:11:16 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CNDNL_OFRSTAT%RowType;

Line 5: old_references IGS_AD_CNDNL_OFRSTAT%RowType;

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

Line 6: new_references IGS_AD_CNDNL_OFRSTAT%RowType;

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

Line 25: FROM IGS_AD_CNDNL_OFRSTAT

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

Line 167: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_CNDNL_OFRSTAT (

163:
164: PROCEDURE Check_Child_Existance AS
165: BEGIN
166:
167: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_CNDNL_OFRSTAT (
168: old_references.adm_cndtnl_offer_status
169: );
170:
171: END Check_Child_Existance;

Line 179: FROM IGS_AD_CNDNL_OFRSTAT

175: x_closed_ind IN VARCHAR2 )
176: RETURN BOOLEAN AS
177: CURSOR cur_rowid IS
178: SELECT rowid
179: FROM IGS_AD_CNDNL_OFRSTAT
180: WHERE adm_cndtnl_offer_status = x_adm_cndtnl_offer_status AND
181: closed_ind = NVL(x_closed_ind,closed_ind);
182:
183: lv_rowid cur_rowid%RowType;

Line 202: FROM IGS_AD_CNDNL_OFRSTAT

198: ) AS
199:
200: CURSOR cur_rowid IS
201: SELECT rowid
202: FROM IGS_AD_CNDNL_OFRSTAT
203: WHERE s_adm_cndtnl_offer_status = x_s_adm_cndtnl_offer_status ;
204:
205: lv_rowid cur_rowid%RowType;
206:

Line 305: cursor C is select ROWID from IGS_AD_CNDNL_OFRSTAT

301: X_SYSTEM_DEFAULT_IND in VARCHAR2,
302: X_CLOSED_IND in VARCHAR2,
303: X_MODE in VARCHAR2 default 'R'
304: ) AS
305: cursor C is select ROWID from IGS_AD_CNDNL_OFRSTAT
306: where ADM_CNDTNL_OFFER_STATUS = X_ADM_CNDTNL_OFFER_STATUS;
307: X_LAST_UPDATE_DATE DATE;
308: X_LAST_UPDATED_BY NUMBER;
309: X_LAST_UPDATE_LOGIN NUMBER;

Line 345: insert into IGS_AD_CNDNL_OFRSTAT (

341: x_last_updated_by=>X_LAST_UPDATED_BY,
342: x_last_update_login=>X_LAST_UPDATE_LOGIN
343: );
344:
345: insert into IGS_AD_CNDNL_OFRSTAT (
346: ADM_CNDTNL_OFFER_STATUS,
347: DESCRIPTION,
348: S_ADM_CNDTNL_OFFER_STATUS,
349: SYSTEM_DEFAULT_IND,

Line 396: from IGS_AD_CNDNL_OFRSTAT

392: DESCRIPTION,
393: S_ADM_CNDTNL_OFFER_STATUS,
394: SYSTEM_DEFAULT_IND,
395: CLOSED_IND
396: from IGS_AD_CNDNL_OFRSTAT
397: where ROWID = X_ROWID for update nowait;
398: tlinfo c1%rowtype;
399:
400: begin

Line 473: update IGS_AD_CNDNL_OFRSTAT set

469: x_last_updated_by=>X_LAST_UPDATED_BY,
470: x_last_update_login=>X_LAST_UPDATE_LOGIN
471: );
472:
473: update IGS_AD_CNDNL_OFRSTAT set
474: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
475: S_ADM_CNDTNL_OFFER_STATUS = NEW_REFERENCES.S_ADM_CNDTNL_OFFER_STATUS,
476: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
477: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 502: cursor c1 is select rowid from IGS_AD_CNDNL_OFRSTAT

498: X_SYSTEM_DEFAULT_IND in VARCHAR2,
499: X_CLOSED_IND in VARCHAR2,
500: X_MODE in VARCHAR2 default 'R'
501: ) AS
502: cursor c1 is select rowid from IGS_AD_CNDNL_OFRSTAT
503: where ADM_CNDTNL_OFFER_STATUS = X_ADM_CNDTNL_OFFER_STATUS
504: ;
505: begin
506: open c1;

Line 540: delete from IGS_AD_CNDNL_OFRSTAT

536: Before_DML (
537: p_action => 'DELETE',
538: x_rowid => X_ROWID);
539:
540: delete from IGS_AD_CNDNL_OFRSTAT
541: where ROWID = X_ROWID;
542: if (sql%notfound) then
543: raise no_data_found;
544: end if;

Line 552: end IGS_AD_CNDNL_OFRSTAT_PKG;

548: x_rowid => X_ROWID);
549:
550: end DELETE_ROW;
551:
552: end IGS_AD_CNDNL_OFRSTAT_PKG;