eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_FLOW2_PVT dependencies on AK_FLOWS

Line 1397: from AK_FLOWS

1393: p_nls_language IN VARCHAR2
1394: ) is
1395: cursor l_get_flow_csr is
1396: select *
1397: from AK_FLOWS
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 *

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 1409: l_flows_rec AK_FLOWS%ROWTYPE;

1405: and LANGUAGE = p_nls_language;
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

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 1750: from AK_FLOWS

1746: p_nls_language IN VARCHAR2
1747: ) is
1748: cursor l_get_flow_list_csr (appl_id_parm number) is
1749: select flow_application_id, flow_code
1750: from AK_FLOWS
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

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