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

Line 18: -- Validate IGS_FI_UNIT_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_UNIT or COMPOSITE

14: p_message_name OUT NOCOPY VARCHAR2)
15: RETURN BOOLEAN AS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- finp_val_uft_ins
18: -- Validate IGS_FI_UNIT_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_UNIT or COMPOSITE
19: -- otherwise IGS_PS_UNIT fee triggers cannot be defined.
20: DECLARE
21: CURSOR c_ft(
22: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 68: -- Validate IGS_FI_UNIT_FEE_TRG can belong to a IGS_FI_FEE_TRG_GRP

64: p_message_name OUT NOCOPY VARCHAR2)
65: RETURN BOOLEAN AS
66: gv_other_detail VARCHAR2(255);
67: BEGIN -- finp_val_uft_ftg
68: -- Validate IGS_FI_UNIT_FEE_TRG can belong to a IGS_FI_FEE_TRG_GRP
69: DECLARE
70: CURSOR c_ft(
71: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
72: SELECT s_fee_trigger_cat

Line 92: p_message_name:= 'IGS_FI_UNIT_FEE_TRG_COMPOSITE';

88: RETURN TRUE;
89: END IF;
90: CLOSE c_ft;
91: IF v_ft_rec.s_fee_trigger_cat <> cst_composite THEN
92: p_message_name:= 'IGS_FI_UNIT_FEE_TRG_COMPOSITE';
93: RETURN FALSE;
94: END IF;
95: RETURN TRUE;
96: END;

Line 99: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.

95: RETURN TRUE;
96: END;
97: END finp_val_uft_ftg;
98: --
99: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.
100: FUNCTION finp_val_uft_open(
101: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
102: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
103: p_fee_ci_sequence_number IN NUMBER ,

Line 101: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,

97: END finp_val_uft_ftg;
98: --
99: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.
100: FUNCTION finp_val_uft_open(
101: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
102: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
103: p_fee_ci_sequence_number IN NUMBER ,
104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,

Line 102: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,

98: --
99: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.
100: FUNCTION finp_val_uft_open(
101: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
102: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
103: p_fee_ci_sequence_number IN NUMBER ,
104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
106: p_sequence_number IN NUMBER ,

Line 104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,

100: FUNCTION finp_val_uft_open(
101: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
102: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
103: p_fee_ci_sequence_number IN NUMBER ,
104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
106: p_sequence_number IN NUMBER ,
107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,

Line 105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,

101: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
102: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
103: p_fee_ci_sequence_number IN NUMBER ,
104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
106: p_sequence_number IN NUMBER ,
107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,
109: p_ci_sequence_number IN NUMBER ,

Line 107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,

103: p_fee_ci_sequence_number IN NUMBER ,
104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
106: p_sequence_number IN NUMBER ,
107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,
109: p_ci_sequence_number IN NUMBER ,
110: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
111: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

Line 108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,

104: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
105: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
106: p_sequence_number IN NUMBER ,
107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,
109: p_ci_sequence_number IN NUMBER ,
110: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
111: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
112: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

Line 110: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,

106: p_sequence_number IN NUMBER ,
107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,
109: p_ci_sequence_number IN NUMBER ,
110: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
111: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
112: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
113: p_fee_trigger_group_number IN NUMBER ,
114: p_message_name OUT NOCOPY VARCHAR2)

Line 111: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

107: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,
109: p_ci_sequence_number IN NUMBER ,
110: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
111: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
112: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
113: p_fee_trigger_group_number IN NUMBER ,
114: p_message_name OUT NOCOPY VARCHAR2)
115: RETURN BOOLEAN AS

Line 112: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

108: p_cal_type IN IGS_FI_UNIT_FEE_TRG.cal_type%TYPE ,
109: p_ci_sequence_number IN NUMBER ,
110: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
111: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
112: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
113: p_fee_trigger_group_number IN NUMBER ,
114: p_message_name OUT NOCOPY VARCHAR2)
115: RETURN BOOLEAN AS
116: gv_other_detail VARCHAR2(255);

Line 118: -- Validate that there are no other "open" IGS_FI_UNIT_FEE_TRG records for

114: p_message_name OUT NOCOPY VARCHAR2)
115: RETURN BOOLEAN AS
116: gv_other_detail VARCHAR2(255);
117: BEGIN -- finp_val_uft_open
118: -- Validate that there are no other "open" IGS_FI_UNIT_FEE_TRG records for
119: -- the nominated unit_cd details and the same parent IGS_FI_F_CAT_FEE_LBL.
120: DECLARE
121: CURSOR c_uft IS
122: SELECT 'x'

Line 123: FROM IGS_FI_UNIT_FEE_TRG uft

119: -- the nominated unit_cd details and the same parent IGS_FI_F_CAT_FEE_LBL.
120: DECLARE
121: CURSOR c_uft IS
122: SELECT 'x'
123: FROM IGS_FI_UNIT_FEE_TRG uft
124: WHERE uft.fee_cat = p_fee_cat AND
125: uft.fee_cal_type = p_fee_cal_type AND
126: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
127: uft.fee_type = p_fee_type AND