APPS.IGS_PS_USEC_X_USEC_PKG dependencies on IGS_PS_USEC_X_USEC

Line 1: PACKAGE BODY igs_ps_usec_x_usec_pkg AS

1: PACKAGE BODY igs_ps_usec_x_usec_pkg AS
2: /* $Header: IGSPI1CB.pls 115.7 2002/11/29 02:05:09 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_x_usec%RowType;
5: new_references igs_ps_usec_x_usec%RowType;

Line 4: old_references igs_ps_usec_x_usec%RowType;

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

Line 5: new_references igs_ps_usec_x_usec%RowType;

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

Line 33: FROM IGS_PS_USEC_X_USEC

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

Line 173: FROM igs_ps_usec_x_usec

169: ***************************************************************/
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igs_ps_usec_x_usec
174: WHERE unit_sec_cross_unit_sec_id = x_unit_sec_cross_unit_sec_id
175: FOR UPDATE NOWAIT;
176:
177: lv_rowid cur_rowid%RowType;

Line 210: FROM igs_ps_usec_x_usec

206: ***************************************************************/
207:
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igs_ps_usec_x_usec
211: WHERE child_uoo_id = x_child_uoo_id
212: AND parent_uoo_id = x_parent_uoo_id and ((l_rowid is null) or (rowid <> l_rowid))
213:
214: ;

Line 247: FROM igs_ps_usec_x_usec

243: ***************************************************************/
244:
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM igs_ps_usec_x_usec
248: WHERE ( child_uoo_id = x_uoo_id
249: OR parent_uoo_id = x_uoo_id) ;
250:
251: /************************************************

Line 403: cursor C is select ROWID from IGS_PS_USEC_X_USEC

399:
400: (reverse chronological order - newest change first)
401: ***************************************************************/
402:
403: cursor C is select ROWID from IGS_PS_USEC_X_USEC
404: where UNIT_SEC_CROSS_UNIT_SEC_ID= X_UNIT_SEC_CROSS_UNIT_SEC_ID
405: ;
406: X_LAST_UPDATE_DATE DATE ;
407: X_LAST_UPDATED_BY NUMBER ;

Line 431: IGS_PS_USEC_X_USEC_S.NEXTVAL

427: end if;
428:
429:
430: SELECT
431: IGS_PS_USEC_X_USEC_S.NEXTVAL
432: INTO
433: x_UNIT_SEC_CROSS_UNIT_SEC_ID
434: FROM
435: Dual;

Line 448: insert into IGS_PS_USEC_X_USEC (

444: x_created_by=>X_LAST_UPDATED_BY,
445: x_last_update_date=>X_LAST_UPDATE_DATE,
446: x_last_updated_by=>X_LAST_UPDATED_BY,
447: x_last_update_login=>X_LAST_UPDATE_LOGIN);
448: insert into IGS_PS_USEC_X_USEC (
449: UNIT_SEC_CROSS_UNIT_SEC_ID
450: ,PARENT_UOO_ID
451: ,CHILD_UOO_ID
452: ,CREATION_DATE

Line 497: from IGS_PS_USEC_X_USEC

493:
494: cursor c1 is select
495: PARENT_UOO_ID
496: , CHILD_UOO_ID
497: from IGS_PS_USEC_X_USEC
498: where ROWID = X_ROWID
499: for update nowait;
500: tlinfo c1%rowtype;
501: begin

Line 574: update IGS_PS_USEC_X_USEC set

570: x_created_by=>X_LAST_UPDATED_BY,
571: x_last_update_date=>X_LAST_UPDATE_DATE,
572: x_last_updated_by=>X_LAST_UPDATED_BY,
573: x_last_update_login=>X_LAST_UPDATE_LOGIN);
574: update IGS_PS_USEC_X_USEC set
575: PARENT_UOO_ID = NEW_REFERENCES.PARENT_UOO_ID,
576: CHILD_UOO_ID = NEW_REFERENCES.CHILD_UOO_ID,
577: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
578: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 608: cursor c1 is select ROWID from IGS_PS_USEC_X_USEC

604:
605: (reverse chronological order - newest change first)
606: ***************************************************************/
607:
608: cursor c1 is select ROWID from IGS_PS_USEC_X_USEC
609: where UNIT_SEC_CROSS_UNIT_SEC_ID= X_UNIT_SEC_CROSS_UNIT_SEC_ID
610: ;
611: begin
612: open c1;

Line 651: delete from IGS_PS_USEC_X_USEC

647: Before_DML (
648: p_action => 'DELETE',
649: x_rowid => X_ROWID
650: );
651: delete from IGS_PS_USEC_X_USEC
652: where ROWID = X_ROWID;
653: if (sql%notfound) then
654: raise no_data_found;
655: end if;

Line 661: END igs_ps_usec_x_usec_pkg;

657: p_action => 'DELETE',
658: x_rowid => X_ROWID
659: );
660: end DELETE_ROW;
661: END igs_ps_usec_x_usec_pkg;