1 PACKAGE IGS_FI_VAL_UFT AUTHID CURRENT_USER AS
2 /* $Header: IGSFI42S.pls 115.5 2002/11/29 00:23:12 nsidana ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 removed the function crsp_val_loc_cd
5 -- As part of the bug# 1956374 removed the function crsp_val_posp_cat
6 -- As part of the bug# 1956374 removed the function crsp_val_uv_sys_sts
7 -- As part of the bug# 1956374 removed the function crsp_val_ucl_closed
8 -- As part of the bug# 1956374 removed the function crsp_val_uv_active
9
10 -- Ensure IGS_PS_UNIT fee triggers can be created.
11 FUNCTION finp_val_uft_ins(
12 p_fee_type IN VARCHAR2 ,
13 p_message_name OUT NOCOPY VARCHAR2)
14 RETURN BOOLEAN;
15 PRAGMA RESTRICT_REFERENCES(finp_val_uft_ins,WNDS);
16
17 --
18 -- Validate IGS_PS_UNIT fee trigger can belong to a fee trigger group.
19 FUNCTION finp_val_uft_ftg(
20 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
21 p_fee_trigger_group_num IN NUMBER ,
22 p_message_name OUT NOCOPY VARCHAR2)
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 ,
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 ,
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);
45
46 --
47 -- Warn if no IGS_PS_UNIT offering option exists for the specified options.
48 FUNCTION finp_val_uft_uoo(
49 p_unit_cd IN VARCHAR2 ,
50 p_cal_type IN VARCHAR2 ,
51 p_ci_sequence_number IN NUMBER ,
52 p_location_cd IN VARCHAR2 ,
53 p_unit_class IN VARCHAR2 ,
54 p_message_name OUT NOCOPY VARCHAR2)
55 RETURN BOOLEAN;
56 PRAGMA RESTRICT_REFERENCES(finp_val_uft_uoo,WNDS);
57
58
59
60
61 END IGS_FI_VAL_UFT;