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_LINE_ASSGNS_T

Line 150: CURSOR c_xla_line_assgns_t IS -- cursor for xla_line_assgns_t

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
151: SELECT *
152: FROM xla_line_assgns_t
153: WHERE error_value = 0
154: FOR UPDATE of error_value;

Line 152: FROM xla_line_assgns_t

148: FOR UPDATE of error_value;
149:
150: CURSOR c_xla_line_assgns_t IS -- cursor for xla_line_assgns_t
151: SELECT *
152: FROM xla_line_assgns_t
153: WHERE error_value = 0
154: FOR UPDATE of error_value;
155:
156: CURSOR c_languages IS -- cursor for installed languages

Line 164: l_xla_line_assgns c_xla_line_assgns_t%ROWTYPE;

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;
168: l_login_id INTEGER;

Line 509: OPEN c_xla_line_assgns_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;
512: EXIT WHEN c_xla_line_assgns_t%NOTFOUND;
513:

Line 511: FETCH c_xla_line_assgns_t INTO l_xla_line_assgns;

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;
512: EXIT WHEN c_xla_line_assgns_t%NOTFOUND;
513:
514: BEGIN -- Block begins
515: -- Insert data into xla_line_defn_adr_assgns

Line 512: EXIT WHEN c_xla_line_assgns_t%NOTFOUND;

508:
509: OPEN c_xla_line_assgns_t;
510: LOOP
511: FETCH c_xla_line_assgns_t INTO l_xla_line_assgns;
512: EXIT WHEN c_xla_line_assgns_t%NOTFOUND;
513:
514: BEGIN -- Block begins
515: -- Insert data into xla_line_defn_adr_assgns
516: INSERT INTO xla_line_defn_adr_assgns

Line 563: UPDATE xla_line_assgns_t

559: ,l_xla_line_assgns.application_id
560: ,0
561: );
562: -- Mark the row in the interface table as been processed
563: UPDATE xla_line_assgns_t
564: SET error_value = 1 -- The row has been processed with no error
565: WHERE CURRENT OF c_xla_line_assgns_t;
566: EXCEPTION
567: WHEN OTHERS THEN

Line 565: WHERE CURRENT OF c_xla_line_assgns_t;

561: );
562: -- Mark the row in the interface table as been processed
563: UPDATE xla_line_assgns_t
564: SET error_value = 1 -- The row has been processed with no error
565: WHERE CURRENT OF c_xla_line_assgns_t;
566: EXCEPTION
567: WHEN OTHERS THEN
568: l_error_code := SQLCODE;
569: UPDATE xla_line_assgns_t

Line 569: UPDATE xla_line_assgns_t

565: WHERE CURRENT OF c_xla_line_assgns_t;
566: EXCEPTION
567: WHEN OTHERS THEN
568: l_error_code := SQLCODE;
569: UPDATE xla_line_assgns_t
570: SET error_value = l_error_code -- The row has been processed with errors
571: WHERE CURRENT OF c_xla_line_assgns_t;
572: END; -- Block ends
573: END LOOP;

Line 571: WHERE CURRENT OF c_xla_line_assgns_t;

567: WHEN OTHERS THEN
568: l_error_code := SQLCODE;
569: UPDATE xla_line_assgns_t
570: SET error_value = l_error_code -- The row has been processed with errors
571: WHERE CURRENT OF c_xla_line_assgns_t;
572: END; -- Block ends
573: END LOOP;
574: CLOSE c_xla_line_assgns_t;
575:

Line 574: CLOSE c_xla_line_assgns_t;

570: SET error_value = l_error_code -- The row has been processed with errors
571: WHERE CURRENT OF c_xla_line_assgns_t;
572: END; -- Block ends
573: END LOOP;
574: CLOSE c_xla_line_assgns_t;
575:
576: --END LOOP;
577: --CLOSE c_xla_rules_t;
578: