DBA Data[Home] [Help]

APPS.AK_FLOW2_PVT dependencies on AK_FLOWS_TL

Line 1402: from AK_FLOWS_TL

1398: where flow_application_id = p_flow_application_id
1399: and flow_code = p_flow_code;
1400: cursor l_get_flow_tl_csr is
1401: select *
1402: from AK_FLOWS_TL
1403: where flow_application_id = p_flow_application_id
1404: and flow_code = p_flow_code
1405: and LANGUAGE = p_nls_language;
1406: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';

Line 1410: l_flows_tl_rec AK_FLOWS_TL%ROWTYPE;

1406: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1407: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1408: l_index NUMBER;
1409: l_flows_rec AK_FLOWS%ROWTYPE;
1410: l_flows_tl_rec AK_FLOWS_TL%ROWTYPE;
1411: l_return_status varchar2(1);
1412: begin
1413: -- Retrieve flow information from the database
1414:

Line 3628: from ak_flows af, ak_flows_tl aft

3624: select af.primary_page_code, af.primary_page_appl_id, af.last_updated_by,
3625: aft.last_updated_by,
3626: af.last_update_date, aft.last_update_date
3627: into l_temp_key_code, l_temp_key_appl_id, l_user_id1, l_user_id2, l_update1, l_update2
3628: from ak_flows af, ak_flows_tl aft
3629: where af.flow_code = l_flow_tbl(l_index).flow_code
3630: and af.flow_application_id = l_flow_tbl(l_index).flow_application_id
3631: and af.flow_code = aft.flow_code
3632: and af.flow_application_id = aft.flow_application_id