PACKAGE: APPS.IGS_EN_VAL_USFT

Source

1 PACKAGE IGS_EN_VAL_USFT AUTHID CURRENT_USER AS
2 /* $Header: IGSEN72S.pls 115.4 2002/11/29 00:09:02 nsidana ship $ */
3   --
4 
5   -- gt_rowid_table IGS_FI_VAL_CFT.t_cft_rowids;
6 
7   --
8 
9   --
10 
11   --gt_empty_table IGS_FI_VAL_CFT.t_cft_rowids;
12 
13   --
14 
15   --
16 
17   --gv_table_index BINARY_INTEGER;
18 
19   --
20 
21   --
22 
23   -- Ensure IGS_PS_UNIT set fee triggers can be created.
24 
25   FUNCTION finp_val_usft_ins(
26 
27   p_fee_type IN VARCHAR2 ,
28 
29   p_message_name OUT NOCOPY VARCHAR2)
30 
31 RETURN BOOLEAN;
32 --PRAGMA RESTRICT_REFERENCES(finp_val_usft_ins , WNDS);
33 
34   --
35 
36   -- Validate IGS_PS_UNIT set fee trigger can belong to a fee trigger group.
37 
38   FUNCTION finp_val_usft_ftg(
39 
40   p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
41 
42   p_fee_trigger_group_num IN NUMBER ,
43 
44   p_message_name OUT NOCOPY VARCHAR2)
45 
46 RETURN BOOLEAN;
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 ,
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 ,
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 ,
70 
71   p_message_name OUT NOCOPY VARCHAR2)
72 
73 RETURN BOOLEAN;
74 --PRAGMA RESTRICT_REFERENCES( finp_val_usft_open, WNDS);
75 
76   --
77 
78   -- To validate the calendar instance system cal status is not 'INACTIVE'
79 
80   FUNCTION FINP_VAL_US_STATUS(
81 
82   p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,
83 
84   p_version_number IN IGS_EN_UNIT_SET_ALL.version_number%TYPE ,
85 
86   p_message_name OUT NOCOPY VARCHAR2)
87 
88 RETURN boolean;
89 --PRAGMA RESTRICT_REFERENCES(FINP_VAL_US_STATUS , WNDS);
90 
91   --
92 
93   -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
94 
95  -- PROCEDURE genp_prc_clear_rowid;
96 
97   --
98 
99   -- Routine to save rowids in a PL/SQL TABLE for the current commit.
100 
101  -- PROCEDURE genp_set_rowid(  v_rowid  ROWID );
102 
103   --
104 
105   -- Routine to process usft rowids in PL/SQL TABLE for the current commit.
106 
107 
108 
109 END IGS_EN_VAL_USFT;