APPS.XLA_SOURCES_F_PKG dependencies on XLA_SOURCES_B

Line 90: FROM xla_sources_b

86: IS
87:
88: CURSOR c IS
89: SELECT rowid
90: FROM xla_sources_b
91: WHERE application_id = x_application_id
92: AND source_code = x_source_code
93: AND source_type_code = x_source_type_code
94: ;

Line 99: INSERT INTO xla_sources_b

95:
96: BEGIN
97: xla_utility_pkg.trace('> xla_sources_f_pkg.insert_row' ,20);
98:
99: INSERT INTO xla_sources_b
100: (creation_date
101: ,created_by
102: ,plsql_function_name
103: ,source_type_code

Line 245: FROM xla_sources_b

241: ,key_flexfield_flag
242: ,segment_code
243: ,flexfield_application_id
244: ,id_flex_code
245: FROM xla_sources_b
246: WHERE application_id = x_application_id
247: AND source_code = x_source_code
248: AND source_type_code = x_source_type_code
249: FOR UPDATE OF application_id NOWAIT;

Line 428: UPDATE xla_sources_b

424: IS
425:
426: BEGIN
427: xla_utility_pkg.trace('> xla_sources_f_pkg.update_row' ,20);
428: UPDATE xla_sources_b
429: SET
430: last_update_date = x_last_update_date
431: ,plsql_function_name = x_plsql_function_name
432: ,flex_value_set_id = x_flex_value_set_id

Line 500: DELETE FROM xla_sources_b

496: IF (SQL%NOTFOUND) THEN
497: RAISE NO_DATA_FOUND;
498: END IF;
499:
500: DELETE FROM xla_sources_b
501: WHERE application_id = x_application_id
502: AND source_code = x_source_code
503: AND source_type_code = x_source_type_code;
504:

Line 529: FROM xla_sources_b b

525:
526: DELETE FROM xla_sources_tl T
527: WHERE NOT EXISTS
528: (SELECT NULL
529: FROM xla_sources_b b
530: WHERE b.application_id = t.application_id
531: AND b.source_code = t.source_code
532: AND b.source_type_code = t.source_type_code);
533: