DBA Data[Home] [Help]

APPS.XLA_DESCRIPT_DETAILS_F_PKG dependencies on XLA_DESCRIPT_DETAILS_B

Line 88: FROM xla_descript_details_b

84: IS
85:
86: CURSOR c IS
87: SELECT rowid
88: FROM xla_descript_details_b
89: WHERE description_detail_id = x_description_detail_id
90: ;
91:
92: l_log_module VARCHAR2(240);

Line 105: INSERT INTO xla_descript_details_b

101: p_level => C_LEVEL_PROCEDURE);
102: END IF;
103:
104:
105: INSERT INTO xla_descript_details_b
106: (creation_date
107: ,created_by
108: ,amb_context_code
109: ,flexfield_segment_code

Line 217: FROM xla_descript_details_b

213: ,value_type_code
214: ,source_application_id
215: ,source_type_code
216: ,source_code
217: FROM xla_descript_details_b
218: WHERE description_detail_id = x_description_detail_id
219: FOR UPDATE OF description_detail_id NOWAIT;
220:
221: recinfo c%ROWTYPE;

Line 343: UPDATE xla_descript_details_b

339: p_module => l_log_module,
340: p_level => C_LEVEL_PROCEDURE);
341: END IF;
342:
343: UPDATE xla_descript_details_b
344: SET
345: last_update_date = x_last_update_date
346: ,amb_context_code = x_amb_context_code
347: ,flexfield_segment_code = x_flexfield_segment_code

Line 415: DELETE FROM xla_descript_details_b

411: IF (SQL%NOTFOUND) THEN
412: RAISE NO_DATA_FOUND;
413: END IF;
414:
415: DELETE FROM xla_descript_details_b
416: WHERE description_detail_id = x_description_detail_id;
417:
418:
419: IF (SQL%NOTFOUND) THEN

Line 456: FROM xla_descript_details_b b

452:
453: DELETE FROM xla_descript_details_tl T
454: WHERE NOT EXISTS
455: (SELECT NULL
456: FROM xla_descript_details_b b
457: WHERE b.description_detail_id = t.description_detail_id);
458:
459: UPDATE xla_descript_details_tl t
460: SET (literal)

Line 558: FROM xla_descript_details_b

554: AND user_sequence = p_priority_num;
555:
556: CURSOR c_dtl IS
557: SELECT description_detail_id
558: FROM xla_descript_details_b
559: WHERE amb_context_code = p_amb_context_code
560: AND description_prio_id = l_description_prio_id
561: AND user_sequence = p_user_sequence;
562: