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_RATE_PKG dependencies on IGS_FI_FEE_AS_RATE

Line 1: PACKAGE BODY igs_fi_fee_as_rate_pkg AS

1: PACKAGE BODY igs_fi_fee_as_rate_pkg AS
2: /* $Header: IGSSI68B.pls 120.4 2006/05/26 10:57:37 sapanigr ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_RATE%RowType;

Line 5: old_references IGS_FI_FEE_AS_RATE%RowType;

1: PACKAGE BODY igs_fi_fee_as_rate_pkg AS
2: /* $Header: IGSSI68B.pls 120.4 2006/05/26 10:57:37 sapanigr ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_RATE%RowType;
6: new_references IGS_FI_FEE_AS_RATE%RowType;
7: -- Forward declaring the private procedure to ensure compiling of the package
8: PROCEDURE beforerowupdate;
9:

Line 6: new_references IGS_FI_FEE_AS_RATE%RowType;

2: /* $Header: IGSSI68B.pls 120.4 2006/05/26 10:57:37 sapanigr ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FEE_AS_RATE%RowType;
6: new_references IGS_FI_FEE_AS_RATE%RowType;
7: -- Forward declaring the private procedure to ensure compiling of the package
8: PROCEDURE beforerowupdate;
9:
10: PROCEDURE Set_Column_Values (

Line 63: FROM IGS_FI_FEE_AS_RATE

59: || Added 2 new columns unit_set_cd and us_version_number
60: --------------------------------------------------------------------*/
61: CURSOR cur_old_ref_values IS
62: SELECT *
63: FROM IGS_FI_FEE_AS_RATE
64: WHERE rowid = x_rowid;
65:
66: BEGIN
67: l_rowid := x_rowid;

Line 127: -- before insert or delete or update on IGS_FI_FEE_AS_RATE for each row

123: END set_column_values;
124:
125:
126: -- Trigger description
127: -- before insert or delete or update on IGS_FI_FEE_AS_RATE for each row
128: PROCEDURE BeforeRowInsertUpdateDelete1(
129: p_inserting IN BOOLEAN ,
130: p_updating IN BOOLEAN ,
131: p_deleting IN BOOLEAN

Line 219: -- AFTER UPDATE ON IGS_FI_FEE_AS_RATE FOR EACH ROW

215: END BeforeRowInsertUpdateDelete1;
216:
217:
218: -- Trigger description :-
219: -- AFTER UPDATE ON IGS_FI_FEE_AS_RATE FOR EACH ROW
220: PROCEDURE AfterRowUpdate3(
221: p_inserting IN BOOLEAN ,
222: p_updating IN BOOLEAN ,
223: p_deleting IN BOOLEAN

Line 298: -- AFTER INSERT OR UPDATE ON IGS_FI_FEE_AS_RATE

294: END AfterRowUpdate3;
295:
296:
297: -- Trigger description :-
298: -- AFTER INSERT OR UPDATE ON IGS_FI_FEE_AS_RATE
299: PROCEDURE AfterStmtInsertUpdate4(
300: p_inserting IN BOOLEAN ,
301: p_updating IN BOOLEAN ,
302: p_deleting IN BOOLEAN

Line 651: igs_fi_elm_range_rt_pkg.get_ufk_igs_fi_fee_as_rate (

647: || (reverse chronological order - newest change first)
648: || svuppala 23-JUN-2005 Bug 3392088 Modifications as part of CPF build
649: --------------------------------------------------------------------*/
650: BEGIN
651: igs_fi_elm_range_rt_pkg.get_ufk_igs_fi_fee_as_rate (
652: new_references.fee_type,
653: new_references.fee_cal_type,
654: new_references.fee_ci_sequence_number,
655: new_references.s_relation_type,

Line 661: igs_fi_sub_er_rt_pkg.get_fk_igs_fi_fee_as_rate (

657: new_references.fee_cat
658: );
659:
660: -- checking child
661: igs_fi_sub_er_rt_pkg.get_fk_igs_fi_fee_as_rate (
662: new_references.far_id
663: );
664: END Check_Child_Existance;
665:

Line 692: igs_fi_elm_range_rt_pkg.get_ufk_igs_fi_fee_as_rate(

688: (old_references.rate_number = Null) AND
689: (old_references.fee_cat = Null))) THEN
690: NULL;
691: ELSE
692: igs_fi_elm_range_rt_pkg.get_ufk_igs_fi_fee_as_rate(
693: old_references.fee_type,
694: old_references.fee_cal_type,
695: old_references.fee_ci_sequence_number,
696: old_references.s_relation_type,

Line 913: FROM IGS_FI_FEE_AS_RATE

909: || (reverse chronological order - newest change first)
910: --------------------------------------------------------------------*/
911: CURSOR cur_rowid IS
912: SELECT rowid
913: FROM IGS_FI_FEE_AS_RATE
914: WHERE far_id = x_far_id
915: FOR UPDATE NOWAIT;
916:
917: lv_rowid cur_rowid%RowType;

Line 950: FROM IGS_FI_FEE_AS_RATE

946: || (reverse chronological order - newest change first)
947: --------------------------------------------------------------------*/
948: CURSOR cur_rowid IS
949: SELECT rowid
950: FROM IGS_FI_FEE_AS_RATE
951: WHERE fee_type = x_fee_type
952: AND fee_cal_type = x_fee_cal_type
953: AND fee_ci_sequence_number = x_fee_ci_sequence_number
954: AND rate_number = x_rate_number

Line 991: FROM IGS_FI_FEE_AS_RATE

987: || (reverse chronological order - newest change first)
988: --------------------------------------------------------------------*/
989: CURSOR cur_rowid IS
990: SELECT rowid
991: FROM IGS_FI_FEE_AS_RATE
992: WHERE fee_type = x_fee_type
993: AND fee_cal_type = x_fee_cal_type
994: AND fee_ci_sequence_number = x_fee_ci_sequence_number
995: AND s_relation_type = x_s_relation_type

Line 1029: FROM igs_fi_fee_as_rate

1025: ------------------------------------------------------------
1026: */
1027: CURSOR cur_rowid IS
1028: SELECT rowid
1029: FROM igs_fi_fee_as_rate
1030: WHERE (unit_mode = x_unit_mode);
1031:
1032: lv_rowid cur_rowid%RowType;
1033:

Line 1063: FROM IGS_FI_FEE_AS_RATE

1059: || (reverse chronological order - newest change first)
1060: --------------------------------------------------------------------*/
1061: CURSOR cur_rowid IS
1062: SELECT rowid
1063: FROM IGS_FI_FEE_AS_RATE
1064: WHERE attendance_mode = x_attendance_mode ;
1065: lv_rowid cur_rowid%RowType;
1066: BEGIN
1067: Open cur_rowid;

Line 1094: FROM IGS_FI_FEE_AS_RATE

1090: || (reverse chronological order - newest change first)
1091: --------------------------------------------------------------------*/
1092: CURSOR cur_rowid IS
1093: SELECT rowid
1094: FROM IGS_FI_FEE_AS_RATE
1095: WHERE attendance_type = x_attendance_type ;
1096: lv_rowid cur_rowid%RowType;
1097: BEGIN
1098: Open cur_rowid;

Line 1125: FROM IGS_FI_FEE_AS_RATE

1121: || (reverse chronological order - newest change first)
1122: --------------------------------------------------------------------*/
1123: CURSOR cur_rowid IS
1124: SELECT rowid
1125: FROM IGS_FI_FEE_AS_RATE
1126: WHERE govt_hecs_cntrbtn_band = x_govt_hecs_cntrbtn_band ;
1127: lv_rowid cur_rowid%RowType;
1128: BEGIN
1129: Open cur_rowid;

Line 1156: FROM IGS_FI_FEE_AS_RATE

1152: || (reverse chronological order - newest change first)
1153: --------------------------------------------------------------------*/
1154: CURSOR cur_rowid IS
1155: SELECT rowid
1156: FROM IGS_FI_FEE_AS_RATE
1157: WHERE govt_hecs_payment_option = x_govt_hecs_payment_option ;
1158: lv_rowid cur_rowid%RowType;
1159: BEGIN
1160: Open cur_rowid;

Line 1187: FROM IGS_FI_FEE_AS_RATE

1183: || (reverse chronological order - newest change first)
1184: --------------------------------------------------------------------*/
1185: CURSOR cur_rowid IS
1186: SELECT rowid
1187: FROM IGS_FI_FEE_AS_RATE
1188: WHERE location_cd = x_location_cd ;
1189: lv_rowid cur_rowid%RowType;
1190: BEGIN
1191: Open cur_rowid;

Line 1219: FROM IGS_FI_FEE_AS_RATE

1215: || (reverse chronological order - newest change first)
1216: --------------------------------------------------------------------*/
1217: CURSOR cur_rowid IS
1218: SELECT rowid
1219: FROM IGS_FI_FEE_AS_RATE
1220: WHERE course_cd = x_course_cd
1221: AND version_number = x_version_number;
1222: lv_rowid cur_rowid%RowType;
1223: BEGIN

Line 1249: -- Modified cur_rowid to fetch records from igs_fi_fee_as_rate instead of fetching from

1245: || Change History :
1246: || Who When What
1247: || (reverse chronological order - newest change first)
1248: --------------------------------------------------------------------*/
1249: -- Modified cur_rowid to fetch records from igs_fi_fee_as_rate instead of fetching from
1250: -- IGS_PR_CLASS_STD. This has been done as per Bug# 2637262.
1251: CURSOR cur_rowid IS
1252: SELECT rowid
1253: FROM IGS_FI_FEE_AS_RATE

Line 1253: FROM IGS_FI_FEE_AS_RATE

1249: -- Modified cur_rowid to fetch records from igs_fi_fee_as_rate instead of fetching from
1250: -- IGS_PR_CLASS_STD. This has been done as per Bug# 2637262.
1251: CURSOR cur_rowid IS
1252: SELECT rowid
1253: FROM IGS_FI_FEE_AS_RATE
1254: WHERE class_standing = x_class_standing;
1255: lv_rowid cur_rowid%RowType;
1256: BEGIN
1257: Open cur_rowid;

Line 1480: CURSOR C (cp_range_id IN NUMBER) is select ROWID from IGS_FI_FEE_AS_RATE

1476: || Unit Version and Unit Level
1477: || pathipat 10-Sep-2003 Enh 3108052 - Add Unit Sets to Rate Table
1478: || Added 2 new columns unit_set_cd and us_version_number
1479: --------------------------------------------------------------------*/
1480: CURSOR C (cp_range_id IN NUMBER) is select ROWID from IGS_FI_FEE_AS_RATE
1481: where far_id = cp_range_id;
1482:
1483: X_LAST_UPDATE_DATE DATE;
1484: X_LAST_UPDATED_BY NUMBER;

Line 1522: SELECT igs_fi_fee_as_rate_far_id_s.nextval

1518: igs_ge_msg_stack.add;
1519: app_exception.raise_exception;
1520: END IF;
1521:
1522: SELECT igs_fi_fee_as_rate_far_id_s.nextval
1523: INTO x_far_id
1524: FROM dual;
1525:
1526: Before_DML(

Line 1564: INSERT INTO igs_fi_fee_as_rate (

1560: x_unit_class => x_unit_class ,
1561: x_unit_mode => x_unit_mode
1562: );
1563:
1564: INSERT INTO igs_fi_fee_as_rate (
1565: far_id,
1566: fee_type,
1567: fee_cal_type,
1568: fee_ci_sequence_number,

Line 1730: FROM igs_fi_fee_as_rate

1726: unit_level ,
1727: unit_type_id ,
1728: unit_class ,
1729: unit_mode
1730: FROM igs_fi_fee_as_rate
1731: WHERE rowid = x_rowid
1732: FOR UPDATE NOWAIT;
1733:
1734: tlinfo c1%ROWTYPE;

Line 1912: UPDATE igs_fi_fee_as_rate

1908: x_unit_class => x_unit_class ,
1909: x_unit_mode => x_unit_mode
1910: );
1911:
1912: UPDATE igs_fi_fee_as_rate
1913: SET
1914: far_id = far_id,
1915: fee_cal_type = new_references.fee_cal_type,
1916: fee_ci_sequence_number = new_references.fee_ci_sequence_number,

Line 2009: FROM igs_fi_fee_as_rate

2005: || Added 2 new columns unit_set_cd and us_version_number
2006: --------------------------------------------------------------------*/
2007: CURSOR c1 IS
2008: SELECT rowid
2009: FROM igs_fi_fee_as_rate
2010: WHERE far_id = x_far_id ;
2011: BEGIN
2012: OPEN c1;
2013: FETCH c1 INTO x_rowid;

Line 2103: DELETE FROM igs_fi_fee_as_rate

2099: BEGIN
2100: Before_DML( p_action =>'DELETE',
2101: x_rowid => X_ROWID
2102: );
2103: DELETE FROM igs_fi_fee_as_rate
2104: WHERE rowid = x_rowid;
2105: IF (SQL%NOTFOUND) THEN
2106: RAISE NO_DATA_FOUND;
2107: END IF;

Line 2145: FROM igs_fi_fee_as_rate

2141: || (reverse chronological order - newest change first)
2142: --------------------------------------------------------------------*/
2143: CURSOR cur_rowid IS
2144: SELECT rowid
2145: FROM igs_fi_fee_as_rate
2146: WHERE unit_set_cd = x_unit_set_cd
2147: AND us_version_number = x_us_version_number;
2148:
2149: lv_rowid cur_rowid%ROWTYPE;

Line 2165: END igs_fi_fee_as_rate_pkg;

2161: END IF;
2162: CLOSE cur_rowid;
2163: END get_fk_igs_en_unit_set_all;
2164:
2165: END igs_fi_fee_as_rate_pkg;