DBA Data[Home] [Help]

PACKAGE: APPS.IGS_CO_PRC_SP_MX

Source


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;