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_CONDITION_GROUPS_B

Line 59: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

55:
56: PROCEDURE process_segment_string(
57: p_account_string IN VARCHAR2,
58: p_chart_of_accounts_id IN
59: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
60: p_return_status OUT NOCOPY VARCHAR2,
61: p_error_buffer OUT NOCOPY VARCHAR2);
62:
63: PROCEDURE get_account_flexfield_info(

Line 69: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_error_buffer OUT NOCOPY VARCHAR2);

Line 71: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

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,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_error_buffer OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE get_geography_info(

Line 141: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%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,
144: p_return_status OUT NOCOPY VARCHAR2,
145: p_error_buffer OUT NOCOPY VARCHAR2);

Line 143: ZX_CONDITION_GROUPS_B.LEDGER_ID%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,
144: p_return_status OUT NOCOPY VARCHAR2,
145: p_error_buffer OUT NOCOPY VARCHAR2);
146:
147:

Line 154: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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);
158:

Line 197: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%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:
200: PROCEDURE evaluate_condition(
201: p_condition_index IN BINARY_INTEGER,

Line 205: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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);
209:

Line 212: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,

208: p_error_buffer OUT NOCOPY VARCHAR2);
209:
210: PROCEDURE check_condition_group_result(
211: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
212: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
213: p_trx_line_index IN BINARY_INTEGER,
214: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
215: p_template_evaluated OUT NOCOPY BOOLEAN,
216: p_result OUT NOCOPY BOOLEAN);

Line 220: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,

216: p_result OUT NOCOPY BOOLEAN);
217:
218: PROCEDURE insert_condition_group_result(
219: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
220: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
221: p_result IN BOOLEAN,
222: p_trx_line_index IN BINARY_INTEGER,
223: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
224:

Line 251: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

247: p_tax IN ZX_TAXES_B.TAX%TYPE,
248: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
249: p_result IN OUT NOCOPY BOOLEAN,
250: p_chart_of_accounts_id IN
251: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
252: p_sob_id IN
253: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_error_buffer OUT NOCOPY VARCHAR2);

Line 253: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

249: p_result IN OUT NOCOPY BOOLEAN,
250: p_chart_of_accounts_id IN
251: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
252: p_sob_id IN
253: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_error_buffer OUT NOCOPY VARCHAR2);
256:
257:

Line 261: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,

257:
258: PROCEDURE get_and_process_condition(
259: p_structure_name IN VARCHAR2,
260: p_structure_index IN BINARY_INTEGER,
261: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
262: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
263: p_tax IN ZX_TAXES_B.TAX%TYPE,
264: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
265: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,

Line 268: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

264: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
265: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
266: p_result IN OUT NOCOPY BOOLEAN,
267: p_chart_of_accounts_id IN
268: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
269: p_sob_id IN
270: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
271: p_return_status OUT NOCOPY VARCHAR2,
272: p_error_buffer OUT NOCOPY VARCHAR2);

Line 270: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

266: p_result IN OUT NOCOPY BOOLEAN,
267: p_chart_of_accounts_id IN
268: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
269: p_sob_id IN
270: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
271: p_return_status OUT NOCOPY VARCHAR2,
272: p_error_buffer OUT NOCOPY VARCHAR2);
273:
274:

Line 1432: l_condition_group_code ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE;

1428: p_return_status OUT NOCOPY VARCHAR2,
1429: p_error_buffer OUT NOCOPY VARCHAR2)
1430: IS
1431: l_det_factor_templ_cd ZX_RULES_B.DET_FACTOR_TEMPL_CODE%TYPE;
1432: l_condition_group_code ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE;
1433: l_result BOOLEAN;
1434: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
1435: l_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE;
1436:

Line 2741: SELECT /+ leading(P) use_nl_with_index(s ZX_CONDITION_GROUPS_B_U1) /

2737: (c_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
2738: c_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE,
2739: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
2740: IS
2741: SELECT /*+ leading(P) use_nl_with_index(s ZX_CONDITION_GROUPS_B_U1) */
2742: s.CONDITION_GROUP_ID, s.CONDITION_GROUP_CODE, More_Than_Max_Cond_Flag,
2743: Determining_Factor_Class1_Code, Determining_Factor_Cq1_Code,
2744: Data_Type1_Code, DETERMINING_FACTOR_CODE1,
2745: Operator1_Code, NUMERIC_VALUE1, DATE_VALUE1, ALPHANUMERIC_VALUE1,

Line 2785: FROM ZX_CONDITION_GROUPS_B s,

2781: ALPHANUMERIC_VALUE10, VALUE_LOW10, VALUE_HIGH10,
2782: TAX_PARAMETER_CODE10, CHART_OF_ACCOUNTS_ID, LEDGER_ID,
2783: p.RESULT_ID,
2784: s.constraint_id
2785: FROM ZX_CONDITION_GROUPS_B s,
2786: ZX_PROCESS_RESULTS p
2787: WHERE --s.det_factor_templ_code = c_det_factor_templ_code AND
2788: s.enabled_flag = 'Y' AND
2789: --s.condition_group_code = p.condition_group_code AND

Line 3248: ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,

3244: PROCEDURE get_and_process_condition(
3245: p_structure_name IN VARCHAR2,
3246: p_structure_index IN BINARY_INTEGER,
3247: p_condition_group_code IN
3248: ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
3249: p_event_class_rec IN
3250: ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3251: p_tax IN ZX_TAXES_B.TAX%TYPE,
3252: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

Line 3257: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

3253: p_tax_determine_date IN
3254: ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3255: p_result IN OUT NOCOPY BOOLEAN,
3256: p_chart_of_accounts_id IN
3257: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3258: p_sob_id IN
3259: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
3260: p_return_status OUT NOCOPY VARCHAR2,
3261: p_error_buffer OUT NOCOPY VARCHAR2)

Line 3259: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

3255: p_result IN OUT NOCOPY BOOLEAN,
3256: p_chart_of_accounts_id IN
3257: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3258: p_sob_id IN
3259: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
3260: p_return_status OUT NOCOPY VARCHAR2,
3261: p_error_buffer OUT NOCOPY VARCHAR2)
3262: IS
3263: l_condition_result BOOLEAN;

Line 3266: (c_condition_group_code ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE)

3262: IS
3263: l_condition_result BOOLEAN;
3264:
3265: CURSOR get_condition_csr
3266: (c_condition_group_code ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE)
3267: IS
3268:
3269: SELECT Determining_Factor_Class_Code,
3270: Determining_Factor_Cq_Code,

Line 3643: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

3639: p_tax IN ZX_TAXES_B.TAX%TYPE,
3640: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3641: p_result IN OUT NOCOPY BOOLEAN,
3642: p_chart_of_accounts_id IN
3643: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3644: p_sob_id IN
3645: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
3646: p_return_status OUT NOCOPY VARCHAR2,
3647: p_error_buffer OUT NOCOPY VARCHAR2)

Line 3645: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

3641: p_result IN OUT NOCOPY BOOLEAN,
3642: p_chart_of_accounts_id IN
3643: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3644: p_sob_id IN
3645: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
3646: p_return_status OUT NOCOPY VARCHAR2,
3647: p_error_buffer OUT NOCOPY VARCHAR2)
3648:
3649: IS

Line 3920: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%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,
3923: p_return_status OUT NOCOPY VARCHAR2,
3924: p_error_buffer OUT NOCOPY VARCHAR2)

Line 3922: ZX_CONDITION_GROUPS_B.LEDGER_ID%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,
3923: p_return_status OUT NOCOPY VARCHAR2,
3924: p_error_buffer OUT NOCOPY VARCHAR2)
3925: IS
3926: i BINARY_INTEGER;

Line 4216: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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)
4220: IS

Line 6342: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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,
6345: p_return_status OUT NOCOPY VARCHAR2,
6346: p_error_buffer OUT NOCOPY VARCHAR2)

Line 6344: ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,

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,
6345: p_return_status OUT NOCOPY VARCHAR2,
6346: p_error_buffer OUT NOCOPY VARCHAR2)
6347: IS
6348: i BINARY_INTEGER;

Line 6353: l_sob_id ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE;

6349: l_account_string VARCHAR2(2000);
6350: l_ccid NUMBER;
6351: l_num_segments NUMBER;
6352: l_tax_parameter_code ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE;
6353: l_sob_id ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE;
6354: BEGIN
6355:
6356: IF (g_level_procedure >= g_current_runtime_level ) THEN
6357: FND_LOG.STRING(g_level_procedure,

Line 6556: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

6552: --
6553: PROCEDURE process_segment_string(
6554: p_account_string IN VARCHAR2,
6555: p_chart_of_accounts_id IN
6556: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
6557: p_return_status OUT NOCOPY VARCHAR2,
6558: p_error_buffer OUT NOCOPY VARCHAR2)
6559: IS
6560: l_delimiter VARCHAR2(1);

Line 6901: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

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)
6905: IS

Line 7569: ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,

7565: PROCEDURE check_condition_group_result(
7566: p_det_factor_templ_code IN
7567: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7568: p_condition_group_code IN
7569: ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
7570: p_trx_line_index IN BINARY_INTEGER,
7571: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7572: p_template_evaluated OUT NOCOPY BOOLEAN,
7573: p_result OUT NOCOPY BOOLEAN)

Line 7671: p_condition_group_code IN ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,

7667: --
7668: --
7669: PROCEDURE insert_condition_group_result(
7670: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7671: p_condition_group_code IN ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
7672: p_result IN BOOLEAN,
7673: p_trx_line_index IN BINARY_INTEGER,
7674: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
7675: )

Line 7771: FROM zx_condition_groups_b zcg,

7767: AND param.event_class_mapping_id = c_event_class_mapping_id
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

Line 8092: p_chart_of_accounts_id IN ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%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;
8095:
8096: l_segments_trx FND_FLEX_EXT.SEGMENTARRAY;