APPS.IGS_AD_DOC_STAT_PKG dependencies on IGS_AD_DOC_STAT

Line 1: package body IGS_AD_DOC_STAT_PKG as

1: package body IGS_AD_DOC_STAT_PKG as
2: /* $Header: IGSAI23B.pls 115.7 2003/10/30 13:11:20 akadam ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_DOC_STAT%RowType;
5: new_references IGS_AD_DOC_STAT%RowType;

Line 4: old_references IGS_AD_DOC_STAT%RowType;

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

Line 5: new_references IGS_AD_DOC_STAT%RowType;

1: package body IGS_AD_DOC_STAT_PKG as
2: /* $Header: IGSAI23B.pls 115.7 2003/10/30 13:11:20 akadam ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_DOC_STAT%RowType;
5: new_references IGS_AD_DOC_STAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_AD_DOC_STAT

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

Line 182: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_DOC_STAT (

178:
179: PROCEDURE Check_Child_Existance AS
180: BEGIN
181:
182: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_AD_DOC_STAT (
183: old_references.adm_doc_status
184: );
185:
186: END Check_Child_Existance;

Line 196: FROM IGS_AD_DOC_STAT

192: AS
193:
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM IGS_AD_DOC_STAT
197: WHERE adm_doc_status = x_adm_doc_status AND
198: closed_ind = NVL(x_closed_ind,closed_ind);
199:
200: lv_rowid cur_rowid%RowType;

Line 222: FROM IGS_AD_DOC_STAT

218: ) AS
219:
220: CURSOR cur_rowid IS
221: SELECT rowid
222: FROM IGS_AD_DOC_STAT
223: WHERE s_adm_doc_status = x_s_adm_doc_status ;
224:
225: lv_rowid cur_rowid%RowType;
226:

Line 332: cursor C is select ROWID from IGS_AD_DOC_STAT

328: X_SYSTEM_DEFAULT_IND in VARCHAR2,
329: X_CLOSED_IND in VARCHAR2,
330: X_MODE in VARCHAR2 default 'R'
331: ) is
332: cursor C is select ROWID from IGS_AD_DOC_STAT
333: where ADM_DOC_STATUS = X_ADM_DOC_STATUS;
334: X_LAST_UPDATE_DATE DATE;
335: X_LAST_UPDATED_BY NUMBER;
336: X_LAST_UPDATE_LOGIN NUMBER;

Line 372: insert into IGS_AD_DOC_STAT (

368: x_last_updated_by=>X_LAST_UPDATED_BY ,
369: x_last_update_login=> X_LAST_UPDATE_LOGIN
370: );
371:
372: insert into IGS_AD_DOC_STAT (
373: ADM_DOC_STATUS,
374: DESCRIPTION,
375: S_ADM_DOC_STATUS,
376: SYSTEM_DEFAULT_IND,

Line 424: from IGS_AD_DOC_STAT

420: DESCRIPTION,
421: S_ADM_DOC_STATUS,
422: SYSTEM_DEFAULT_IND,
423: CLOSED_IND
424: from IGS_AD_DOC_STAT
425: WHERE ROWID = X_ROWID for update nowait ;
426:
427: tlinfo c1%rowtype;
428:

Line 502: update IGS_AD_DOC_STAT set

498: x_last_updated_by=>X_LAST_UPDATED_BY ,
499: x_last_update_login=> X_LAST_UPDATE_LOGIN
500: );
501:
502: update IGS_AD_DOC_STAT set
503: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
504: S_ADM_DOC_STATUS = NEW_REFERENCES.S_ADM_DOC_STATUS,
505: SYSTEM_DEFAULT_IND = NEW_REFERENCES.SYSTEM_DEFAULT_IND,
506: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 532: cursor c1 is select rowid from IGS_AD_DOC_STAT

528: X_SYSTEM_DEFAULT_IND in VARCHAR2,
529: X_CLOSED_IND in VARCHAR2,
530: X_MODE in VARCHAR2 default 'R'
531: ) is
532: cursor c1 is select rowid from IGS_AD_DOC_STAT
533: where ADM_DOC_STATUS = X_ADM_DOC_STATUS
534: ;
535:
536: begin

Line 572: delete from IGS_AD_DOC_STAT

568: p_action=>'DELETE',
569: x_rowid=> X_ROWID
570: );
571:
572: delete from IGS_AD_DOC_STAT
573: where ROWID = X_ROWID;
574: if (sql%notfound) then
575: raise no_data_found;
576: end if;

Line 585: end IGS_AD_DOC_STAT_PKG;

581: );
582:
583: end DELETE_ROW;
584:
585: end IGS_AD_DOC_STAT_PKG;