APPS.IGS_FI_FEE_AS_RT_HT_PKG dependencies on IGS_FI_FEE_AS_RT_HT_ALL

Line 4: old_references IGS_FI_FEE_AS_RT_HT_ALL%RowType;

1: package body IGS_FI_FEE_AS_RT_HT_PKG AS
2: /* $Header: IGSSI22B.pls 115.7 2003/02/11 06:49:37 pathipat ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_AS_RT_HT_ALL%RowType;
5: new_references IGS_FI_FEE_AS_RT_HT_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_FEE_AS_RT_HT_ALL%RowType;

1: package body IGS_FI_FEE_AS_RT_HT_PKG AS
2: /* $Header: IGSSI22B.pls 115.7 2003/02/11 06:49:37 pathipat ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_AS_RT_HT_ALL%RowType;
5: new_references IGS_FI_FEE_AS_RT_HT_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_person_id IN NUMBER DEFAULT NULL,

Line 31: FROM IGS_FI_FEE_AS_RT_HT_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_FEE_AS_RT_HT_ALL
32: WHERE rowid = x_rowid;
33: BEGIN
34: l_rowid := x_rowid;
35: -- Code for setting the Old and New Reference Values.

Line 194: FROM IGS_FI_FEE_AS_RT_HT_ALL

190: ) RETURN BOOLEAN
191: AS
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM IGS_FI_FEE_AS_RT_HT_ALL
195: WHERE person_id = x_person_id
196: AND course_cd = x_course_cd
197: AND fee_type = x_fee_type
198: AND start_dt = x_start_dt

Line 220: FROM IGS_FI_FEE_AS_RT_HT_ALL

216: x_person_id IN NUMBER
217: ) AS
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM IGS_FI_FEE_AS_RT_HT_ALL
221: WHERE person_id = x_person_id ;
222: lv_rowid cur_rowid%RowType;
223: BEGIN
224: Open cur_rowid;

Line 334: cursor C is select ROWID from IGS_FI_FEE_AS_RT_HT_ALL

330: X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
331: X_ORG_ID in NUMBER,
332: X_MODE in VARCHAR2 default 'R'
333: ) AS
334: cursor C is select ROWID from IGS_FI_FEE_AS_RT_HT_ALL
335: where PERSON_ID = X_PERSON_ID
336: and COURSE_CD = X_COURSE_CD
337: and FEE_TYPE = X_FEE_TYPE
338: and START_DT = X_START_DT

Line 385: insert into IGS_FI_FEE_AS_RT_HT_ALL (

381: x_last_update_date=>X_LAST_UPDATE_DATE,
382: x_last_updated_by=>X_LAST_UPDATED_BY,
383: x_last_update_login=>X_LAST_UPDATE_LOGIN
384: );
385: insert into IGS_FI_FEE_AS_RT_HT_ALL (
386: PERSON_ID,
387: COURSE_CD,
388: FEE_TYPE,
389: START_DT,

Line 459: from IGS_FI_FEE_AS_RT_HT_ALL

455: ATTENDANCE_TYPE,
456: ATTENDANCE_MODE,
457: CHG_RATE,
458: LOWER_NRML_RATE_OVRD_IND
459: from IGS_FI_FEE_AS_RT_HT_ALL
460: where ROWID = X_ROWID
461: for update nowait;
462: tlinfo c1%rowtype;
463: begin

Line 564: update IGS_FI_FEE_AS_RT_HT_ALL set

560: x_last_update_date=>X_LAST_UPDATE_DATE,
561: x_last_updated_by=>X_LAST_UPDATED_BY,
562: x_last_update_login=>X_LAST_UPDATE_LOGIN
563: );
564: update IGS_FI_FEE_AS_RT_HT_ALL set
565: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
566: HIST_WHO = NEW_REFERENCES.HIST_WHO,
567: END_DT = NEW_REFERENCES.END_DT,
568: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,

Line 599: cursor c1 is select rowid from IGS_FI_FEE_AS_RT_HT_ALL

595: X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
596: X_ORG_ID in NUMBER,
597: X_MODE in VARCHAR2 default 'R'
598: ) AS
599: cursor c1 is select rowid from IGS_FI_FEE_AS_RT_HT_ALL
600: where PERSON_ID = X_PERSON_ID
601: and COURSE_CD = X_COURSE_CD
602: and FEE_TYPE = X_FEE_TYPE
603: and START_DT = X_START_DT

Line 652: delete from IGS_FI_FEE_AS_RT_HT_ALL

648: procedure DELETE_ROW (
649: X_ROWID in VARCHAR2
650: ) AS
651: begin
652: delete from IGS_FI_FEE_AS_RT_HT_ALL
653: where ROWID = X_ROWID;
654: if (sql%notfound) then
655: raise no_data_found;
656: end if;