[Home] [Help]
PACKAGE: APPS.OKC_XPRT_RULE_PVT
Source
1 PACKAGE okc_xprt_rule_pvt
2 /* $Header: OKCVXIRS.pls 120.2 2011/03/10 18:18:06 harchand noship $ */
3 AUTHID CURRENT_USER AS
4
5
6 -- g_Success CONSTANT VARCHAR2(30) := 'SUCCESS';
7 -- g_Error CONSTANT VARCHAR2(30) := 'ERROR';
8 -- Exceptions
9 G_VAL_EXCEPTION EXCEPTION;
10
11 ---------------------------------------------------------------------------
12 -- GLOBAL VARIABLES
13 ---------------------------------------------------------------------------
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_RULE_PVT';
15 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16
17 ------------------------------------------------------------------------------
18 -- GLOBAL CONSTANTS
19 ------------------------------------------------------------------------------
20 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
21 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22 G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25
26
27
28
29 TYPE template_rules_rec_type
30 IS RECORD
31 ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM
32 , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33 , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34 , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35 , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36 , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37 , created_by NUMBER := OKC_API.G_MISS_NUM
38 , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39 , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40 , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE
41 , last_update_login NUMBER := OKC_API.G_MISS_NUM
42 );
43 TYPE template_rules_tbl_type IS TABLE OF template_rules_rec_type INDEX BY PLS_INTEGER;
44
45
46 TYPE rule_outcome_rec_type IS RECORD
47 ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM
48 , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49 , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50 , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51 , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52 , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53 , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54 , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55 , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56 , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57 , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR
58 , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR
59 );
60 TYPE rule_outcome_tbl_type IS TABLE OF rule_outcome_rec_type INDEX BY PLS_INTEGER;
61
62 TYPE rule_cond_vals_rec_type IS RECORD
63 (
64 RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
65 , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66 , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67 , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68 , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69 , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70 , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71 , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72 , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
73 );
74 TYPE rule_cond_vals_tbl_type IS TABLE OF rule_cond_vals_rec_type INDEX BY PLS_INTEGER;
75
76 TYPE rule_condition_rec_type IS RECORD
77 (
78 RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
79 , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80 , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81 , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82 , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83 , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84 , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85 , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86 , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87 , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88 , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89 , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90 , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91 , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92 , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
93 , rule_cond_vals_tbl rule_cond_vals_tbl_type
94 );
95 TYPE rule_condition_tbl_type IS TABLE OF rule_condition_rec_type INDEX BY PLS_INTEGER;
96
97 TYPE rule_header_rec_type IS RECORD
98 (
99 RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM
100 ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101 ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102 ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103 ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104 ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105 ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106 ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107 ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108 ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109 ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110 ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
111 ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
112 ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM
113 ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
114 ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
115 ,LAST_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
116 ,LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
117 ,PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM
118 ,PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM
119 ,PROGRAM_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
120 );
121 TYPE rule_header_tbl_type IS TABLE OF rule_header_rec_type INDEX BY PLS_INTEGER;
122
123 TYPE rule_rec_type IS RECORD
124 (
125 RULE_HEADER_REC RULE_HEADER_REC_TYPE
126 ,RULE_CONDITION_TBL RULE_CONDITION_TBL_TYPE
127 ,RULE_OUTCOME_TBL RULE_OUTCOME_TBL_TYPE
128 ,TEMPLATE_RULES_TBL TEMPLATE_RULES_TBL_TYPE
129 ,STATUS VARCHAR2(1)
130 ,ERRMSG VARCHAR2(2500)
131 );
132 TYPE RULE_TBL_TYPE IS TABLE OF RULE_REC_TYPE INDEX BY PLS_INTEGER;
133
134 TYPE RULE_CHILD_ENTITY_TBL_TYPE IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
135
136 TYPE rule_child_entities_rec_type IS RECORD
137 ( RULE_ID NUMBER
138 ,RULE_CONDITION_ID_TBL RULE_CHILD_ENTITY_TBL_TYPE
139 ,RULE_OUTCOME_ID_TBL RULE_CHILD_ENTITY_TBL_TYPE
140 ,TEMPLATE_RULE_ID_TBL RULE_CHILD_ENTITY_TBL_TYPE
141 ,STATUS VARCHAR2(1)
142 ,ERRMSG VARCHAR2(2500)
143 );
144
145 TYPE rule_child_entities_tbl_type IS TABLE OF rule_child_entities_rec_type INDEX BY PLS_INTEGER;
146
147
148 PROCEDURE create_rule(P_RULE_TBL IN OUT NOCOPY RULE_TBL_TYPE
149 ,p_commit IN VARCHAR2 := FND_API.G_FALSE );
150
151 PROCEDURE update_rule(P_RULE_TBL IN OUT NOCOPY RULE_TBL_TYPE
152 ,p_commit IN VARCHAR2 := FND_API.G_FALSE );
153
154 PROCEDURE delete_rule_child_entities(P_RULE_CHILD_ENTITIES_TBL IN OUT NOCOPY rule_child_entities_tbl_type
155 ,p_commit IN VARCHAR2 := FND_API.G_FALSE);
156
157 END okc_xprt_rule_pvt;