1 PACKAGE IGS_CO_PRC_SP_MX AUTHID CURRENT_USER AS
2 /* $Header: IGSCO04S.pls 115.3 2002/02/12 16:42:10 pkm ship $ */
3 TYPE t_splrg_max_rec IS RECORD
4 (
5 letter_repeating_group_cd VARCHAR2(10),
6 max_value NUMBER(3,0)
7 );
8 --
9 --
10 TYPE t_splrg_max_vals IS TABLE OF
11 IGS_CO_PRC_SP_MX.t_splrg_max_rec
12 INDEX BY BINARY_INTEGER;
13 --
14 --
15 gt_splrg_table t_splrg_max_vals;
16 --
17 --
18 gt_empty_table t_splrg_max_vals;
19 --
20 --
21 gv_table_index BINARY_INTEGER;
22 --
23 -- Routine to retrieve splrg max value from a PL/SQL TABLE.
24 FUNCTION corp_get_splrg_max(
25 p_letter_repeating_group_cd IN VARCHAR2 )
26 RETURN NUMBER;
27 PRAGMA RESTRICT_REFERENCES(corp_get_splrg_max,WNDS);
28 --
29 -- Routine to save splrg max value in a PL/SQL TABLE.
30 PROCEDURE corp_set_splrg_max(
31 p_letter_repeating_group_cd IN VARCHAR2 ,
32 p_max_value IN NUMBER );
33 --
34 -- Routine to initialise splrg max value from a PL/SQL TABLE.
35 PROCEDURE corp_prc_clear_splrg;
36 END IGS_CO_PRC_SP_MX;