APPS.IGS_PS_UNT_OFR_OPT_N_PKG dependencies on IGS_PS_UNT_OFR_OPT_N

Line 1: package body IGS_PS_UNT_OFR_OPT_N_PKG as

1: package body IGS_PS_UNT_OFR_OPT_N_PKG as
2: /* $Header: IGSPI84B.pls 115.5 2002/11/29 02:39:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNT_OFR_OPT_N%RowType;

Line 5: old_references IGS_PS_UNT_OFR_OPT_N%RowType;

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

Line 6: new_references IGS_PS_UNT_OFR_OPT_N%RowType;

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

Line 29: FROM IGS_PS_UNT_OFR_OPT_N

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PS_UNT_OFR_OPT_N
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 77: v_unit_cd IGS_PS_UNT_OFR_OPT_N.unit_cd%TYPE;

73: p_inserting IN BOOLEAN DEFAULT FALSE,
74: p_updating IN BOOLEAN DEFAULT FALSE,
75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_unit_cd IGS_PS_UNT_OFR_OPT_N.unit_cd%TYPE;
78: v_version_number IGS_PS_UNT_OFR_OPT_N.version_number%TYPE;
79: v_message_name Varchar2(30);
80: BEGIN
81: -- Set IGS_PS_UNIT_OFR_OPT key.

Line 78: v_version_number IGS_PS_UNT_OFR_OPT_N.version_number%TYPE;

74: p_updating IN BOOLEAN DEFAULT FALSE,
75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_unit_cd IGS_PS_UNT_OFR_OPT_N.unit_cd%TYPE;
78: v_version_number IGS_PS_UNT_OFR_OPT_N.version_number%TYPE;
79: v_message_name Varchar2(30);
80: BEGIN
81: -- Set IGS_PS_UNIT_OFR_OPT key.
82: IF p_inserting THEN

Line 260: FROM IGS_PS_UNT_OFR_OPT_N

256: ) RETURN BOOLEAN AS
257:
258: CURSOR cur_rowid IS
259: SELECT rowid
260: FROM IGS_PS_UNT_OFR_OPT_N
261: WHERE unit_cd = x_unit_cd
262: AND version_number = x_version_number
263: AND cal_type = x_cal_type
264: AND ci_sequence_number = x_ci_sequence_number

Line 292: FROM IGS_PS_UNT_OFR_OPT_N

288: ) AS
289:
290: CURSOR cur_rowid IS
291: SELECT rowid
292: FROM IGS_PS_UNT_OFR_OPT_N
293: WHERE crs_note_type = x_crs_note_type ;
294:
295: lv_rowid cur_rowid%RowType;
296:

Line 318: FROM IGS_PS_UNT_OFR_OPT_N

314: ) AS
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM IGS_PS_UNT_OFR_OPT_N
319: WHERE reference_number = x_reference_number ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 349: FROM IGS_PS_UNT_OFR_OPT_N

345: ) AS
346:
347: CURSOR cur_rowid IS
348: SELECT rowid
349: FROM IGS_PS_UNT_OFR_OPT_N
350: WHERE unit_cd = x_unit_cd
351: AND version_number = x_version_number
352: AND cal_type = x_cal_type
353: AND ci_sequence_number = x_ci_sequence_number

Line 380: FROM IGS_PS_UNT_OFR_OPT_N

376: ) AS
377:
378: CURSOR cur_rowid IS
379: SELECT rowid
380: FROM IGS_PS_UNT_OFR_OPT_N
381: WHERE uoo_id = x_uoo_id ;
382:
383: lv_rowid cur_rowid%RowType;
384:

Line 507: cursor C is select ROWID from IGS_PS_UNT_OFR_OPT_N

503: X_UOO_ID in out NOCOPY NUMBER,
504: X_CRS_NOTE_TYPE in VARCHAR2,
505: X_MODE in VARCHAR2 default 'R'
506: ) AS
507: cursor C is select ROWID from IGS_PS_UNT_OFR_OPT_N
508: where UNIT_CD = X_UNIT_CD
509: and VERSION_NUMBER = X_VERSION_NUMBER
510: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
511: and UNIT_CLASS = X_UNIT_CLASS

Line 557: insert into IGS_PS_UNT_OFR_OPT_N (

553: x_last_updated_by => X_LAST_UPDATED_BY,
554: x_last_update_login => X_LAST_UPDATE_LOGIN
555: );
556:
557: insert into IGS_PS_UNT_OFR_OPT_N (
558: UNIT_CD,
559: VERSION_NUMBER,
560: CAL_TYPE,
561: CI_SEQUENCE_NUMBER,

Line 619: from IGS_PS_UNT_OFR_OPT_N

615: ) AS
616: cursor c1 is select
617: UOO_ID,
618: CRS_NOTE_TYPE
619: from IGS_PS_UNT_OFR_OPT_N
620: where ROWID = X_ROWID for update nowait;
621: tlinfo c1%rowtype;
622:
623: begin

Line 702: update IGS_PS_UNT_OFR_OPT_N set

698: x_last_updated_by => X_LAST_UPDATED_BY,
699: x_last_update_login => X_LAST_UPDATE_LOGIN
700: );
701:
702: update IGS_PS_UNT_OFR_OPT_N set
703: UOO_ID = NEW_REFERENCES.UOO_ID,
704: CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
705: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
706: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 733: cursor c1 is select rowid from IGS_PS_UNT_OFR_OPT_N

729: X_UOO_ID in out NOCOPY NUMBER,
730: X_CRS_NOTE_TYPE in VARCHAR2,
731: X_MODE in VARCHAR2 default 'R'
732: ) AS
733: cursor c1 is select rowid from IGS_PS_UNT_OFR_OPT_N
734: where UNIT_CD = X_UNIT_CD
735: and VERSION_NUMBER = X_VERSION_NUMBER
736: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
737: and UNIT_CLASS = X_UNIT_CLASS

Line 785: delete from IGS_PS_UNT_OFR_OPT_N

781: p_action => 'DELETE',
782: x_rowid => X_ROWID
783: );
784:
785: delete from IGS_PS_UNT_OFR_OPT_N
786: where ROWID = X_ROWID;
787: if (sql%notfound) then
788: raise no_data_found;
789: end if;

Line 797: end IGS_PS_UNT_OFR_OPT_N_PKG;

793: );
794:
795: end DELETE_ROW;
796:
797: end IGS_PS_UNT_OFR_OPT_N_PKG;