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_PERS_UNT_EXCL_PKG dependencies on IGS_PE_PERS_UNT_EXCL

Line 1: package body IGS_PE_PERS_UNT_EXCL_PKG AS

1: package body IGS_PE_PERS_UNT_EXCL_PKG AS
2: /* $Header: IGSNI33B.pls 120.1 2005/09/08 14:23:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_PERS_UNT_EXCL%RowType;

Line 5: old_references IGS_PE_PERS_UNT_EXCL%RowType;

1: package body IGS_PE_PERS_UNT_EXCL_PKG AS
2: /* $Header: IGSNI33B.pls 120.1 2005/09/08 14:23:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_PERS_UNT_EXCL%RowType;
6: new_references IGS_PE_PERS_UNT_EXCL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_PERS_UNT_EXCL%RowType;

2: /* $Header: IGSNI33B.pls 120.1 2005/09/08 14:23:26 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_PERS_UNT_EXCL%RowType;
6: new_references IGS_PE_PERS_UNT_EXCL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PE_PERS_UNT_EXCL

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

Line 133: 'IGS_PE_PERS_UNT_EXCL',

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

Line 160: -- ON IGS_PE_PERS_UNT_EXCL

156:
157: -- Trigger description :-
158: -- "OSS_TST".trg_pue_ar_iu
159: -- AFTER INSERT OR UPDATE
160: -- ON IGS_PE_PERS_UNT_EXCL
161: -- FOR EACH ROW
162:
163: PROCEDURE AfterRowInsertUpdate2(
164: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 173: -- Validate for open ended IGS_PE_PERS_UNT_EXCL records.

169: v_rowid_saved BOOLEAN := FALSE;
170: BEGIN
171: -- Validate for open ended IGS_PE_PERSON IGS_PS_UNIT exclusion records.
172: IF new_references.expiry_dt IS NULL THEN
173: -- Validate for open ended IGS_PE_PERS_UNT_EXCL records.
174: IF new_references.expiry_dt IS NULL THEN
175: IF IGS_EN_VAL_PUE.enrp_val_pue_open (
176: new_references.person_id,
177: new_references.encumbrance_type,

Line 198: -- ON IGS_PE_PERS_UNT_EXCL

194:
195: -- Trigger description :-
196: -- "OSS_TST".trg_pue_as_iu
197: -- AFTER INSERT OR UPDATE
198: -- ON IGS_PE_PERS_UNT_EXCL
199:
200:
201:
202: PROCEDURE Check_Constraints (

Line 302: FROM IGS_PE_PERS_UNT_EXCL

298: ) RETURN BOOLEAN AS
299:
300: CURSOR cur_rowid IS
301: SELECT rowid
302: FROM IGS_PE_PERS_UNT_EXCL
303: WHERE person_id = x_person_id
304: AND encumbrance_type = x_encumbrance_type
305: AND pen_start_dt = x_pen_start_dt
306: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 340: FROM IGS_PE_PERS_UNT_EXCL

336: ) AS
337:
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM IGS_PE_PERS_UNT_EXCL
341: WHERE person_id = x_person_id
342: AND encumbrance_type = x_encumbrance_type
343: AND pen_start_dt = x_pen_start_dt
344: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 371: FROM IGS_PE_PERS_UNT_EXCL

367: ) AS
368:
369: CURSOR cur_rowid IS
370: SELECT rowid
371: FROM IGS_PE_PERS_UNT_EXCL
372: WHERE unit_cd = x_unit_cd ;
373:
374: lv_rowid cur_rowid%RowType;
375:

Line 523: cursor C is select ROWID from IGS_PE_PERS_UNT_EXCL

519: X_PUE_START_DT in DATE,
520: X_EXPIRY_DT in DATE,
521: X_MODE in VARCHAR2 default 'R'
522: ) AS
523: cursor C is select ROWID from IGS_PE_PERS_UNT_EXCL
524: where PERSON_ID = X_PERSON_ID
525: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
526: and PEN_START_DT = X_PEN_START_DT
527: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 573: insert into IGS_PE_PERS_UNT_EXCL (

569: x_last_updated_by=>X_LAST_UPDATED_BY,
570: x_last_update_login=>X_LAST_UPDATE_LOGIN
571: );
572:
573: insert into IGS_PE_PERS_UNT_EXCL (
574: PERSON_ID,
575: ENCUMBRANCE_TYPE,
576: PEN_START_DT,
577: S_ENCMB_EFFECT_TYPE,

Line 632: from IGS_PE_PERS_UNT_EXCL

628: X_EXPIRY_DT in DATE
629: ) AS
630: cursor c1 is select
631: EXPIRY_DT
632: from IGS_PE_PERS_UNT_EXCL
633: where ROWID = X_ROWID
634: for update nowait;
635: tlinfo c1%rowtype;
636:

Line 715: update IGS_PE_PERS_UNT_EXCL set

711: x_last_updated_by=>X_LAST_UPDATED_BY,
712: x_last_update_login=>X_LAST_UPDATE_LOGIN
713: );
714:
715: update IGS_PE_PERS_UNT_EXCL set
716: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
717: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
718: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
719: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 745: cursor c1 is select rowid from IGS_PE_PERS_UNT_EXCL

741: X_PUE_START_DT in DATE,
742: X_EXPIRY_DT in DATE,
743: X_MODE in VARCHAR2 default 'R'
744: ) AS
745: cursor c1 is select rowid from IGS_PE_PERS_UNT_EXCL
746: where PERSON_ID = X_PERSON_ID
747: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
748: and PEN_START_DT = X_PEN_START_DT
749: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 798: delete from IGS_PE_PERS_UNT_EXCL

794: Before_DML(
795: p_action => 'DELETE',
796: x_rowid => X_ROWID
797: );
798: delete from IGS_PE_PERS_UNT_EXCL
799: where ROWID = X_ROWID;
800: if (sql%notfound) then
801: raise no_data_found;
802: end if;

Line 809: end IGS_PE_PERS_UNT_EXCL_PKG;

805: x_rowid => X_ROWID
806: );
807: end DELETE_ROW;
808:
809: end IGS_PE_PERS_UNT_EXCL_PKG;