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 29: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

25: ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
26: p_item_org_id IN NUMBER,
27: p_application_id IN NUMBER,
28: p_event_class_code IN VARCHAR2,
29: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
30: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE);
31:
32: PROCEDURE get_fc(
33: p_structure_name IN VARCHAR2,

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

26: p_item_org_id IN NUMBER,
27: p_application_id IN NUMBER,
28: p_event_class_code IN VARCHAR2,
29: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
30: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE);
31:
32: PROCEDURE get_fc(
33: p_structure_name IN VARCHAR2,
34: p_structure_index IN BINARY_INTEGER,

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

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

Line 40: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

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

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

Line 52: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

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

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

Line 80: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

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

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

Line 91: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

Line 106: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

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

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

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

Line 114: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

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

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

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

Line 122: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

Line 123: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

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

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

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

Line 136: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

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

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

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

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

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

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

Line 153: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

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

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

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

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

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

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

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

Line 179: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

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

Line 180: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

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

Line 181: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)

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

Line 185: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

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

Line 186: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

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

Line 187: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)

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

Line 191: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

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

Line 192: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

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

Line 193: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

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

Line 194: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

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

Line 195: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

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

Line 202: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

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

Line 203: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

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

Line 204: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

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

Line 3280: FROM ZX_CONDITIONS

3276: DATE_VALUE,
3277: ALPHANUMERIC_VALUE,
3278: VALUE_LOW,
3279: VALUE_HIGH
3280: FROM ZX_CONDITIONS
3281: WHERE CONDITION_GROUP_CODE = c_condition_group_code
3282: AND (Ignore_Flag <> 'Y' OR IGNORE_FLAG IS NULL);
3283:
3284:

Line 3656: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;

3652: -- This procedure processes 1 condition record
3653: --
3654: l_count NUMBER;
3655: n BINARY_INTEGER;
3656: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3657: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3658: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3659: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3660:

Line 3657: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;

3653: --
3654: l_count NUMBER;
3655: n BINARY_INTEGER;
3656: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3657: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3658: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3659: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3660:
3661: cursor get_acct_segment_num( n number) is

Line 3658: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

3654: l_count NUMBER;
3655: n BINARY_INTEGER;
3656: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3657: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3658: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3659: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3660:
3661: cursor get_acct_segment_num( n number) is
3662: select segment_num

Line 3659: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;

3655: n BINARY_INTEGER;
3656: l_Determining_Factor_Cq_Code ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE;
3657: l_trx_numeric_value ZX_CONDITIONS.NUMERIC_VALUE%TYPE;
3658: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
3659: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
3660:
3661: cursor get_acct_segment_num( n number) is
3662: select segment_num
3663: from fnd_id_flex_segments

Line 3915: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

3911: p_condition_index IN BINARY_INTEGER,
3912: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3913: p_tax IN ZX_TAXES_B.TAX%TYPE,
3914: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3915: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3916: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3917: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3918: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3919: p_chart_of_accounts_id IN

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

3912: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3913: p_tax IN ZX_TAXES_B.TAX%TYPE,
3914: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3915: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3916: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3917: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3918: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3919: p_chart_of_accounts_id IN
3920: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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

3913: p_tax IN ZX_TAXES_B.TAX%TYPE,
3914: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3915: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3916: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3917: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3918: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3919: p_chart_of_accounts_id IN
3920: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3921: p_sob_id IN

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

3914: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3915: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3916: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3917: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3918: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
3919: p_chart_of_accounts_id IN
3920: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3921: p_sob_id IN
3922: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

Line 4215: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

4211: p_structure_name IN VARCHAR2,
4212: p_structure_index IN BINARY_INTEGER,
4213: p_condition_index IN BINARY_INTEGER,
4214: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
4215: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
4216: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
4217: p_result IN OUT NOCOPY BOOLEAN,
4218: p_return_status OUT NOCOPY VARCHAR2,
4219: p_error_buffer OUT NOCOPY VARCHAR2)

Line 4223: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

4219: p_error_buffer OUT NOCOPY VARCHAR2)
4220: IS
4221: i BINARY_INTEGER;
4222: j BINARY_INTEGER;
4223: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
4224: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
4225:
4226: l_count NUMBER;
4227: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;

Line 4224: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;

4220: IS
4221: i BINARY_INTEGER;
4222: j BINARY_INTEGER;
4223: l_trx_alphanum_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
4224: l_trx_date_value ZX_CONDITIONS.DATE_VALUE%TYPE;
4225:
4226: l_count NUMBER;
4227: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;
4228: BEGIN

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

4369: PROCEDURE get_tsrm_parameter_value(
4370: p_structure_name IN VARCHAR2,
4371: p_structure_index IN BINARY_INTEGER,
4372: p_condition_index IN BINARY_INTEGER,
4373: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4374: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4375: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4376: p_return_status OUT NOCOPY VARCHAR2,
4377: p_error_buffer OUT NOCOPY VARCHAR2)

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

4370: p_structure_name IN VARCHAR2,
4371: p_structure_index IN BINARY_INTEGER,
4372: p_condition_index IN BINARY_INTEGER,
4373: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4374: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4375: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4376: p_return_status OUT NOCOPY VARCHAR2,
4377: p_error_buffer OUT NOCOPY VARCHAR2)
4378: IS

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

4371: p_structure_index IN BINARY_INTEGER,
4372: p_condition_index IN BINARY_INTEGER,
4373: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4374: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4375: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4376: p_return_status OUT NOCOPY VARCHAR2,
4377: p_error_buffer OUT NOCOPY VARCHAR2)
4378: IS
4379: i BINARY_INTEGER;

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

4485: PROCEDURE get_tsrm_num_value(
4486: p_structure_name IN VARCHAR2,
4487: p_structure_index IN BINARY_INTEGER,
4488: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4489: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4490: p_return_status OUT NOCOPY VARCHAR2,
4491: p_error_buffer OUT NOCOPY VARCHAR2)
4492: IS
4493: --l_table_index NUMBER;

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

4569: PROCEDURE get_tsrm_alphanum_value(
4570: p_structure_name IN VARCHAR2,
4571: p_structure_index IN BINARY_INTEGER,
4572: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4573: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4574: p_return_status OUT NOCOPY VARCHAR2,
4575: p_error_buffer OUT NOCOPY VARCHAR2)
4576: IS
4577: --l_table_index NUMBER;

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

4653: PROCEDURE get_account_num_value(
4654: p_structure_name IN VARCHAR2,
4655: p_structure_index IN BINARY_INTEGER,
4656: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4657: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4658: p_return_status OUT NOCOPY VARCHAR2,
4659: p_error_buffer OUT NOCOPY VARCHAR2)
4660: IS
4661: l_table_index NUMBER;

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

4738: PROCEDURE get_account_alphanum_value(
4739: p_structure_name IN VARCHAR2,
4740: p_structure_index IN BINARY_INTEGER,
4741: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4742: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4743: p_return_status OUT NOCOPY VARCHAR2,
4744: p_error_buffer OUT NOCOPY VARCHAR2)
4745: IS
4746: l_table_index NUMBER;

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

4826: p_structure_name IN VARCHAR2,
4827: p_structure_index IN BINARY_INTEGER,
4828: p_condition_index IN BINARY_INTEGER,
4829: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4830: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4831: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4832: p_return_status OUT NOCOPY VARCHAR2,
4833: p_error_buffer OUT NOCOPY VARCHAR2)
4834: IS

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

4827: p_structure_index IN BINARY_INTEGER,
4828: p_condition_index IN BINARY_INTEGER,
4829: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4830: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4831: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4832: p_return_status OUT NOCOPY VARCHAR2,
4833: p_error_buffer OUT NOCOPY VARCHAR2)
4834: IS
4835: i BINARY_INTEGER;

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

4909: p_structure_name IN VARCHAR2,
4910: p_structure_index IN BINARY_INTEGER,
4911: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4912: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4913: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4914: p_return_status OUT NOCOPY VARCHAR2,
4915: p_error_buffer OUT NOCOPY VARCHAR2)
4916: IS
4917: l_table_index NUMBER;

Line 4918: l_trx_alphanumeric_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

4914: p_return_status OUT NOCOPY VARCHAR2,
4915: p_error_buffer OUT NOCOPY VARCHAR2)
4916: IS
4917: l_table_index NUMBER;
4918: l_trx_alphanumeric_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
4919: l_in_cache_flg BOOLEAN := FALSE;
4920:
4921: BEGIN
4922:

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

5002: p_condition_index IN BINARY_INTEGER,
5003: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5004: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5005: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5006: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
5007: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5008: p_return_status OUT NOCOPY VARCHAR2,
5009: p_error_buffer OUT NOCOPY VARCHAR2)
5010:

Line 5007: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

5003: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5004: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5005: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5006: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
5007: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5008: p_return_status OUT NOCOPY VARCHAR2,
5009: p_error_buffer OUT NOCOPY VARCHAR2)
5010:
5011: IS

Line 5023: l_prod_trx_parm_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

5019: l_classified_entity_id NUMBER;
5020: l_item_org_id NUMBER;
5021: l_le_id NUMBER;
5022: l_length NUMBER;
5023: l_prod_trx_parm_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
5024: l_fsc_rec ZX_TCM_CONTROL_PKG.ZX_FISCAL_CLASS_INFO_REC;
5025: l_fsc_cat_rec ZX_TCM_CONTROL_PKG.ZX_CATEGORY_CODE_INFO_REC;
5026: i BINARY_INTEGER;
5027: j BINARY_INTEGER;

Line 5030: l_condition_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

5026: i BINARY_INTEGER;
5027: j BINARY_INTEGER;
5028: l_classification_category ZX_FC_TYPES_B.Classification_Type_Categ_Code%TYPE;
5029: l_classification_type ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;
5030: l_condition_value ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
5031:
5032: l_fc_base_category_set_id zx_fc_types_b.owner_id_num%TYPE;
5033: l_fc_level zx_fc_types_b.classification_type_level_code%TYPE;
5034: l_level_start_position zx_fc_types_b.start_position%TYPE;

Line 6014: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

6010: p_structure_name IN VARCHAR2,
6011: p_structure_index IN BINARY_INTEGER,
6012: p_condition_index IN BINARY_INTEGER,
6013: p_zone_tbl OUT NOCOPY HZ_GEO_GET_PUB.zone_tbl_type,
6014: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6015: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
6016: p_return_status OUT NOCOPY VARCHAR2,
6017: p_error_buffer OUT NOCOPY VARCHAR2)
6018: IS

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

6128: PROCEDURE get_master_geography_info(
6129: p_structure_name IN VARCHAR2,
6130: p_structure_index IN BINARY_INTEGER,
6131: p_condition_index IN BINARY_INTEGER,
6132: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6133: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6134: p_return_status OUT NOCOPY VARCHAR2,
6135: p_error_buffer OUT NOCOPY VARCHAR2)
6136: IS

Line 6133: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

6129: p_structure_name IN VARCHAR2,
6130: p_structure_index IN BINARY_INTEGER,
6131: p_condition_index IN BINARY_INTEGER,
6132: p_trx_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6133: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6134: p_return_status OUT NOCOPY VARCHAR2,
6135: p_error_buffer OUT NOCOPY VARCHAR2)
6136: IS
6137: l_location_id NUMBER;

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

6244: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6245: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
6246: p_tax IN ZX_TAXES_B.TAX%TYPE,
6247: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
6248: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6249: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6250: p_return_status OUT NOCOPY VARCHAR2,
6251: p_error_buffer OUT NOCOPY VARCHAR2)
6252: IS

Line 6249: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

6245: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
6246: p_tax IN ZX_TAXES_B.TAX%TYPE,
6247: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
6248: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6249: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6250: p_return_status OUT NOCOPY VARCHAR2,
6251: p_error_buffer OUT NOCOPY VARCHAR2)
6252: IS
6253: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;

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

6336: PROCEDURE get_account_flexfield_info(
6337: p_structure_name IN VARCHAR2,
6338: p_structure_index IN BINARY_INTEGER,
6339: p_condition_index IN BINARY_INTEGER,
6340: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6341: p_chart_of_accounts_id IN
6342: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6343: p_sob_id IN
6344: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

Line 6624: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

6620:
6621: PROCEDURE get_product_tax_info(
6622: p_structure_name IN VARCHAR2,
6623: p_structure_index IN BINARY_INTEGER,
6624: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6625: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6626: p_return_status OUT NOCOPY VARCHAR2,
6627: p_error_buffer OUT NOCOPY VARCHAR2)
6628:

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

6621: PROCEDURE get_product_tax_info(
6622: p_structure_name IN VARCHAR2,
6623: p_structure_index IN BINARY_INTEGER,
6624: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6625: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6626: p_return_status OUT NOCOPY VARCHAR2,
6627: p_error_buffer OUT NOCOPY VARCHAR2)
6628:
6629: IS

Line 6735: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

6731:
6732: PROCEDURE get_tax_info_from_item(
6733: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6734: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6735: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6736: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6737: p_return_status OUT NOCOPY VARCHAR2,
6738: p_error_buffer OUT NOCOPY VARCHAR2)
6739:

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

6732: PROCEDURE get_tax_info_from_item(
6733: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6734: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6735: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6736: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6737: p_return_status OUT NOCOPY VARCHAR2,
6738: p_error_buffer OUT NOCOPY VARCHAR2)
6739:
6740: IS

Line 6808: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

6804:
6805: PROCEDURE get_party_tax_info(
6806: p_structure_name IN VARCHAR2,
6807: p_structure_index IN BINARY_INTEGER,
6808: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6809: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6810: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6811: p_return_status OUT NOCOPY VARCHAR2,
6812: p_error_buffer OUT NOCOPY VARCHAR2)

Line 6809: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,

6805: PROCEDURE get_party_tax_info(
6806: p_structure_name IN VARCHAR2,
6807: p_structure_index IN BINARY_INTEGER,
6808: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6809: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6810: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6811: p_return_status OUT NOCOPY VARCHAR2,
6812: p_error_buffer OUT NOCOPY VARCHAR2)
6813:

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

6806: p_structure_name IN VARCHAR2,
6807: p_structure_index IN BINARY_INTEGER,
6808: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6809: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6810: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6811: p_return_status OUT NOCOPY VARCHAR2,
6812: p_error_buffer OUT NOCOPY VARCHAR2)
6813:
6814: IS

Line 6898: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

6894: --
6895:
6896: PROCEDURE evaluate_condition(
6897: p_condition_index IN BINARY_INTEGER,
6898: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6899: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6900: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
6901: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6902: p_result OUT NOCOPY BOOLEAN,

Line 6899: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

6895:
6896: PROCEDURE evaluate_condition(
6897: p_condition_index IN BINARY_INTEGER,
6898: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6899: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6900: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
6901: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6902: p_result OUT NOCOPY BOOLEAN,
6903: p_return_status OUT NOCOPY VARCHAR2,

Line 6900: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

6896: PROCEDURE evaluate_condition(
6897: p_condition_index IN BINARY_INTEGER,
6898: p_trx_alphanumeric_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6899: p_trx_numeric_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
6900: p_trx_date_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
6901: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6902: p_result OUT NOCOPY BOOLEAN,
6903: p_return_status OUT NOCOPY VARCHAR2,
6904: p_error_buffer OUT NOCOPY VARCHAR2)

Line 7426: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

7422: ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
7423: p_item_org_id IN NUMBER,
7424: p_application_id IN NUMBER,
7425: p_event_class_code IN VARCHAR2,
7426: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7427: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE)
7428:
7429: IS
7430: l_count NUMBER;

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

7423: p_item_org_id IN NUMBER,
7424: p_application_id IN NUMBER,
7425: p_event_class_code IN VARCHAR2,
7426: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
7427: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE)
7428:
7429: IS
7430: l_count NUMBER;
7431: l_search_pointer NUMBER;

Line 7772: zx_conditions zc

7768: AND param.tax_parameter_code = dtl.tax_parameter_code
7769: AND NOT EXISTS
7770: (SELECT /*+ FIRST_ROWS (1) */ 1
7771: FROM zx_condition_groups_b zcg,
7772: zx_conditions zc
7773: WHERE zcg.det_factor_templ_code = c_det_factor_templ_cd
7774: AND zcg.enabled_flag = 'Y'
7775: AND zc.condition_group_code = zcg.condition_group_code
7776: AND zc.determining_factor_code = dtl.determining_factor_code

Line 8026: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,

8022: -- value cache structure
8023: --
8024:
8025: FUNCTION get_trx_value_index(
8026: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
8027: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
8028: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
8029: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
8030: RETURN BINARY_INTEGER IS

Line 8027: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,

8023: --
8024:
8025: FUNCTION get_trx_value_index(
8026: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
8027: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
8028: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
8029: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
8030: RETURN BINARY_INTEGER IS
8031: l_count NUMBER;

Line 8028: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,

8024:
8025: FUNCTION get_trx_value_index(
8026: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
8027: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
8028: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
8029: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
8030: RETURN BINARY_INTEGER IS
8031: l_count NUMBER;
8032: l_tbl_index BINARY_INTEGER;

Line 8029: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )

8025: FUNCTION get_trx_value_index(
8026: p_Det_Factor_Class_Code IN ZX_CONDITIONS.Determining_Factor_Class_Code%TYPE,
8027: p_determining_factor_code IN ZX_CONDITIONS.determining_factor_code%TYPE,
8028: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
8029: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE )
8030: RETURN BINARY_INTEGER IS
8031: l_count NUMBER;
8032: l_tbl_index BINARY_INTEGER;
8033: cache_delim CONSTANT VARCHAR2(03) := '|$|';

Line 8086: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

8082: -- The procedure is to evaluate condition value of alphanumeric data type
8083: --
8084:
8085: FUNCTION evaluate_alphanum_condition(
8086: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

Line 8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

8083: --
8084:
8085: FUNCTION evaluate_alphanum_condition(
8086: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
8091: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,

Line 8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,

8084:
8085: FUNCTION evaluate_alphanum_condition(
8086: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
8091: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
8092: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)

Line 8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,

8085: FUNCTION evaluate_alphanum_condition(
8086: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
8091: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
8092: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
8093: RETURN BOOLEAN IS

Line 8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,

8086: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8087: p_condition_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8088: p_trx_value IN ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
8089: p_value_low IN ZX_CONDITIONS.VALUE_LOW%TYPE,
8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
8091: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
8092: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
8093: RETURN BOOLEAN IS
8094: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

Line 8094: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;

8090: p_value_high IN ZX_CONDITIONS.VALUE_HIGH%TYPE,
8091: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
8092: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE)
8093: RETURN BOOLEAN IS
8094: l_str ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE;
8095:
8096: l_segments_trx FND_FLEX_EXT.SEGMENTARRAY;
8097: l_segments_low FND_FLEX_EXT.SEGMENTARRAY;
8098: l_segments_high FND_FLEX_EXT.SEGMENTARRAY;

Line 8273: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

8269: -- The procedure is to evaluate condition value of numeric data type
8270: --
8271:
8272: FUNCTION evaluate_numeric_condition(
8273: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8274: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
8275: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
8276: RETURN BOOLEAN IS
8277: BEGIN

Line 8274: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,

8270: --
8271:
8272: FUNCTION evaluate_numeric_condition(
8273: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8274: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
8275: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
8276: RETURN BOOLEAN IS
8277: BEGIN
8278:

Line 8275: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)

8271:
8272: FUNCTION evaluate_numeric_condition(
8273: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8274: p_condition_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
8275: p_trx_value IN ZX_CONDITIONS.NUMERIC_VALUE%TYPE)
8276: RETURN BOOLEAN IS
8277: BEGIN
8278:
8279: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 8386: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,

8382: -- The procedure is to evaluate condition value of date data type
8383: --
8384:
8385: FUNCTION evaluate_date_condition(
8386: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8387: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
8388: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
8389: RETURN BOOLEAN IS
8390: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;

Line 8387: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,

8383: --
8384:
8385: FUNCTION evaluate_date_condition(
8386: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8387: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
8388: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
8389: RETURN BOOLEAN IS
8390: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8391: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;

Line 8388: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)

8384:
8385: FUNCTION evaluate_date_condition(
8386: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8387: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
8388: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
8389: RETURN BOOLEAN IS
8390: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8391: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8392: BEGIN

Line 8390: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;

8386: p_Operator_Code IN ZX_CONDITIONS.Operator_Code%TYPE,
8387: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
8388: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
8389: RETURN BOOLEAN IS
8390: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8391: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8392: BEGIN
8393:
8394: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 8391: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;

8387: p_condition_value IN ZX_CONDITIONS.DATE_VALUE%TYPE,
8388: p_trx_value IN ZX_CONDITIONS.DATE_VALUE%TYPE)
8389: RETURN BOOLEAN IS
8390: l_condition_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8391: l_trx_value ZX_CONDITIONS.DATE_VALUE%TYPE;
8392: BEGIN
8393:
8394: IF (g_level_procedure >= g_current_runtime_level ) THEN
8395: FND_LOG.STRING(g_level_procedure,

Line 8507: p_det_fact_cq_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CQ_CODE%TYPE)

8503: -- or not for the input event class
8504: --
8505:
8506: FUNCTION evaluate_if_first_party(
8507: p_det_fact_cq_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CQ_CODE%TYPE)
8508: RETURN BOOLEAN IS
8509:
8510: BEGIN
8511: