eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_FEE_AS_RT_PKG dependencies on IGS_FI_FEE_AS_RT

Line 1: package body IGS_FI_FEE_AS_RT_PKG as

1: package body IGS_FI_FEE_AS_RT_PKG as
2: /* $Header: IGSSI20B.pls 120.2 2006/05/26 13:42:06 skharida ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_RT%RowType;

Line 5: old_references IGS_FI_FEE_AS_RT%RowType;

1: package body IGS_FI_FEE_AS_RT_PKG as
2: /* $Header: IGSSI20B.pls 120.2 2006/05/26 13:42:06 skharida ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_RT%RowType;
6: new_references IGS_FI_FEE_AS_RT%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_FI_FEE_AS_RT%RowType;

2: /* $Header: IGSSI20B.pls 120.2 2006/05/26 13:42:06 skharida ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_RT%RowType;
6: new_references IGS_FI_FEE_AS_RT%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 28: FROM IGS_FI_FEE_AS_RT

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

Line 69: -- ON IGS_FI_FEE_AS_RT

65: END Set_Column_Values;
66: -- Trigger description :-
67: -- "OSS_TST".trg_cfar_br_iu
68: -- BEFORE INSERT OR UPDATE
69: -- ON IGS_FI_FEE_AS_RT
70: -- FOR EACH ROW
71: PROCEDURE BeforeRowInsertUpdate1(
72: p_inserting IN BOOLEAN DEFAULT FALSE,
73: p_updating IN BOOLEAN DEFAULT FALSE,

Line 146: -- ON IGS_FI_FEE_AS_RT

142: END BeforeRowInsertUpdate1;
143: -- Trigger description :-
144: -- "OSS_TST".trg_cfar_ar_u_hist
145: -- AFTER UPDATE
146: -- ON IGS_FI_FEE_AS_RT
147: -- FOR EACH ROW
148: PROCEDURE AfterRowUpdate3(
149: p_inserting IN BOOLEAN DEFAULT FALSE,
150: p_updating IN BOOLEAN DEFAULT FALSE,

Line 179: -- ON IGS_FI_FEE_AS_RT

175: END AfterRowUpdate3;
176: -- Trigger description :-
177: -- "OSS_TST".trg_cfar_as_iu
178: -- AFTER INSERT OR UPDATE
179: -- ON IGS_FI_FEE_AS_RT
180: PROCEDURE AfterStmtInsertUpdate4(
181: p_inserting IN BOOLEAN DEFAULT FALSE,
182: p_updating IN BOOLEAN DEFAULT FALSE,
183: p_deleting IN BOOLEAN DEFAULT FALSE

Line 390: FROM IGS_FI_FEE_AS_RT

386: ) Return Boolean
387: AS
388: CURSOR cur_rowid IS
389: SELECT rowid
390: FROM IGS_FI_FEE_AS_RT
391: WHERE person_id = x_person_id
392: AND course_cd = x_course_cd
393: AND fee_type = x_fee_type
394: AND start_dt = x_start_dt

Line 413: FROM IGS_FI_FEE_AS_RT

409: x_attendance_mode IN VARCHAR2
410: ) AS
411: CURSOR cur_rowid IS
412: SELECT rowid
413: FROM IGS_FI_FEE_AS_RT
414: WHERE attendance_mode = x_attendance_mode ;
415: lv_rowid cur_rowid%RowType;
416: BEGIN
417: Open cur_rowid;

Line 433: FROM IGS_FI_FEE_AS_RT

429: x_attendance_type IN VARCHAR2
430: ) AS
431: CURSOR cur_rowid IS
432: SELECT rowid
433: FROM IGS_FI_FEE_AS_RT
434: WHERE attendance_type = x_attendance_type ;
435: lv_rowid cur_rowid%RowType;
436: BEGIN
437: Open cur_rowid;

Line 454: FROM IGS_FI_FEE_AS_RT

450: x_location_cd IN VARCHAR2
451: ) AS
452: CURSOR cur_rowid IS
453: SELECT rowid
454: FROM IGS_FI_FEE_AS_RT
455: WHERE location_cd = x_location_cd ;
456: lv_rowid cur_rowid%RowType;
457: BEGIN
458: Open cur_rowid;

Line 475: FROM IGS_FI_FEE_AS_RT

471: x_course_cd IN VARCHAR2
472: ) AS
473: CURSOR cur_rowid IS
474: SELECT rowid
475: FROM IGS_FI_FEE_AS_RT
476: WHERE person_id = x_person_id
477: AND course_cd = x_course_cd ;
478: lv_rowid cur_rowid%RowType;
479: BEGIN

Line 603: cursor C is select ROWID from IGS_FI_FEE_AS_RT

599: X_CHG_RATE in NUMBER,
600: X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
601: X_MODE in VARCHAR2 default 'R'
602: ) as
603: cursor C is select ROWID from IGS_FI_FEE_AS_RT
604: where PERSON_ID = X_PERSON_ID
605: and COURSE_CD = X_COURSE_CD
606: and FEE_TYPE = X_FEE_TYPE
607: and START_DT = X_START_DT;

Line 667: insert into IGS_FI_FEE_AS_RT (

663: );
664: IF (x_mode = 'S') THEN
665: igs_sc_gen_001.set_ctx('R');
666: END IF;
667: insert into IGS_FI_FEE_AS_RT (
668: PERSON_ID,
669: COURSE_CD,
670: FEE_TYPE,
671: START_DT,

Line 757: from IGS_FI_FEE_AS_RT

753: ATTENDANCE_TYPE,
754: ATTENDANCE_MODE,
755: CHG_RATE,
756: LOWER_NRML_RATE_OVRD_IND
757: from IGS_FI_FEE_AS_RT
758: where ROWID = X_ROWID
759: for update nowait;
760: tlinfo c1%rowtype;
761: begin

Line 868: update IGS_FI_FEE_AS_RT set

864: end if;
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.set_ctx('R');
867: END IF;
868: update IGS_FI_FEE_AS_RT set
869: END_DT = NEW_REFERENCES.END_DT,
870: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
871: ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
872: ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,

Line 925: cursor c1 is select rowid from IGS_FI_FEE_AS_RT

921: X_CHG_RATE in NUMBER,
922: X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
923: X_MODE in VARCHAR2 default 'R'
924: ) as
925: cursor c1 is select rowid from IGS_FI_FEE_AS_RT
926: where PERSON_ID = X_PERSON_ID
927: and COURSE_CD = X_COURSE_CD
928: and FEE_TYPE = X_FEE_TYPE
929: and START_DT = X_START_DT

Line 978: delete from IGS_FI_FEE_AS_RT

974: );
975: IF (x_mode = 'S') THEN
976: igs_sc_gen_001.set_ctx('R');
977: END IF;
978: delete from IGS_FI_FEE_AS_RT
979: where ROWID = X_ROWID;
980: if (sql%notfound) then
981: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
982: igs_ge_msg_stack.add;

Line 995: END igs_fi_fee_as_rt_pkg;

991: p_action => 'DELETE',
992: x_rowid => X_ROWID
993: );
994: END delete_row;
995: END igs_fi_fee_as_rt_pkg;