DBA Data[Home] [Help]

APPS.AK_OBJECT2_PVT dependencies on AK_OBJECTS

Line 1779: from AK_OBJECTS

1775: p_nls_language IN VARCHAR2
1776: ) is
1777: cursor l_get_object_csr is
1778: select *
1779: from AK_OBJECTS
1780: where DATABASE_OBJECT_NAME = p_database_object_name;
1781: cursor l_get_object_tl_csr is
1782: select *
1783: from AK_OBJECTS_TL

Line 1783: from AK_OBJECTS_TL

1779: from AK_OBJECTS
1780: where DATABASE_OBJECT_NAME = p_database_object_name;
1781: cursor l_get_object_tl_csr is
1782: select *
1783: from AK_OBJECTS_TL
1784: where database_object_name = p_database_object_name
1785: and language = p_nls_language;
1786: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1787: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

Line 1789: l_objects_rec AK_OBJECTS%ROWTYPE;

1785: and language = p_nls_language;
1786: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1787: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1788: l_index NUMBER;
1789: l_objects_rec AK_OBJECTS%ROWTYPE;
1790: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;
1791: l_return_status varchar2(1);
1792: begin
1793: -- Retrieve object information from the database

Line 1790: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;

1786: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1787: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1788: l_index NUMBER;
1789: l_objects_rec AK_OBJECTS%ROWTYPE;
1790: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;
1791: l_return_status varchar2(1);
1792: begin
1793: -- Retrieve object information from the database
1794:

Line 1816: -- dbms_output.put_line('Cannot find object in ak_objects_tl '||p_database_object_name);

1812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1813: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1814: FND_MSG_PUB.Add;
1815: end if;
1816: -- dbms_output.put_line('Cannot find object in ak_objects_tl '||p_database_object_name);
1817: RAISE FND_API.G_EXC_ERROR;
1818: end if;
1819: close l_get_object_tl_csr;
1820:

Line 2201: from AK_OBJECTS

2197: p_get_region_flag IN VARCHAR2
2198: ) is
2199: cursor l_get_object_list_csr (appl_id_parm number) is
2200: select database_object_name
2201: from AK_OBJECTS
2202: where APPLICATION_ID = appl_id_parm;
2203: cursor l_get_regions_csr (database_object_name_param varchar2) is
2204: select REGION_APPLICATION_ID, REGION_CODE
2205: from AK_REGIONS

Line 2268: -- dbms_output.put_line('API error in AK_OBJECTS2_PVT');

2264: begin
2265: IF NOT FND_API.Compatible_API_Call (
2266: l_api_version_number, p_api_version_number, l_api_name,
2267: G_PKG_NAME) then
2268: -- dbms_output.put_line('API error in AK_OBJECTS2_PVT');
2269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: return;
2271: END IF;
2272: