APPS.AK_OBJECT2_PVT dependencies on AK_FOREIGN_KEYS

Line 820: from AK_FOREIGN_KEYS

816: p_nls_language IN VARCHAR2
817: ) is
818: cursor l_get_foreign_keys_csr is
819: select *
820: from AK_FOREIGN_KEYS
821: where DATABASE_OBJECT_NAME = p_database_object_name;
822: cursor l_get_foreign_key_tl_csr (foreign_key_name_param varchar2) is
823: select *
824: from AK_FOREIGN_KEYS_TL

Line 824: from AK_FOREIGN_KEYS_TL

820: from AK_FOREIGN_KEYS
821: where DATABASE_OBJECT_NAME = p_database_object_name;
822: cursor l_get_foreign_key_tl_csr (foreign_key_name_param varchar2) is
823: select *
824: from AK_FOREIGN_KEYS_TL
825: where FOREIGN_KEY_NAME = foreign_key_name_param
826: and LANGUAGE = p_nls_language;
827: cursor l_get_key_columns_csr (foreign_key_name_param varchar2) is
828: select *

Line 834: l_foreign_keys_rec AK_FOREIGN_KEYS%ROWTYPE;

830: where FOREIGN_KEY_NAME = foreign_key_name_param;
831: l_api_name CONSTANT varchar2(30) := 'Write_Foreign_key_to_buffer';
832: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
833: l_index NUMBER;
834: l_foreign_keys_rec AK_FOREIGN_KEYS%ROWTYPE;
835: l_foreign_keys_tl_rec AK_FOREIGN_KEYS_TL%ROWTYPE;
836: l_key_columns_rec AK_FOREIGN_KEY_COLUMNS%ROWTYPE;
837: l_return_status varchar2(1);
838: begin

Line 835: l_foreign_keys_tl_rec AK_FOREIGN_KEYS_TL%ROWTYPE;

831: l_api_name CONSTANT varchar2(30) := 'Write_Foreign_key_to_buffer';
832: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
833: l_index NUMBER;
834: l_foreign_keys_rec AK_FOREIGN_KEYS%ROWTYPE;
835: l_foreign_keys_tl_rec AK_FOREIGN_KEYS_TL%ROWTYPE;
836: l_key_columns_rec AK_FOREIGN_KEY_COLUMNS%ROWTYPE;
837: l_return_status varchar2(1);
838: begin
839: -- Find out where the next buffer entry to be written to

Line 2219: from AK_UNIQUE_KEYS uk, AK_FOREIGN_KEYS fk

2215: where REGION_APPLICATION_ID = region_appl_id_param
2216: and REGION_CODE = region_code_param;
2217: cursor l_get_fk_objects_csr (database_object_name_param varchar2) is
2218: select uk.DATABASE_OBJECT_NAME
2219: from AK_UNIQUE_KEYS uk, AK_FOREIGN_KEYS fk
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