APPS.IGS_PR_MS_STAT_PKG dependencies on IGS_PR_MS_STAT_ALL

Line 4: old_references IGS_PR_MS_STAT_ALL%RowType;

1: package body IGS_PR_MS_STAT_PKG as
2: /* $Header: IGSQI04B.pls 115.5 2002/11/29 03:14:19 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_MS_STAT_ALL%RowType;
5: new_references IGS_PR_MS_STAT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PR_MS_STAT_ALL%RowType;

1: package body IGS_PR_MS_STAT_PKG as
2: /* $Header: IGSQI04B.pls 115.5 2002/11/29 03:14:19 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_MS_STAT_ALL%RowType;
5: new_references IGS_PR_MS_STAT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PR_MS_STAT_ALL

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

Line 99: FROM IGS_PR_MS_STAT_ALL

95: ) RETURN BOOLEAN AS
96:
97: CURSOR cur_rowid IS
98: SELECT rowid
99: FROM IGS_PR_MS_STAT_ALL
100: WHERE milestone_status = x_milestone_status
101: FOR UPDATE NOWAIT;
102:
103: lv_rowid cur_rowid%RowType;

Line 125: FROM IGS_PR_MS_STAT_ALL

121: ) AS
122:
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM IGS_PR_MS_STAT_ALL
126: WHERE s_milestone_status = x_s_milestone_status ;
127:
128: lv_rowid cur_rowid%RowType;
129:

Line 245: cursor C is select ROWID from IGS_PR_MS_STAT_ALL

241: X_CLOSED_IND in VARCHAR2,
242: X_MODE in VARCHAR2 default 'R',
243: X_ORG_ID IN NUMBER
244: ) as
245: cursor C is select ROWID from IGS_PR_MS_STAT_ALL
246: where MILESTONE_STATUS = X_MILESTONE_STATUS;
247: X_LAST_UPDATE_DATE DATE;
248: X_LAST_UPDATED_BY NUMBER;
249: X_LAST_UPDATE_LOGIN NUMBER;

Line 285: insert into IGS_PR_MS_STAT_ALL (

281: x_last_update_login => x_last_update_login,
282: x_org_id => igs_ge_gen_003.get_org_id
283: ) ;
284:
285: insert into IGS_PR_MS_STAT_ALL (
286: MILESTONE_STATUS,
287: DESCRIPTION,
288: S_MILESTONE_STATUS,
289: CLOSED_IND,

Line 333: from IGS_PR_MS_STAT_ALL

329: cursor c1 is select
330: DESCRIPTION,
331: S_MILESTONE_STATUS,
332: CLOSED_IND
333: from IGS_PR_MS_STAT_ALL
334: where ROWID = X_ROWID for update nowait;
335: tlinfo c1%rowtype;
336:
337: begin

Line 407: update IGS_PR_MS_STAT_ALL set

403: x_last_update_login => x_last_update_login
404: ) ;
405:
406:
407: update IGS_PR_MS_STAT_ALL set
408: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
409: S_MILESTONE_STATUS = NEW_REFERENCES.S_MILESTONE_STATUS,
410: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
411: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 434: cursor c1 is select rowid from IGS_PR_MS_STAT_ALL

430: X_CLOSED_IND in VARCHAR2,
431: X_MODE in VARCHAR2 default 'R',
432: X_ORG_ID IN NUMBER
433: ) as
434: cursor c1 is select rowid from IGS_PR_MS_STAT_ALL
435: where MILESTONE_STATUS = X_MILESTONE_STATUS
436: ;
437: begin
438: open c1;

Line 470: delete from IGS_PR_MS_STAT_ALL

466: Before_DML (
467: p_action => 'DELETE',
468: x_rowid => X_ROWID
469: );
470: delete from IGS_PR_MS_STAT_ALL
471: where ROWID = X_ROWID;
472: if (sql%notfound) then
473: raise no_data_found;
474: end if;