eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_UNT_SET_EXCL_PKG dependencies on IGS_PE_UNT_SET_EXCL

Line 1: package body IGS_PE_UNT_SET_EXCL_PKG AS

1: package body IGS_PE_UNT_SET_EXCL_PKG AS
2: /* $Header: IGSNI35B.pls 115.4 2002/11/29 01:22:46 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_UNT_SET_EXCL%RowType;

Line 5: old_references IGS_PE_UNT_SET_EXCL%RowType;

1: package body IGS_PE_UNT_SET_EXCL_PKG AS
2: /* $Header: IGSNI35B.pls 115.4 2002/11/29 01:22:46 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_UNT_SET_EXCL%RowType;
6: new_references IGS_PE_UNT_SET_EXCL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_UNT_SET_EXCL%RowType;

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

Line 30: FROM IGS_PE_UNT_SET_EXCL

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

Line 136: 'IGS_PE_UNT_SET_EXCL',

132: -- effect type.
133: IF p_inserting THEN
134: IF IGS_EN_VAL_PCE.enrp_val_pee_table (
135: new_references.s_encmb_effect_type,
136: 'IGS_PE_UNT_SET_EXCL',
137: v_message_name ) = FALSE THEN
138: Fnd_Message.Set_Name('IGS', v_message_name);
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;

Line 164: -- ON IGS_PE_UNT_SET_EXCL

160:
161: -- Trigger description :-
162: -- "OSS_TST".trg_puse_ar_iu
163: -- AFTER INSERT OR UPDATE
164: -- ON IGS_PE_UNT_SET_EXCL
165: -- FOR EACH ROW
166:
167: PROCEDURE AfterRowInsertUpdate2(
168: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 177: -- Validate for open ended IGS_PE_UNT_SET_EXCL records.

173: v_rowid_saved BOOLEAN := FALSE;
174: BEGIN
175: -- Validate for open ended IGS_PE_PERSON IGS_PS_UNIT set exclusion records.
176: IF new_references.expiry_dt IS NULL THEN
177: -- Validate for open ended IGS_PE_UNT_SET_EXCL records.
178: IF new_references.expiry_dt IS NULL THEN
179: IF IGS_EN_VAL_PUSE.enrp_val_puse_open (
180: new_references.person_id,
181: new_references.encumbrance_type,

Line 203: -- ON IGS_PE_UNT_SET_EXCL

199:
200: -- Trigger description :-
201: -- "OSS_TST".trg_puse_as_iu
202: -- AFTER INSERT OR UPDATE
203: -- ON IGS_PE_UNT_SET_EXCL
204:
205:
206:
207: PROCEDURE Check_Constraints (

Line 313: FROM IGS_PE_UNT_SET_EXCL

309: ) RETURN BOOLEAN AS
310:
311: CURSOR cur_rowid IS
312: SELECT rowid
313: FROM IGS_PE_UNT_SET_EXCL
314: WHERE s_encmb_effect_type = x_s_encmb_effect_type
315: AND pen_start_dt = x_pen_start_dt
316: AND person_id = x_person_id
317: AND encumbrance_type = x_encumbrance_type

Line 352: FROM IGS_PE_UNT_SET_EXCL

348: ) AS
349:
350: CURSOR cur_rowid IS
351: SELECT rowid
352: FROM IGS_PE_UNT_SET_EXCL
353: WHERE person_id = x_person_id
354: AND encumbrance_type = x_encumbrance_type
355: AND pen_start_dt = x_pen_start_dt
356: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 384: FROM IGS_PE_UNT_SET_EXCL

380: ) AS
381:
382: CURSOR cur_rowid IS
383: SELECT rowid
384: FROM IGS_PE_UNT_SET_EXCL
385: WHERE unit_set_cd = x_unit_set_cd
386: AND us_version_number = x_version_number ;
387:
388: lv_rowid cur_rowid%RowType;

Line 540: cursor C is select ROWID from IGS_PE_UNT_SET_EXCL

536: X_PUSE_START_DT in DATE,
537: X_EXPIRY_DT in DATE,
538: X_MODE in VARCHAR2 default 'R'
539: ) AS
540: cursor C is select ROWID from IGS_PE_UNT_SET_EXCL
541: where PERSON_ID = X_PERSON_ID
542: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
543: and PEN_START_DT = X_PEN_START_DT
544: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 592: insert into IGS_PE_UNT_SET_EXCL (

588: x_last_update_date=>X_LAST_UPDATE_DATE,
589: x_last_updated_by=>X_LAST_UPDATED_BY,
590: x_last_update_login=>X_LAST_UPDATE_LOGIN
591: );
592: insert into IGS_PE_UNT_SET_EXCL (
593: PERSON_ID,
594: ENCUMBRANCE_TYPE,
595: PEN_START_DT,
596: S_ENCMB_EFFECT_TYPE,

Line 654: from IGS_PE_UNT_SET_EXCL

650: X_EXPIRY_DT in DATE
651: ) AS
652: cursor c1 is select
653: EXPIRY_DT
654: from IGS_PE_UNT_SET_EXCL
655: where ROWID = X_ROWID
656: for update nowait;
657: tlinfo c1%rowtype;
658:

Line 738: update IGS_PE_UNT_SET_EXCL set

734: x_last_update_date=>X_LAST_UPDATE_DATE,
735: x_last_updated_by=>X_LAST_UPDATED_BY,
736: x_last_update_login=>X_LAST_UPDATE_LOGIN
737: );
738: update IGS_PE_UNT_SET_EXCL set
739: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
740: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
741: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
742: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 768: cursor c1 is select rowid from IGS_PE_UNT_SET_EXCL

764: X_PUSE_START_DT in DATE,
765: X_EXPIRY_DT in DATE,
766: X_MODE in VARCHAR2 default 'R'
767: ) AS
768: cursor c1 is select rowid from IGS_PE_UNT_SET_EXCL
769: where PERSON_ID = X_PERSON_ID
770: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
771: and PEN_START_DT = X_PEN_START_DT
772: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 825: delete from IGS_PE_UNT_SET_EXCL

821: Before_DML(
822: p_action => 'DELETE',
823: x_rowid => X_ROWID
824: );
825: delete from IGS_PE_UNT_SET_EXCL
826: where ROWID = X_ROWID;
827: if (sql%notfound) then
828: raise no_data_found;
829: end if;

Line 836: end IGS_PE_UNT_SET_EXCL_PKG;

832: x_rowid => X_ROWID
833: );
834: end DELETE_ROW;
835:
836: end IGS_PE_UNT_SET_EXCL_PKG;