APPS.IGS_OR_STATUS_PKG dependencies on IGS_OR_STATUS

Line 1: package body IGS_OR_STATUS_PKG AS

1: package body IGS_OR_STATUS_PKG AS
2: /* $Header: IGSOI08B.pls 120.0 2005/06/01 22:49:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_STATUS%RowType;

Line 5: old_references IGS_OR_STATUS%RowType;

1: package body IGS_OR_STATUS_PKG AS
2: /* $Header: IGSOI08B.pls 120.0 2005/06/01 22:49:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_STATUS%RowType;
6: new_references IGS_OR_STATUS%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_OR_STATUS%RowType;

2: /* $Header: IGSOI08B.pls 120.0 2005/06/01 22:49:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_STATUS%RowType;
6: new_references IGS_OR_STATUS%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_OR_STATUS

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

Line 66: IGS_OR_UNIT_PKG.GET_FK_IGS_OR_STATUS (

62:
63: PROCEDURE Check_Child_Existance AS
64: BEGIN
65:
66: IGS_OR_UNIT_PKG.GET_FK_IGS_OR_STATUS (
67: old_references.org_status
68: );
69:
70: END Check_Child_Existance;

Line 78: FROM IGS_OR_STATUS

74: )RETURN BOOLEAN AS
75:
76: CURSOR cur_rowid IS
77: SELECT rowid
78: FROM IGS_OR_STATUS
79: WHERE org_status = x_org_status
80: FOR UPDATE NOWAIT;
81:
82: lv_rowid cur_rowid%RowType;

Line 191: cursor C is select ROWID from IGS_OR_STATUS

187: X_S_ORG_STATUS in VARCHAR2,
188: X_CLOSED_IND in VARCHAR2,
189: X_MODE in VARCHAR2 default 'R'
190: ) AS
191: cursor C is select ROWID from IGS_OR_STATUS
192: where ORG_STATUS = X_ORG_STATUS;
193: X_LAST_UPDATE_DATE DATE;
194: X_LAST_UPDATED_BY NUMBER;
195: X_LAST_UPDATE_LOGIN NUMBER;

Line 231: insert into IGS_OR_STATUS (

227: x_last_updated_by=>X_LAST_UPDATED_BY,
228: x_last_update_login=>X_LAST_UPDATE_LOGIN
229: );
230:
231: insert into IGS_OR_STATUS (
232: ORG_STATUS,
233: DESCRIPTION,
234: S_ORG_STATUS,
235: CLOSED_IND,

Line 279: from IGS_OR_STATUS

275: cursor c1 is select
276: DESCRIPTION,
277: S_ORG_STATUS,
278: CLOSED_IND
279: from IGS_OR_STATUS
280: where ROWID = X_ROWID
281: for update nowait ;
282: tlinfo c1%rowtype;
283:

Line 352: update IGS_OR_STATUS set

348: x_last_updated_by=>X_LAST_UPDATED_BY,
349: x_last_update_login=>X_LAST_UPDATE_LOGIN
350: );
351:
352: update IGS_OR_STATUS set
353: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
354: S_ORG_STATUS = NEW_REFERENCES.S_ORG_STATUS,
355: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
356: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 380: cursor c1 is select rowid from IGS_OR_STATUS

376: X_S_ORG_STATUS in VARCHAR2,
377: X_CLOSED_IND in VARCHAR2,
378: X_MODE in VARCHAR2 default 'R'
379: ) AS
380: cursor c1 is select rowid from IGS_OR_STATUS
381: where ORG_STATUS = X_ORG_STATUS
382: ;
383:
384: begin

Line 418: delete from IGS_OR_STATUS

414: p_action=>'DELETE',
415: x_rowid=>X_ROWID
416: );
417:
418: delete from IGS_OR_STATUS
419: where ROWID = X_ROWID ;
420: if (sql%notfound) then
421: raise no_data_found;
422: end if;

Line 491: end IGS_OR_STATUS_PKG;

487:
488:
489: end Check_Constraints ;
490:
491: end IGS_OR_STATUS_PKG;