1 PACKAGE CSC_ACTION_ASSEMBLER_PVT AUTHID CURRENT_USER AS
2 /* $Header: cscvrens.pls 115.14 2004/07/13 07:47:34 bhroy ship $ */
3
4 G_OUTCOME_TBL OKC_CONDITION_EVAL_PUB.OUTCOME_TAB_TYPE;
5
6 G_MSG_REC OKC_AQ_PVT.MSG_REC_TYP;
7 G_MSG_TBL OKC_AQ_PVT.MSG_TAB_TYP;
8
9
10 TYPE Params_Rec_Type IS RECORD (
11 PNAME VARCHAR2(2000),
12 Name VARCHAR2(200),
13 Value VARCHAR2(2000) );
14 TYPE Params_Tab_Type IS TABLE OF Params_Rec_Type
15 INDEX BY BINARY_INTEGER;
16
17 TYPE Plan_Id_Type IS RECORD (
18 PLAN_ID NUMBER );
19 TYPE Plan_id_Tab_Type IS TABLE OF Plan_Id_Type
20 INDEX BY BINARY_INTEGER;
21
22 TYPE Results_Rec_Type IS RECORD (
23 NAME VARCHAR2(1000),
24 TYPE VARCHAR2(1000),
25 DESCRIPTION VARCHAR2(1800) );
26
27 TYPE Results_Tab_Type IS TABLE OF Results_Rec_Type
28 INDEX BY BINARY_INTEGER;
29
30 TYPE Condition_ID_Rec_Type IS RECORD (
31 Condition_Id NUMBER );
32
33 TYPE Condition_ID_Tab_Type IS TABLE OF Condition_ID_Rec_Type
34 INDEX BY BINARY_INTEGER;
35
36
37 PROCEDURE ENABLE_PLAN (P_PARTY_ID NUMBER,
38 P_CUST_ACCOUNT_ID NUMBER,
39 P_END_USER_TYPE VARCHAR2 := NULL,
40 X_CONDITION_ID_TBL OUT NOCOPY CONDITION_ID_Tab_Type ) ;
41
42
43 PROCEDURE ENABLE_PLAN_AND_GET_OUTCOMES (
44 P_PARTY_ID NUMBER,
45 P_Cust_Account_Id NUMBER,
46 P_End_User_Type VARCHAR2 := NULL,
47 P_Application_Short_Name VARCHAR2,
48 p_Msg_Tbl OKC_AQ_PVT.MSG_TAB_TYP,
49 x_results_tbl OUT NOCOPY RESULTS_TAB_TYPE ) ;
50
51 PROCEDURE GET_OUTCOMES(
52 p_api_version_number IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
54 p_condition_id IN okc_condition_headers_b.id%TYPE,
55 p_application_short_name IN VARCHAR2,
56 p_Msg_Tbl IN OKC_AQ_PVT.MSG_TAB_TYP,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 X_RESULTS_TBL IN OUT NOCOPY RESULTS_TAB_TYPE );
61
62 FUNCTION GET_ALERT_NAME(P_String VARCHAR2,p_Application_Short_Name IN VARCHAR2,
63 x_name OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2;
64
65 FUNCTION GET_SCRIPT_NAME( P_String VARCHAR2 ) RETURN VARCHAR2;
66
67 FUNCTION DETACH_STRING ( p_string VARCHAR2,x_Name OUT NOCOPY VARCHAR2 ) RETURN params_tab_type;
68
69
70
71 END CSC_ACTION_ASSEMBLER_PVT;