APPS.AMV_CONTENT_TYPE_PVT dependencies on AMV_I_CONTENT_TYPES_TL

Line 23: From amv_i_content_types_tl

19: ----------------------------- Private Cursors in this package ------------------
20: CURSOR Check_DupContTypeName_csr(p_name IN varchar2) IS
21: Select
22: content_type_id
23: From amv_i_content_types_tl
24: Where content_type_name = p_name
25: And language IN
26: (
27: Select L.language_code

Line 36: From amv_i_content_types_tl

32: --
33: CURSOR Check_ValidContTypeName_csr(p_name varchar2) IS
34: Select
35: content_type_id
36: From amv_i_content_types_tl
37: Where content_type_name = p_name
38: And language = userenv('lang');
39: --
40: --------------------------- Private Utility inside this package ----------------

Line 644: From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B

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: --

Line 898: 'From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';

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: --

Line 901: 'From AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';

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'') ';