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.

[Home] [Help]

APPS.IGS_FI_F_CAT_FEE_LBL_PKG dependencies on IGS_FI_F_CAT_FEE_LBL_ALL

Line 4: old_references IGS_FI_F_CAT_FEE_LBL_ALL%RowType;

1: package body IGS_FI_F_CAT_FEE_LBL_PKG AS
2: /* $Header: IGSSI45B.pls 120.1 2005/07/28 07:04:52 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_F_CAT_FEE_LBL_ALL%RowType;
5: new_references IGS_FI_F_CAT_FEE_LBL_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 ,

Line 5: new_references IGS_FI_F_CAT_FEE_LBL_ALL%RowType;

1: package body IGS_FI_F_CAT_FEE_LBL_PKG AS
2: /* $Header: IGSSI45B.pls 120.1 2005/07/28 07:04:52 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_F_CAT_FEE_LBL_ALL%RowType;
5: new_references IGS_FI_F_CAT_FEE_LBL_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 ,
9: x_fee_cat IN VARCHAR2 ,

Line 42: FROM IGS_FI_F_CAT_FEE_LBL_ALL

38: || into new_references value.
39: ----------------------------------------------------------------------------*/
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_FI_F_CAT_FEE_LBL_ALL
43: WHERE rowid = x_rowid;
44: BEGIN
45: l_rowid := x_rowid;
46: -- Code for setting the Old and New Reference Values.

Line 84: -- ON IGS_FI_F_CAT_FEE_LBL_ALL

80: END Set_Column_Values;
81:
82: -- Trigger description :-
83: -- BEFORE INSERT OR DELETE OR UPDATE
84: -- ON IGS_FI_F_CAT_FEE_LBL_ALL
85: -- FOR EACH ROW
86: PROCEDURE BeforeRowInsertUpdateDelete1(
87: p_inserting IN BOOLEAN ,
88: p_updating IN BOOLEAN ,

Line 217: -- If it is, then restrict deletion of the Fee type from the IGS_FI_F_CAT_FEE_LBL_ALL table.

213: -- Bug # 2021281
214: -- added by schodava
215: -- If the system Fee trigger category is 'INSTITUTION' then,
216: -- Check whether the fee type calendar instance is present in the Fee Assessment table.
217: -- If it is, then restrict deletion of the Fee type from the IGS_FI_F_CAT_FEE_LBL_ALL table.
218: -- This is introduced to implement the foreign key IGS_FI_FEE_AS_PKG.GET_FK_IGS_FI_F_CAT_FEE_LBL
219: -- for a null fee_cat in the IGS_FI_FEE_AS table.
220:
221: END BeforeRowInsertUpdateDelete1;

Line 225: -- ON IGS_FI_F_CAT_FEE_LBL_ALL

221: END BeforeRowInsertUpdateDelete1;
222:
223: -- Trigger description :-
224: -- AFTER UPDATE
225: -- ON IGS_FI_F_CAT_FEE_LBL_ALL
226: -- FOR EACH ROW
227: PROCEDURE AfterRowUpdate3(
228: p_inserting IN BOOLEAN ,
229: p_updating IN BOOLEAN ,

Line 272: -- ON IGS_FI_F_CAT_FEE_LBL_ALL

268: -- Following procedure commented as part of bug#2403209
269:
270: -- Trigger description :-
271: -- AFTER INSERT OR UPDATE
272: -- ON IGS_FI_F_CAT_FEE_LBL_ALL
273:
274: PROCEDURE Check_Uniqueness AS
275: BEGIN
276: IF Get_UK1_For_Validation (

Line 457: FROM IGS_FI_F_CAT_FEE_LBL_ALL

453: x_fee_type IN VARCHAR2
454: ) RETURN BOOLEAN AS
455: CURSOR cur_rowid IS
456: SELECT rowid
457: FROM IGS_FI_F_CAT_FEE_LBL_ALL
458: WHERE fee_cat = x_fee_cat
459: AND fee_cal_type = x_fee_cal_type
460: AND fee_ci_sequence_number = x_fee_ci_sequence_number
461: AND fee_type = x_fee_type;

Line 484: FROM IGS_FI_F_CAT_FEE_LBL_ALL

480: x_s_chg_method_type IN VARCHAR2
481: ) RETURN BOOLEAN AS
482: CURSOR cur_rowid IS
483: SELECT rowid
484: FROM IGS_FI_F_CAT_FEE_LBL_ALL
485: WHERE fee_cat = x_fee_cat
486: AND fee_cal_type = x_fee_cal_type
487: AND fee_ci_sequence_number = x_fee_ci_sequence_number
488: AND fee_type = x_fee_type

Line 512: FROM IGS_FI_F_CAT_FEE_LBL_ALL

508: x_ci_sequence_number IN NUMBER
509: ) AS
510: CURSOR cur_rowid IS
511: SELECT rowid
512: FROM IGS_FI_F_CAT_FEE_LBL_ALL
513: WHERE start_dt_alias = x_dt_alias
514: AND start_dai_sequence_number = x_sequence_number
515: AND fee_cal_type = x_cal_type
516: AND fee_ci_sequence_number = x_ci_sequence_number ;

Line 537: FROM IGS_FI_F_CAT_FEE_LBL_ALL

533: x_fee_ci_sequence_number IN NUMBER
534: ) AS
535: CURSOR cur_rowid IS
536: SELECT rowid
537: FROM IGS_FI_F_CAT_FEE_LBL_ALL
538: WHERE fee_cat = x_fee_cat
539: AND fee_cal_type = x_fee_cal_type
540: AND fee_ci_sequence_number = x_fee_ci_sequence_number ;
541: lv_rowid cur_rowid%RowType;

Line 559: FROM IGS_FI_F_CAT_FEE_LBL_ALL

555: x_fee_structure_status IN VARCHAR2
556: ) AS
557: CURSOR cur_rowid IS
558: SELECT rowid
559: FROM IGS_FI_F_CAT_FEE_LBL_ALL
560: WHERE fee_liability_status = x_fee_structure_status ;
561: lv_rowid cur_rowid%RowType;
562: BEGIN
563: Open cur_rowid;

Line 580: FROM IGS_FI_F_CAT_FEE_LBL_ALL

576: x_sequence_number IN NUMBER
577: ) AS
578: CURSOR cur_rowid IS
579: SELECT rowid
580: FROM IGS_FI_F_CAT_FEE_LBL_ALL
581: WHERE rul_sequence_number = x_sequence_number ;
582: lv_rowid cur_rowid%RowType;
583: BEGIN
584: Open cur_rowid;

Line 600: FROM IGS_FI_F_CAT_FEE_LBL_ALL

596: x_s_chg_method_type IN VARCHAR2
597: ) AS
598: CURSOR cur_rowid IS
599: SELECT rowid
600: FROM IGS_FI_F_CAT_FEE_LBL_ALL
601: WHERE s_chg_method_type = x_s_chg_method_type ;
602: lv_rowid cur_rowid%RowType;
603: BEGIN
604: Open cur_rowid;

Line 764: cursor C is select ROWID from IGS_FI_F_CAT_FEE_LBL_ALL

760: before_dml and from insert statement.
761: sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
762: in call to before_dml as part of SWCR006 build.
763: *****************************************************************************/
764: cursor C is select ROWID from IGS_FI_F_CAT_FEE_LBL_ALL
765: where FEE_CAT = X_FEE_CAT
766: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
767: and FEE_TYPE = X_FEE_TYPE
768: and FEE_CAL_TYPE = X_FEE_CAL_TYPE;

Line 826: insert into IGS_FI_F_CAT_FEE_LBL_ALL (

822: x_last_updated_by=>X_LAST_UPDATED_BY,
823: x_last_update_login=>X_LAST_UPDATE_LOGIN,
824: x_waiver_calc_flag => X_WAIVER_CALC_FLAG
825: );
826: insert into IGS_FI_F_CAT_FEE_LBL_ALL (
827: FEE_CAT,
828: FEE_CAL_TYPE,
829: FEE_CI_SEQUENCE_NUMBER,
830: FEE_TYPE,

Line 912: from IGS_FI_F_CAT_FEE_LBL_ALL

908: START_DAI_SEQUENCE_NUMBER,
909: S_CHG_METHOD_TYPE,
910: RUL_SEQUENCE_NUMBER,
911: WAIVER_CALC_FLAG
912: from IGS_FI_F_CAT_FEE_LBL_ALL
913: where ROWID=X_ROWID
914: for update nowait;
915: tlinfo c1%rowtype;
916: begin

Line 1033: update IGS_FI_F_CAT_FEE_LBL_ALL set

1029: x_last_updated_by=>X_LAST_UPDATED_BY,
1030: x_last_update_login=>X_LAST_UPDATE_LOGIN,
1031: x_waiver_calc_flag => X_WAIVER_CALC_FLAG
1032: );
1033: update IGS_FI_F_CAT_FEE_LBL_ALL set
1034: FEE_LIABILITY_STATUS = NEW_REFERENCES.FEE_LIABILITY_STATUS,
1035: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
1036: START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
1037: S_CHG_METHOD_TYPE = NEW_REFERENCES.S_CHG_METHOD_TYPE,

Line 1083: cursor c1 is select rowid from IGS_FI_F_CAT_FEE_LBL_ALL

1079: || (reverse chronological order - newest change first)
1080: || vvutukur 19-Jul-2002 Bug#2425767.removed parameter x_payment_hierarchy_rank
1081: || and from calls to insert_row and update_row.
1082: ----------------------------------------------------------------------------*/
1083: cursor c1 is select rowid from IGS_FI_F_CAT_FEE_LBL_ALL
1084: where FEE_CAT = X_FEE_CAT
1085: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
1086: and FEE_TYPE = X_FEE_TYPE
1087: and FEE_CAL_TYPE = X_FEE_CAL_TYPE