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_CONDITIONS_T

Line 144: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t

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
145: SELECT *
146: FROM xla_conditions_t
147: WHERE error_value = 0
148: FOR UPDATE of error_value;

Line 146: FROM xla_conditions_t

142: FOR UPDATE of error_value;
143:
144: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t
145: SELECT *
146: FROM xla_conditions_t
147: WHERE error_value = 0
148: FOR UPDATE of error_value;
149:
150: CURSOR c_xla_line_assgns_t IS -- cursor for xla_line_assgns_t

Line 163: l_xla_conditions c_xla_conditions_t%ROWTYPE;

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;
167: l_user_id INTEGER;

Line 424: OPEN c_xla_conditions_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;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:

Line 426: FETCH c_xla_conditions_t INTO l_xla_conditions;

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;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:
429: BEGIN -- Block begins
430: -- Insert data into xla_conditions

Line 427: EXIT WHEN c_xla_conditions_t%NOTFOUND;

423:
424: OPEN c_xla_conditions_t;
425: LOOP
426: FETCH c_xla_conditions_t INTO l_xla_conditions;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:
429: BEGIN -- Block begins
430: -- Insert data into xla_conditions
431: INSERT INTO xla_conditions

Line 496: UPDATE xla_conditions_t

492: ,l_login_id
493: ,l_xla_conditions.independent_value_constant
494: );
495: -- Mark the row in the interface table as been processed
496: UPDATE xla_conditions_t
497: SET error_value = 1 -- The row has been processed with no error
498: WHERE CURRENT OF c_xla_conditions_t;
499: EXCEPTION
500: WHEN OTHERS THEN

Line 498: WHERE CURRENT OF c_xla_conditions_t;

494: );
495: -- Mark the row in the interface table as been processed
496: UPDATE xla_conditions_t
497: SET error_value = 1 -- The row has been processed with no error
498: WHERE CURRENT OF c_xla_conditions_t;
499: EXCEPTION
500: WHEN OTHERS THEN
501: l_error_code := SQLCODE;
502: UPDATE xla_conditions_t

Line 502: UPDATE xla_conditions_t

498: WHERE CURRENT OF c_xla_conditions_t;
499: EXCEPTION
500: WHEN OTHERS THEN
501: l_error_code := SQLCODE;
502: UPDATE xla_conditions_t
503: SET error_value = l_error_code -- The row has been processed with errors
504: WHERE CURRENT OF c_xla_conditions_t;
505: END; -- Block ends
506: END LOOP;

Line 504: WHERE CURRENT OF c_xla_conditions_t;

500: WHEN OTHERS THEN
501: l_error_code := SQLCODE;
502: UPDATE xla_conditions_t
503: SET error_value = l_error_code -- The row has been processed with errors
504: WHERE CURRENT OF c_xla_conditions_t;
505: END; -- Block ends
506: END LOOP;
507: CLOSE c_xla_conditions_t;
508:

Line 507: CLOSE c_xla_conditions_t;

503: SET error_value = l_error_code -- The row has been processed with errors
504: WHERE CURRENT OF c_xla_conditions_t;
505: END; -- Block ends
506: END LOOP;
507: CLOSE c_xla_conditions_t;
508:
509: OPEN c_xla_line_assgns_t;
510: LOOP
511: FETCH c_xla_line_assgns_t INTO l_xla_line_assgns;