APPS.IGS_EN_VAL_USFT dependencies on IGS_EN_UNITSETFEETRG

Line 51: -- Ensure only one open IGS_EN_UNITSETFEETRG record exists.

47: --PRAGMA RESTRICT_REFERENCES( finp_val_usft_ftg, WNDS);
48:
49: --
50:
51: -- Ensure only one open IGS_EN_UNITSETFEETRG record exists.
52:
53: FUNCTION finp_val_usft_open(
54:
55: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,

Line 55: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,

51: -- Ensure only one open IGS_EN_UNITSETFEETRG record exists.
52:
53: FUNCTION finp_val_usft_open(
54:
55: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,
56:
57: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,
58:
59: p_fee_ci_sequence_number IN NUMBER ,

Line 57: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,

53: FUNCTION finp_val_usft_open(
54:
55: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,
56:
57: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,
58:
59: p_fee_ci_sequence_number IN NUMBER ,
60:
61: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,

Line 61: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,

57: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,
58:
59: p_fee_ci_sequence_number IN NUMBER ,
60:
61: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,
62:
63: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
64:
65: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,

Line 63: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,

59: p_fee_ci_sequence_number IN NUMBER ,
60:
61: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,
62:
63: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
64:
65: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,
66:
67: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,

Line 65: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,

61: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,
62:
63: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
64:
65: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,
66:
67: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,
68:
69: p_fee_trigger_group_number IN NUMBER ,

Line 67: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,

63: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
64:
65: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,
66:
67: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,
68:
69: p_fee_trigger_group_number IN NUMBER ,
70:
71: p_message_name OUT NOCOPY VARCHAR2)