APPS.IGS_PS_UNIT_DISC_CRT_PKG dependencies on IGS_PS_UNIT_DISC_CRT

Line 1: package body IGS_PS_UNIT_DISC_CRT_PKG as

1: package body IGS_PS_UNIT_DISC_CRT_PKG as
2: /* $Header: IGSPI78B.pls 115.6 2003/10/30 13:31:28 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_DISC_CRT%RowType;

Line 5: old_references IGS_PS_UNIT_DISC_CRT%RowType;

1: package body IGS_PS_UNIT_DISC_CRT_PKG as
2: /* $Header: IGSPI78B.pls 115.6 2003/10/30 13:31:28 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_DISC_CRT%RowType;
6: new_references IGS_PS_UNIT_DISC_CRT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_DISC_CRT%RowType;

2: /* $Header: IGSPI78B.pls 115.6 2003/10/30 13:31:28 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_DISC_CRT%RowType;
6: new_references IGS_PS_UNIT_DISC_CRT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PS_UNIT_DISC_CRT

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

Line 187: FROM IGS_PS_UNIT_DISC_CRT

183: ) RETURN BOOLEAN AS
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_PS_UNIT_DISC_CRT
188: WHERE unit_discont_dt_alias = x_unit_discont_dt_alias
189: FOR UPDATE NOWAIT;
190:
191: lv_rowid cur_rowid%RowType;

Line 212: FROM IGS_PS_UNIT_DISC_CRT

208: ) AS
209:
210: CURSOR cur_rowid IS
211: SELECT rowid
212: FROM IGS_PS_UNIT_DISC_CRT
213: WHERE unit_discont_dt_alias = x_dt_alias ;
214:
215: lv_rowid cur_rowid%RowType;
216:

Line 311: cursor C is select ROWID from IGS_PS_UNIT_DISC_CRT

307: X_DELETE_IND in VARCHAR2,
308: X_DFLT_IND in VARCHAR2,
309: X_MODE in VARCHAR2 default 'R'
310: ) AS
311: cursor C is select ROWID from IGS_PS_UNIT_DISC_CRT
312: where UNIT_DISCONT_DT_ALIAS = X_UNIT_DISCONT_DT_ALIAS;
313: X_LAST_UPDATE_DATE DATE;
314: X_LAST_UPDATED_BY NUMBER;
315: X_LAST_UPDATE_LOGIN NUMBER;

Line 350: insert into IGS_PS_UNIT_DISC_CRT (

346: x_last_updated_by => X_LAST_UPDATED_BY,
347: x_last_update_login => X_LAST_UPDATE_LOGIN
348: );
349:
350: insert into IGS_PS_UNIT_DISC_CRT (
351: UNIT_DISCONT_DT_ALIAS,
352: ADMINISTRATIVE_UNIT_STATUS,
353: DELETE_IND,
354: DFLT_IND,

Line 397: from IGS_PS_UNIT_DISC_CRT

393: cursor c1 is select
394: ADMINISTRATIVE_UNIT_STATUS,
395: DELETE_IND,
396: DFLT_IND
397: from IGS_PS_UNIT_DISC_CRT
398: where ROWID = X_ROWID
399: for update nowait;
400: tlinfo c1%rowtype;
401:

Line 473: update IGS_PS_UNIT_DISC_CRT set

469: x_last_update_date => X_LAST_UPDATE_DATE,
470: x_last_updated_by => X_LAST_UPDATED_BY,
471: x_last_update_login => X_LAST_UPDATE_LOGIN
472: );
473: update IGS_PS_UNIT_DISC_CRT set
474: ADMINISTRATIVE_UNIT_STATUS = NEW_REFERENCES.ADMINISTRATIVE_UNIT_STATUS,
475: DELETE_IND = NEW_REFERENCES.DELETE_IND,
476: DFLT_IND = NEW_REFERENCES.DFLT_IND,
477: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 500: cursor c1 is select rowid from IGS_PS_UNIT_DISC_CRT

496: X_DELETE_IND in VARCHAR2,
497: X_DFLT_IND in VARCHAR2,
498: X_MODE in VARCHAR2 default 'R'
499: ) AS
500: cursor c1 is select rowid from IGS_PS_UNIT_DISC_CRT
501: where UNIT_DISCONT_DT_ALIAS = X_UNIT_DISCONT_DT_ALIAS
502: ;
503: begin
504: open c1;

Line 535: delete from IGS_PS_UNIT_DISC_CRT

531: Before_DML (
532: p_action => 'DELETE',
533: x_rowid => X_ROWID
534: );
535: delete from IGS_PS_UNIT_DISC_CRT
536: where ROWID = X_ROWID;
537: if (sql%notfound) then
538: raise no_data_found;
539: end if;

Line 547: end IGS_PS_UNIT_DISC_CRT_PKG;

543: );
544:
545: end DELETE_ROW;
546:
547: end IGS_PS_UNIT_DISC_CRT_PKG;