DBA Data[Home] [Help]

APPS.AK_FLOW2_PVT dependencies on AK_FLOW_PAGE_REGIONS

Line 358: from AK_FLOW_PAGE_REGIONS

354: p_page_code IN VARCHAR2
355: ) is
356: cursor l_get_regions_csr is
357: select *
358: from AK_FLOW_PAGE_REGIONS
359: where FLOW_APPLICATION_ID = p_flow_application_id
360: and FLOW_CODE = p_flow_code
361: and PAGE_APPLICATION_ID = p_page_application_id
362: and PAGE_CODE = p_page_code;

Line 383: l_regions_rec AK_FLOW_PAGE_REGIONS%ROWTYPE;

379: l_api_name CONSTANT varchar2(30) := 'Write_Region_to_buffer';
380: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
381: l_foreign_key_name VARCHAR2(30);
382: l_index NUMBER;
383: l_regions_rec AK_FLOW_PAGE_REGIONS%ROWTYPE;
384: l_return_status varchar2(1);
385: begin
386: -- Find out where the next buffer entry to be written to
387: l_index := 1;

Line 988: -- Load Page regions (AK_FLOW_PAGE_REGIONS) and their page region

984: end if;
985:
986: l_databuffer_tbl.delete;
987:
988: -- Load Page regions (AK_FLOW_PAGE_REGIONS) and their page region
989: -- item (AK_FLOW_PAGE_REGION_ITEMS)
990: WRITE_REGIONS_TO_BUFFER (
991: p_validation_level => p_validation_level,
992: p_return_status => l_return_status,

Line 1755: from AK_FLOW_PAGE_REGIONS

1751: where FLOW_APPLICATION_ID = appl_id_parm;
1752: cursor l_get_regions_csr (flow_appl_id_param number,
1753: flow_code_param varchar2) is
1754: select distinct REGION_APPLICATION_ID, REGION_CODE
1755: from AK_FLOW_PAGE_REGIONS
1756: where flow_application_id = flow_appl_id_param
1757: and flow_code = flow_code_param;
1758: l_api_version_number CONSTANT number := 1.0;
1759: l_api_name CONSTANT varchar2(30) := 'Download_Flow';

Line 3788: from ak_flow_page_regions

3784: );
3785: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
3786: select last_updated_by, last_update_date
3787: into l_user_id1, l_update1
3788: from ak_flow_page_regions
3789: where flow_code = l_region_tbl(l_index).flow_code
3790: and flow_application_id = l_region_tbl(l_index).flow_application_id
3791: and page_code = l_region_tbl(l_index).page_code
3792: and page_application_id = l_region_tbl(l_index).page_application_id