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);
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: --
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: --
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
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
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: --
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;