APPS.XLA_TB_DEFINITION_PVT dependencies on XLA_TB_DEFINITIONS_B

Line 55: FROM xla_tb_definitions_b

51: SELECT definition_code
52: ,object_version_number
53: ,last_updated_by
54: ,last_update_date
55: FROM xla_tb_definitions_b
56: WHERE definition_code = p_definition_code;
57:
58: CURSOR c_ledger IS
59: SELECT ledger_id

Line 187: FROM xla_tb_definitions_b

183:
184:
185: CURSOR c_tb_b IS
186: SELECT rowid
187: FROM xla_tb_definitions_b
188: WHERE definition_code = p_definition_code;
189:
190: BEGIN
191:

Line 196: INSERT INTO xla_tb_definitions_b

192: IF p_definition_code IS NULL THEN
193: RAISE no_data_found;
194: END IF;
195:
196: INSERT INTO xla_tb_definitions_b
197: (
198: definition_code
199: ,object_version_number
200: ,ledger_id

Line 325: FROM xla_tb_definitions_b

321: -- Allow update. Increment the database's OVN by 1
322: --
323: SELECT object_version_number
324: INTO l_object_version_number
325: FROM xla_tb_definitions_b
326: WHERE definition_code = p_definition_code;
327:
328: l_object_version_number := l_object_version_number + 1;
329:

Line 342: FROM xla_tb_definitions_b

338: --
339:
340: SELECT object_version_number
341: INTO l_object_version_number
342: FROM xla_tb_definitions_b
343: WHERE definition_code = p_definition_code
344: FOR UPDATE;
345:
346: IF (l_object_version_number = p_object_version_number) THEN

Line 362: UPDATE xla_tb_definitions_b

358: END IF;
359:
360: END IF;
361:
362: UPDATE xla_tb_definitions_b
363: SET object_version_number = l_object_version_number
364: ,ledger_id = p_ledger_id
365: ,enabled_flag = p_enabled_flag
366: ,balance_side_code = p_balance_side_code

Line 431: DELETE FROM xla_tb_definitions_b

427: IF SQL%NOTFOUND then
428: RAISE no_data_found;
429: END IF;
430:
431: DELETE FROM xla_tb_definitions_b
432: WHERE definition_code = p_definition_code;
433:
434: IF (sql%notfound) then
435: RAISE no_data_found;

Line 471: FROM xla_tb_definitions_b b

467:
468: DELETE FROM xla_tb_definitions_tl t
469: WHERE NOT EXISTS
470: (SELECT NULL
471: FROM xla_tb_definitions_b b
472: WHERE b.definition_code = t.definition_code
473: );
474:
475: UPDATE xla_tb_definitions_tl t