APPS.IGS_PS_FEE_TRG_HIST_PKG dependencies on IGS_PS_FEE_TRG_HIST_ALL

Line 6: old_references IGS_PS_FEE_TRG_HIST_ALL%RowType;

2: /* $Header: IGSPI12B.pls 115.9 2003/02/12 09:49:00 shtatiko ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_FEE_TRG_HIST_ALL%RowType;
7: new_references IGS_PS_FEE_TRG_HIST_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_FEE_TRG_HIST_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_FEE_TRG_HIST_ALL%RowType;
7: new_references IGS_PS_FEE_TRG_HIST_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_PS_FEE_TRG_HIST_ALL

34: ) AS
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_PS_FEE_TRG_HIST_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 283: FROM IGS_PS_FEE_TRG_HIST_ALL

279: RETURN BOOLEAN AS
280:
281: CURSOR cur_rowid IS
282: SELECT rowid
283: FROM IGS_PS_FEE_TRG_HIST_ALL
284: WHERE fee_cat = x_fee_cat
285: AND fee_cal_type = x_fee_cal_type
286: AND fee_ci_sequence_number = x_fee_ci_sequence_number
287: AND fee_type = x_fee_type

Line 326: FROM IGS_PS_FEE_TRG_HIST_ALL

322: RETURN BOOLEAN AS
323:
324: CURSOR cur_rowid IS
325: SELECT rowid
326: FROM IGS_PS_FEE_TRG_HIST_ALL
327: WHERE fee_cat = new_references.fee_cat
328: AND fee_cal_type = new_references.fee_cal_type
329: AND fee_ci_sequence_number = new_references.fee_ci_sequence_number
330: AND fee_type = new_references.fee_type

Line 488: cursor C is select ROWID from IGS_PS_FEE_TRG_HIST_ALL

484: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
485: X_MODE in VARCHAR2 default 'R',
486: X_ORG_ID in number
487: ) AS
488: cursor C is select ROWID from IGS_PS_FEE_TRG_HIST_ALL
489: where FEE_CAT = X_FEE_CAT
490: and FEE_TYPE = X_FEE_TYPE
491: and COURSE_CD = X_COURSE_CD
492: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 546: insert into IGS_PS_FEE_TRG_HIST_ALL (

542: x_last_update_login => X_LAST_UPDATE_LOGIN,
543: x_org_id => igs_ge_gen_003.get_org_id
544: );
545:
546: insert into IGS_PS_FEE_TRG_HIST_ALL (
547: FEE_CAT,
548: FEE_CAL_TYPE,
549: FEE_CI_SEQUENCE_NUMBER,
550: FEE_TYPE,

Line 639: from IGS_PS_FEE_TRG_HIST_ALL

635: ATTENDANCE_TYPE,
636: CREATE_DT,
637: FEE_TRIGGER_GROUP_NUMBER
638:
639: from IGS_PS_FEE_TRG_HIST_ALL
640: where ROWID = X_ROWID
641: for update nowait;
642: tlinfo c1%rowtype;
643:

Line 761: update IGS_PS_FEE_TRG_HIST_ALL set

757: x_last_update_login => X_LAST_UPDATE_LOGIN
758:
759: );
760:
761: update IGS_PS_FEE_TRG_HIST_ALL set
762: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
763: HIST_WHO = NEW_REFERENCES.HIST_WHO,
764: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
765: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,

Line 807: cursor c1 is select rowid from IGS_PS_FEE_TRG_HIST_ALL

803: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
804: X_MODE in VARCHAR2 default 'R',
805: X_ORG_ID in NUMBER
806: ) AS
807: cursor c1 is select rowid from IGS_PS_FEE_TRG_HIST_ALL
808: where FEE_CAT = X_FEE_CAT
809: and FEE_TYPE = X_FEE_TYPE
810: and COURSE_CD = X_COURSE_CD
811: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 874: delete from IGS_PS_FEE_TRG_HIST_ALL

870: Before_DML (
871: p_action => 'DELETE',
872: x_rowid => X_ROWID
873: );
874: delete from IGS_PS_FEE_TRG_HIST_ALL
875: where ROWID = X_ROWID;
876: if (sql%notfound) then
877: raise no_data_found;
878: end if;