APPS.IGS_AD_ENT_QF_STAT_PKG dependencies on IGS_AD_ENT_QF_STAT

Line 1: package body IGS_AD_ENT_QF_STAT_PKG as

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

Line 5: old_references IGS_AD_ENT_QF_STAT%RowType;

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

Line 6: new_references IGS_AD_ENT_QF_STAT%RowType;

2: /* $Header: IGSAI24B.pls 115.6 2003/10/30 13:11:41 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_ENT_QF_STAT%RowType;
6: new_references IGS_AD_ENT_QF_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_ENT_QF_STAT

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

Line 185: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_ENT_QF_STAT (

181:
182: PROCEDURE Check_Child_Existance as
183: BEGIN
184:
185: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_ENT_QF_STAT (
186: old_references.adm_entry_qual_status
187: );
188:
189: END Check_Child_Existance;

Line 199: FROM IGS_AD_ENT_QF_STAT

195: AS
196:
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM IGS_AD_ENT_QF_STAT
200: WHERE adm_entry_qual_status = x_adm_entry_qual_status AND
201: closed_ind = NVL(x_closed_ind,closed_ind);
202:
203: lv_rowid cur_rowid%RowType;

Line 226: FROM IGS_AD_ENT_QF_STAT

222: ) as
223:
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM IGS_AD_ENT_QF_STAT
227: WHERE s_adm_entry_qual_status = x_s_adm_entry_qual_status ;
228:
229: lv_rowid cur_rowid%RowType;
230:

Line 336: cursor C is select ROWID from IGS_AD_ENT_QF_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_ENT_QF_STAT
337: where ADM_ENTRY_QUAL_STATUS = X_ADM_ENTRY_QUAL_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_ENT_QF_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_ENT_QF_STAT (
377: ADM_ENTRY_QUAL_STATUS,
378: DESCRIPTION,
379: S_ADM_ENTRY_QUAL_STATUS,
380: SYSTEM_DEFAULT_IND,

Line 430: from IGS_AD_ENT_QF_STAT

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

Line 508: update IGS_AD_ENT_QF_STAT set

504: x_last_update_login=> X_LAST_UPDATE_LOGIN
505: );
506:
507:
508: update IGS_AD_ENT_QF_STAT set
509: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
510: S_ADM_ENTRY_QUAL_STATUS = NEW_REFERENCES.S_ADM_ENTRY_QUAL_STATUS,
511: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
512: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 539: cursor c1 is select rowid from IGS_AD_ENT_QF_STAT

535: X_SYSTEM_DEFAULT_IND in VARCHAR2,
536: X_CLOSED_IND in VARCHAR2,
537: X_MODE in VARCHAR2 default 'R'
538: ) as
539: cursor c1 is select rowid from IGS_AD_ENT_QF_STAT
540: where ADM_ENTRY_QUAL_STATUS = X_ADM_ENTRY_QUAL_STATUS
541: ;
542:
543: begin

Line 579: delete from IGS_AD_ENT_QF_STAT

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

Line 592: end IGS_AD_ENT_QF_STAT_PKG;

588: );
589:
590: end DELETE_ROW;
591:
592: end IGS_AD_ENT_QF_STAT_PKG;