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_UNIT_FEE_TRG_PKG dependencies on IGS_FI_UNIT_FEE_TRG

Line 1: package body IGS_FI_UNIT_FEE_TRG_PKG AS

1: package body IGS_FI_UNIT_FEE_TRG_PKG AS
2: /* $Header: IGSSI64B.pls 120.6 2006/05/25 08:28:19 abshriva ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_UNIT_FEE_TRG%RowType;
5: new_references IGS_FI_UNIT_FEE_TRG%RowType;

Line 4: old_references IGS_FI_UNIT_FEE_TRG%RowType;

1: package body IGS_FI_UNIT_FEE_TRG_PKG AS
2: /* $Header: IGSSI64B.pls 120.6 2006/05/25 08:28:19 abshriva ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_UNIT_FEE_TRG%RowType;
5: new_references IGS_FI_UNIT_FEE_TRG%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_UNIT_FEE_TRG%RowType;

1: package body IGS_FI_UNIT_FEE_TRG_PKG AS
2: /* $Header: IGSSI64B.pls 120.6 2006/05/25 08:28:19 abshriva ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_UNIT_FEE_TRG%RowType;
5: new_references IGS_FI_UNIT_FEE_TRG%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_fee_cat IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_FI_UNIT_FEE_TRG

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

Line 77: -- ON IGS_FI_UNIT_FEE_TRG

73:
74:
75: -- Trigger description :-
76: -- BEFORE INSERT OR UPDATE
77: -- ON IGS_FI_UNIT_FEE_TRG
78: -- FOR EACH ROW
79: PROCEDURE BeforeRowInsertUpdate1(
80: p_inserting IN BOOLEAN DEFAULT FALSE,
81: p_updating IN BOOLEAN DEFAULT FALSE,

Line 176: -- ON IGS_FI_UNIT_FEE_TRG

172: END IF;
173: END BeforeRowInsertUpdate1;
174: -- Trigger description :-
175: -- AFTER UPDATE
176: -- ON IGS_FI_UNIT_FEE_TRG
177: -- FOR EACH ROW
178: PROCEDURE AfterRowUpdate3(
179: p_inserting IN BOOLEAN DEFAULT FALSE,
180: p_updating IN BOOLEAN DEFAULT FALSE,

Line 212: -- ON IGS_FI_UNIT_FEE_TRG

208: old_references.last_update_date);
209: END AfterRowUpdate3;
210: -- Trigger description :-
211: -- AFTER INSERT OR UPDATE
212: -- ON IGS_FI_UNIT_FEE_TRG
213: PROCEDURE AfterStmtInsertUpdate4(
214: p_inserting IN BOOLEAN DEFAULT FALSE,
215: p_updating IN BOOLEAN DEFAULT FALSE,
216: p_deleting IN BOOLEAN DEFAULT FALSE

Line 221: -- Validate for open ended IGS_FI_UNIT_FEE_TRG records.

217: ) AS
218: v_message_name varchar2(30);
219: v_message_string VARCHAR2(512);
220: BEGIN
221: -- Validate for open ended IGS_FI_UNIT_FEE_TRG records.
222: IF (p_inserting OR p_updating) THEN
223: IF new_references.logical_delete_dt IS NULL THEN
224: IF IGS_FI_VAL_UFT.finp_val_uft_open(
225: new_references.fee_cat,

Line 512: FROM IGS_FI_UNIT_FEE_TRG

508: x_sequence_number IN NUMBER
509: ) RETURN BOOLEAN AS
510: CURSOR cur_rowid IS
511: SELECT rowid
512: FROM IGS_FI_UNIT_FEE_TRG
513: WHERE fee_cat = x_fee_cat
514: AND fee_cal_type = x_fee_cal_type
515: AND fee_ci_sequence_number = x_fee_ci_sequence_number
516: AND fee_type = x_fee_type

Line 547: FROM IGS_FI_UNIT_FEE_TRG

543: x_create_dt IN DATE
544: ) RETURN BOOLEAN AS
545: CURSOR cur_rowid IS
546: SELECT rowid
547: FROM IGS_FI_UNIT_FEE_TRG
548: WHERE fee_cat = x_fee_cat
549: AND fee_cal_type = x_fee_cal_type
550: AND fee_ci_sequence_number = x_fee_ci_sequence_number
551: AND fee_type = x_fee_type

Line 578: FROM IGS_FI_UNIT_FEE_TRG

574: x_cal_type IN VARCHAR2
575: ) AS
576: CURSOR cur_rowid IS
577: SELECT rowid
578: FROM IGS_FI_UNIT_FEE_TRG
579: WHERE cal_type = x_cal_type ;
580: lv_rowid cur_rowid%RowType;
581: BEGIN
582: Open cur_rowid;

Line 599: FROM IGS_FI_UNIT_FEE_TRG

595: x_sequence_number IN NUMBER
596: ) AS
597: CURSOR cur_rowid IS
598: SELECT rowid
599: FROM IGS_FI_UNIT_FEE_TRG
600: WHERE cal_type = x_cal_type
601: AND ci_sequence_number = x_sequence_number ;
602: lv_rowid cur_rowid%RowType;
603: BEGIN

Line 625: FROM IGS_FI_UNIT_FEE_TRG

621: x_fee_trigger_group_number IN NUMBER
622: ) AS
623: CURSOR cur_rowid IS
624: SELECT rowid
625: FROM IGS_FI_UNIT_FEE_TRG
626: WHERE fee_cat = x_fee_cat
627: AND fee_cal_type = x_fee_cal_type
628: AND fee_ci_sequence_number = x_fee_ci_sequence_number
629: AND fee_type = x_fee_type

Line 649: FROM IGS_FI_UNIT_FEE_TRG

645: x_location_cd IN VARCHAR2
646: ) AS
647: CURSOR cur_rowid IS
648: SELECT rowid
649: FROM IGS_FI_UNIT_FEE_TRG
650: WHERE location_cd = x_location_cd ;
651: lv_rowid cur_rowid%RowType;
652: BEGIN
653: Open cur_rowid;

Line 669: FROM IGS_FI_UNIT_FEE_TRG

665: x_unit_cd IN VARCHAR2
666: ) AS
667: CURSOR cur_rowid IS
668: SELECT rowid
669: FROM IGS_FI_UNIT_FEE_TRG
670: WHERE unit_cd = x_unit_cd ;
671: lv_rowid cur_rowid%RowType;
672: BEGIN
673: Open cur_rowid;

Line 690: FROM IGS_FI_UNIT_FEE_TRG

686: x_version_number IN NUMBER
687: ) AS
688: CURSOR cur_rowid IS
689: SELECT rowid
690: FROM IGS_FI_UNIT_FEE_TRG
691: WHERE unit_cd = x_unit_cd
692: AND version_number = x_version_number ;
693: lv_rowid cur_rowid%RowType;
694: BEGIN

Line 830: cursor C is select ROWID from IGS_FI_UNIT_FEE_TRG

826: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
827: X_LOGICAL_DELETE_DT in DATE,
828: X_MODE in VARCHAR2 default 'R'
829: ) AS
830: cursor C is select ROWID from IGS_FI_UNIT_FEE_TRG
831: where FEE_CAT = X_FEE_CAT
832: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
833: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
834: and UNIT_CD = X_UNIT_CD

Line 882: insert into IGS_FI_UNIT_FEE_TRG (

878: x_last_update_date=>X_LAST_UPDATE_DATE,
879: x_last_updated_by=>X_LAST_UPDATED_BY,
880: x_last_update_login=>X_LAST_UPDATE_LOGIN
881: );
882: insert into IGS_FI_UNIT_FEE_TRG (
883: FEE_CAT,
884: FEE_CAL_TYPE,
885: FEE_CI_SEQUENCE_NUMBER,
886: FEE_TYPE,

Line 957: from IGS_FI_UNIT_FEE_TRG

953: UNIT_CLASS,
954: CREATE_DT,
955: FEE_TRIGGER_GROUP_NUMBER,
956: LOGICAL_DELETE_DT
957: from IGS_FI_UNIT_FEE_TRG
958: where ROWID=X_ROWID
959: for update nowait;
960: tlinfo c1%rowtype;
961: begin

Line 1066: update IGS_FI_UNIT_FEE_TRG set

1062: x_last_update_date=>X_LAST_UPDATE_DATE,
1063: x_last_updated_by=>X_LAST_UPDATED_BY,
1064: x_last_update_login=>X_LAST_UPDATE_LOGIN
1065: );
1066: update IGS_FI_UNIT_FEE_TRG set
1067: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
1068: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
1069: CI_SEQUENCE_NUMBER = NEW_REFERENCES.CI_SEQUENCE_NUMBER,
1070: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,

Line 1106: cursor c1 is select rowid from IGS_FI_UNIT_FEE_TRG

1102: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
1103: X_LOGICAL_DELETE_DT in DATE,
1104: X_MODE in VARCHAR2 default 'R'
1105: ) AS
1106: cursor c1 is select rowid from IGS_FI_UNIT_FEE_TRG
1107: where FEE_CAT = X_FEE_CAT
1108: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
1109: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
1110: and UNIT_CD = X_UNIT_CD

Line 1161: delete from IGS_FI_UNIT_FEE_TRG

1157: procedure DELETE_ROW (
1158: X_ROWID in VARCHAR2
1159: ) AS
1160: begin
1161: delete from IGS_FI_UNIT_FEE_TRG
1162: where ROWID=X_ROWID;
1163: if (sql%notfound) then
1164: raise no_data_found;
1165: end if;

Line 1167: end IGS_FI_UNIT_FEE_TRG_PKG;

1163: if (sql%notfound) then
1164: raise no_data_found;
1165: end if;
1166: end DELETE_ROW;
1167: end IGS_FI_UNIT_FEE_TRG_PKG;