DBA Data[Home] [Help]

APPS.AK_FLOW2_PVT dependencies on AK_FLOW_PAGES_TL

Line 751: from AK_FLOW_PAGES_TL

747: and FLOW_CODE = p_flow_code;
748: cursor l_get_page_tl_csr (page_appl_id_param number,
749: page_code_param varchar2) is
750: select *
751: from AK_FLOW_PAGES_TL
752: where FLOW_APPLICATION_ID = p_flow_application_id
753: and FLOW_CODE = p_flow_code
754: and PAGE_APPLICATION_ID = page_appl_id_param
755: and PAGE_CODE = page_code_param

Line 761: l_pages_tl_rec AK_FLOW_PAGES_TL%ROWTYPE;

757: l_api_name CONSTANT varchar2(30) := 'Write_Pages_to_buffer';
758: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
759: l_index NUMBER;
760: l_pages_rec AK_FLOW_PAGES%ROWTYPE;
761: l_pages_tl_rec AK_FLOW_PAGES_TL%ROWTYPE;
762: l_return_status varchar2(1);
763: begin
764: -- Find out where the next buffer entry to be written to
765: l_index := 1;

Line 4057: from ak_flow_pages afp, ak_flow_pages_tl afpt

4053: afpt.last_updated_by,
4054: afp.last_update_date, afpt.last_update_date
4055: into l_temp_key_code, l_temp_key_appl_id,
4056: l_user_id1 , l_user_id2, l_update1, l_update2
4057: from ak_flow_pages afp, ak_flow_pages_tl afpt
4058: where afp.flow_code = l_page_tbl(l_index).flow_code
4059: and afp.flow_application_id = l_page_tbl(l_index).flow_application_id
4060: and afp.page_code = l_page_tbl(l_index).page_code
4061: and afp.page_application_id = l_page_tbl(l_index).page_application_id