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_FEE_RET_SCHD_PKG dependencies on IGS_FI_FEE_RET_SCHD

Line 1: package body IGS_FI_FEE_RET_SCHD_PKG AS

1: package body IGS_FI_FEE_RET_SCHD_PKG AS
2: /* $Header: IGSSI33B.pls 120.1 2006/05/26 10:55:26 sapanigr noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_RET_SCHD%RowType;
5: new_references IGS_FI_FEE_RET_SCHD%RowType;

Line 4: old_references IGS_FI_FEE_RET_SCHD%RowType;

1: package body IGS_FI_FEE_RET_SCHD_PKG AS
2: /* $Header: IGSSI33B.pls 120.1 2006/05/26 10:55:26 sapanigr noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_RET_SCHD%RowType;
5: new_references IGS_FI_FEE_RET_SCHD%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_RET_SCHD%RowType;

1: package body IGS_FI_FEE_RET_SCHD_PKG AS
2: /* $Header: IGSSI33B.pls 120.1 2006/05/26 10:55:26 sapanigr noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_RET_SCHD%RowType;
5: new_references IGS_FI_FEE_RET_SCHD%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_fee_cal_type IN VARCHAR2 DEFAULT NULL,

Line 39: FROM IGS_FI_FEE_RET_SCHD

35: || copying old_references value into new_references.value.
36: ----------------------------------------------------------------------------*/
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_FI_FEE_RET_SCHD
40: WHERE rowid = x_rowid;
41: BEGIN
42: l_rowid := x_rowid;
43: -- Code for setting the Old and New Reference Values.

Line 81: -- ON IGS_FI_FEE_RET_SCHD

77: END Set_Column_Values;
78: -- Trigger description :-
79: -- "OSS_TST".trg_frtns_br_iu
80: -- BEFORE INSERT OR UPDATE
81: -- ON IGS_FI_FEE_RET_SCHD
82: -- FOR EACH ROW
83: PROCEDURE BeforeRowInsertUpdate1(
84: p_inserting IN BOOLEAN DEFAULT FALSE,
85: p_updating IN BOOLEAN DEFAULT FALSE,

Line 143: -- ON IGS_FI_FEE_RET_SCHD

139: END BeforeRowInsertUpdate1;
140: -- Trigger description :-
141: -- "OSS_TST".trg_frtns_ar_u_hist
142: -- AFTER UPDATE
143: -- ON IGS_FI_FEE_RET_SCHD
144: -- FOR EACH ROW
145: PROCEDURE AfterRowUpdate3(
146: p_inserting IN BOOLEAN DEFAULT FALSE,
147: p_updating IN BOOLEAN DEFAULT FALSE,

Line 189: -- ON IGS_FI_FEE_RET_SCHD

185: END AfterRowUpdate3;
186: -- Trigger description :-
187: -- "OSS_TST".trg_frtns_as_iu
188: -- AFTER INSERT OR UPDATE
189: -- ON IGS_FI_FEE_RET_SCHD
190: PROCEDURE AfterStmtInsertUpdate4(
191: p_inserting IN BOOLEAN DEFAULT FALSE,
192: p_updating IN BOOLEAN DEFAULT FALSE,
193: p_deleting IN BOOLEAN DEFAULT FALSE

Line 349: FROM IGS_FI_FEE_RET_SCHD

345: x_dai_sequence_number IN NUMBER
346: )RETURN BOOLEAN AS
347: CURSOR cur_rowid IS
348: SELECT rowid
349: FROM IGS_FI_FEE_RET_SCHD
350: WHERE fee_cal_type = x_fee_cal_type
351: AND fee_ci_sequence_number = x_fee_ci_sequence_number
352: AND ((fee_cat = x_fee_cat) OR (fee_cat IS NULL AND x_fee_cat IS NULL))
353: AND ((fee_type = x_fee_type) OR (fee_type IS NULL AND x_fee_type IS NULL))

Line 384: FROM IGS_FI_FEE_RET_SCHD

380: )RETURN BOOLEAN
381: AS
382: CURSOR cur_rowid IS
383: SELECT rowid
384: FROM IGS_FI_FEE_RET_SCHD
385: WHERE fee_cal_type = x_fee_cal_type
386: AND fee_ci_sequence_number = x_fee_ci_sequence_number
387: AND ((fee_type = x_fee_type) OR (fee_type IS NULL AND x_fee_type IS NULL))
388: AND ((fee_cat = x_fee_cat) OR (fee_cat IS NULL AND x_fee_cat IS NULL))

Line 514: FROM IGS_FI_FEE_RET_SCHD

510: x_sequence_number IN NUMBER
511: ) RETURN BOOLEAN AS
512: CURSOR cur_rowid IS
513: SELECT rowid
514: FROM IGS_FI_FEE_RET_SCHD
515: WHERE fee_cal_type = x_fee_cal_type
516: AND fee_ci_sequence_number = x_fee_ci_sequence_number
517: AND s_relation_type = x_s_relation_type
518: AND sequence_number = x_sequence_number

Line 542: FROM IGS_FI_FEE_RET_SCHD

538: x_ci_sequence_number IN NUMBER
539: ) AS
540: CURSOR cur_rowid IS
541: SELECT rowid
542: FROM IGS_FI_FEE_RET_SCHD
543: WHERE dt_alias = x_dt_alias
544: AND dai_sequence_number = x_sequence_number
545: AND fee_cal_type = x_cal_type
546: AND fee_ci_sequence_number = x_ci_sequence_number ;

Line 567: FROM IGS_FI_FEE_RET_SCHD

563: x_fee_ci_sequence_number IN NUMBER
564: ) AS
565: CURSOR cur_rowid IS
566: SELECT rowid
567: FROM IGS_FI_FEE_RET_SCHD
568: WHERE fee_cat = x_fee_cat
569: AND fee_cal_type = x_fee_cal_type
570: AND fee_ci_sequence_number = x_fee_ci_sequence_number ;
571: lv_rowid cur_rowid%RowType;

Line 737: cursor C is select ROWID from IGS_FI_FEE_RET_SCHD

733: || (reverse chronological order - newest change first)
734: || vvutukur 24-Jul-2002 Bug#2425767.Removed references to deduction_amount(from call to
735: || before_dml and from insert statement).
736: ----------------------------------------------------------------------------*/
737: cursor C is select ROWID from IGS_FI_FEE_RET_SCHD
738: where FEE_CAL_TYPE = X_FEE_CAL_TYPE
739: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
740: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
741: and S_RELATION_TYPE = X_S_RELATION_TYPE;

Line 799: insert into IGS_FI_FEE_RET_SCHD (

795: x_last_update_date=>X_LAST_UPDATE_DATE,
796: x_last_updated_by=>X_LAST_UPDATED_BY,
797: x_last_update_login=>X_LAST_UPDATE_LOGIN
798: );
799: insert into IGS_FI_FEE_RET_SCHD (
800: FEE_CAL_TYPE,
801: FEE_CI_SEQUENCE_NUMBER,
802: S_RELATION_TYPE,
803: SEQUENCE_NUMBER,

Line 887: from IGS_FI_FEE_RET_SCHD

883: DT_ALIAS,
884: DAI_SEQUENCE_NUMBER,
885: RETENTION_PERCENTAGE,
886: RETENTION_AMOUNT
887: from IGS_FI_FEE_RET_SCHD
888: where ROWID = X_ROWID
889: for update nowait;
890: tlinfo c1%rowtype;
891: begin

Line 1009: update IGS_FI_FEE_RET_SCHD set

1005: x_last_update_date=>X_LAST_UPDATE_DATE,
1006: x_last_updated_by=>X_LAST_UPDATED_BY,
1007: x_last_update_login=>X_LAST_UPDATE_LOGIN
1008: );
1009: update IGS_FI_FEE_RET_SCHD set
1010: FEE_CAT = NEW_REFERENCES.FEE_CAT,
1011: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
1012: SCHEDULE_NUMBER = NEW_REFERENCES.SCHEDULE_NUMBER,
1013: DT_ALIAS = NEW_REFERENCES.DT_ALIAS,

Line 1059: cursor c1 is select rowid from IGS_FI_FEE_RET_SCHD

1055: || (reverse chronological order - newest change first)
1056: || vvutukur 24-Jul-2002 Bug#2425767.Removed references to deduction_amount(from calls to
1057: || insert_row and update_row).
1058: ----------------------------------------------------------------------------*/
1059: cursor c1 is select rowid from IGS_FI_FEE_RET_SCHD
1060: where FEE_CAL_TYPE = X_FEE_CAL_TYPE
1061: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1062: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
1063: and S_RELATION_TYPE = X_S_RELATION_TYPE

Line 1110: delete from IGS_FI_FEE_RET_SCHD

1106: Before_DML (
1107: p_action => 'DELETE',
1108: x_rowid => X_ROWID
1109: );
1110: delete from IGS_FI_FEE_RET_SCHD
1111: where ROWID = X_ROWID;
1112: if (sql%notfound) then
1113: raise no_data_found;
1114: end if;

Line 1116: end IGS_FI_FEE_RET_SCHD_PKG;

1112: if (sql%notfound) then
1113: raise no_data_found;
1114: end if;
1115: end DELETE_ROW;
1116: end IGS_FI_FEE_RET_SCHD_PKG;