APPS.IGS_FI_FEE_TRG_GRP_PKG dependencies on IGS_FI_FEE_TRG_GRP

Line 1: package body IGS_FI_FEE_TRG_GRP_PKG AS

1: package body IGS_FI_FEE_TRG_GRP_PKG AS
2: /* $Header: IGSSI36B.pls 115.5 2003/02/12 10:14:46 shtatiko ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_TRG_GRP%RowType;
5: new_references IGS_FI_FEE_TRG_GRP%RowType;

Line 4: old_references IGS_FI_FEE_TRG_GRP%RowType;

1: package body IGS_FI_FEE_TRG_GRP_PKG AS
2: /* $Header: IGSSI36B.pls 115.5 2003/02/12 10:14:46 shtatiko ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_TRG_GRP%RowType;
5: new_references IGS_FI_FEE_TRG_GRP%RowType;
6:
7: PROCEDURE Set_Column_Values (
8:

Line 5: new_references IGS_FI_FEE_TRG_GRP%RowType;

1: package body IGS_FI_FEE_TRG_GRP_PKG AS
2: /* $Header: IGSSI36B.pls 115.5 2003/02/12 10:14:46 shtatiko ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_TRG_GRP%RowType;
5: new_references IGS_FI_FEE_TRG_GRP%RowType;
6:
7: PROCEDURE Set_Column_Values (
8:
9: p_action IN VARCHAR2,

Line 47: FROM IGS_FI_FEE_TRG_GRP

43: CURSOR cur_old_ref_values IS
44:
45: SELECT *
46:
47: FROM IGS_FI_FEE_TRG_GRP
48:
49: WHERE rowid = x_rowid;
50:
51:

Line 134: -- ON IGS_FI_FEE_TRG_GRP

130: -- "OSS_TST".trg_ftg_br_iu
131:
132: -- BEFORE INSERT OR UPDATE
133:
134: -- ON IGS_FI_FEE_TRG_GRP
135:
136: -- FOR EACH ROW
137:
138:

Line 288: IGS_PS_FEE_TRG_PKG.GET_FK_IGS_FI_FEE_TRG_GRP (

284:
285: PROCEDURE Check_Child_Existance AS
286:
287: BEGIN
288: IGS_PS_FEE_TRG_PKG.GET_FK_IGS_FI_FEE_TRG_GRP (
289: OLD_references.fee_cat,
290: OLD_references.fee_cal_type,
291: OLD_references.fee_ci_sequence_number,
292: OLD_references.fee_type,

Line 296: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_FI_FEE_TRG_GRP (

292: OLD_references.fee_type,
293: OLD_references.fee_trigger_group_number
294: );
295:
296: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_FI_FEE_TRG_GRP (
297: OLD_references.fee_cat,
298: OLD_references.fee_cal_type,
299: OLD_references.fee_ci_sequence_number,
300: OLD_references.fee_type,

Line 304: IGS_EN_UNITSETFEETRG_PKG.GET_FK_IGS_FI_FEE_TRG_GRP (

300: OLD_references.fee_type,
301: OLD_references.fee_trigger_group_number
302: );
303:
304: IGS_EN_UNITSETFEETRG_PKG.GET_FK_IGS_FI_FEE_TRG_GRP (
305: OLD_references.fee_cat,
306: OLD_references.fee_cal_type,
307: old_references.fee_ci_sequence_number,
308: OLD_references.fee_type,

Line 325: FROM IGS_FI_FEE_TRG_GRP

321: ) RETURN BOOLEAN AS
322:
323: CURSOR cur_rowid IS
324: SELECT rowid
325: FROM IGS_FI_FEE_TRG_GRP
326: WHERE fee_cat = x_fee_cat
327: AND fee_cal_type = x_fee_cal_type
328: AND fee_ci_sequence_number = x_fee_ci_sequence_number
329: AND fee_type = x_fee_type

Line 482: cursor C is select ROWID from IGS_FI_FEE_TRG_GRP

478: X_LOGICAL_DELETE_DT in DATE,
479: X_COMMENTS in VARCHAR2,
480: X_MODE in VARCHAR2 default 'R'
481: ) AS
482: cursor C is select ROWID from IGS_FI_FEE_TRG_GRP
483: where FEE_CAT = X_FEE_CAT
484: and FEE_TRIGGER_GROUP_NUMBER = X_FEE_TRIGGER_GROUP_NUMBER
485: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
486: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER

Line 549: insert into IGS_FI_FEE_TRG_GRP (

545: );
546:
547:
548:
549: insert into IGS_FI_FEE_TRG_GRP (
550: FEE_CAT,
551: FEE_CAL_TYPE,
552: FEE_CI_SEQUENCE_NUMBER,
553: FEE_TYPE,

Line 604: from IGS_FI_FEE_TRG_GRP

600: cursor c1 is select
601: DESCRIPTION,
602: LOGICAL_DELETE_DT,
603: COMMENTS
604: from IGS_FI_FEE_TRG_GRP
605: where ROWID = X_ROWID
606: for update nowait;
607: tlinfo c1%rowtype;
608:

Line 712: update IGS_FI_FEE_TRG_GRP set

708:
709:
710:
711:
712: update IGS_FI_FEE_TRG_GRP set
713: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
714: LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
715: COMMENTS = NEW_REFERENCES.COMMENTS,
716: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 738: cursor c1 is select rowid from IGS_FI_FEE_TRG_GRP

734: X_LOGICAL_DELETE_DT in DATE,
735: X_COMMENTS in VARCHAR2,
736: X_MODE in VARCHAR2 default 'R'
737: ) AS
738: cursor c1 is select rowid from IGS_FI_FEE_TRG_GRP
739: where FEE_CAT = X_FEE_CAT
740: and FEE_TRIGGER_GROUP_NUMBER = X_FEE_TRIGGER_GROUP_NUMBER
741: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
742: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER

Line 785: delete from IGS_FI_FEE_TRG_GRP

781: Before_DML (
782: p_action => 'DELETE',
783: x_rowid => X_ROWID
784: );
785: delete from IGS_FI_FEE_TRG_GRP
786: where ROWID = X_ROWID;
787: if (sql%notfound) then
788: raise no_data_found;
789: end if;

Line 792: end IGS_FI_FEE_TRG_GRP_PKG;

788: raise no_data_found;
789: end if;
790: end DELETE_ROW;
791:
792: end IGS_FI_FEE_TRG_GRP_PKG;