APPS.XLA_ADR_INTERFACE_PKG dependencies on XLA_RULE_DETAILS_T

Line 101: CURSOR c_xla_rule_details_t IS -- cursor for xla_rule_details_t

97: FROM xla_rules_t
98: WHERE error_value = 0
99: FOR UPDATE of error_value;
100:
101: CURSOR c_xla_rule_details_t IS -- cursor for xla_rule_details_t
102: SELECT *
103: FROM xla_rule_details_t
104: WHERE error_value = 0
105: FOR UPDATE of error_value;

Line 103: FROM xla_rule_details_t

99: FOR UPDATE of error_value;
100:
101: CURSOR c_xla_rule_details_t IS -- cursor for xla_rule_details_t
102: SELECT *
103: FROM xla_rule_details_t
104: WHERE error_value = 0
105: FOR UPDATE of error_value;
106:
107: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t

Line 125: l_xla_rule_details c_xla_rule_details_t%ROWTYPE;

121: FROM fnd_languages
122: WHERE installed_flag = 'I';
123:
124: l_xla_rules c_xla_rules_t%ROWTYPE;
125: l_xla_rule_details c_xla_rule_details_t%ROWTYPE;
126: l_xla_conditions c_xla_conditions_t%ROWTYPE;
127: l_xla_line_assgns c_xla_line_assgns_t%ROWTYPE;
128: l_base_language VARCHAR2(4);
129: l_installed_language t_array_vl4;

Line 307: OPEN c_xla_rule_details_t;

303: END; -- Block ends
304: END LOOP;
305: CLOSE c_xla_rules_t;
306:
307: OPEN c_xla_rule_details_t;
308: LOOP
309: FETCH c_xla_rule_details_t into l_xla_rule_details;
310: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
311:

Line 309: FETCH c_xla_rule_details_t into l_xla_rule_details;

305: CLOSE c_xla_rules_t;
306:
307: OPEN c_xla_rule_details_t;
308: LOOP
309: FETCH c_xla_rule_details_t into l_xla_rule_details;
310: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
311:
312: BEGIN -- Block begins
313: -- Insert data into xla_seg_rule_details

Line 310: EXIT WHEN c_xla_rule_details_t%NOTFOUND;

306:
307: OPEN c_xla_rule_details_t;
308: LOOP
309: FETCH c_xla_rule_details_t into l_xla_rule_details;
310: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
311:
312: BEGIN -- Block begins
313: -- Insert data into xla_seg_rule_details
314: INSERT INTO xla_seg_rule_details

Line 371: UPDATE xla_rule_details_t

367: ,l_xla_rule_details.value_segment_rule_code
368: ,l_xla_rule_details.value_adr_version_num
369: );
370: -- Mark the row in the interface table as been processed
371: UPDATE xla_rule_details_t
372: SET error_value = 1 -- The row has been processed with no error
373: WHERE CURRENT OF c_xla_rule_details_t;
374: EXCEPTION
375: WHEN OTHERS THEN

Line 373: WHERE CURRENT OF c_xla_rule_details_t;

369: );
370: -- Mark the row in the interface table as been processed
371: UPDATE xla_rule_details_t
372: SET error_value = 1 -- The row has been processed with no error
373: WHERE CURRENT OF c_xla_rule_details_t;
374: EXCEPTION
375: WHEN OTHERS THEN
376: l_error_code := SQLCODE;
377: UPDATE xla_rule_details_t

Line 377: UPDATE xla_rule_details_t

373: WHERE CURRENT OF c_xla_rule_details_t;
374: EXCEPTION
375: WHEN OTHERS THEN
376: l_error_code := SQLCODE;
377: UPDATE xla_rule_details_t
378: SET error_value = l_error_code -- The row has been processed with errors
379: WHERE CURRENT OF c_xla_rule_details_t;
380: END; -- Block ends
381: END LOOP;

Line 379: WHERE CURRENT OF c_xla_rule_details_t;

375: WHEN OTHERS THEN
376: l_error_code := SQLCODE;
377: UPDATE xla_rule_details_t
378: SET error_value = l_error_code -- The row has been processed with errors
379: WHERE CURRENT OF c_xla_rule_details_t;
380: END; -- Block ends
381: END LOOP;
382: CLOSE c_xla_rule_details_t;
383:

Line 382: CLOSE c_xla_rule_details_t;

378: SET error_value = l_error_code -- The row has been processed with errors
379: WHERE CURRENT OF c_xla_rule_details_t;
380: END; -- Block ends
381: END LOOP;
382: CLOSE c_xla_rule_details_t;
383:
384: OPEN c_xla_conditions_t;
385: LOOP
386: FETCH c_xla_conditions_t INTO l_xla_conditions;