DBA Data[Home] [Help]

APPS.IGS_FI_VAL_UFT dependencies on IGS_FI_UNIT_FEE_TRG

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

23: RETURN BOOLEAN;
24: PRAGMA RESTRICT_REFERENCES(finp_val_uft_ftg,WNDS);
25:
26: --
27: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.
28: FUNCTION finp_val_uft_open(
29: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
30: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
31: p_fee_ci_sequence_number IN NUMBER ,

Line 29: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,

25:
26: --
27: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.
28: FUNCTION finp_val_uft_open(
29: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
30: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
31: p_fee_ci_sequence_number IN NUMBER ,
32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,

Line 30: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,

26: --
27: -- Ensure only one open IGS_FI_UNIT_FEE_TRG record exists.
28: FUNCTION finp_val_uft_open(
29: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
30: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
31: p_fee_ci_sequence_number IN NUMBER ,
32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
34: p_sequence_number IN NUMBER ,

Line 32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,

28: FUNCTION finp_val_uft_open(
29: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
30: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
31: p_fee_ci_sequence_number IN NUMBER ,
32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
34: p_sequence_number IN NUMBER ,
35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,

Line 33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,

29: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.fee_cat%TYPE ,
30: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
31: p_fee_ci_sequence_number IN NUMBER ,
32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
34: p_sequence_number IN NUMBER ,
35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
37: p_ci_sequence_number IN NUMBER ,

Line 35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,

31: p_fee_ci_sequence_number IN NUMBER ,
32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
34: p_sequence_number IN NUMBER ,
35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
37: p_ci_sequence_number IN NUMBER ,
38: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
39: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

Line 36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,

32: p_fee_type IN IGS_FI_UNIT_FEE_TRG.fee_type%TYPE ,
33: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
34: p_sequence_number IN NUMBER ,
35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
37: p_ci_sequence_number IN NUMBER ,
38: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
39: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
40: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

Line 38: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,

34: p_sequence_number IN NUMBER ,
35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
37: p_ci_sequence_number IN NUMBER ,
38: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
39: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
40: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
41: p_fee_trigger_group_number IN NUMBER ,
42: p_message_name OUT NOCOPY VARCHAR2)

Line 39: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

35: p_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
37: p_ci_sequence_number IN NUMBER ,
38: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
39: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
40: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
41: p_fee_trigger_group_number IN NUMBER ,
42: p_message_name OUT NOCOPY VARCHAR2)
43: RETURN BOOLEAN;

Line 40: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

36: p_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
37: p_ci_sequence_number IN NUMBER ,
38: p_unit_class IN IGS_FI_UNIT_FEE_TRG.unit_class%TYPE ,
39: p_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
40: p_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
41: p_fee_trigger_group_number IN NUMBER ,
42: p_message_name OUT NOCOPY VARCHAR2)
43: RETURN BOOLEAN;
44: PRAGMA RESTRICT_REFERENCES(finp_val_uft_open,WNDS);