APPS.AK_FLOW2_PVT dependencies on AK_FLOW_PAGE_REGION_ITEMS

Line 46: from AK_FLOW_PAGE_REGION_ITEMS

42: p_region_code IN VARCHAR2
43: ) is
44: cursor l_get_items_csr is
45: select *
46: from AK_FLOW_PAGE_REGION_ITEMS
47: where FLOW_APPLICATION_ID = p_flow_application_id
48: and FLOW_CODE = p_flow_code
49: and PAGE_APPLICATION_ID = p_page_application_id
50: and PAGE_CODE = p_page_code

Line 56: l_items_rec AK_FLOW_PAGE_REGION_ITEMS%ROWTYPE;

52: and REGION_CODE = p_region_code;
53: l_api_name CONSTANT varchar2(30) := 'Write_Items_to_buffer';
54: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
55: l_index NUMBER;
56: l_items_rec AK_FLOW_PAGE_REGION_ITEMS%ROWTYPE;
57: l_return_status varchar2(1);
58: begin
59: -- Find out where the next buffer entry to be written to
60: l_index := 1;

Line 640: -- Load region items (AK_FLOW_PAGE_REGION_ITEMS)

636: end if;
637:
638: l_databuffer_tbl.delete;
639:
640: -- Load region items (AK_FLOW_PAGE_REGION_ITEMS)
641: WRITE_ITEMS_TO_BUFFER (
642: p_validation_level => p_validation_level,
643: p_return_status => l_return_status,
644: p_flow_application_id => p_flow_application_id,

Line 989: -- item (AK_FLOW_PAGE_REGION_ITEMS)

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,
993: p_flow_application_id => p_flow_application_id,

Line 4446: from ak_flow_page_region_items

4442: );
4443: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4444: select last_updated_by, last_update_date
4445: into l_user_id1, l_update1
4446: from ak_flow_page_region_items
4447: where flow_code = l_item_tbl(l_index).flow_code
4448: and flow_application_id = l_item_tbl(l_index).flow_application_id
4449: and page_code = l_item_tbl(l_index).page_code
4450: and page_application_id = l_item_tbl(l_index).page_application_id