APPS.IGS_FI_UNIT_FEE_TR_H_PKG dependencies on IGS_FI_UNIT_FEE_TR_H_ALL

Line 4: old_references IGS_FI_UNIT_FEE_TR_H_ALL%RowType;

1: package body IGS_FI_UNIT_FEE_TR_H_PKG AS
2: /* $Header: IGSSI65B.pls 115.8 2003/02/12 10:19:15 shtatiko ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_UNIT_FEE_TR_H_ALL%RowType;
5: new_references IGS_FI_UNIT_FEE_TR_H_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_UNIT_FEE_TR_H_ALL%RowType;

1: package body IGS_FI_UNIT_FEE_TR_H_PKG AS
2: /* $Header: IGSSI65B.pls 115.8 2003/02/12 10:19:15 shtatiko ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_UNIT_FEE_TR_H_ALL%RowType;
5: new_references IGS_FI_UNIT_FEE_TR_H_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_location_cd IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_FI_UNIT_FEE_TR_H_ALL

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

Line 244: FROM IGS_FI_UNIT_FEE_TR_H_ALL

240: x_hist_start_dt IN DATE
241: ) RETURN BOOLEAN AS
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM IGS_FI_UNIT_FEE_TR_H_ALL
245: WHERE fee_cat = x_fee_cat
246: AND fee_cal_type = x_fee_cal_type
247: AND fee_ci_sequence_number = x_fee_ci_sequence_number
248: AND fee_type = x_fee_type

Line 281: FROM IGS_FI_UNIT_FEE_TR_H_ALL

277: x_hist_start_dt IN DATE
278: ) RETURN BOOLEAN AS
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM IGS_FI_UNIT_FEE_TR_H_ALL
282: WHERE fee_cat = x_fee_cat
283: AND fee_cal_type = x_fee_cal_type
284: AND fee_ci_sequence_number = x_fee_ci_sequence_number
285: AND fee_type = x_fee_type

Line 427: cursor C is select ROWID from IGS_FI_UNIT_FEE_TR_H_ALL

423: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
424: X_ORG_ID in NUMBER,
425: X_MODE in VARCHAR2 default 'R'
426: ) AS
427: cursor C is select ROWID from IGS_FI_UNIT_FEE_TR_H_ALL
428: where FEE_CAT = X_FEE_CAT
429: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
430: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
431: and FEE_TYPE = X_FEE_TYPE

Line 483: insert into IGS_FI_UNIT_FEE_TR_H_ALL (

479: x_last_update_date=>X_LAST_UPDATE_DATE,
480: x_last_updated_by=>X_LAST_UPDATED_BY,
481: x_last_update_login=>X_LAST_UPDATE_LOGIN
482: );
483: insert into IGS_FI_UNIT_FEE_TR_H_ALL (
484: FEE_CAT,
485: FEE_CAL_TYPE,
486: FEE_CI_SEQUENCE_NUMBER,
487: FEE_TYPE,

Line 567: from IGS_FI_UNIT_FEE_TR_H_ALL

563: LOCATION_CD,
564: UNIT_CLASS,
565: CREATE_DT,
566: FEE_TRIGGER_GROUP_NUMBER
567: from IGS_FI_UNIT_FEE_TR_H_ALL
568: where ROWID=X_ROWID
569: for update nowait;
570: tlinfo c1%rowtype;
571: begin

Line 681: update IGS_FI_UNIT_FEE_TR_H_ALL set

677: x_last_update_date=>X_LAST_UPDATE_DATE,
678: x_last_updated_by=>X_LAST_UPDATED_BY,
679: x_last_update_login=>X_LAST_UPDATE_LOGIN
680: );
681: update IGS_FI_UNIT_FEE_TR_H_ALL set
682: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
683: HIST_WHO = NEW_REFERENCES.HIST_WHO,
684: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
685: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,

Line 721: cursor c1 is select rowid from IGS_FI_UNIT_FEE_TR_H_ALL

717: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
718: X_ORG_ID in NUMBER,
719: X_MODE in VARCHAR2 default 'R'
720: ) AS
721: cursor c1 is select rowid from IGS_FI_UNIT_FEE_TR_H_ALL
722: where FEE_CAT = X_FEE_CAT
723: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
724: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
725: and FEE_TYPE = X_FEE_TYPE

Line 782: delete from IGS_FI_UNIT_FEE_TR_H_ALL

778: procedure DELETE_ROW (
779: X_ROWID in VARCHAR2
780: ) AS
781: begin
782: delete from IGS_FI_UNIT_FEE_TR_H_ALL
783: where ROWID=X_ROWID;
784: if (sql%notfound) then
785: raise no_data_found;
786: end if;