[Home] [Help]
PACKAGE: APPS.CSD_PARAMETER_EFFECTIVITY_PVT
Source
1 PACKAGE CSD_PARAMETER_EFFECTIVITY_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvpres.pls 120.2 2011/04/18 10:19:12 subhat noship $ */
3 -- Start of Comments
4 -- Package name : CSD_PARAMETER_EFFECTIVITY_PVT
5 -- Purpose : Mar-04-2011 subhat created
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 G_EQUALS CONSTANT VARCHAR2(6) := 'EQUALS';
11 G_NOT_EQUALS CONSTANT VARCHAR2(10) := 'NOT_EQUALS';
12 G_LESS_THAN CONSTANT VARCHAR2(9) := 'LESS_THAN';
13 G_GREATER_THAN CONSTANT VARCHAR2(12) := 'GREATER_THAN';
14
15 /*--------------------------------------------------------------------*/
16 /* Record name: CSD_RULE_CONDITION_REC_TYPE */
17 /* Description : Record used for single match from rules engine */
18 /* */
19 /* */
20 /* Called from : Depot Repair Rule Engine */
21 /* */
22 /*--------------------------------------------------------------------*/
23 TYPE RULE_CONDITION_REC_TYPE IS RECORD
24 (
25 RULE_CONDITION_ID NUMBER
26 , RETURN_RULE_ID NUMBER
27 , ATTRIBUTE_CATEGORY VARCHAR2(30)
28 , ATTRIBUTE1 VARCHAR2(150)
29 , ATTRIBUTE2 VARCHAR2(150)
30 , ATTRIBUTE3 VARCHAR2(150)
31 , ATTRIBUTE4 VARCHAR2(150)
32 , ATTRIBUTE5 VARCHAR2(150)
33 , ATTRIBUTE6 VARCHAR2(150)
34 , ATTRIBUTE7 VARCHAR2(150)
35 , ATTRIBUTE8 VARCHAR2(150)
36 , ATTRIBUTE9 VARCHAR2(150)
37 , ATTRIBUTE10 VARCHAR2(150)
38 , ATTRIBUTE11 VARCHAR2(150)
39 , ATTRIBUTE12 VARCHAR2(150)
40 , ATTRIBUTE13 VARCHAR2(150)
41 , ATTRIBUTE14 VARCHAR2(150)
42 , ATTRIBUTE15 VARCHAR2(150)
43 );
44
45 /*--------------------------------------------------------------------*/
46 /* Type to hold multiple rule conditions */
47 /*--------------------------------------------------------------------*/
48 TYPE RULE_CONDITION_TBL_TYPE IS TABLE OF RULE_CONDITION_REC_TYPE
49 INDEX BY BINARY_INTEGER;
50
51 /*--------------------------------------------------------------------*/
52 /* Record name: CSD_RULE_INPUT_REC_TYPE */
53 /* Description : Record used for Input values into rules engine */
54 /* */
55 /* The following are valid criteria for the rules engine: */
56 /* SR Customer */
57 /* SR Customer Account */
58 /* SR Bill to country */
59 /* SR Ship to country */
60 /* SR Item */
61 /* SR Item Category */
62 /* SR Contract Entitlement */
63 /* Return Type Id */
64 /* Called from: Depot Repair Rules Engine */
65 /* Change Hist : Jan-14-08 rfieldma created */
66 /*--------------------------------------------------------------------*/
67 TYPE RULE_INPUT_REC_TYPE IS RECORD
68 (
69 RETURN_TYPE NUMBER
70 , CUSTOMER_ID NUMBER
71 , BILL_TO_SITE_USE_ID NUMBER
72 , SHIP_TO_SITE_USE_ID NUMBER
73 , ITEM_ID NUMBER
74 , ITEM_CATEGORY_ID NUMBER
75 , CONTRACT_ID NUMBER
76 );
77
78 TYPE PARAM_VALUE_REC_TYPE IS RECORD
79 (
80 RULE_ID NUMBER
81 , VALUE VARCHAR2(500)
82 );
83
84 TYPE PARAM_VALUE_TBL_TYPE IS TABLE OF PARAM_VALUE_REC_TYPE INDEX BY BINARY_INTEGER;
85
86
87 /*--------------------------------------------------------------------*/
88 /* procedure name: PARAMETER_VALUE */
89 /* description : procedure used to get the value of the parameter */
90 /* */
91 /* */
92 /* */
93 /* Called from : Returns portal. Can be potentially called from */
94 /* anywhere where we use parameters */
95 /* Input Parm : */
96 /* p_api_version NUMBER Req Api Version number */
97 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
98 /* p_commit VARCHAR2 Opt Commits in API */
99 /* p_validation_level NUMBER Opt validation steps */
100 /* p_param_id NUMBER parameter_id */
101 /* Output Parm : */
102 /* x_value VARCHAR2 the value as calculated of the */
103 /* parameter */
104 /* x_return_status VARCHAR2 Return status after the call. */
105 /* x_msg_count NUMBER Number of messages in stack */
106 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
107 /* Change Hist : Mar-04-11 rfieldma created */
108 /* */
109 /* */
110 /* */
111 /*--------------------------------------------------------------------*/
112 PROCEDURE PARAMETER_VALUE(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 p_param_id IN NUMBER,
118 p_rule_input_rec IN RULE_INPUT_REC_TYPE,
119 x_param_value OUT NOCOPY VARCHAR2,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 /*--------------------------------------------------------------------*/
126 /* function name: GET_SQL_OPERATOR */
127 /* description : Turns the given operator into the corresponding */
128 /* operator symbol used in a sql query */
129 /* */
130 /* Called from : FUNCTION GET_RULE_SQL_FOR_RO */
131 /* Input Parm : */
132 /* p_operator VARCHAR2 Req */
133 /* */
134 /* */
135 /* Return Val : */
136 /* VARCHAR2 - Operator Lookup code from CSD_RULE_OPERATORS */
137 /* */
138 /*--------------------------------------------------------------------*/
139 FUNCTION GET_SQL_OPERATOR (
140 p_operator IN VARCHAR2
141 ) RETURN VARCHAR2;
142
143 END CSD_PARAMETER_EFFECTIVITY_PVT;