APPS.IGS_PS_USEC_WLST_PRI_PKG dependencies on IGS_PS_USEC_WLST_PRI

Line 1: PACKAGE BODY igs_ps_usec_wlst_pri_pkg AS

1: PACKAGE BODY igs_ps_usec_wlst_pri_pkg AS
2: /* $Header: IGSPI0YB.pls 120.0 2005/06/01 16:01:10 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_wlst_pri%RowType;
5: new_references igs_ps_usec_wlst_pri%RowType;

Line 4: old_references igs_ps_usec_wlst_pri%RowType;

1: PACKAGE BODY igs_ps_usec_wlst_pri_pkg AS
2: /* $Header: IGSPI0YB.pls 120.0 2005/06/01 16:01:10 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_wlst_pri%RowType;
5: new_references igs_ps_usec_wlst_pri%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_wlst_pri%RowType;

1: PACKAGE BODY igs_ps_usec_wlst_pri_pkg AS
2: /* $Header: IGSPI0YB.pls 120.0 2005/06/01 16:01:10 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_wlst_pri%RowType;
5: new_references igs_ps_usec_wlst_pri%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_WLST_PRI

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

Line 168: Igs_Ps_Usec_Wlst_Prf_Pkg.Get_FK_Igs_Ps_Usec_Wlst_Pri (

164: ***************************************************************/
165:
166: BEGIN
167:
168: Igs_Ps_Usec_Wlst_Prf_Pkg.Get_FK_Igs_Ps_Usec_Wlst_Pri (
169: old_references.unit_sec_waitlist_priority_id
170: );
171:
172: END Check_Child_Existance;

Line 191: FROM igs_ps_usec_wlst_pri

187: ***************************************************************/
188:
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igs_ps_usec_wlst_pri
192: WHERE unit_sec_waitlist_priority_id = x_unit_sec_wlst_priority_id
193: FOR UPDATE NOWAIT;
194:
195: lv_rowid cur_rowid%RowType;

Line 228: FROM igs_ps_usec_wlst_pri

224: ***************************************************************/
225:
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_ps_usec_wlst_pri
229: WHERE priority_value = x_priority_value
230: AND uoo_id = x_uoo_id
231: AND ((l_rowid is null) or (rowid <> l_rowid)) ;
232: lv_rowid cur_rowid%RowType;

Line 264: FROM igs_ps_usec_wlst_pri

260: ***************************************************************/
261:
262: CURSOR cur_rowid IS
263: SELECT rowid
264: FROM igs_ps_usec_wlst_pri
265: WHERE uoo_id = x_uoo_id;
266:
267: lv_rowid cur_rowid%RowType;
268:

Line 419: FROM igs_ps_usec_wlst_pri

415: ***************************************************************/
416:
417: CURSOR C IS
418: SELECT ROWID
419: FROM igs_ps_usec_wlst_pri
420: WHERE unit_sec_waitlist_priority_id = x_unit_sec_wlst_priority_id;
421:
422: X_LAST_UPDATE_DATE DATE ;
423: X_LAST_UPDATED_BY NUMBER ;

Line 445: igs_ps_usec_wlst_pri_s.nextval

441: IGS_GE_MSG_STACK.ADD;
442: app_exception.raise_exception;
443: end if;
444: SELECT
445: igs_ps_usec_wlst_pri_s.nextval
446: INTO
447: x_unit_sec_wlst_priority_id
448: FROM dual;
449: before_dml(p_action=>'INSERT',

Line 460: INSERT INTO igs_ps_usec_wlst_pri (

456: x_created_by=>x_last_updated_by,
457: x_last_update_date=>x_last_update_date,
458: x_last_updated_by=>x_last_updated_by,
459: x_last_update_login=>x_last_update_login);
460: INSERT INTO igs_ps_usec_wlst_pri (
461: unit_sec_waitlist_priority_id
462: ,priority_number
463: ,priority_value
464: ,uoo_id

Line 514: FROM igs_ps_usec_wlst_pri

510: CURSOR c1 IS SELECT
511: priority_number
512: , priority_value
513: , uoo_id
514: FROM igs_ps_usec_wlst_pri
515: WHERE ROWID = x_rowid
516: FOR UPDATE NOWAIT;
517: tlinfo c1%ROWTYPE;
518: BEGIN

Line 595: UPDATE IGS_PS_USEC_WLST_PRI set

591: x_created_by=>X_LAST_UPDATED_BY,
592: x_last_update_date=>X_LAST_UPDATE_DATE,
593: x_last_updated_by=>X_LAST_UPDATED_BY,
594: x_last_update_login=>X_LAST_UPDATE_LOGIN);
595: UPDATE IGS_PS_USEC_WLST_PRI set
596: uoo_id = new_references.uoo_id,
597: priority_number = new_references.priority_number,
598: priority_value = new_references.priority_value,
599: last_update_date = x_last_update_date,

Line 632: CURSOR c1 is select ROWID from IGS_PS_USEC_WLST_PRI

628:
629: (reverse chronological order - newest change first)
630: ***************************************************************/
631:
632: CURSOR c1 is select ROWID from IGS_PS_USEC_WLST_PRI
633: where UNIT_SEC_WAITLIST_PRIORITY_ID= x_unit_sec_wlst_priority_id
634: ;
635: BEGIN
636: open c1;

Line 679: igs_ps_usec_wlst_pri

675: p_action => 'DELETE',
676: x_rowid => X_ROWID
677: );
678: DELETE FROM
679: igs_ps_usec_wlst_pri
680: WHERE ROWID = x_rowid;
681: if (sql%notfound) THEN
682: RAISE no_data_found;
683: end if;

Line 690: END igs_ps_usec_wlst_pri_pkg;

686: x_rowid => X_ROWID
687: );
688: end delete_row;
689:
690: END igs_ps_usec_wlst_pri_pkg;