eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_OBJECT2_PVT dependencies on AK_OBJECT_ATTRIBUTES

Line 326: from AK_OBJECT_ATTRIBUTES

322: p_nls_language IN VARCHAR2
323: ) is
324: cursor l_get_attributes_csr is
325: select *
326: from AK_OBJECT_ATTRIBUTES
327: where DATABASE_OBJECT_NAME = p_database_object_name;
328: cursor l_get_attribute_tl_csr (attribute_appl_id_param number,
329: attribute_code_param varchar2) is
330: select *

Line 331: from AK_OBJECT_ATTRIBUTES_TL

327: where DATABASE_OBJECT_NAME = p_database_object_name;
328: cursor l_get_attribute_tl_csr (attribute_appl_id_param number,
329: attribute_code_param varchar2) is
330: select *
331: from AK_OBJECT_ATTRIBUTES_TL
332: where DATABASE_OBJECT_NAME = p_database_object_name
333: and ATTRIBUTE_APPLICATION_ID = attribute_appl_id_param
334: and ATTRIBUTE_CODE = attribute_code_param
335: and LANGUAGE = p_nls_language;

Line 339: l_attributes_rec AK_OBJECT_ATTRIBUTES%ROWTYPE;

335: and LANGUAGE = p_nls_language;
336: l_api_name CONSTANT varchar2(30) := 'Write_Attribute_to_buffer';
337: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
338: l_index NUMBER;
339: l_attributes_rec AK_OBJECT_ATTRIBUTES%ROWTYPE;
340: l_attributes_tl_rec AK_OBJECT_ATTRIBUTES_TL%ROWTYPE;
341: l_return_status varchar2(1);
342: begin
343: -- Find out where the next buffer entry to be written to

Line 340: l_attributes_tl_rec AK_OBJECT_ATTRIBUTES_TL%ROWTYPE;

336: l_api_name CONSTANT varchar2(30) := 'Write_Attribute_to_buffer';
337: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
338: l_index NUMBER;
339: l_attributes_rec AK_OBJECT_ATTRIBUTES%ROWTYPE;
340: l_attributes_tl_rec AK_OBJECT_ATTRIBUTES_TL%ROWTYPE;
341: l_return_status varchar2(1);
342: begin
343: -- Find out where the next buffer entry to be written to
344: l_index := 1;

Line 2209: from AK_OBJECT_ATTRIBUTES

2205: from AK_REGIONS
2206: where DATABASE_OBJECT_NAME = database_object_name_param;
2207: cursor l_get_attributes_csr (database_object_name_param varchar2) is
2208: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
2209: from AK_OBJECT_ATTRIBUTES
2210: where DATABASE_OBJECT_NAME = database_object_name_param;
2211: cursor l_get_region_items_csr (region_appl_id_param number,
2212: region_code_param varchar2) is
2213: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE

Line 2224: from ak_attributes aa, ak_object_attributes aoa

2220: where uk.UNIQUE_KEY_NAME = fk.UNIQUE_KEY_NAME
2221: and fk.DATABASE_OBJECT_NAME = database_object_name_param;
2222: cursor l_get_attr_lov_regions_csr (database_object_name_param varchar2) is
2223: select aa.lov_region_application_id, aa.lov_region_code
2224: from ak_attributes aa, ak_object_attributes aoa
2225: where aa.attribute_application_id = aoa.attribute_application_id
2226: and aa.attribute_code = aoa.attribute_code
2227: and aoa.database_object_name = database_object_name_param
2228: and aa.lov_region_code is not null;

Line 2231: from ak_object_attributes

2227: and aoa.database_object_name = database_object_name_param
2228: and aa.lov_region_code is not null;
2229: cursor l_get_objattr_lov_regions_csr (database_object_name_param varchar2) is
2230: select lov_region_application_id, lov_region_code
2231: from ak_object_attributes
2232: where database_object_name = database_object_name_param
2233: and lov_region_code is not null;
2234: cursor l_get_region_lov_regions_csr (region_appl_id_param number,
2235: region_code_param varchar2) is