[Home] [Help]
PACKAGE: APPS.IEM_RULES_ENGINE_PUB
Source
1 PACKAGE IEM_RULES_ENGINE_PUB AUTHID CURRENT_USER AS
2 /* $Header: iempruls.pls 120.0.12010000.2 2009/07/13 04:51:23 lkullamb ship $ */
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 -- lkullamb 7/13/2009 Added parameter3 to parameter_type record type
16 -- --------- ------ ------------------------------------------
17
18 TYPE parameter_type is RECORD (
19 parameter1 iem_action_dtls.parameter1%type,
20 parameter2 iem_action_dtls.parameter2%type,
21 parameter3 iem_action_dtls.parameter3%type,
22 type varchar2(30)
23 );
24
25 --Table of Key-Values
26 TYPE parameter_tbl_type is TABLE OF parameter_type INDEX BY BINARY_INTEGER;
27
28 PROCEDURE auto_process_email(
29 p_api_version_number IN Number,
30 p_init_msg_list IN VARCHAR2 := null,
31 p_commit IN VARCHAR2 := null,
32 p_rule_type IN VARCHAR2,
33 p_keyVals_tbl IN IEM_ROUTE_PUB.keyVals_tbl_type,
34 p_accountId IN Number,
35 x_result OUT NOCOPY VARCHAR2,
36 x_action OUT NOCOPY Varchar2,
37 x_parameters OUT NOCOPY IEM_RULES_ENGINE_PUB.parameter_tbl_type,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2);
41
42 function is_valid ( p_value VARCHAR2 )
43 return VARCHAR2;
44
45 function get_document_total ( p_cat_id VARCHAR2 )
46 return NUMBER;
47
48 function is_document_exist ( p_cat_id VARCHAR2, p_doc_id VARCHAR2 )
49 return VARCHAR2;
50
51 END IEM_RULES_ENGINE_PUB;