1 PACKAGE igf_sl_cl_chg_prc AS
2 /* $Header: IGFSL23S.pls 120.0 2005/06/01 14:25:12 appldev noship $ */
3
4 ------------------------------------------------------------------
5 --Created by : Sanil Madathil, Oracle IDC
6 --Date created: 10 October 2004
7 --
8 --Purpose:
9 -- Invoked : From igf_sl_cl_create_chg process to validate change record
10 -- Function : This process would be invoked automatically for each change
11 -- record created
12 --
13 --Known limitations/enhancements and/or remarks:
14 --
15 --Change History:
16 --Who When What
17 ------------------------------------------------------------------
18
19 TYPE token_rec_type IS RECORD (
20 token_name VARCHAR2(256),
21 token_value VARCHAR2(1024)
22 );
23
24 token_rec token_rec_type;
25
26 TYPE token_tab_type IS TABLE OF token_rec%TYPE INDEX BY BINARY_INTEGER;
27 token_tab token_tab_type;
28 g_message_tokens token_tab%TYPE;
29
30 PROCEDURE validate_chg ( p_n_clchgsnd_id IN igf_sl_clchsn_dtls.clchgsnd_id%TYPE,
31 p_b_return_status OUT NOCOPY BOOLEAN,
32 p_v_message_name OUT NOCOPY VARCHAR2,
33 p_t_message_tokens OUT NOCOPY token_tab%TYPE
34 );
35
36 PROCEDURE parse_tokens ( p_t_message_tokens IN token_tab%TYPE
37 );
38
39 END igf_sl_cl_chg_prc;