APPS.AK_QUERY_PKG dependencies on AK_FLOW_PAGE_REGIONS

Line 633: ak_flow_page_regions afpr1,

629: FROM
630: ak_flow_region_relations afrr,
631: ak_regions ar1,
632: ak_regions ar2,
633: ak_flow_page_regions afpr1,
634: ak_flow_page_regions afpr2,
635: ak_objects ao1,
636: ak_objects ao2,
637: ak_foreign_keys afk

Line 634: ak_flow_page_regions afpr2,

630: ak_flow_region_relations afrr,
631: ak_regions ar1,
632: ak_regions ar2,
633: ak_flow_page_regions afpr1,
634: ak_flow_page_regions afpr2,
635: ak_objects ao1,
636: ak_objects ao2,
637: ak_foreign_keys afk
638: WHERE afrr.flow_application_id = flow_appl_id_param

Line 1895: -- First try to get them from AK_FLOW_PAGE_REGIONS

1891: BEGIN
1892: print_debug('** In function: create_region_record **');
1893:
1894: -- Get the rest of the attributes of the region
1895: -- First try to get them from AK_FLOW_PAGE_REGIONS
1896:
1897: BEGIN
1898: SELECT fpr.region_style region_style,
1899: fpr.num_columns number_of_format_columns,

Line 1922: FROM ak_flow_page_regions fpr,

1918: l_region_validation_api_proc,
1919: l_region_defaulting_api_pkg ,
1920: l_region_defaulting_api_proc,
1921: l_display_sequence
1922: FROM ak_flow_page_regions fpr,
1923: ak_regions ar,
1924: ak_regions_tl art,
1925: ak_objects ao
1926: WHERE fpr.flow_application_id = p_region_rec.flow_application_id

Line 1941: -- If AK_FLOW_PAGE_REGIONS does not have a record (i.e. this

1937: AND ao.database_object_name = ar.database_object_name;
1938:
1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN
1941: -- If AK_FLOW_PAGE_REGIONS does not have a record (i.e. this
1942: -- call is for an LOV (i.e. no flow) then get the default information
1943: -- from AK_REGIONS directly
1944: SELECT ar.region_style region_style,
1945: ar.num_columns number_of_format_columns,