70: l_current_date date;
71: --
72: CURSOR Get_DateAndId_csr IS
73: select
74: AMV_I_CONTENT_TYPES_B_S.nextval, sysdate
75: from dual;
76: --
77: BEGIN
78: -- Standard call to check for call compatibility.
430: --
431: CURSOR Get_Version_csr(p_ctype_id IN NUMBER) IS
432: Select
433: object_version_number
434: from Amv_i_content_types_b
435: where content_type_id = p_ctype_id;
436: --
437: --
438: BEGIN
640: B.CREATED_BY,
641: B.LAST_UPDATE_DATE,
642: B.LAST_UPDATED_BY,
643: B.LAST_UPDATE_LOGIN
644: From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B
645: Where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID
646: And T.LANGUAGE = userenv('LANG')
647: And B.CONTENT_TYPE_ID = p_ID;
648: --
894: 'B.CREATED_BY, ' ||
895: 'B.LAST_UPDATE_DATE, ' ||
896: 'B.LAST_UPDATED_BY, ' ||
897: 'B.LAST_UPDATE_LOGIN ' ||
898: 'From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';
899: l_sql_statement2 :=
900: 'Select count(*) ' ||
901: 'From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';
902: --
897: 'B.LAST_UPDATE_LOGIN ' ||
898: 'From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';
899: l_sql_statement2 :=
900: 'Select count(*) ' ||
901: 'From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';
902: --
903: l_where_clause :=
904: 'Where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID ' ||
905: 'And T.LANGUAGE = userenv(''LANG'') ';