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_REQUIRMNT_PKG dependencies on IGS_PE_UNT_REQUIRMNT

Line 1: package body IGS_PE_UNT_REQUIRMNT_PKG AS

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

Line 5: old_references IGS_PE_UNT_REQUIRMNT%RowType;

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

Line 6: new_references IGS_PE_UNT_REQUIRMNT%RowType;

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

Line 29: FROM IGS_PE_UNT_REQUIRMNT

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

Line 135: 'IGS_PE_UNT_REQUIRMNT',

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

Line 149: -- ON IGS_PE_UNT_REQUIRMNT

145:
146: -- Trigger description :-
147: -- "OSS_TST".trg_pur_ar_iu
148: -- AFTER INSERT OR UPDATE
149: -- ON IGS_PE_UNT_REQUIRMNT
150: -- FOR EACH ROW
151:
152: PROCEDURE AfterRowInsertUpdate2(
153: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 163: -- Validate for open ended IGS_PE_UNT_REQUIRMNT records.

159: BEGIN
160: -- Validate for open ended IGS_PE_PERSON IGS_PS_UNIT requirement records.
161: IF new_references.expiry_dt IS NULL THEN
162: -- Save the rowid of the current row.
163: -- Validate for open ended IGS_PE_UNT_REQUIRMNT records.
164: IF new_references.expiry_dt IS NULL THEN
165: IF IGS_EN_VAL_PUR.enrp_val_pur_open (
166: new_references.person_id,
167: new_references.encumbrance_type,

Line 187: -- ON IGS_PE_UNT_REQUIRMNT

183:
184: -- Trigger description :-
185: -- "OSS_TST".trg_pur_as_iu
186: -- AFTER INSERT OR UPDATE
187: -- ON IGS_PE_UNT_REQUIRMNT
188:
189:
190: PROCEDURE Check_Constraints (
191: Column_Name IN VARCHAR2 DEFAULT NULL,

Line 291: FROM IGS_PE_UNT_REQUIRMNT

287: ) RETURN BOOLEAN AS
288:
289: CURSOR cur_rowid IS
290: SELECT rowid
291: FROM IGS_PE_UNT_REQUIRMNT
292: WHERE s_encmb_effect_type = x_s_encmb_effect_type
293: AND pen_start_dt = x_pen_start_dt
294: AND person_id = x_person_id
295: AND encumbrance_type = x_encumbrance_type

Line 330: FROM IGS_PE_UNT_REQUIRMNT

326: ) AS
327:
328: CURSOR cur_rowid IS
329: SELECT rowid
330: FROM IGS_PE_UNT_REQUIRMNT
331: WHERE person_id = x_person_id
332: AND encumbrance_type = x_encumbrance_type
333: AND pen_start_dt = x_pen_start_dt
334: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 361: FROM IGS_PE_UNT_REQUIRMNT

357: ) AS
358:
359: CURSOR cur_rowid IS
360: SELECT rowid
361: FROM IGS_PE_UNT_REQUIRMNT
362: WHERE unit_cd = x_unit_cd ;
363:
364: lv_rowid cur_rowid%RowType;
365:

Line 509: cursor C is select ROWID from IGS_PE_UNT_REQUIRMNT

505: X_PUR_START_DT in DATE,
506: X_EXPIRY_DT in DATE,
507: X_MODE in VARCHAR2 default 'R'
508: ) AS
509: cursor C is select ROWID from IGS_PE_UNT_REQUIRMNT
510: where PERSON_ID = X_PERSON_ID
511: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
512: and PEN_START_DT = X_PEN_START_DT
513: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 559: insert into IGS_PE_UNT_REQUIRMNT (

555: x_last_updated_by=>X_LAST_UPDATED_BY,
556: x_last_update_login=>X_LAST_UPDATE_LOGIN
557: );
558:
559: insert into IGS_PE_UNT_REQUIRMNT (
560: PERSON_ID,
561: ENCUMBRANCE_TYPE,
562: PEN_START_DT,
563: S_ENCMB_EFFECT_TYPE,

Line 618: from IGS_PE_UNT_REQUIRMNT

614: X_EXPIRY_DT in DATE
615: ) AS
616: cursor c1 is select
617: EXPIRY_DT
618: from IGS_PE_UNT_REQUIRMNT
619: where ROWID = X_ROWID
620: for update nowait;
621: tlinfo c1%rowtype;
622:

Line 701: update IGS_PE_UNT_REQUIRMNT set

697: x_last_updated_by=>X_LAST_UPDATED_BY,
698: x_last_update_login=>X_LAST_UPDATE_LOGIN
699: );
700:
701: update IGS_PE_UNT_REQUIRMNT set
702: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
703: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
704: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
705: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 730: cursor c1 is select rowid from IGS_PE_UNT_REQUIRMNT

726: X_PUR_START_DT in DATE,
727: X_EXPIRY_DT in DATE,
728: X_MODE in VARCHAR2 default 'R'
729: ) AS
730: cursor c1 is select rowid from IGS_PE_UNT_REQUIRMNT
731: where PERSON_ID = X_PERSON_ID
732: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
733: and PEN_START_DT = X_PEN_START_DT
734: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 783: delete from IGS_PE_UNT_REQUIRMNT

779: Before_DML(
780: p_action => 'DELETE',
781: x_rowid => X_ROWID
782: );
783: delete from IGS_PE_UNT_REQUIRMNT
784: where ROWID = X_ROWID;
785: if (sql%notfound) then
786: raise no_data_found;
787: end if;

Line 794: end IGS_PE_UNT_REQUIRMNT_PKG;

790: x_rowid => X_ROWID
791: );
792: end DELETE_ROW;
793:
794: end IGS_PE_UNT_REQUIRMNT_PKG;