APPS.IGS_PS_UNIT_OFR_NOTE_PKG dependencies on IGS_PS_UNIT_OFR_NOTE

Line 1: package body IGS_PS_UNIT_OFR_NOTE_PKG as

1: package body IGS_PS_UNIT_OFR_NOTE_PKG as
2: /* $Header: IGSPI83B.pls 115.4 2002/11/29 02:39:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_OFR_NOTE%RowType;

Line 5: old_references IGS_PS_UNIT_OFR_NOTE%RowType;

1: package body IGS_PS_UNIT_OFR_NOTE_PKG as
2: /* $Header: IGSPI83B.pls 115.4 2002/11/29 02:39:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_OFR_NOTE%RowType;
6: new_references IGS_PS_UNIT_OFR_NOTE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_OFR_NOTE%RowType;

2: /* $Header: IGSPI83B.pls 115.4 2002/11/29 02:39:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_OFR_NOTE%RowType;
6: new_references IGS_PS_UNIT_OFR_NOTE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_PS_UNIT_OFR_NOTE

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

Line 167: FROM IGS_PS_UNIT_OFR_NOTE

163: ) RETURN BOOLEAN AS
164:
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM IGS_PS_UNIT_OFR_NOTE
168: WHERE unit_cd = x_unit_cd
169: AND version_number = x_version_number
170: AND cal_type = x_cal_type
171: AND reference_number = x_reference_number

Line 196: FROM IGS_PS_UNIT_OFR_NOTE

192: ) AS
193:
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM IGS_PS_UNIT_OFR_NOTE
197: WHERE crs_note_type = x_crs_note_type ;
198:
199: lv_rowid cur_rowid%RowType;
200:

Line 222: FROM IGS_PS_UNIT_OFR_NOTE

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

Line 250: FROM IGS_PS_UNIT_OFR_NOTE

246: ) AS
247:
248: CURSOR cur_rowid IS
249: SELECT rowid
250: FROM IGS_PS_UNIT_OFR_NOTE
251: WHERE unit_cd = x_unit_cd
252: AND version_number = x_version_number
253: AND cal_type = x_cal_type ;
254:

Line 357: cursor C is select ROWID from IGS_PS_UNIT_OFR_NOTE

353: X_REFERENCE_NUMBER in NUMBER,
354: X_CRS_NOTE_TYPE in VARCHAR2,
355: X_MODE in VARCHAR2 default 'R'
356: ) AS
357: cursor C is select ROWID from IGS_PS_UNIT_OFR_NOTE
358: where UNIT_CD = X_UNIT_CD
359: and VERSION_NUMBER = X_VERSION_NUMBER
360: and CAL_TYPE = X_CAL_TYPE
361: and REFERENCE_NUMBER = X_REFERENCE_NUMBER;

Line 400: insert into IGS_PS_UNIT_OFR_NOTE (

396: x_last_updated_by => X_LAST_UPDATED_BY,
397: x_last_update_login => X_LAST_UPDATE_LOGIN
398: );
399:
400: insert into IGS_PS_UNIT_OFR_NOTE (
401: UNIT_CD,
402: VERSION_NUMBER,
403: CAL_TYPE,
404: REFERENCE_NUMBER,

Line 447: from IGS_PS_UNIT_OFR_NOTE

443: X_CRS_NOTE_TYPE in VARCHAR2
444: ) AS
445: cursor c1 is select
446: CRS_NOTE_TYPE
447: from IGS_PS_UNIT_OFR_NOTE
448: where ROWID = X_ROWID
449: for update nowait;
450: tlinfo c1%rowtype;
451:

Line 522: update IGS_PS_UNIT_OFR_NOTE set

518: x_last_updated_by => X_LAST_UPDATED_BY,
519: x_last_update_login => X_LAST_UPDATE_LOGIN
520: );
521:
522: update IGS_PS_UNIT_OFR_NOTE set
523: CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
524: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
525: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
526: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 548: cursor c1 is select rowid from IGS_PS_UNIT_OFR_NOTE

544: X_REFERENCE_NUMBER in NUMBER,
545: X_CRS_NOTE_TYPE in VARCHAR2,
546: X_MODE in VARCHAR2 default 'R'
547: ) AS
548: cursor c1 is select rowid from IGS_PS_UNIT_OFR_NOTE
549: where UNIT_CD = X_UNIT_CD
550: and VERSION_NUMBER = X_VERSION_NUMBER
551: and CAL_TYPE = X_CAL_TYPE
552: and REFERENCE_NUMBER = X_REFERENCE_NUMBER

Line 588: delete from IGS_PS_UNIT_OFR_NOTE

584: Before_DML (
585: p_action => 'DELETE',
586: x_rowid => X_ROWID
587: );
588: delete from IGS_PS_UNIT_OFR_NOTE
589: where ROWID = X_ROWID;
590: if (sql%notfound) then
591: raise no_data_found;
592: end if;

Line 601: end IGS_PS_UNIT_OFR_NOTE_PKG;

597:
598:
599: end DELETE_ROW;
600:
601: end IGS_PS_UNIT_OFR_NOTE_PKG;