DBA Data[Home] [Help]

APPS.AK_FLOW_PVT dependencies on AK_FLOW_PAGES_TL

Line 1174: insert into AK_FLOW_PAGES_TL (

1170: end if;
1171: raise FND_API.G_EXC_ERROR;
1172: end if;
1173:
1174: insert into AK_FLOW_PAGES_TL (
1175: FLOW_APPLICATION_ID,
1176: FLOW_CODE,
1177: PAGE_APPLICATION_ID,
1178: PAGE_CODE,

Line 1206: from AK_FLOW_PAGES_TL T

1202: from FND_LANGUAGES L
1203: where L.INSTALLED_FLAG in ('I', 'B')
1204: and not exists
1205: (select NULL
1206: from AK_FLOW_PAGES_TL T
1207: where T.FLOW_APPLICATION_ID = p_flow_application_id
1208: and T.FLOW_CODE = p_flow_code
1209: and T.PAGE_APPLICATION_ID = p_page_application_id
1210: and T.PAGE_CODE = p_page_code

Line 3142: delete from ak_flow_pages_tl

3138: end if;
3139: raise FND_API.G_EXC_ERROR;
3140: end if;
3141:
3142: delete from ak_flow_pages_tl
3143: where flow_application_id = p_flow_application_id
3144: and flow_code = p_flow_code
3145: and page_application_id = p_page_application_id
3146: and page_code = p_page_code;

Line 4561: from AK_FLOW_PAGES_TL

4557: and page_code = p_page_code
4558: for update of primary_region_appl_id;
4559: cursor l_get_tl_row_csr (lang_parm varchar2) is
4560: select *
4561: from AK_FLOW_PAGES_TL
4562: where FLOW_APPLICATION_ID = p_flow_application_id
4563: and FLOW_CODE = p_flow_code
4564: and page_application_id = p_page_application_id
4565: and page_code = p_page_code

Line 4580: l_pages_tl_rec ak_flow_pages_tl%ROWTYPE;

4576: l_last_update_date date;
4577: l_last_update_login number;
4578: l_last_updated_by number;
4579: l_pages_rec ak_flow_pages%ROWTYPE;
4580: l_pages_tl_rec ak_flow_pages_tl%ROWTYPE;
4581: l_return_status varchar2(1);
4582: l_file_version number;
4583: begin
4584: IF NOT FND_API.Compatible_API_Call (

Line 4817: update AK_FLOW_PAGES_TL set

4813: end if;
4814: raise FND_API.G_EXC_ERROR;
4815: end if;
4816:
4817: update AK_FLOW_PAGES_TL set
4818: NAME = l_pages_tl_rec.name,
4819: DESCRIPTION = l_pages_tl_rec.description,
4820: LAST_UPDATED_BY = l_last_updated_by,
4821: LAST_UPDATE_DATE = l_last_update_date,