APPS.IGS_FI_ELM_RANGE_RT_PKG dependencies on IGS_FI_ELM_RANGE_RT

Line 1: package body IGS_FI_ELM_RANGE_RT_PKG AS

1: package body IGS_FI_ELM_RANGE_RT_PKG AS
2: /* $Header: IGSSI67B.pls 115.6 2003/04/22 09:13:05 vvutukur ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_ELM_RANGE_RT%RowType;
5: new_references IGS_FI_ELM_RANGE_RT%RowType;

Line 4: old_references IGS_FI_ELM_RANGE_RT%RowType;

1: package body IGS_FI_ELM_RANGE_RT_PKG AS
2: /* $Header: IGSSI67B.pls 115.6 2003/04/22 09:13:05 vvutukur ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_ELM_RANGE_RT%RowType;
5: new_references IGS_FI_ELM_RANGE_RT%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_RT%RowType;

1: package body IGS_FI_ELM_RANGE_RT_PKG AS
2: /* $Header: IGSSI67B.pls 115.6 2003/04/22 09:13:05 vvutukur ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_ELM_RANGE_RT%RowType;
5: new_references IGS_FI_ELM_RANGE_RT%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_ERR_ID IN NUMBER DEFAULT NULL,

Line 27: FROM IGS_FI_ELM_RANGE_RT

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

Line 67: -- ON IGS_FI_ELM_RANGE_RT

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

Line 110: -- ON IGS_FI_ELM_RANGE_RT

106: END IF;
107: END BeforeRowInsertUpdateDelete1;
108: -- Trigger description :-
109: -- AFTER INSERT OR UPDATE
110: -- ON IGS_FI_ELM_RANGE_RT
111: PROCEDURE AfterStmtInsertUpdate3(
112: p_inserting IN BOOLEAN DEFAULT FALSE,
113: p_updating IN BOOLEAN DEFAULT FALSE,
114: p_deleting IN BOOLEAN DEFAULT FALSE

Line 286: FROM IGS_FI_ELM_RANGE_RT

282: x_ERR_ID NUMBER
283: ) RETURN BOOLEAN AS
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM IGS_FI_ELM_RANGE_RT
287: WHERE ERR_ID = x_ERR_ID
288: FOR UPDATE NOWAIT;
289: lv_rowid cur_rowid%RowType;
290: BEGIN

Line 312: FROM IGS_FI_ELM_RANGE_RT

308: x_fee_cat IN VARCHAR2
309: ) RETURN BOOLEAN AS
310: CURSOR cur_rowid IS
311: SELECT rowid
312: FROM IGS_FI_ELM_RANGE_RT
313: WHERE fee_type = x_fee_type
314: AND fee_cal_type = x_fee_cal_type
315: AND fee_ci_sequence_number = x_fee_ci_sequence_number
316: AND range_number = x_range_number

Line 340: FROM IGS_FI_ELM_RANGE_RT

336: x_ERR_ID NUMBER
337: ) RETURN BOOLEAN AS
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM IGS_FI_ELM_RANGE_RT
341: WHERE ERR_ID = x_ERR_ID
342: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
343: FOR UPDATE NOWAIT;
344: lv_rowid cur_rowid%RowType;

Line 366: FROM IGS_FI_ELM_RANGE_RT

362: x_fee_cat IN VARCHAR2
363: ) AS
364: CURSOR cur_rowid IS
365: SELECT rowid
366: FROM IGS_FI_ELM_RANGE_RT
367: WHERE fee_type = x_fee_type
368: AND fee_cal_type = x_fee_cal_type
369: AND fee_ci_sequence_number = x_fee_ci_sequence_number
370: AND s_relation_type = x_s_relation_type

Line 396: FROM IGS_FI_ELM_RANGE_RT

392: x_fee_cat IN VARCHAR2
393: ) AS
394: CURSOR cur_rowid IS
395: SELECT rowid
396: FROM IGS_FI_ELM_RANGE_RT
397: WHERE fee_type = x_fee_type
398: AND fee_cal_type = x_fee_cal_type
399: AND fee_ci_sequence_number = x_fee_ci_sequence_number
400: AND s_relation_type = x_s_relation_type

Line 520: cursor C (cp_range_id IN NUMBER) is select ROWID from IGS_FI_ELM_RANGE_RT

516: X_FEE_CAT in VARCHAR2,
517: X_LOGICAL_DELETE_DT in DATE,
518: X_MODE in VARCHAR2 default 'R'
519: ) AS
520: cursor C (cp_range_id IN NUMBER) is select ROWID from IGS_FI_ELM_RANGE_RT
521: where ERR_ID = cp_range_id;
522: X_LAST_UPDATE_DATE DATE;
523: X_LAST_UPDATED_BY NUMBER;
524: X_LAST_UPDATE_LOGIN NUMBER;

Line 559: SELECT IGS_FI_ELM_RANGE_RT_ERR_ID_S.NextVal

555: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
556: IGS_GE_MSG_STACK.ADD;
557: app_exception.raise_exception;
558: end if;
559: SELECT IGS_FI_ELM_RANGE_RT_ERR_ID_S.NextVal
560: INTO x_ERR_ID
561: FROM dual;
562: Before_DML(
563: p_action=>'INSERT',

Line 581: insert into IGS_FI_ELM_RANGE_RT (

577: x_last_update_date=>X_LAST_UPDATE_DATE,
578: x_last_updated_by=>X_LAST_UPDATED_BY,
579: x_last_update_login=>X_LAST_UPDATE_LOGIN
580: );
581: insert into IGS_FI_ELM_RANGE_RT (
582: ERR_ID,
583: FEE_TYPE,
584: FEE_CAL_TYPE,
585: FEE_CI_SEQUENCE_NUMBER,

Line 657: from IGS_FI_ELM_RANGE_RT

653: RATE_NUMBER,
654: CREATE_DT,
655: FEE_CAT,
656: LOGICAL_DELETE_DT
657: from IGS_FI_ELM_RANGE_RT
658: where ROWID=X_ROWID
659: for update nowait;
660: tlinfo c1%rowtype;
661: begin

Line 764: update IGS_FI_ELM_RANGE_RT set

760: x_last_update_date=>X_LAST_UPDATE_DATE,
761: x_last_updated_by=>X_LAST_UPDATED_BY,
762: x_last_update_login=>X_LAST_UPDATE_LOGIN
763: );
764: update IGS_FI_ELM_RANGE_RT set
765: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
766: FEE_CAL_TYPE = NEW_REFERENCES.FEE_CAL_TYPE,
767: FEE_CI_SEQUENCE_NUMBER = NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
768: S_RELATION_TYPE = NEW_REFERENCES.S_RELATION_TYPE,

Line 805: cursor c1 is select rowid from IGS_FI_ELM_RANGE_RT

801: X_FEE_CAT in VARCHAR2,
802: X_LOGICAL_DELETE_DT in DATE,
803: X_MODE in VARCHAR2 default 'R'
804: ) AS
805: cursor c1 is select rowid from IGS_FI_ELM_RANGE_RT
806: where ERR_ID = x_ERR_ID
807: ;
808: begin
809: open c1;

Line 851: delete from IGS_FI_ELM_RANGE_RT

847: Before_DML(
848: p_action =>'DELETE',
849: x_rowid => X_ROWID
850: );
851: delete from IGS_FI_ELM_RANGE_RT
852: where ROWID=X_ROWID;
853: if (sql%notfound) then
854: raise no_data_found;
855: end if;

Line 857: end IGS_FI_ELM_RANGE_RT_PKG;

853: if (sql%notfound) then
854: raise no_data_found;
855: end if;
856: end DELETE_ROW;
857: end IGS_FI_ELM_RANGE_RT_PKG;