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_FI_EL_RNG_PKG dependencies on IGS_FI_ELM_RANGE

Line 4: old_references IGS_FI_ELM_RANGE%RowType;

1: package body IGS_FI_EL_RNG_PKG AS
2: /* $Header: IGSSI66B.pls 120.1 2005/07/05 21:52:05 appldev ship $*/
3: l_rowid VARCHAR2(25) ;
4: old_references IGS_FI_ELM_RANGE%RowType;
5: new_references IGS_FI_ELM_RANGE%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_ELM_RANGE%RowType;

1: package body IGS_FI_EL_RNG_PKG AS
2: /* $Header: IGSSI66B.pls 120.1 2005/07/05 21:52:05 appldev ship $*/
3: l_rowid VARCHAR2(25) ;
4: old_references IGS_FI_ELM_RANGE%RowType;
5: new_references IGS_FI_ELM_RANGE%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_ER_ID IN NUMBER DEFAULT NULL,

Line 28: FROM IGS_FI_ELM_RANGE

24: x_last_update_login IN NUMBER DEFAULT NULL
25: ) AS
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_FI_ELM_RANGE
29: WHERE rowid = x_rowid;
30: BEGIN
31: l_rowid := x_rowid;
32: -- Code for setting the Old and New Reference Values.

Line 69: -- ON IGS_FI_ELM_RANGE

65: new_references.last_update_login := x_last_update_login;
66: END Set_Column_Values;
67: -- Trigger description :-
68: -- BEFORE INSERT OR DELETE OR UPDATE
69: -- ON IGS_FI_ELM_RANGE
70: -- FOR EACH ROW
71: PROCEDURE BeforeRowInsertUpdateDelete1(
72: p_inserting IN BOOLEAN DEFAULT FALSE,
73: p_updating IN BOOLEAN DEFAULT FALSE,

Line 127: -- ON IGS_FI_ELM_RANGE

123: END IF;
124: END BeforeRowInsertUpdateDelete1;
125: -- Trigger description :-
126: -- AFTER UPDATE
127: -- ON IGS_FI_ELM_RANGE
128: -- FOR EACH ROW
129: PROCEDURE AfterRowUpdate3(
130: p_inserting IN BOOLEAN DEFAULT FALSE,
131: p_updating IN BOOLEAN DEFAULT FALSE,

Line 156: -- ON IGS_FI_ELM_RANGE

152: old_references.last_update_date);
153: END AfterRowUpdate3;
154: -- Trigger description :-
155: -- AFTER INSERT OR UPDATE
156: -- ON IGS_FI_ELM_RANGE
157: PROCEDURE AfterStmtInsertUpdate4(
158: p_inserting IN BOOLEAN DEFAULT FALSE,
159: p_updating IN BOOLEAN DEFAULT FALSE,
160: p_deleting IN BOOLEAN DEFAULT FALSE

Line 366: IGS_FI_ELM_RANGE_RT_PKG.GET_UFK_IGS_FI_ELM_RANGE (

362: END IF;
363: END Check_Parent_Existance;
364: PROCEDURE Check_Child_Existance AS
365: BEGIN
366: IGS_FI_ELM_RANGE_RT_PKG.GET_UFK_IGS_FI_ELM_RANGE (
367: new_references.fee_type,
368: new_references.fee_cal_type,
369: new_references.fee_ci_sequence_number,
370: new_references.s_relation_type,

Line 391: IGS_FI_ELM_RANGE_RT_PKG.GET_UFK_IGS_FI_ELM_RANGE (

387: (old_references.range_number = Null) AND
388: (old_references.fee_cat = Null))) THEN
389: Null;
390: ELSE
391: IGS_FI_ELM_RANGE_RT_PKG.GET_UFK_IGS_FI_ELM_RANGE (
392: old_references.fee_type,
393: old_references.fee_cal_type,
394: old_references.fee_ci_sequence_number,
395: old_references.s_relation_type,

Line 406: FROM IGS_FI_ELM_RANGE

402: x_ER_ID NUMBER
403: ) RETURN BOOLEAN AS
404: CURSOR cur_rowid IS
405: SELECT rowid
406: FROM IGS_FI_ELM_RANGE
407: WHERE ER_ID = x_ER_ID
408: FOR UPDATE NOWAIT;
409: lv_rowid cur_rowid%RowType;
410: BEGIN

Line 430: FROM IGS_FI_ELM_RANGE

426: x_fee_cat IN VARCHAR2
427: ) RETURN BOOLEAN AS
428: CURSOR cur_rowid IS
429: SELECT rowid
430: FROM IGS_FI_ELM_RANGE
431: WHERE fee_type = x_fee_type
432: AND fee_cal_type = x_fee_cal_type
433: AND fee_ci_sequence_number = x_fee_ci_sequence_number
434: AND range_number = x_range_number

Line 459: FROM IGS_FI_ELM_RANGE

455: x_fee_cat IN VARCHAR2
456: ) RETURN BOOLEAN AS
457: CURSOR cur_rowid IS
458: SELECT rowid
459: FROM IGS_FI_ELM_RANGE
460: WHERE fee_type = x_fee_type
461: AND fee_cal_type = x_fee_cal_type
462: AND fee_ci_sequence_number = x_fee_ci_sequence_number
463: AND s_relation_type = x_s_relation_type

Line 485: FROM IGS_FI_ELM_RANGE

481: x_er_id IN NUMBER
482: ) RETURN BOOLEAN AS
483: CURSOR cur_rowid IS
484: SELECT rowid
485: FROM IGS_FI_ELM_RANGE
486: WHERE er_id = x_er_id
487: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
488: FOR UPDATE NOWAIT;
489: lv_rowid cur_rowid%RowType;

Line 507: FROM IGS_FI_ELM_RANGE

503: x_s_chg_method_type IN VARCHAR2
504: ) AS
505: CURSOR cur_rowid IS
506: SELECT rowid
507: FROM IGS_FI_ELM_RANGE
508: WHERE s_chg_method_type = x_s_chg_method_type ;
509: lv_rowid cur_rowid%RowType;
510: BEGIN
511: Open cur_rowid;

Line 634: cursor C (cp_range_id IN NUMBER) is select ROWID from IGS_FI_ELM_RANGE

630: X_S_CHG_METHOD_TYPE in VARCHAR2,
631: X_LOGICAL_DELETE_DT in DATE,
632: X_MODE in VARCHAR2 default 'R'
633: ) AS
634: cursor C (cp_range_id IN NUMBER) is select ROWID from IGS_FI_ELM_RANGE
635: where ER_ID = cp_range_id;
636: X_LAST_UPDATE_DATE DATE;
637: X_LAST_UPDATED_BY NUMBER;
638: X_LAST_UPDATE_LOGIN NUMBER;

Line 673: SELECT IGS_FI_ELM_RANGE_ER_ID_S.NextVal

669: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
670: IGS_GE_MSG_STACK.ADD;
671: app_exception.raise_exception;
672: end if;
673: SELECT IGS_FI_ELM_RANGE_ER_ID_S.NextVal
674: INTO X_ER_ID
675: FROM dual;
676: Before_DML(
677: p_action=>'INSERT',

Line 696: insert into IGS_FI_ELM_RANGE (

692: x_last_update_date=>X_LAST_UPDATE_DATE,
693: x_last_updated_by=>X_LAST_UPDATED_BY,
694: x_last_update_login=>X_LAST_UPDATE_LOGIN
695: );
696: insert into IGS_FI_ELM_RANGE (
697: ER_ID,
698: FEE_TYPE,
699: FEE_CAL_TYPE,
700: FEE_CI_SEQUENCE_NUMBER,

Line 776: from IGS_FI_ELM_RANGE

772: LOWER_RANGE,
773: UPPER_RANGE,
774: S_CHG_METHOD_TYPE,
775: LOGICAL_DELETE_DT
776: from IGS_FI_ELM_RANGE
777: where ROWID=X_ROWID
778: for update nowait;
779: tlinfo c1%rowtype;
780: begin

Line 892: update IGS_FI_ELM_RANGE set

888: x_last_update_date=>X_LAST_UPDATE_DATE,
889: x_last_updated_by=>X_LAST_UPDATED_BY,
890: x_last_update_login=>X_LAST_UPDATE_LOGIN
891: );
892: update IGS_FI_ELM_RANGE set
893: FEE_CAL_TYPE = NEW_REFERENCES.FEE_CAL_TYPE,
894: FEE_CI_SEQUENCE_NUMBER = NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
895: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
896: S_RELATION_TYPE = NEW_REFERENCES.S_RELATION_TYPE,

Line 935: cursor c1 is select rowid from IGS_FI_ELM_RANGE

931: X_S_CHG_METHOD_TYPE in VARCHAR2,
932: X_LOGICAL_DELETE_DT in DATE,
933: X_MODE in VARCHAR2 default 'R'
934: ) AS
935: cursor c1 is select rowid from IGS_FI_ELM_RANGE
936: where ER_ID = X_ER_ID;
937: begin
938: open c1;
939: fetch c1 into X_ROWID;

Line 982: delete from IGS_FI_ELM_RANGE

978: Before_DML(
979: p_action =>'DELETE',
980: x_rowid => X_ROWID
981: );
982: delete from IGS_FI_ELM_RANGE
983: where ROWID=X_ROWID;
984: if (sql%notfound) then
985: raise no_data_found;
986: end if;