APPS.IGS_FI_ELM_RANGE_H_PKG dependencies on IGS_FI_ELM_RANGE_H_ALL

Line 5: old_references IGS_FI_ELM_RANGE_H_ALL%RowType;

1: package body IGS_FI_ELM_RANGE_H_PKG AS
2: /* $Header: IGSSI15B.pls 115.9 2003/02/12 10:03:13 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_ELM_RANGE_H_ALL%RowType;
6: new_references IGS_FI_ELM_RANGE_H_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_FI_ELM_RANGE_H_ALL%RowType;

2: /* $Header: IGSSI15B.pls 115.9 2003/02/12 10:03:13 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_ELM_RANGE_H_ALL%RowType;
6: new_references IGS_FI_ELM_RANGE_H_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_fee_type IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_FI_ELM_RANGE_H_ALL

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

Line 243: FROM IGS_FI_ELM_RANGE_H_ALL

239: ) Return Boolean
240: AS
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM IGS_FI_ELM_RANGE_H_ALL
244: WHERE fee_type = x_fee_type
245: AND fee_cal_type = x_fee_cal_type
246: AND fee_ci_sequence_number = x_fee_ci_sequence_number
247: AND s_relation_type = x_s_relation_type

Line 275: FROM IGS_FI_ELM_RANGE_H_ALL

271: ) Return Boolean
272: AS
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM IGS_FI_ELM_RANGE_H_ALL
276: WHERE fee_type = new_references.fee_type
277: AND fee_cal_type = new_references.fee_cal_type
278: AND fee_ci_sequence_number = new_references.fee_ci_sequence_number
279: AND range_number = new_references.range_number

Line 407: cursor C is select ROWID from IGS_FI_ELM_RANGE_H_ALL

403: X_S_CHG_METHOD_TYPE in VARCHAR2,
404: X_ORG_ID in NUMBER,
405: X_MODE in VARCHAR2 default 'R'
406: ) AS
407: cursor C is select ROWID from IGS_FI_ELM_RANGE_H_ALL
408: where FEE_TYPE = X_FEE_TYPE
409: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
410: and RANGE_NUMBER = X_RANGE_NUMBER
411: and HIST_START_DT = X_HIST_START_DT

Line 458: insert into IGS_FI_ELM_RANGE_H_ALL (

454: x_last_update_date => X_LAST_UPDATE_DATE,
455: x_last_updated_by => X_LAST_UPDATED_BY,
456: x_last_update_login => X_LAST_UPDATE_LOGIN
457: );
458: insert into IGS_FI_ELM_RANGE_H_ALL (
459: FEE_TYPE,
460: FEE_CAL_TYPE,
461: FEE_CI_SEQUENCE_NUMBER,
462: S_RELATION_TYPE,

Line 527: from IGS_FI_ELM_RANGE_H_ALL

523: FEE_CAT,
524: LOWER_RANGE,
525: UPPER_RANGE,
526: S_CHG_METHOD_TYPE
527: from IGS_FI_ELM_RANGE_H_ALL
528: where ROWID = X_ROWID
529: for update nowait;
530: tlinfo c1%rowtype;
531: begin

Line 624: update IGS_FI_ELM_RANGE_H_ALL set

620: x_last_update_date => X_LAST_UPDATE_DATE,
621: x_last_updated_by => X_LAST_UPDATED_BY,
622: x_last_update_login => X_LAST_UPDATE_LOGIN
623: );
624: update IGS_FI_ELM_RANGE_H_ALL set
625: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
626: HIST_WHO = NEW_REFERENCES.HIST_WHO,
627: FEE_CAT = NEW_REFERENCES.FEE_CAT,
628: LOWER_RANGE = NEW_REFERENCES.LOWER_RANGE,

Line 656: cursor c1 is select rowid from IGS_FI_ELM_RANGE_H_ALL

652: X_S_CHG_METHOD_TYPE in VARCHAR2,
653: X_ORG_ID in NUMBER,
654: X_MODE in VARCHAR2 default 'R'
655: ) AS
656: cursor c1 is select rowid from IGS_FI_ELM_RANGE_H_ALL
657: where FEE_TYPE = X_FEE_TYPE
658: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
659: and RANGE_NUMBER = X_RANGE_NUMBER
660: and HIST_START_DT = X_HIST_START_DT

Line 712: delete from IGS_FI_ELM_RANGE_H_ALL

708: Before_DML(
709: p_action => 'DELETE',
710: x_rowid => X_ROWID
711: );
712: delete from IGS_FI_ELM_RANGE_H_ALL
713: where ROWID = X_ROWID;
714: if (sql%notfound) then
715: raise no_data_found;
716: end if;