48: v_name VARCHAR2(240);
49:
50: CURSOR get_duplicate_name_cur IS
51: SELECT distinct name
52: FROM qp_list_headers_tl
53: WHERE name = p_name;
54:
55: BEGIN
56:
97: ELSE
98: v_name := p_name;
99: END IF;
100:
101: INSERT INTO QP_LIST_HEADERS_TL (
102: LIST_HEADER_ID, LANGUAGE, SOURCE_LANG, NAME, DESCRIPTION,
103: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
104: VERSION_NO)
105:
110: FROM FND_LANGUAGES l
111: WHERE l.INSTALLED_FLAG in ('I', 'B')
112: AND NOT EXISTS
113: (SELECT NULL
114: FROM QP_LIST_HEADERS_TL t
115: WHERE t.LIST_HEADER_ID = x_list_header_id
116: AND t.LANGUAGE = l.LANGUAGE_CODE);
117:
118: EXCEPTION