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_F_CAT_CA_INST_PKG dependencies on IGS_FI_F_CAT_CA_INST

Line 1: package body IGS_FI_F_CAT_CA_INST_PKG as

1: package body IGS_FI_F_CAT_CA_INST_PKG as
2: /* $Header: IGSSI44B.pls 115.8 2002/11/29 03:48:12 nsidana ship $*/
3:
4: /******************************
5: Removed calls to IGS_FI_FEE_ENCMB_PKG and IGS_FI_FEE_ENCMB_H_PKG as these 2 tables are obsleted as part of bug 2126091 -sykrishn -30112001

Line 8: old_references IGS_FI_F_CAT_CA_INST%RowType;

4: /******************************
5: Removed calls to IGS_FI_FEE_ENCMB_PKG and IGS_FI_FEE_ENCMB_H_PKG as these 2 tables are obsleted as part of bug 2126091 -sykrishn -30112001
6: ***************************/
7: l_rowid VARCHAR2(25);
8: old_references IGS_FI_F_CAT_CA_INST%RowType;
9: new_references IGS_FI_F_CAT_CA_INST%RowType;
10: PROCEDURE Set_Column_Values (
11: p_action IN VARCHAR2,
12: x_rowid IN VARCHAR2,

Line 9: new_references IGS_FI_F_CAT_CA_INST%RowType;

5: Removed calls to IGS_FI_FEE_ENCMB_PKG and IGS_FI_FEE_ENCMB_H_PKG as these 2 tables are obsleted as part of bug 2126091 -sykrishn -30112001
6: ***************************/
7: l_rowid VARCHAR2(25);
8: old_references IGS_FI_F_CAT_CA_INST%RowType;
9: new_references IGS_FI_F_CAT_CA_INST%RowType;
10: PROCEDURE Set_Column_Values (
11: p_action IN VARCHAR2,
12: x_rowid IN VARCHAR2,
13: x_fee_cat IN VARCHAR2,

Line 31: FROM IGS_FI_F_CAT_CA_INST

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

Line 71: -- ON IGS_FI_F_CAT_CA_INST

67: new_references.last_update_login := x_last_update_login;
68: END Set_Column_Values;
69: -- Trigger description :-
70: -- BEFORE INSERT OR DELETE OR UPDATE
71: -- ON IGS_FI_F_CAT_CA_INST
72: -- FOR EACH ROW
73: PROCEDURE BeforeRowInsertUpdateDelete1(
74: p_inserting IN BOOLEAN,
75: p_updating IN BOOLEAN,

Line 154: -- ON IGS_FI_F_CAT_CA_INST

150: END IF;
151: END BeforeRowInsertUpdateDelete1;
152: -- Trigger description :-
153: -- AFTER UPDATE
154: -- ON IGS_FI_F_CAT_CA_INST
155: -- FOR EACH ROW
156: PROCEDURE AfterRowUpdate2(
157: p_inserting IN BOOLEAN,
158: p_updating IN BOOLEAN,

Line 402: || vvutukur 26-Aug-2002 Bug#2531390.Removed the call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_FI_F_CAT_CA_INST

398: || Known limitations, enhancements or remarks :
399: || Change History :
400: || Who When What
401: || (reverse chronological order - newest change first)
402: || vvutukur 26-Aug-2002 Bug#2531390.Removed the call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_FI_F_CAT_CA_INST
403: || and IGS_FI_F_PAY_SCHD_HT_PKG.GET_FK_IGS_FI_F_CAT_CA_INST.
404: ----------------------------------------------------------------------------*/
405: BEGIN
406: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (

Line 403: || and IGS_FI_F_PAY_SCHD_HT_PKG.GET_FK_IGS_FI_F_CAT_CA_INST.

399: || Change History :
400: || Who When What
401: || (reverse chronological order - newest change first)
402: || vvutukur 26-Aug-2002 Bug#2531390.Removed the call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_FI_F_CAT_CA_INST
403: || and IGS_FI_F_PAY_SCHD_HT_PKG.GET_FK_IGS_FI_F_CAT_CA_INST.
404: ----------------------------------------------------------------------------*/
405: BEGIN
406: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (
407: old_references.fee_cat,

Line 406: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (

402: || vvutukur 26-Aug-2002 Bug#2531390.Removed the call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_FI_F_CAT_CA_INST
403: || and IGS_FI_F_PAY_SCHD_HT_PKG.GET_FK_IGS_FI_F_CAT_CA_INST.
404: ----------------------------------------------------------------------------*/
405: BEGIN
406: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (
407: old_references.fee_cat,
408: old_references.fee_cal_type,
409: old_references.fee_ci_sequence_number
410: );

Line 413: IGS_FI_F_RET_SCHD_HT_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (

409: old_references.fee_ci_sequence_number
410: );
411: --Removed calls to IGS_FI_FEE_ENCMB_PKG and IGS_FI_FEE_ENCMB_H_PKG as these 2 tables are obsleted as part of bug 2126091 -sykrishn -30112001
412:
413: IGS_FI_F_RET_SCHD_HT_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (
414: old_references.fee_cat,
415: old_references.fee_cal_type,
416: old_references.fee_ci_sequence_number
417: );

Line 418: IGS_FI_FEE_RET_SCHD_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (

414: old_references.fee_cat,
415: old_references.fee_cal_type,
416: old_references.fee_ci_sequence_number
417: );
418: IGS_FI_FEE_RET_SCHD_PKG.GET_FK_IGS_FI_F_CAT_CA_INST (
419: old_references.fee_cat,
420: old_references.fee_cal_type,
421: old_references.fee_ci_sequence_number
422: );

Line 431: FROM IGS_FI_F_CAT_CA_INST

427: x_fee_ci_sequence_number IN NUMBER
428: ) RETURN BOOLEAN AS
429: CURSOR cur_rowid IS
430: SELECT rowid
431: FROM IGS_FI_F_CAT_CA_INST
432: WHERE fee_cat = x_fee_cat
433: AND fee_cal_type = x_fee_cal_type
434: AND fee_ci_sequence_number = x_fee_ci_sequence_number
435: FOR UPDATE NOWAIT;

Line 456: FROM IGS_FI_F_CAT_CA_INST

452: x_ci_sequence_number IN NUMBER
453: ) AS
454: CURSOR cur_rowid IS
455: SELECT rowid
456: FROM IGS_FI_F_CAT_CA_INST
457: WHERE (start_dt_alias = x_dt_alias
458: AND start_dai_sequence_number = x_sequence_number
459: AND fee_cal_type = x_cal_type
460: AND fee_ci_sequence_number = x_ci_sequence_number)

Line 484: FROM IGS_FI_F_CAT_CA_INST

480: x_sequence_number IN NUMBER
481: ) AS
482: CURSOR cur_rowid IS
483: SELECT rowid
484: FROM IGS_FI_F_CAT_CA_INST
485: WHERE fee_cal_type = x_cal_type
486: AND fee_ci_sequence_number = x_sequence_number ;
487: lv_rowid cur_rowid%RowType;
488: BEGIN

Line 505: FROM IGS_FI_F_CAT_CA_INST

501: x_fee_cat IN VARCHAR2
502: ) AS
503: CURSOR cur_rowid IS
504: SELECT rowid
505: FROM IGS_FI_F_CAT_CA_INST
506: WHERE fee_cat = x_fee_cat ;
507: lv_rowid cur_rowid%RowType;
508: BEGIN
509: Open cur_rowid;

Line 525: FROM IGS_FI_F_CAT_CA_INST

521: x_fee_structure_status IN VARCHAR2
522: ) AS
523: CURSOR cur_rowid IS
524: SELECT rowid
525: FROM IGS_FI_F_CAT_CA_INST
526: WHERE fee_cat_ci_status = x_fee_structure_status ;
527: lv_rowid cur_rowid%RowType;
528: BEGIN
529: Open cur_rowid;

Line 678: cursor C is select ROWID from IGS_FI_F_CAT_CA_INST

674: X_RETRO_DT_ALIAS in VARCHAR2,
675: X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
676: X_MODE in VARCHAR2
677: ) as
678: cursor C is select ROWID from IGS_FI_F_CAT_CA_INST
679: where FEE_CAT = X_FEE_CAT
680: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
681: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER;
682: X_LAST_UPDATE_DATE DATE;

Line 738: insert into IGS_FI_F_CAT_CA_INST (

734: x_last_update_date=>X_LAST_UPDATE_DATE,
735: x_last_updated_by=>X_LAST_UPDATED_BY,
736: x_last_update_login=>X_LAST_UPDATE_LOGIN
737: );
738: insert into IGS_FI_F_CAT_CA_INST (
739: FEE_CAT,
740: FEE_CAL_TYPE,
741: FEE_CI_SEQUENCE_NUMBER,
742: FEE_CAT_CI_STATUS,

Line 812: from IGS_FI_F_CAT_CA_INST

808: END_DT_ALIAS,
809: END_DAI_SEQUENCE_NUMBER,
810: RETRO_DT_ALIAS,
811: RETRO_DAI_SEQUENCE_NUMBER
812: from IGS_FI_F_CAT_CA_INST
813: where ROWID=X_ROWID
814: for update nowait;
815: tlinfo c1%rowtype;
816: begin

Line 917: update IGS_FI_F_CAT_CA_INST set

913: x_last_update_date=>X_LAST_UPDATE_DATE,
914: x_last_updated_by=>X_LAST_UPDATED_BY,
915: x_last_update_login=>X_LAST_UPDATE_LOGIN
916: );
917: update IGS_FI_F_CAT_CA_INST set
918: FEE_CAT_CI_STATUS = NEW_REFERENCES.FEE_CAT_CI_STATUS,
919: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
920: START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
921: END_DT_ALIAS = NEW_REFERENCES.END_DT_ALIAS,

Line 956: cursor c1 is select rowid from IGS_FI_F_CAT_CA_INST

952: X_RETRO_DT_ALIAS in VARCHAR2,
953: X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
954: X_MODE in VARCHAR2
955: ) as
956: cursor c1 is select rowid from IGS_FI_F_CAT_CA_INST
957: where FEE_CAT = X_FEE_CAT
958: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
959: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
960: ;

Line 1004: delete from IGS_FI_F_CAT_CA_INST

1000: Before_DML (
1001: p_action => 'DELETE',
1002: x_rowid => X_ROWID
1003: );
1004: delete from IGS_FI_F_CAT_CA_INST
1005: where ROWID=X_ROWID;
1006: if (sql%notfound) then
1007: raise no_data_found;
1008: end if;

Line 1014: end IGS_FI_F_CAT_CA_INST_PKG;

1010: p_action => 'DELETE',
1011: x_rowid => X_ROWID
1012: );
1013: end DELETE_ROW;
1014: end IGS_FI_F_CAT_CA_INST_PKG;