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.XLA_ADR_INTERFACE_PKG dependencies on XLA_RULE_DETAILS_T

Line 138: CURSOR c_xla_rule_details_t IS -- cursor for xla_rule_details_t

134: FROM xla_rules_t
135: WHERE error_value = 0
136: FOR UPDATE of error_value;
137:
138: CURSOR c_xla_rule_details_t IS -- cursor for xla_rule_details_t
139: SELECT *
140: FROM xla_rule_details_t
141: WHERE error_value = 0
142: FOR UPDATE of error_value;

Line 140: FROM xla_rule_details_t

136: FOR UPDATE of error_value;
137:
138: CURSOR c_xla_rule_details_t IS -- cursor for xla_rule_details_t
139: SELECT *
140: FROM xla_rule_details_t
141: WHERE error_value = 0
142: FOR UPDATE of error_value;
143:
144: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t

Line 162: l_xla_rule_details c_xla_rule_details_t%ROWTYPE;

158: FROM fnd_languages
159: WHERE installed_flag = 'I';
160:
161: l_xla_rules c_xla_rules_t%ROWTYPE;
162: l_xla_rule_details c_xla_rule_details_t%ROWTYPE;
163: l_xla_conditions c_xla_conditions_t%ROWTYPE;
164: l_xla_line_assgns c_xla_line_assgns_t%ROWTYPE;
165: l_base_language VARCHAR2(4);
166: l_installed_language t_array_vl4;

Line 347: OPEN c_xla_rule_details_t;

343: END; -- Block ends
344: END LOOP;
345: CLOSE c_xla_rules_t;
346:
347: OPEN c_xla_rule_details_t;
348: LOOP
349: FETCH c_xla_rule_details_t into l_xla_rule_details;
350: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
351:

Line 349: FETCH c_xla_rule_details_t into l_xla_rule_details;

345: CLOSE c_xla_rules_t;
346:
347: OPEN c_xla_rule_details_t;
348: LOOP
349: FETCH c_xla_rule_details_t into l_xla_rule_details;
350: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
351:
352: BEGIN -- Block begins
353: -- Insert data into xla_seg_rule_details

Line 350: EXIT WHEN c_xla_rule_details_t%NOTFOUND;

346:
347: OPEN c_xla_rule_details_t;
348: LOOP
349: FETCH c_xla_rule_details_t into l_xla_rule_details;
350: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
351:
352: BEGIN -- Block begins
353: -- Insert data into xla_seg_rule_details
354: INSERT INTO xla_seg_rule_details

Line 411: UPDATE xla_rule_details_t

407: ,l_xla_rule_details.value_segment_rule_code
408: ,l_xla_rule_details.value_adr_version_num
409: );
410: -- Mark the row in the interface table as been processed
411: UPDATE xla_rule_details_t
412: SET error_value = 1 -- The row has been processed with no error
413: WHERE CURRENT OF c_xla_rule_details_t;
414: EXCEPTION
415: WHEN OTHERS THEN

Line 413: WHERE CURRENT OF c_xla_rule_details_t;

409: );
410: -- Mark the row in the interface table as been processed
411: UPDATE xla_rule_details_t
412: SET error_value = 1 -- The row has been processed with no error
413: WHERE CURRENT OF c_xla_rule_details_t;
414: EXCEPTION
415: WHEN OTHERS THEN
416: l_error_code := SQLCODE;
417: UPDATE xla_rule_details_t

Line 417: UPDATE xla_rule_details_t

413: WHERE CURRENT OF c_xla_rule_details_t;
414: EXCEPTION
415: WHEN OTHERS THEN
416: l_error_code := SQLCODE;
417: UPDATE xla_rule_details_t
418: SET error_value = l_error_code -- The row has been processed with errors
419: WHERE CURRENT OF c_xla_rule_details_t;
420: END; -- Block ends
421: END LOOP;

Line 419: WHERE CURRENT OF c_xla_rule_details_t;

415: WHEN OTHERS THEN
416: l_error_code := SQLCODE;
417: UPDATE xla_rule_details_t
418: SET error_value = l_error_code -- The row has been processed with errors
419: WHERE CURRENT OF c_xla_rule_details_t;
420: END; -- Block ends
421: END LOOP;
422: CLOSE c_xla_rule_details_t;
423:

Line 422: CLOSE c_xla_rule_details_t;

418: SET error_value = l_error_code -- The row has been processed with errors
419: WHERE CURRENT OF c_xla_rule_details_t;
420: END; -- Block ends
421: END LOOP;
422: CLOSE c_xla_rule_details_t;
423:
424: OPEN c_xla_conditions_t;
425: LOOP
426: FETCH c_xla_conditions_t INTO l_xla_conditions;