[Home] [Help]
266: p_attribute_code IN VARCHAR2
267: ) return BOOLEAN is
268: cursor l_check_csr is
269: select 1
270: from AK_FLOW_PAGE_REGION_ITEMS
271: where flow_application_id = p_flow_application_id
272: and flow_code = p_flow_code
273: and page_application_id = p_page_application_id
274: and page_code = p_page_code
2161:
2162: select userenv('LANG') into l_lang
2163: from dual;
2164:
2165: insert into AK_FLOW_PAGE_REGION_ITEMS (
2166: FLOW_APPLICATION_ID,
2167: FLOW_CODE,
2168: PAGE_APPLICATION_ID,
2169: PAGE_CODE,
3243: p_delete_cascade IN VARCHAR2
3244: ) is
3245: cursor l_get_items_csr is
3246: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
3247: from AK_FLOW_PAGE_REGION_ITEMS
3248: where flow_application_id = p_flow_application_id
3249: and flow_code = p_flow_code
3250: and page_application_id = p_page_application_id
3251: and page_code = p_page_code
3344: -- If we are not deleting any referencing records, we cannot
3345: -- delete the flow page region if it is being referenced in any of
3346: -- following tables.
3347: --
3348: -- AK_FLOW_PAGE_REGION_ITEMS
3349: --
3350: open l_get_items_csr;
3351: fetch l_get_items_csr into l_attribute_appl_id, l_attribute_code;
3352: if l_get_items_csr%found then
3419: else
3420: --
3421: -- Otherwise, delete all referencing rows in other tables
3422: --
3423: -- AK_FLOW_PAGE_REGION_ITEMS
3424: --
3425: open l_get_items_csr;
3426: loop
3427: fetch l_get_items_csr into l_attribute_appl_id, l_attribute_code;
3771: --
3772: -- delete page region item once we checked that there are no references
3773: -- to it, or all references have been deleted.
3774: --
3775: delete from ak_flow_page_region_items
3776: where flow_application_id = p_flow_application_id
3777: and flow_code = p_flow_code
3778: and page_application_id = p_page_application_id
3779: and page_code = p_page_code
3898: p_delete_cascade IN VARCHAR2
3899: ) is
3900: cursor l_get_items_csr is
3901: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
3902: from AK_FLOW_PAGE_REGION_ITEMS
3903: where flow_application_id = p_flow_application_id
3904: and flow_code = p_flow_code
3905: and page_application_id = p_from_page_appl_id
3906: and page_code = p_from_page_code
3960: -- If we are not deleting any referencing records, we cannot
3961: -- delete the region relation if it is being referenced in any of
3962: -- following tables.
3963: --
3964: -- AK_FLOW_PAGE_REGION_ITEMS
3965: --
3966: open l_get_items_csr;
3967: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
3968: if l_get_items_csr%found then
5587: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
5588: ) is
5589: cursor l_get_row_csr is
5590: select *
5591: from AK_FLOW_PAGE_REGION_ITEMS
5592: where FLOW_APPLICATION_ID = p_flow_application_id
5593: and FLOW_CODE = p_flow_code
5594: and page_application_id = p_page_application_id
5595: and page_code = p_page_code
5606: l_lang varchar2(30);
5607: l_last_update_date date;
5608: l_last_update_login number;
5609: l_last_updated_by number;
5610: l_items_rec ak_flow_page_region_items%ROWTYPE;
5611: l_return_status varchar2(1);
5612: l_file_version number;
5613: begin
5614: IF NOT FND_API.Compatible_API_Call (
5629: select userenv('LANG') into l_lang
5630: from dual;
5631:
5632: --
5633: -- retrieve ak_flow_page_region_items row if it exists
5634: --
5635: open l_get_row_csr;
5636: fetch l_get_row_csr into l_items_rec;
5637: if (l_get_row_csr%notfound) then
5821: p_db_last_update_date => l_items_rec.last_update_date,
5822: p_last_update_login => l_last_update_login,
5823: p_create_or_update => 'UPDATE') then
5824:
5825: update AK_FLOW_PAGE_REGION_ITEMS set
5826: TO_PAGE_APPL_ID = l_items_rec.to_page_appl_id,
5827: TO_PAGE_CODE = l_items_rec.to_page_code,
5828: TO_URL_ATTRIBUTE_APPL_ID = l_items_rec.to_url_attribute_appl_id,
5829: TO_URL_ATTRIBUTE_CODE = l_items_rec.to_url_attribute_code,