APPS.XLA_TB_DEFN_DETAIL_PVT dependencies on XLA_TB_DEFN_DETAILS

Line 56: FROM xla_tb_defn_details

52: WHERE definition_code = p_definition_code;
53:
54: CURSOR c_detail_f IS
55: SELECT 'Y'
56: FROM xla_tb_defn_details
57: WHERE definition_code = p_definition_code
58: AND code_combination_id = p_code_combination_id;
59:
60: CURSOR c_detail_s IS

Line 62: FROM xla_tb_defn_details

58: AND code_combination_id = p_code_combination_id;
59:
60: CURSOR c_detail_s IS
61: SELECT 'Y'
62: FROM xla_tb_defn_details
63: WHERE definition_code = p_definition_code
64: AND code_combination_id = p_segment_value_to;
65:
66:

Line 263: INSERT INTO xla_tb_defn_details

259: l_segment_value_to := p_segment_value_to;
260:
261: END IF;
262:
263: INSERT INTO xla_tb_defn_details
264: (
265: definition_detail_id
266: ,object_version_number
267: ,definition_code

Line 280: xla_tb_defn_details_s.nextval

276: ,last_update_login
277: )
278: VALUES
279: (
280: xla_tb_defn_details_s.nextval
281: ,1 -- Ignore p_object_version_number
282: ,p_definition_code
283: ,l_flexfield_segment_code
284: ,l_segment_value_from

Line 337: DELETE FROM xla_tb_defn_details

333: (p_definition_code IN VARCHAR2
334: ,p_code_combination_id IN NUMBER) IS
335: BEGIN
336:
337: DELETE FROM xla_tb_defn_details
338: WHERE definition_code = p_definition_code
339: AND code_combination_id = p_code_combination_id;
340:
341: IF SQL%NOTFOUND then

Line 365: DELETE FROM xla_tb_defn_details

361: ,p_flexfield_segment_code IN VARCHAR2
362: ,p_segment_value_from IN VARCHAR2) IS
363: BEGIN
364:
365: DELETE FROM xla_tb_defn_details
366: WHERE definition_code = p_definition_code
367: AND flexfield_segment_code = p_flexfield_segment_code
368: AND segment_value_from = p_segment_value_from;
369: