APPS.XLA_ANALYTICAL_HDRS_F_PKG dependencies on XLA_ANALYTICAL_HDRS_B

Line 88: FROM xla_analytical_hdrs_b

84: IS
85:
86: CURSOR c IS
87: SELECT rowid
88: FROM xla_analytical_hdrs_b
89: WHERE analytical_criterion_code = x_analytical_criterion_code
90: AND analytical_criterion_type_code = x_analytical_criterion_type_co
91: AND amb_context_code = x_amb_context_code
92: ;

Line 107: INSERT INTO xla_analytical_hdrs_b

103: p_level => C_LEVEL_PROCEDURE);
104: END IF;
105:
106:
107: INSERT INTO xla_analytical_hdrs_b
108: (creation_date
109: ,created_by
110: ,analytical_criterion_code
111: ,analytical_criterion_type_code

Line 228: FROM xla_analytical_hdrs_b

224: ,enabled_flag
225: ,year_end_carry_forward_code
226: ,display_in_inquiries_flag
227: ,criterion_value_code
228: FROM xla_analytical_hdrs_b
229: WHERE analytical_criterion_code = x_analytical_criterion_code
230: AND analytical_criterion_type_code = x_analytical_criterion_type_co
231: AND amb_context_code = x_amb_context_code
232: FOR UPDATE OF analytical_criterion_code NOWAIT;

Line 351: UPDATE xla_analytical_hdrs_b

347: p_module => l_log_module,
348: p_level => C_LEVEL_PROCEDURE);
349: END IF;
350:
351: UPDATE xla_analytical_hdrs_b
352: SET
353: last_update_date = x_last_update_date
354: ,application_id = x_application_id
355: ,balancing_flag = x_balancing_flag

Line 431: DELETE FROM xla_analytical_hdrs_b

427: IF (SQL%NOTFOUND) THEN
428: RAISE NO_DATA_FOUND;
429: END IF;
430:
431: DELETE FROM xla_analytical_hdrs_b
432: WHERE analytical_criterion_code = x_analytical_criterion_code
433: AND analytical_criterion_type_code = x_analytical_criterion_type_co
434: AND amb_context_code = x_amb_context_code;
435:

Line 474: FROM xla_analytical_hdrs_b b

470:
471: DELETE FROM xla_analytical_hdrs_tl T
472: WHERE NOT EXISTS
473: (SELECT NULL
474: FROM xla_analytical_hdrs_b b
475: WHERE b.analytical_criterion_code = t.analytical_criterion_code
476: AND b.analytical_criterion_type_code = t.analytical_criterion_type_code
477: AND b.amb_context_code = t.amb_context_code);
478: