APPS.XLA_ADR_INTERFACE_PKG dependencies on XLA_CONDITIONS_T

Line 107: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t

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
108: SELECT *
109: FROM xla_conditions_t
110: WHERE error_value = 0
111: FOR UPDATE of error_value;

Line 109: FROM xla_conditions_t

105: FOR UPDATE of error_value;
106:
107: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t
108: SELECT *
109: FROM xla_conditions_t
110: WHERE error_value = 0
111: FOR UPDATE of error_value;
112:
113: CURSOR c_xla_line_assgns_t IS -- cursor for xla_line_assgns_t

Line 126: l_xla_conditions c_xla_conditions_t%ROWTYPE;

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

Line 384: OPEN c_xla_conditions_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;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:

Line 386: FETCH c_xla_conditions_t INTO l_xla_conditions;

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;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:
389: BEGIN -- Block begins
390: -- Insert data into xla_conditions

Line 387: EXIT WHEN c_xla_conditions_t%NOTFOUND;

383:
384: OPEN c_xla_conditions_t;
385: LOOP
386: FETCH c_xla_conditions_t INTO l_xla_conditions;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:
389: BEGIN -- Block begins
390: -- Insert data into xla_conditions
391: INSERT INTO xla_conditions

Line 456: UPDATE xla_conditions_t

452: ,l_login_id
453: ,l_xla_conditions.independent_value_constant
454: );
455: -- Mark the row in the interface table as been processed
456: UPDATE xla_conditions_t
457: SET error_value = 1 -- The row has been processed with no error
458: WHERE CURRENT OF c_xla_conditions_t;
459: EXCEPTION
460: WHEN OTHERS THEN

Line 458: WHERE CURRENT OF c_xla_conditions_t;

454: );
455: -- Mark the row in the interface table as been processed
456: UPDATE xla_conditions_t
457: SET error_value = 1 -- The row has been processed with no error
458: WHERE CURRENT OF c_xla_conditions_t;
459: EXCEPTION
460: WHEN OTHERS THEN
461: l_error_code := SQLCODE;
462: UPDATE xla_conditions_t

Line 462: UPDATE xla_conditions_t

458: WHERE CURRENT OF c_xla_conditions_t;
459: EXCEPTION
460: WHEN OTHERS THEN
461: l_error_code := SQLCODE;
462: UPDATE xla_conditions_t
463: SET error_value = l_error_code -- The row has been processed with errors
464: WHERE CURRENT OF c_xla_conditions_t;
465: END; -- Block ends
466: END LOOP;

Line 464: WHERE CURRENT OF c_xla_conditions_t;

460: WHEN OTHERS THEN
461: l_error_code := SQLCODE;
462: UPDATE xla_conditions_t
463: SET error_value = l_error_code -- The row has been processed with errors
464: WHERE CURRENT OF c_xla_conditions_t;
465: END; -- Block ends
466: END LOOP;
467: CLOSE c_xla_conditions_t;
468:

Line 467: CLOSE c_xla_conditions_t;

463: SET error_value = l_error_code -- The row has been processed with errors
464: WHERE CURRENT OF c_xla_conditions_t;
465: END; -- Block ends
466: END LOOP;
467: CLOSE c_xla_conditions_t;
468:
469: OPEN c_xla_line_assgns_t;
470: LOOP
471: FETCH c_xla_line_assgns_t INTO l_xla_line_assgns;