[Home] [Help]
81: IS
82:
83: CURSOR c IS
84: SELECT rowid
85: FROM xla_analytical_dtls_b
86: WHERE analytical_criterion_code = x_analytical_criterion_code
87: AND analytical_criterion_type_code = x_analytical_criterion_type_co
88: AND amb_context_code = x_amb_context_code
89: AND analytical_detail_code = x_analytical_detail_code
101: p_level => C_LEVEL_PROCEDURE);
102: END IF;
103:
104:
105: INSERT INTO xla_analytical_dtls_b
106: (creation_date
107: ,created_by
108: ,analytical_criterion_code
109: ,analytical_criterion_type_code
204: CURSOR c IS
205: SELECT analytical_criterion_code
206: ,grouping_order
207: ,data_type_code
208: FROM xla_analytical_dtls_b
209: WHERE analytical_criterion_code = x_analytical_criterion_code
210: AND analytical_criterion_type_code = x_analytical_criterion_type_co
211: AND amb_context_code = x_amb_context_code
212: AND analytical_detail_code = x_analytical_detail_code
316: p_module => l_log_module,
317: p_level => C_LEVEL_PROCEDURE);
318: END IF;
319:
320: UPDATE xla_analytical_dtls_b
321: SET
322: last_update_date = x_last_update_date
323: ,grouping_order = x_grouping_order
324: ,data_type_code = x_data_type_code
394: IF (SQL%NOTFOUND) THEN
395: RAISE NO_DATA_FOUND;
396: END IF;
397:
398: DELETE FROM xla_analytical_dtls_b
399: WHERE analytical_criterion_code = x_analytical_criterion_code
400: AND analytical_criterion_type_code = x_analytical_criterion_type_co
401: AND amb_context_code = x_amb_context_code
402: AND analytical_detail_code = x_analytical_detail_code;
439:
440: DELETE FROM xla_analytical_dtls_tl T
441: WHERE NOT EXISTS
442: (SELECT NULL
443: FROM xla_analytical_dtls_b b
444: WHERE b.analytical_criterion_code = t.analytical_criterion_code
445: AND b.analytical_criterion_type_code = t.analytical_criterion_type_code
446: AND b.amb_context_code = t.amb_context_code
447: AND b.analytical_detail_code = t.analytical_detail_code);