APPS.IGS_PS_UNT_OFR_PAT_N_PKG dependencies on IGS_PS_UNT_OFR_PAT_N

Line 1: package body IGS_PS_UNT_OFR_PAT_N_PKG as

1: package body IGS_PS_UNT_OFR_PAT_N_PKG as
2: /* $Header: IGSPI86B.pls 115.4 2002/11/29 02:40:22 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNT_OFR_PAT_N%RowType;

Line 5: old_references IGS_PS_UNT_OFR_PAT_N%RowType;

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

Line 6: new_references IGS_PS_UNT_OFR_PAT_N%RowType;

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

Line 26: FROM IGS_PS_UNT_OFR_PAT_N

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

Line 173: FROM IGS_PS_UNT_OFR_PAT_N

169: ) RETURN BOOLEAN AS
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM IGS_PS_UNT_OFR_PAT_N
174: WHERE unit_cd = x_unit_cd
175: AND version_number = x_version_number
176: AND cal_type = x_cal_type
177: AND ci_sequence_number = x_ci_sequence_number

Line 203: FROM IGS_PS_UNT_OFR_PAT_N

199: ) AS
200:
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM IGS_PS_UNT_OFR_PAT_N
204: WHERE crs_note_type = x_crs_note_type ;
205:
206: lv_rowid cur_rowid%RowType;
207:

Line 229: FROM IGS_PS_UNT_OFR_PAT_N

225: ) AS
226:
227: CURSOR cur_rowid IS
228: SELECT rowid
229: FROM IGS_PS_UNT_OFR_PAT_N
230: WHERE reference_number = x_reference_number ;
231:
232: lv_rowid cur_rowid%RowType;
233:

Line 258: FROM IGS_PS_UNT_OFR_PAT_N

254: ) AS
255:
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM IGS_PS_UNT_OFR_PAT_N
259: WHERE unit_cd = x_unit_cd
260: AND version_number = x_version_number
261: AND cal_type = x_cal_type
262: AND ci_sequence_number = x_ci_sequence_number ;

Line 371: cursor C is select ROWID from IGS_PS_UNT_OFR_PAT_N

367: X_CI_SEQUENCE_NUMBER in NUMBER,
368: X_CRS_NOTE_TYPE in VARCHAR2,
369: X_MODE in VARCHAR2 default 'R'
370: ) AS
371: cursor C is select ROWID from IGS_PS_UNT_OFR_PAT_N
372: where UNIT_CD = X_UNIT_CD
373: and REFERENCE_NUMBER = X_REFERENCE_NUMBER
374: and VERSION_NUMBER = X_VERSION_NUMBER
375: and CAL_TYPE = X_CAL_TYPE

Line 416: insert into IGS_PS_UNT_OFR_PAT_N (

412: x_last_updated_by => X_LAST_UPDATED_BY,
413: x_last_update_login => X_LAST_UPDATE_LOGIN
414: );
415:
416: insert into IGS_PS_UNT_OFR_PAT_N (
417: UNIT_CD,
418: VERSION_NUMBER,
419: CAL_TYPE,
420: CI_SEQUENCE_NUMBER,

Line 468: from IGS_PS_UNT_OFR_PAT_N

464: X_CRS_NOTE_TYPE in VARCHAR2
465: ) AS
466: cursor c1 is select
467: CRS_NOTE_TYPE
468: from IGS_PS_UNT_OFR_PAT_N
469: where ROWID = X_ROWID for update nowait;
470: tlinfo c1%rowtype;
471:
472: begin

Line 543: update IGS_PS_UNT_OFR_PAT_N set

539: x_last_update_date => X_LAST_UPDATE_DATE,
540: x_last_updated_by => X_LAST_UPDATED_BY,
541: x_last_update_login => X_LAST_UPDATE_LOGIN
542: );
543: update IGS_PS_UNT_OFR_PAT_N set
544: CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
545: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
546: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
547: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 569: cursor c1 is select rowid from IGS_PS_UNT_OFR_PAT_N

565: X_CI_SEQUENCE_NUMBER in NUMBER,
566: X_CRS_NOTE_TYPE in VARCHAR2,
567: X_MODE in VARCHAR2 default 'R'
568: ) AS
569: cursor c1 is select rowid from IGS_PS_UNT_OFR_PAT_N
570: where UNIT_CD = X_UNIT_CD
571: and REFERENCE_NUMBER = X_REFERENCE_NUMBER
572: and VERSION_NUMBER = X_VERSION_NUMBER
573: and CAL_TYPE = X_CAL_TYPE

Line 612: delete from IGS_PS_UNT_OFR_PAT_N

608: Before_DML (
609: p_action => 'DELETE',
610: x_rowid => X_ROWID
611: );
612: delete from IGS_PS_UNT_OFR_PAT_N
613: where ROWID = X_ROWID;
614: if (sql%notfound) then
615: raise no_data_found;
616: end if;

Line 624: end IGS_PS_UNT_OFR_PAT_N_PKG;

620: );
621:
622: end DELETE_ROW;
623:
624: end IGS_PS_UNT_OFR_PAT_N_PKG;