[Home] [Help]
731: end if;
732: raise FND_API.G_EXC_ERROR;
733: end if;
734:
735: insert into AK_FLOWS_TL (
736: FLOW_APPLICATION_ID,
737: FLOW_CODE,
738: LANGUAGE,
739: NAME,
759: from FND_LANGUAGES L
760: where L.INSTALLED_FLAG in ('I', 'B')
761: and not exists
762: (select NULL
763: from AK_FLOWS_TL T
764: where T.FLOW_APPLICATION_ID = p_flow_application_id
765: and T.FLOW_CODE = p_flow_code
766: and T.LANGUAGE = L.LANGUAGE_CODE);
767:
2867: end if;
2868: raise FND_API.G_EXC_ERROR;
2869: end if;
2870:
2871: delete from ak_flows_tl
2872: where flow_application_id = p_flow_application_id
2873: and flow_code = p_flow_code;
2874:
2875: if (sql%notfound) then
4160: and FLOW_CODE = p_flow_code
4161: for update of primary_page_appl_id;
4162: cursor l_get_tl_row_csr (lang_parm varchar2) is
4163: select *
4164: from AK_FLOWS_TL
4165: where FLOW_APPLICATION_ID = p_flow_application_id
4166: and FLOW_CODE = p_flow_code
4167: and LANGUAGE = lang_parm
4168: for update of name;
4170: l_api_name CONSTANT varchar2(30) := 'Update_Flow';
4171: l_created_by number;
4172: l_creation_date date;
4173: l_flows_rec ak_flows%ROWTYPE;
4174: l_flows_tl_rec ak_flows_tl%ROWTYPE;
4175: l_error boolean;
4176: l_lang varchar2(30);
4177: l_last_update_date date;
4178: l_last_update_login number;
4213: end if;
4214: close l_get_row_csr;
4215:
4216: --
4217: -- retrieve ak_flows_tl row if it exists
4218: --
4219: open l_get_tl_row_csr(l_lang);
4220: fetch l_get_tl_row_csr into l_flows_tl_rec;
4221: if (l_get_tl_row_csr%notfound) then
4409: end if;
4410: raise FND_API.G_EXC_ERROR;
4411: end if;
4412:
4413: update AK_FLOWS_TL set
4414: NAME = l_flows_tl_rec.name,
4415: DESCRIPTION = l_flows_tl_rec.description,
4416: LAST_UPDATED_BY = l_last_updated_by,
4417: LAST_UPDATE_DATE = l_last_update_date,