APPS.AK_KEY_PVT dependencies on AK_FOREIGN_KEYS_TL

Line 337: insert into AK_FOREIGN_KEYS_TL (

333: --dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
334: raise FND_API.G_EXC_ERROR;
335: end if;
336:
337: insert into AK_FOREIGN_KEYS_TL (
338: FOREIGN_KEY_NAME,
339: LANGUAGE,
340: FROM_TO_NAME,
341: FROM_TO_DESCRIPTION,

Line 367: from AK_FOREIGN_KEYS_TL T

363: from FND_LANGUAGES L
364: where L.INSTALLED_FLAG in ('I', 'B')
365: and not exists
366: (select NULL
367: from AK_FOREIGN_KEYS_TL T
368: where T.FOREIGN_KEY_NAME = p_foreign_key_name
369: and T.LANGUAGE = L.LANGUAGE_CODE);
370:
371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

Line 1664: delete from ak_foreign_keys_tl

1660: end if;
1661: raise FND_API.G_EXC_ERROR;
1662: end if;
1663:
1664: delete from ak_foreign_keys_tl
1665: where foreign_key_name = p_foreign_key_name;
1666:
1667: if (sql%notfound) then
1668: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 2623: from AK_FOREIGN_KEYS_TL

2619: where FOREIGN_KEY_NAME = p_foreign_key_name
2620: for update of DATABASE_OBJECT_NAME;
2621: cursor l_get_tl_row_csr (lang_parm varchar2) is
2622: select *
2623: from AK_FOREIGN_KEYS_TL
2624: where FOREIGN_KEY_NAME = p_foreign_key_name
2625: and LANGUAGE = lang_parm
2626: for update of FROM_TO_NAME;
2627: l_api_version_number CONSTANT number := 1.0;

Line 2632: l_foreign_key_tl_rec ak_foreign_keys_tl%ROWTYPE;

2628: l_api_name CONSTANT varchar2(30):= 'Update_Foreign_Key';
2629: l_created_by number;
2630: l_creation_date date;
2631: l_foreign_key_rec ak_foreign_keys%ROWTYPE;
2632: l_foreign_key_tl_rec ak_foreign_keys_tl%ROWTYPE;
2633: l_error boolean;
2634: l_lang varchar2(30);
2635: l_last_update_date date;
2636: l_last_update_login number;

Line 2674: --** retrieve ak_foreign_keys_tl row if it exists **

2670: raise FND_API.G_EXC_ERROR;
2671: end if;
2672: close l_get_row_csr;
2673:
2674: --** retrieve ak_foreign_keys_tl row if it exists **
2675: open l_get_tl_row_csr(l_lang);
2676: fetch l_get_tl_row_csr into l_foreign_key_tl_rec;
2677: if (l_get_tl_row_csr%notfound) then
2678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 2868: update AK_FOREIGN_KEYS_TL set

2864: -- dbms_output.put_line('Row does not exist during update');
2865: raise FND_API.G_EXC_ERROR;
2866: end if;
2867:
2868: update AK_FOREIGN_KEYS_TL set
2869: FROM_TO_NAME = l_foreign_key_tl_rec.from_to_name,
2870: FROM_TO_DESCRIPTION = l_foreign_key_tl_rec.from_to_description,
2871: TO_FROM_NAME = l_foreign_key_tl_rec.to_from_name,
2872: TO_FROM_DESCRIPTION = l_foreign_key_tl_rec.to_from_description,