PACKAGE: APPS.IGS_GE_INS_SLE

Source

1 PACKAGE IGS_GE_INS_SLE AUTHID CURRENT_USER AS
2 /* $Header: IGSGE05S.pls 115.5 2002/11/29 00:32:10 nsidana ship $ */
3 
4   --
5   --
6   TYPE log_entry_typ_rec IS RECORD
7   (
8   s_log_type IGS_GE_S_LOG_ENTRY.S_LOG_TYPE%TYPE,
9   sl_key IGS_GE_S_LOG.KEY%TYPE,
10   sle_key IGS_GE_S_LOG_ENTRY.KEY%TYPE,
11   sle_message_name IGS_GE_S_LOG_ENTRY.MESSAGE_NAME%TYPE,
12   text IGS_GE_S_LOG_ENTRY.TEXT%TYPE);
13   --
14   --
15   TYPE t_log_entry_typ IS TABLE OF
16   IGS_GE_INS_SLE.log_entry_typ_rec
17   INDEX BY BINARY_INTEGER;
18   --
19   --
20   t_log_entry t_log_entry_typ;
21   --
22   --
23   t_log_entry_blank t_log_entry_typ;
24   --
25   --
26   r_log_entry log_entry_typ_rec;
27   --
28   --
29   gv_cntr BINARY_INTEGER;
30   --
31   -- Insert into IGS_GE_S_LOG_ENTRY from a pl/sql table.
32   PROCEDURE GENP_INS_SLE(
33   p_creation_dt IN OUT NOCOPY DATE )
34 ;
35   --
36   -- To insert entry into PL/SQL table to allow log entries after rollback
37   PROCEDURE GENP_SET_LOG_ENTRY(
38   p_s_log_type IN VARCHAR2 ,
39   p_sl_key IN VARCHAR2 ,
40   p_sle_key IN VARCHAR2 ,
41   p_sle_message_name IN VARCHAR2 ,
42   p_text IN VARCHAR2 )
43 ;
44   --
45   -- Initialise pl/sql table when creating IGS_GE_S_LOG_ENTRY records.
46   PROCEDURE GENP_SET_LOG_CNTR
47 ;
48 END IGS_GE_INS_SLE;