APPS.IGS_PS_USEC_X_UNITS_PKG dependencies on IGS_PS_USEC_X_UNITS

Line 1: PACKAGE BODY igs_ps_usec_x_units_pkg AS

1: PACKAGE BODY igs_ps_usec_x_units_pkg AS
2: /* $Header: IGSPI1BB.pls 115.7 2002/11/29 02:04:50 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_x_units%RowType;
5: new_references igs_ps_usec_x_units%RowType;

Line 4: old_references igs_ps_usec_x_units%RowType;

1: PACKAGE BODY igs_ps_usec_x_units_pkg AS
2: /* $Header: IGSPI1BB.pls 115.7 2002/11/29 02:04:50 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_x_units%RowType;
5: new_references igs_ps_usec_x_units%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_x_units%RowType;

1: PACKAGE BODY igs_ps_usec_x_units_pkg AS
2: /* $Header: IGSPI1BB.pls 115.7 2002/11/29 02:04:50 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_x_units%RowType;
5: new_references igs_ps_usec_x_units%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_USEC_X_UNITS

30: ***************************************************************/
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_PS_USEC_X_UNITS
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 165: FROM igs_ps_usec_x_units

161: ***************************************************************/
162:
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM igs_ps_usec_x_units
166: WHERE unit_sec_cross_units_id = x_unit_sec_cross_units_id
167: FOR UPDATE NOWAIT;
168:
169: lv_rowid cur_rowid%RowType;

Line 203: FROM igs_ps_usec_x_units

199: ***************************************************************/
200:
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igs_ps_usec_x_units
204: WHERE cross_listed_version_number = x_cross_listed_version_number
205: AND cross_listed_unit_cd = x_cross_listed_unit_cd
206: AND uoo_id = x_uoo_id and ((l_rowid is null) or (rowid <> l_rowid))
207:

Line 240: FROM igs_ps_usec_x_units

236: ***************************************************************/
237:
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM igs_ps_usec_x_units
241: WHERE uoo_id = x_uoo_id ;
242:
243: lv_rowid cur_rowid%RowType;
244:

Line 391: cursor C is select ROWID from IGS_PS_USEC_X_UNITS

387:
388: (reverse chronological order - newest change first)
389: ***************************************************************/
390:
391: cursor C is select ROWID from IGS_PS_USEC_X_UNITS
392: where UNIT_SEC_CROSS_UNITS_ID= X_UNIT_SEC_CROSS_UNITS_ID
393: ;
394: X_LAST_UPDATE_DATE DATE ;
395: X_LAST_UPDATED_BY NUMBER ;

Line 417: IGS_PS_USEC_X_UNITS_S.NextVal

413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: end if;
416: SELECT
417: IGS_PS_USEC_X_UNITS_S.NextVal
418: INTO
419: x_UNIT_SEC_CROSS_UNITS_ID
420: FROM
421: dual;

Line 434: insert into IGS_PS_USEC_X_UNITS (

430: x_created_by=>X_LAST_UPDATED_BY,
431: x_last_update_date=>X_LAST_UPDATE_DATE,
432: x_last_updated_by=>X_LAST_UPDATED_BY,
433: x_last_update_login=>X_LAST_UPDATE_LOGIN);
434: insert into IGS_PS_USEC_X_UNITS (
435: UNIT_SEC_CROSS_UNITS_ID
436: ,UOO_ID
437: ,CROSS_LISTED_UNIT_CD
438: ,CROSS_LISTED_VERSION_NUMBER

Line 487: from IGS_PS_USEC_X_UNITS

483: cursor c1 is select
484: UOO_ID
485: , CROSS_LISTED_UNIT_CD
486: , CROSS_LISTED_VERSION_NUMBER
487: from IGS_PS_USEC_X_UNITS
488: where ROWID = X_ROWID
489: for update nowait;
490: tlinfo c1%rowtype;
491: begin

Line 567: update IGS_PS_USEC_X_UNITS set

563: x_created_by=>X_LAST_UPDATED_BY,
564: x_last_update_date=>X_LAST_UPDATE_DATE,
565: x_last_updated_by=>X_LAST_UPDATED_BY,
566: x_last_update_login=>X_LAST_UPDATE_LOGIN);
567: update IGS_PS_USEC_X_UNITS set
568: UOO_ID = NEW_REFERENCES.UOO_ID,
569: CROSS_LISTED_UNIT_CD = NEW_REFERENCES.CROSS_LISTED_UNIT_CD,
570: CROSS_LISTED_VERSION_NUMBER = NEW_REFERENCES.CROSS_LISTED_VERSION_NUMBER,
571: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 603: cursor c1 is select ROWID from IGS_PS_USEC_X_UNITS

599:
600: (reverse chronological order - newest change first)
601: ***************************************************************/
602:
603: cursor c1 is select ROWID from IGS_PS_USEC_X_UNITS
604: where UNIT_SEC_CROSS_UNITS_ID= X_UNIT_SEC_CROSS_UNITS_ID
605: ;
606: begin
607: open c1;

Line 648: delete from IGS_PS_USEC_X_UNITS

644: Before_DML (
645: p_action => 'DELETE',
646: x_rowid => X_ROWID
647: );
648: delete from IGS_PS_USEC_X_UNITS
649: where ROWID = X_ROWID;
650: if (sql%notfound) then
651: raise no_data_found;
652: end if;

Line 658: END igs_ps_usec_x_units_pkg;

654: p_action => 'DELETE',
655: x_rowid => X_ROWID
656: );
657: end DELETE_ROW;
658: END igs_ps_usec_x_units_pkg;