DBA Data[Home] [Help]

APPS.ICX_ON_CABO dependencies on AK_FLOW_PAGES_VL

Line 83: from AK_FLOW_PAGES_VL

79: select PRIMARY_REGION_APPL_ID,PRIMARY_REGION_CODE,
80: NAME,DESCRIPTION
81: into l_region_appl_id,l_region_code,
82: l_page_title,l_page_description
83: from AK_FLOW_PAGES_VL
84: where PAGE_CODE = p_page_code
85: and PAGE_APPLICATION_ID = p_page_appl_id
86: and FLOW_CODE = p_flow_code
87: and FLOW_APPLICATION_ID = p_flow_appl_id;

Line 502: from AK_FLOW_PAGES_VL

498: htp.formOpen('javascript:submitFunction()','POST','','','NAME="findForm"');
499:
500: select NAME,DESCRIPTION
501: into l_page_title,l_page_description
502: from AK_FLOW_PAGES_VL
503: where PAGE_CODE = p_page_code
504: and PAGE_APPLICATION_ID = p_page_appl_id
505: and FLOW_CODE = p_flow_code
506: and FLOW_APPLICATION_ID = p_flow_appl_id;

Line 705: from AK_FLOW_PAGES_VL

701: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
702:
703: select NAME,DESCRIPTION
704: into l_page_title,l_page_description
705: from AK_FLOW_PAGES_VL
706: where PAGE_CODE = l_page_code
707: and PAGE_APPLICATION_ID = l_page_appl_id
708: and FLOW_CODE = l_flow_code
709: and FLOW_APPLICATION_ID = l_flow_appl_id;

Line 879: from AK_FLOW_PAGES_VL

875: begin
876:
877: select NAME,DESCRIPTION
878: into l_page_title,l_page_description
879: from AK_FLOW_PAGES_VL
880: where PAGE_CODE = icx_on_utilities.g_on_parameters(5)
881: and PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
882: and FLOW_CODE = icx_on_utilities.g_on_parameters(3)
883: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);

Line 943: from AK_FLOW_PAGES_VL

939: where ROWID = icx_on_utilities.g_on_parameters(10);
940:
941: select NAME,DESCRIPTION
942: into l_page_title,l_page_description
943: from AK_FLOW_PAGES_VL
944: where PAGE_CODE = l_page_code
945: and PAGE_APPLICATION_ID = l_page_appl_id
946: and FLOW_CODE = l_flow_code
947: and FLOW_APPLICATION_ID = l_flow_appl_id;