1 PACKAGE EDR_RULE_TEMP AUTHID CURRENT_USER AS
2 /* $Header: EDRTEMPS.pls 120.2.12000000.1 2007/01/18 05:55:44 appldev ship $ */
3
4
5 TYPE edr_array_date IS TABLE OF DATE;
6
7
8 /* obtain rule details for a transaction, insert into temp tables */
9 PROCEDURE GET_DETAILS_TRANS ( p_trans_id IN VARCHAR2, p_input_var IN VARCHAR2 ) ;
10
11
12 /* obtain rule details for a rule, insert into temp tables */
13 PROCEDURE GET_DETAILS_RULE ( p_trans_name IN VARCHAR2, p_rule_name IN VARCHAR2 ) ;
14
15
16 /* clear relevant rows in temp tables for a transaction */
17 PROCEDURE CLEAR_DETAILS_TRANS ( p_trans_id IN VARCHAR2 ) ;
18
19
20 /* clear relevant rows in temp tables for a rule */
21 PROCEDURE CLEAR_DETAILS_RULE ( p_trans_id IN VARCHAR2,
22 p_rule_id IN VARCHAR2
23 );
24
25 /* due to empty temp table, take event key as input to generate rows */
26 PROCEDURE GET_TVAR_RULE_DETAIL ( p_trans_var IN VARCHAR2 ) ;
27
28 /* due to empty temp table, take event key as input to generate rows */
29 PROCEDURE GET_RVAR_RULE_DETAIL ( p_trans_rule IN VARCHAR2 ) ;
30
31
32 /* 3016075: event key changed to instance id, use it to find input var */
33 PROCEDURE GET_TRANS_RULES ( p_trans_config_id IN VARCHAR2 ) ;
34
35 /* 3016075: event key changed to instance id, use it to find input var */
36 PROCEDURE GET_RULE_DETAIL ( p_rule_config_id IN VARCHAR2 ) ;
37
38 --This API is used to set the transaction details in the temp tables
39 --for the specified transaction ID and variable name.
40 PROCEDURE SET_TRANSACTION_DETAILS(P_TRANSACTION_ID IN VARCHAR2,
41 P_VARIABLE_NAME IN VARCHAR2);
42
43 --This API is used to set the rule details in the temp tables
44 --for the specified transaction ID and rule ID.
45 PROCEDURE SET_RULE_DETAILS(P_TRANSACTION_ID IN VARCHAR2,
46 P_RULE_ID IN VARCHAR2);
47
48 --This function returns the specified display date in String format.
49 FUNCTION DISPLAY_DATE(P_DATE IN DATE)
50 RETURN VARCHAR2;
51
52 PROCEDURE CHECK_AND_SYNC_RULE_TABLE(P_TRANSACTION_ID IN VARCHAR2);
53
54 END EDR_RULE_TEMP;
[Home] [Help]