APPS.EGO_SEARCH_FWK_PUB dependencies on AK_CUSTOM_REGIONS_TL

Line 36: AK_CUSTOM_REGIONS_TL name_query ,

32:
33: CURSOR fetch_custmztn_code IS
34: select name_query.customization_code customization_code
35: from
36: AK_CUSTOM_REGIONS_TL name_query ,
37: AK_CUSTOM_REGIONS level_id_query ,
38: AK_CUSTOM_REGIONS user_id_query ,
39: EGO_CUSTOMIZATION_EXT ect ,
40: AK_CUSTOM_REGIONS data_level_query

Line 94: UPDATE AK_CUSTOM_REGIONS_TL

90: AND PROPERTY_NAME = 'DEFAULT_RESULT_FLAG'
91: AND CUSTOMIZATION_CODE = l_custmztn_code_tbl(i);
92:
93: FORALL i IN 1..l_custmztn_code_tbl.COUNT
94: UPDATE AK_CUSTOM_REGIONS_TL
95: SET
96: PROPERTY_VARCHAR2_VALUE = 'N'
97: WHERE
98: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID

Line 125: from AK_CUSTOM_REGIONS_TL name_query

121: l_name VARCHAR2(2000);
122:
123: CURSOR get_name IS
124: select name_query.property_varchar2_value name
125: from AK_CUSTOM_REGIONS_TL name_query
126: where name_query.property_name = 'RESULT_NAME'
127: and name_query.language = USERENV('LANG')
128: and name_query.customization_application_id = x_customization_application_id
129: and name_query.customization_code = x_customization_code

Line 299: AK_CUSTOM_REGIONS_TL name_query ,

295: -- get count with customization code (wcc) , with level id (wlv)
296: CURSOR get_cnt_wccwlv IS
297: select count(*) count
298: from
299: AK_CUSTOM_REGIONS_TL name_query ,
300: AK_CUSTOM_REGIONS level_id_query ,
301: AK_CUSTOM_REGIONS user_id_query ,
302: EGO_CUSTOMIZATION_EXT ect
303: where name_query.property_name = 'RESULT_NAME'

Line 336: AK_CUSTOM_REGIONS_TL name_query ,

332: -- get count with customization code (wcc) , without level id (wolv)
333: CURSOR get_cnt_wccwolv IS
334: select count(*) count
335: from
336: AK_CUSTOM_REGIONS_TL name_query ,
337: AK_CUSTOM_REGIONS level_id_query ,
338: AK_CUSTOM_REGIONS user_id_query ,
339: EGO_CUSTOMIZATION_EXT ect
340: where name_query.property_name = 'RESULT_NAME'

Line 369: AK_CUSTOM_REGIONS_TL name_query ,

365: -- get count without customization code (wocc) , with level id (wlv)
366: CURSOR get_cnt_woccwlv IS
367: select count(*) count
368: from
369: AK_CUSTOM_REGIONS_TL name_query ,
370: AK_CUSTOM_REGIONS level_id_query ,
371: AK_CUSTOM_REGIONS user_id_query ,
372: EGO_CUSTOMIZATION_EXT ect
373: where name_query.property_name = 'RESULT_NAME'

Line 405: AK_CUSTOM_REGIONS_TL name_query ,

401: -- get count without customization code (wocc) , without level id (wolv)
402: CURSOR get_cnt_woccwolv IS
403: select count(*) count
404: from
405: AK_CUSTOM_REGIONS_TL name_query ,
406: AK_CUSTOM_REGIONS level_id_query ,
407: AK_CUSTOM_REGIONS user_id_query ,
408: EGO_CUSTOMIZATION_EXT ect
409: where name_query.property_name = 'RESULT_NAME'

Line 1542: AK_CUSTOM_REGIONS_TL name_query ,

1538:
1539: CURSOR get_data_level IS
1540: select data_level_query.property_varchar2_value data_level
1541: from
1542: AK_CUSTOM_REGIONS_TL name_query ,
1543: AK_CUSTOM_REGIONS data_level_query
1544: where name_query.property_name = 'RESULT_NAME'
1545: and name_query.language = USERENV('LANG')
1546: and data_level_query.property_name (+) = 'DATA_LEVEL'

Line 1865: DELETE FROM AK_CUSTOM_REGIONS_TL

1861: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1862: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1863: AND REGION_CODE = X_REGION_CODE;
1864:
1865: DELETE FROM AK_CUSTOM_REGIONS_TL
1866: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1867: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1868: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1869: AND REGION_CODE = X_REGION_CODE;

Line 1919: FROM ak_custom_regions_tl

1915: l_last_updated_by ak_customizations.last_updated_by%TYPE;
1916:
1917: CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS
1918: SELECT last_updated_by, last_update_date
1919: FROM ak_custom_regions_tl
1920: WHERE customization_application_id = p_customization_application_id
1921: AND customization_code = p_customization_code
1922: AND region_application_id = p_region_application_id
1923: AND region_code = p_region_code