eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_CONDITIONS

Line 9: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

5: PROCEDURE get_tsrm_parameter_value(
6: p_structure_name IN VARCHAR2,
7: p_structure_index IN BINARY_INTEGER,
8: p_condition_index IN BINARY_INTEGER,
9: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
10: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
11: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_error_buffer OUT NOCOPY VARCHAR2);

Line 10: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

6: p_structure_name IN VARCHAR2,
7: p_structure_index IN BINARY_INTEGER,
8: p_condition_index IN BINARY_INTEGER,
9: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
10: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
11: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_error_buffer OUT NOCOPY VARCHAR2);
14:

Line 11: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,

7: p_structure_index IN BINARY_INTEGER,
8: p_condition_index IN BINARY_INTEGER,
9: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
10: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
11: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_error_buffer OUT NOCOPY VARCHAR2);
14:
15: PROCEDURE get_fsc_code(

Line 28: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE);

24: p_classified_entity_id IN
25: ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
26: p_item_org_id IN NUMBER,
27: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
28: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE);
29:
30: PROCEDURE get_fc(
31: p_structure_name IN VARCHAR2,
32: p_structure_index IN BINARY_INTEGER,

Line 37: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

33: p_condition_index IN BINARY_INTEGER,
34: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
35: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
36: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
37: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
38: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
39: p_return_status OUT NOCOPY VARCHAR2,
40: p_error_buffer OUT NOCOPY VARCHAR2);
41:

Line 38: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

34: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
35: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
36: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
37: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
38: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
39: p_return_status OUT NOCOPY VARCHAR2,
40: p_error_buffer OUT NOCOPY VARCHAR2);
41:
42: PROCEDURE get_registration_status(

Line 49: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

45: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
46: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
47: p_tax IN ZX_TAXES_B.TAX%TYPE,
48: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
49: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
50: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
51: p_return_status OUT NOCOPY VARCHAR2,
52: p_error_buffer OUT NOCOPY VARCHAR2);
53:

Line 50: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

46: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
47: p_tax IN ZX_TAXES_B.TAX%TYPE,
48: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
49: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
50: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
51: p_return_status OUT NOCOPY VARCHAR2,
52: p_error_buffer OUT NOCOPY VARCHAR2);
53:
54: PROCEDURE process_segment_string(

Line 65: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

61: PROCEDURE get_account_flexfield_info(
62: p_structure_name IN VARCHAR2,
63: p_structure_index IN BINARY_INTEGER,
64: p_condition_index IN BINARY_INTEGER,
65: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
66: p_chart_of_accounts_id IN
67: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
68: p_sob_id IN
69: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

Line 78: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

74: p_structure_name IN VARCHAR2,
75: p_structure_index IN BINARY_INTEGER,
76: p_condition_index IN BINARY_INTEGER,
77: p_zone_tbl OUT NOCOPY HZ_GEO_GET_PUB.zone_tbl_type,
78: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
79: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
80: p_return_status OUT NOCOPY VARCHAR2,
81: p_error_buffer OUT NOCOPY VARCHAR2);
82:

Line 88: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

84: PROCEDURE get_master_geography_info(
85: p_structure_name IN VARCHAR2,
86: p_structure_index IN BINARY_INTEGER,
87: p_condition_index IN BINARY_INTEGER,
88: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
89: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_error_buffer OUT NOCOPY VARCHAR2);
92:

Line 89: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

85: p_structure_name IN VARCHAR2,
86: p_structure_index IN BINARY_INTEGER,
87: p_condition_index IN BINARY_INTEGER,
88: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
89: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_error_buffer OUT NOCOPY VARCHAR2);
92:
93: /* Bugfix 3673395 - Since the list of Determining factors related

Line 104: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

100:
101: PROCEDURE get_tax_info_from_item(
102: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
103: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
104: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
105: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
106: p_return_status OUT NOCOPY VARCHAR2,
107: p_error_buffer OUT NOCOPY VARCHAR2);
108:

Line 105: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

101: PROCEDURE get_tax_info_from_item(
102: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
103: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
104: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
105: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
106: p_return_status OUT NOCOPY VARCHAR2,
107: p_error_buffer OUT NOCOPY VARCHAR2);
108:
109: PROCEDURE get_product_tax_info(

Line 112: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

108:
109: PROCEDURE get_product_tax_info(
110: p_structure_name IN VARCHAR2,
111: p_structure_index IN BINARY_INTEGER,
112: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
113: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
114: p_return_status OUT NOCOPY VARCHAR2,
115: p_error_buffer OUT NOCOPY VARCHAR2);
116:

Line 113: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

109: PROCEDURE get_product_tax_info(
110: p_structure_name IN VARCHAR2,
111: p_structure_index IN BINARY_INTEGER,
112: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
113: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
114: p_return_status OUT NOCOPY VARCHAR2,
115: p_error_buffer OUT NOCOPY VARCHAR2);
116:
117: PROCEDURE get_party_tax_info(

Line 120: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

116:
117: PROCEDURE get_party_tax_info(
118: p_structure_name IN VARCHAR2,
119: p_structure_index IN BINARY_INTEGER,
120: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
121: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
122: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
123: p_return_status OUT NOCOPY VARCHAR2,
124: p_error_buffer OUT NOCOPY VARCHAR2);

Line 121: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

117: PROCEDURE get_party_tax_info(
118: p_structure_name IN VARCHAR2,
119: p_structure_index IN BINARY_INTEGER,
120: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
121: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
122: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
123: p_return_status OUT NOCOPY VARCHAR2,
124: p_error_buffer OUT NOCOPY VARCHAR2);
125: */

Line 122: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

118: p_structure_name IN VARCHAR2,
119: p_structure_index IN BINARY_INTEGER,
120: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
121: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
122: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
123: p_return_status OUT NOCOPY VARCHAR2,
124: p_error_buffer OUT NOCOPY VARCHAR2);
125: */
126: PROCEDURE get_trx_value(

Line 134: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

130: p_condition_index IN BINARY_INTEGER,
131: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
132: p_tax IN ZX_TAXES_B.TAX%TYPE,
133: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
134: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
135: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
136: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
137: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
138: p_chart_of_accounts_id IN

Line 135: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

131: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
132: p_tax IN ZX_TAXES_B.TAX%TYPE,
133: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
134: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
135: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
136: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
137: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
138: p_chart_of_accounts_id IN
139: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

Line 136: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

132: p_tax IN ZX_TAXES_B.TAX%TYPE,
133: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
134: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
135: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
136: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
137: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
138: p_chart_of_accounts_id IN
139: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
140: p_sob_id IN

Line 137: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,

133: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
134: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
135: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
136: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
137: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
138: p_chart_of_accounts_id IN
139: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
140: p_sob_id IN
141: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

Line 151: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

147: p_structure_name IN VARCHAR2,
148: p_structure_index IN BINARY_INTEGER,
149: p_condition_index IN BINARY_INTEGER,
150: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
151: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
152: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
153: p_result IN OUT NOCOPY BOOLEAN,
154: p_return_status OUT NOCOPY VARCHAR2,
155: p_error_buffer OUT NOCOPY VARCHAR2);

Line 162: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

158: p_structure_name IN VARCHAR2,
159: p_structure_index IN BINARY_INTEGER,
160: p_condition_index IN BINARY_INTEGER,
161: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
162: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
163: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
164: p_return_status OUT NOCOPY VARCHAR2,
165: p_error_buffer OUT NOCOPY VARCHAR2);
166:

Line 163: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

159: p_structure_index IN BINARY_INTEGER,
160: p_condition_index IN BINARY_INTEGER,
161: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
162: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
163: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
164: p_return_status OUT NOCOPY VARCHAR2,
165: p_error_buffer OUT NOCOPY VARCHAR2);
166:
167: PROCEDURE get_user_item_alphanum_value(

Line 172: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

168: p_structure_name IN VARCHAR2,
169: p_structure_index IN BINARY_INTEGER,
170: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
171: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
172: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
173: p_return_status OUT NOCOPY VARCHAR2,
174: p_error_buffer OUT NOCOPY VARCHAR2);
175:
176: FUNCTION evaluate_date_condition(

Line 177: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

173: p_return_status OUT NOCOPY VARCHAR2,
174: p_error_buffer OUT NOCOPY VARCHAR2);
175:
176: FUNCTION evaluate_date_condition(
177: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
178: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
179: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
180: RETURN BOOLEAN;
181:

Line 178: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

174: p_error_buffer OUT NOCOPY VARCHAR2);
175:
176: FUNCTION evaluate_date_condition(
177: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
178: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
179: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
180: RETURN BOOLEAN;
181:
182: FUNCTION evaluate_numeric_condition(

Line 179: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)

175:
176: FUNCTION evaluate_date_condition(
177: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
178: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
179: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
180: RETURN BOOLEAN;
181:
182: FUNCTION evaluate_numeric_condition(
183: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

Line 183: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

179: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
180: RETURN BOOLEAN;
181:
182: FUNCTION evaluate_numeric_condition(
183: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
184: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
185: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
186: RETURN BOOLEAN;
187:

Line 184: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

180: RETURN BOOLEAN;
181:
182: FUNCTION evaluate_numeric_condition(
183: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
184: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
185: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
186: RETURN BOOLEAN;
187:
188: FUNCTION evaluate_alphanum_condition(

Line 185: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)

181:
182: FUNCTION evaluate_numeric_condition(
183: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
184: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
185: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
186: RETURN BOOLEAN;
187:
188: FUNCTION evaluate_alphanum_condition(
189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

Line 189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

185: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
186: RETURN BOOLEAN;
187:
188: FUNCTION evaluate_alphanum_condition(
189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

Line 190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

186: RETURN BOOLEAN;
187:
188: FUNCTION evaluate_alphanum_condition(
189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
194: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,

Line 191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

187:
188: FUNCTION evaluate_alphanum_condition(
189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
194: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
195: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)

Line 192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

188: FUNCTION evaluate_alphanum_condition(
189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
194: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
195: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
196: RETURN BOOLEAN;

Line 193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

189: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
190: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
191: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
192: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
193: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
194: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
195: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
196: RETURN BOOLEAN;
197:

Line 200: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

196: RETURN BOOLEAN;
197:
198: PROCEDURE evaluate_condition(
199: p_condition_index IN BINARY_INTEGER,
200: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
201: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
202: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
203: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
204: p_result OUT NOCOPY BOOLEAN,

Line 201: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

197:
198: PROCEDURE evaluate_condition(
199: p_condition_index IN BINARY_INTEGER,
200: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
201: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
202: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
203: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
204: p_result OUT NOCOPY BOOLEAN,
205: p_return_status OUT NOCOPY VARCHAR2,

Line 202: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

198: PROCEDURE evaluate_condition(
199: p_condition_index IN BINARY_INTEGER,
200: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
201: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
202: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
203: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
204: p_result OUT NOCOPY BOOLEAN,
205: p_return_status OUT NOCOPY VARCHAR2,
206: p_error_buffer OUT NOCOPY VARCHAR2);

Line 239: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,

235: PROCEDURE init_set_condition;
236:
237: PROCEDURE get_set_info (
238: p_index IN BINARY_INTEGER,
239: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

Line 240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

236:
237: PROCEDURE get_set_info (
238: p_index IN BINARY_INTEGER,
239: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

Line 241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,

237: PROCEDURE get_set_info (
238: p_index IN BINARY_INTEGER,
239: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

Line 242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,

238: p_index IN BINARY_INTEGER,
239: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

Line 243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

239: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

Line 244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

240: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

Line 245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

241: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
249: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE);

Line 246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

242: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
249: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE);
250:

Line 247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

243: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
249: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE);
250:
251: PROCEDURE process_set_condition (

Line 248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

244: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
249: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE);
250:
251: PROCEDURE process_set_condition (
252: p_structure_name IN VARCHAR2,

Line 249: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE);

245: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
246: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
247: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
248: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
249: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE);
250:
251: PROCEDURE process_set_condition (
252: p_structure_name IN VARCHAR2,
253: p_structure_index IN BINARY_INTEGER,

Line 3037: FROM ZX_CONDITIONS

3033: DATE_VALUE,
3034: ALPHANUMERIC_VALUE,
3035: VALUE_LOW,
3036: VALUE_HIGH
3037: FROM ZX_CONDITIONS
3038: WHERE CONDITION_GROUP_CODE = c_condition_group_code
3039: AND (Ignore_Flag <> 'Y' OR IGNORE_FLAG IS NULL);
3040:
3041:

Line 3162: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,

3158:
3159:
3160: PROCEDURE get_set_info (
3161: p_index IN BINARY_INTEGER,
3162: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,

Line 3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

3159:
3160: PROCEDURE get_set_info (
3161: p_index IN BINARY_INTEGER,
3162: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

Line 3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,

3160: PROCEDURE get_set_info (
3161: p_index IN BINARY_INTEGER,
3162: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

Line 3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,

3161: p_index IN BINARY_INTEGER,
3162: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

Line 3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,

3162: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

Line 3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

3163: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

Line 3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

3164: p_tax_parameter_code IN ZX_CONDITIONS.TAX_PARAMETER_CODE%TYPE,
3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
3172: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE)

Line 3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

3165: p_Data_Type_Code IN ZX_CONDITIONS.Data_Type_Code%TYPE,
3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
3172: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE)
3173: IS

Line 3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

3166: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
3172: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE)
3173: IS
3174: i BINARY_INTEGER;

Line 3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

3167: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
3172: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE)
3173: IS
3174: i BINARY_INTEGER;
3175:

Line 3172: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE)

3168: p_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3169: p_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
3170: p_alphanum_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3171: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
3172: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE)
3173: IS
3174: i BINARY_INTEGER;
3175:
3176: BEGIN

Line 3318: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;

3314: -- This procedure processes 1 condition record
3315: --
3316: l_count NUMBER;
3317: n BINARY_INTEGER;
3318: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3319: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3320: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3321: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3322: BEGIN

Line 3319: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;

3315: --
3316: l_count NUMBER;
3317: n BINARY_INTEGER;
3318: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3319: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3320: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3321: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3322: BEGIN
3323:

Line 3320: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

3316: l_count NUMBER;
3317: n BINARY_INTEGER;
3318: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3319: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3320: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3321: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3322: BEGIN
3323:
3324: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3321: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;

3317: n BINARY_INTEGER;
3318: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3319: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3320: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3321: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3322: BEGIN
3323:
3324: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3325:

Line 3566: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

3562: p_condition_index IN BINARY_INTEGER,
3563: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3564: p_tax IN ZX_TAXES_B.TAX%TYPE,
3565: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3566: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3567: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3568: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3569: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3570: p_chart_of_accounts_id IN

Line 3567: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

3563: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3564: p_tax IN ZX_TAXES_B.TAX%TYPE,
3565: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3566: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3567: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3568: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3569: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3570: p_chart_of_accounts_id IN
3571: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

Line 3568: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

3564: p_tax IN ZX_TAXES_B.TAX%TYPE,
3565: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3566: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3567: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3568: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3569: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3570: p_chart_of_accounts_id IN
3571: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3572: p_sob_id IN

Line 3569: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,

3565: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3566: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3567: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3568: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3569: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3570: p_chart_of_accounts_id IN
3571: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3572: p_sob_id IN
3573: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

Line 3868: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

3864: p_structure_name IN VARCHAR2,
3865: p_structure_index IN BINARY_INTEGER,
3866: p_condition_index IN BINARY_INTEGER,
3867: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3868: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3869: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3870: p_result IN OUT NOCOPY BOOLEAN,
3871: p_return_status OUT NOCOPY VARCHAR2,
3872: p_error_buffer OUT NOCOPY VARCHAR2)

Line 3876: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

3872: p_error_buffer OUT NOCOPY VARCHAR2)
3873: IS
3874: i BINARY_INTEGER;
3875: j BINARY_INTEGER;
3876: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3877: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3878:
3879: l_count NUMBER;
3880: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;

Line 3877: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;

3873: IS
3874: i BINARY_INTEGER;
3875: j BINARY_INTEGER;
3876: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3877: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3878:
3879: l_count NUMBER;
3880: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;
3881: BEGIN

Line 4028: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

4024: PROCEDURE get_tsrm_parameter_value(
4025: p_structure_name IN VARCHAR2,
4026: p_structure_index IN BINARY_INTEGER,
4027: p_condition_index IN BINARY_INTEGER,
4028: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4029: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4030: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4031: p_return_status OUT NOCOPY VARCHAR2,
4032: p_error_buffer OUT NOCOPY VARCHAR2)

Line 4029: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

4025: p_structure_name IN VARCHAR2,
4026: p_structure_index IN BINARY_INTEGER,
4027: p_condition_index IN BINARY_INTEGER,
4028: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4029: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4030: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4031: p_return_status OUT NOCOPY VARCHAR2,
4032: p_error_buffer OUT NOCOPY VARCHAR2)
4033: IS

Line 4030: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,

4026: p_structure_index IN BINARY_INTEGER,
4027: p_condition_index IN BINARY_INTEGER,
4028: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4029: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4030: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4031: p_return_status OUT NOCOPY VARCHAR2,
4032: p_error_buffer OUT NOCOPY VARCHAR2)
4033: IS
4034: i BINARY_INTEGER;

Line 4146: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

4142: PROCEDURE get_tsrm_num_value(
4143: p_structure_name IN VARCHAR2,
4144: p_structure_index IN BINARY_INTEGER,
4145: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4146: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4147: p_return_status OUT NOCOPY VARCHAR2,
4148: p_error_buffer OUT NOCOPY VARCHAR2)
4149: IS
4150: --l_table_index NUMBER;

Line 4230: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

4226: PROCEDURE get_tsrm_alphanum_value(
4227: p_structure_name IN VARCHAR2,
4228: p_structure_index IN BINARY_INTEGER,
4229: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4230: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4231: p_return_status OUT NOCOPY VARCHAR2,
4232: p_error_buffer OUT NOCOPY VARCHAR2)
4233: IS
4234: --l_table_index NUMBER;

Line 4314: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

4310: PROCEDURE get_account_num_value(
4311: p_structure_name IN VARCHAR2,
4312: p_structure_index IN BINARY_INTEGER,
4313: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4314: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4315: p_return_status OUT NOCOPY VARCHAR2,
4316: p_error_buffer OUT NOCOPY VARCHAR2)
4317: IS
4318: l_table_index NUMBER;

Line 4399: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

4395: PROCEDURE get_account_alphanum_value(
4396: p_structure_name IN VARCHAR2,
4397: p_structure_index IN BINARY_INTEGER,
4398: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4399: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4400: p_return_status OUT NOCOPY VARCHAR2,
4401: p_error_buffer OUT NOCOPY VARCHAR2)
4402: IS
4403: l_table_index NUMBER;

Line 4487: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

4483: p_structure_name IN VARCHAR2,
4484: p_structure_index IN BINARY_INTEGER,
4485: p_condition_index IN BINARY_INTEGER,
4486: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4487: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4488: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4489: p_return_status OUT NOCOPY VARCHAR2,
4490: p_error_buffer OUT NOCOPY VARCHAR2)
4491: IS

Line 4488: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

4484: p_structure_index IN BINARY_INTEGER,
4485: p_condition_index IN BINARY_INTEGER,
4486: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4487: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4488: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4489: p_return_status OUT NOCOPY VARCHAR2,
4490: p_error_buffer OUT NOCOPY VARCHAR2)
4491: IS
4492: i BINARY_INTEGER;

Line 4572: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

4568: p_structure_name IN VARCHAR2,
4569: p_structure_index IN BINARY_INTEGER,
4570: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4571: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4572: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4573: p_return_status OUT NOCOPY VARCHAR2,
4574: p_error_buffer OUT NOCOPY VARCHAR2)
4575: IS
4576: l_table_index NUMBER;

Line 4577: l_trx_alphanumeric_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

4573: p_return_status OUT NOCOPY VARCHAR2,
4574: p_error_buffer OUT NOCOPY VARCHAR2)
4575: IS
4576: l_table_index NUMBER;
4577: l_trx_alphanumeric_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
4578: l_in_cache_flg BOOLEAN := FALSE;
4579:
4580: BEGIN
4581:

Line 4665: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

4661: p_condition_index IN BINARY_INTEGER,
4662: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
4663: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
4664: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4665: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4666: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
4667: p_return_status OUT NOCOPY VARCHAR2,
4668: p_error_buffer OUT NOCOPY VARCHAR2)
4669:

Line 4666: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

4662: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
4663: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
4664: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4665: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4666: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
4667: p_return_status OUT NOCOPY VARCHAR2,
4668: p_error_buffer OUT NOCOPY VARCHAR2)
4669:
4670: IS

Line 4682: l_prod_trx_parm_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

4678: l_classified_entity_id NUMBER;
4679: l_item_org_id NUMBER;
4680: l_le_id NUMBER;
4681: l_length NUMBER;
4682: l_prod_trx_parm_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
4683: l_fsc_rec ZX_TCM_CONTROL_PKG.ZX_FISCAL_CLASS_INFO_REC;
4684: l_fsc_cat_rec ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC;
4685: i BINARY_INTEGER;
4686: j BINARY_INTEGER;

Line 4689: l_condition_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

4685: i BINARY_INTEGER;
4686: j BINARY_INTEGER;
4687: l_classification_category ZX_FC_TYPES_B.Classification_Type_Categ_Code%TYPE;
4688: l_classification_type ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;
4689: l_condition_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
4690:
4691: l_fc_base_category_set_id zx_fc_types_b.owner_id_num%TYPE;
4692: l_fc_level zx_fc_types_b.classification_type_level_code%TYPE;
4693: l_level_start_position zx_fc_types_b.start_position%TYPE;

Line 5567: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

5563: p_structure_name IN VARCHAR2,
5564: p_structure_index IN BINARY_INTEGER,
5565: p_condition_index IN BINARY_INTEGER,
5566: p_zone_tbl OUT NOCOPY HZ_GEO_GET_PUB.zone_tbl_type,
5567: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5568: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5569: p_return_status OUT NOCOPY VARCHAR2,
5570: p_error_buffer OUT NOCOPY VARCHAR2)
5571: IS

Line 5680: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

5676: PROCEDURE get_master_geography_info(
5677: p_structure_name IN VARCHAR2,
5678: p_structure_index IN BINARY_INTEGER,
5679: p_condition_index IN BINARY_INTEGER,
5680: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
5681: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5682: p_return_status OUT NOCOPY VARCHAR2,
5683: p_error_buffer OUT NOCOPY VARCHAR2)
5684: IS

Line 5681: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

5677: p_structure_name IN VARCHAR2,
5678: p_structure_index IN BINARY_INTEGER,
5679: p_condition_index IN BINARY_INTEGER,
5680: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
5681: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5682: p_return_status OUT NOCOPY VARCHAR2,
5683: p_error_buffer OUT NOCOPY VARCHAR2)
5684: IS
5685: l_location_id NUMBER;

Line 5797: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

5793: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5794: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5795: p_tax IN ZX_TAXES_B.TAX%TYPE,
5796: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5797: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
5798: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5799: p_return_status OUT NOCOPY VARCHAR2,
5800: p_error_buffer OUT NOCOPY VARCHAR2)
5801: IS

Line 5798: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

5794: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5795: p_tax IN ZX_TAXES_B.TAX%TYPE,
5796: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5797: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
5798: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5799: p_return_status OUT NOCOPY VARCHAR2,
5800: p_error_buffer OUT NOCOPY VARCHAR2)
5801: IS
5802: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;

Line 5889: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

5885: PROCEDURE get_account_flexfield_info(
5886: p_structure_name IN VARCHAR2,
5887: p_structure_index IN BINARY_INTEGER,
5888: p_condition_index IN BINARY_INTEGER,
5889: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
5890: p_chart_of_accounts_id IN
5891: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
5892: p_sob_id IN
5893: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

Line 6171: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

6167:
6168: PROCEDURE get_product_tax_info(
6169: p_structure_name IN VARCHAR2,
6170: p_structure_index IN BINARY_INTEGER,
6171: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6172: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6173: p_return_status OUT NOCOPY VARCHAR2,
6174: p_error_buffer OUT NOCOPY VARCHAR2)
6175:

Line 6172: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

6168: PROCEDURE get_product_tax_info(
6169: p_structure_name IN VARCHAR2,
6170: p_structure_index IN BINARY_INTEGER,
6171: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6172: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6173: p_return_status OUT NOCOPY VARCHAR2,
6174: p_error_buffer OUT NOCOPY VARCHAR2)
6175:
6176: IS

Line 6282: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

6278:
6279: PROCEDURE get_tax_info_from_item(
6280: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6281: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6282: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6283: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6284: p_return_status OUT NOCOPY VARCHAR2,
6285: p_error_buffer OUT NOCOPY VARCHAR2)
6286:

Line 6283: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

6279: PROCEDURE get_tax_info_from_item(
6280: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6281: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6282: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6283: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6284: p_return_status OUT NOCOPY VARCHAR2,
6285: p_error_buffer OUT NOCOPY VARCHAR2)
6286:
6287: IS

Line 6357: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

6353:
6354: PROCEDURE get_party_tax_info(
6355: p_structure_name IN VARCHAR2,
6356: p_structure_index IN BINARY_INTEGER,
6357: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6358: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6359: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6360: p_return_status OUT NOCOPY VARCHAR2,
6361: p_error_buffer OUT NOCOPY VARCHAR2)

Line 6358: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

6354: PROCEDURE get_party_tax_info(
6355: p_structure_name IN VARCHAR2,
6356: p_structure_index IN BINARY_INTEGER,
6357: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6358: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6359: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6360: p_return_status OUT NOCOPY VARCHAR2,
6361: p_error_buffer OUT NOCOPY VARCHAR2)
6362:

Line 6359: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

6355: p_structure_name IN VARCHAR2,
6356: p_structure_index IN BINARY_INTEGER,
6357: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6358: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6359: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6360: p_return_status OUT NOCOPY VARCHAR2,
6361: p_error_buffer OUT NOCOPY VARCHAR2)
6362:
6363: IS

Line 6449: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

6445: --
6446:
6447: PROCEDURE evaluate_condition(
6448: p_condition_index IN BINARY_INTEGER,
6449: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6450: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6451: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
6452: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6453: p_result OUT NOCOPY BOOLEAN,

Line 6450: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

6446:
6447: PROCEDURE evaluate_condition(
6448: p_condition_index IN BINARY_INTEGER,
6449: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6450: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6451: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
6452: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6453: p_result OUT NOCOPY BOOLEAN,
6454: p_return_status OUT NOCOPY VARCHAR2,

Line 6451: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

6447: PROCEDURE evaluate_condition(
6448: p_condition_index IN BINARY_INTEGER,
6449: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6450: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6451: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
6452: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6453: p_result OUT NOCOPY BOOLEAN,
6454: p_return_status OUT NOCOPY VARCHAR2,
6455: p_error_buffer OUT NOCOPY VARCHAR2)

Line 6964: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE)

6960: p_classified_entity_id IN
6961: ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
6962: p_item_org_id IN NUMBER,
6963: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6964: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE)
6965:
6966: IS
6967: l_count NUMBER;
6968: l_fsc_tbl ZX_TCM_CONTROL_PKG.zx_fsc_class_info_cache;

Line 7240: zx_conditions zc

7236: AND param.tax_parameter_code = dtl.tax_parameter_code
7237: AND NOT EXISTS
7238: (SELECT 1
7239: FROM zx_condition_groups_b zcg,
7240: zx_conditions zc
7241: WHERE zcg.det_factor_templ_code = c_det_factor_templ_cd
7242: AND zcg.enabled_flag = 'Y'
7243: AND zc.condition_group_code = zcg.condition_group_code
7244: AND zc.determining_factor_code = dtl.determining_factor_code

Line 7497: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,

7493: -- value cache structure
7494: --
7495:
7496: FUNCTION get_trx_value_index(
7497: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
7498: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
7499: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
7500: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
7501: RETURN BINARY_INTEGER IS

Line 7498: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,

7494: --
7495:
7496: FUNCTION get_trx_value_index(
7497: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
7498: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
7499: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
7500: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
7501: RETURN BINARY_INTEGER IS
7502: l_count NUMBER;

Line 7499: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

7495:
7496: FUNCTION get_trx_value_index(
7497: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
7498: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
7499: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
7500: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
7501: RETURN BINARY_INTEGER IS
7502: l_count NUMBER;
7503: l_tbl_index BINARY_INTEGER;

Line 7500: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )

7496: FUNCTION get_trx_value_index(
7497: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
7498: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
7499: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
7500: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
7501: RETURN BINARY_INTEGER IS
7502: l_count NUMBER;
7503: l_tbl_index BINARY_INTEGER;
7504: cache_delim CONSTANT VARCHAR2(03) := '|$|';

Line 7557: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

7553: -- The procedure is to evaluate condition value of alphanumeric data type
7554: --
7555:
7556: FUNCTION evaluate_alphanum_condition(
7557: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

Line 7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

7554: --
7555:
7556: FUNCTION evaluate_alphanum_condition(
7557: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
7562: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,

Line 7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

7555:
7556: FUNCTION evaluate_alphanum_condition(
7557: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
7562: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7563: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)

Line 7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

7556: FUNCTION evaluate_alphanum_condition(
7557: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
7562: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7563: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
7564: RETURN BOOLEAN IS

Line 7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

7557: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7558: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7559: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7560: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
7562: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7563: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
7564: RETURN BOOLEAN IS
7565: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

Line 7565: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

7561: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
7562: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7563: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
7564: RETURN BOOLEAN IS
7565: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
7566: -- Start : Added for Bug#7412888 by ssohal
7567: TYPE var_tbl IS TABLE OF VARCHAR(150) INDEX BY BINARY_INTEGER;
7568:
7569: trx_acc var_tbl;

Line 7728: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

7724: -- The procedure is to evaluate condition value of numeric data type
7725: --
7726:
7727: FUNCTION evaluate_numeric_condition(
7728: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7729: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
7730: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
7731: RETURN BOOLEAN IS
7732: BEGIN

Line 7729: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

7725: --
7726:
7727: FUNCTION evaluate_numeric_condition(
7728: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7729: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
7730: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
7731: RETURN BOOLEAN IS
7732: BEGIN
7733: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7730: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)

7726:
7727: FUNCTION evaluate_numeric_condition(
7728: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7729: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
7730: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
7731: RETURN BOOLEAN IS
7732: BEGIN
7733: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7734:

Line 7823: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

7819: -- The procedure is to evaluate condition value of date data type
7820: --
7821:
7822: FUNCTION evaluate_date_condition(
7823: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7824: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
7825: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
7826: RETURN BOOLEAN IS
7827: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;

Line 7824: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

7820: --
7821:
7822: FUNCTION evaluate_date_condition(
7823: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7824: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
7825: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
7826: RETURN BOOLEAN IS
7827: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7828: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;

Line 7825: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)

7821:
7822: FUNCTION evaluate_date_condition(
7823: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7824: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
7825: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
7826: RETURN BOOLEAN IS
7827: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7828: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7829: BEGIN

Line 7827: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;

7823: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
7824: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
7825: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
7826: RETURN BOOLEAN IS
7827: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7828: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7829: BEGIN
7830:
7831: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7828: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;

7824: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
7825: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
7826: RETURN BOOLEAN IS
7827: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7828: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;
7829: BEGIN
7830:
7831: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7832:

Line 7926: p_det_fact_cq_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CQ_CODE%TYPE)

7922: -- or not for the input event class
7923: --
7924:
7925: FUNCTION evaluate_if_first_party(
7926: p_det_fact_cq_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CQ_CODE%TYPE)
7927: RETURN BOOLEAN IS
7928:
7929: BEGIN
7930: