PACKAGE: APPS.IEM_RULES_ENGINE_PUB

Source

1 PACKAGE IEM_RULES_ENGINE_PUB AUTHID CURRENT_USER AS
2 /* $Header: iempruls.pls 115.3 2003/09/24 21:18:09 liangxia noship $ */
3 --
4 --
5 -- Purpose: Email Processing Engine to process emails based on the rules
6 --
7 -- MODIFICATION HISTORY
8 -- Person      Date         Comments
9 --  Liang Xia   06/10/2002   Create
10 --  Liang Xia   12/04/2002   Fixed gscc warning: NOCOPY, No G_miss...
11 --  Liang Xia   07/06/2003   Added Document Mapping validation
12 --  Liang Xia   08/17/2003   Added Auto-Redirect rule type
13 --  Liang Xia   09/24/2003   Added extra validation on AUTOACKNOWLEDGE,
14 --                           AUTOREPLYSPECDOC to check if the document is exist
15 -- ---------   ------  ------------------------------------------
16 
17   TYPE parameter_type is RECORD (
18     parameter1      iem_action_dtls.parameter1%type,
19     parameter2      iem_action_dtls.parameter2%type,
20     type            varchar2(30)
21     );
22 
23   --Table of Key-Values
24   TYPE parameter_tbl_type is TABLE OF parameter_type INDEX BY BINARY_INTEGER;
25 
26   PROCEDURE auto_process_email(
27   p_api_version_number  IN Number,
28   p_init_msg_list       IN VARCHAR2 := null,
29   p_commit              IN VARCHAR2 := null,
30   p_rule_type           IN VARCHAR2,
31   p_keyVals_tbl         IN IEM_ROUTE_PUB.keyVals_tbl_type,
32   p_accountId           IN Number,
33   x_result              OUT NOCOPY VARCHAR2,
34   x_action              OUT NOCOPY Varchar2,
35   x_parameters          OUT NOCOPY IEM_RULES_ENGINE_PUB.parameter_tbl_type,
36   x_return_status       OUT NOCOPY VARCHAR2,
37   x_msg_count           OUT NOCOPY NUMBER,
38   x_msg_data            OUT NOCOPY VARCHAR2);
39 
40 function is_valid ( p_value VARCHAR2 )
41    return VARCHAR2;
42 
43 function get_document_total ( p_cat_id VARCHAR2 )
44    return NUMBER;
45 
46 function is_document_exist ( p_cat_id VARCHAR2, p_doc_id VARCHAR2 )
47     return VARCHAR2;
48 
49 END IEM_RULES_ENGINE_PUB;