APPS.EGO_SEARCH_FWK_PUB dependencies on EGO_CUSTOMIZATION_EXT

Line 39: EGO_CUSTOMIZATION_EXT ect ,

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
41: where name_query.property_name = 'RESULT_NAME'
42: and name_query.language = USERENV('LANG')
43: and name_query.customization_application_id = level_id_query.customization_application_id

Line 144: EGO_CUSTOMIZATION_EXT

140: COUNT(*)
141: INTO
142: l_count
143: FROM
144: EGO_CUSTOMIZATION_EXT
145: WHERE
146: RF_CUSTOMIZATION_APPL_ID = X_CUSTOMIZATION_APPLICATION_ID
147: AND RF_CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
148: AND RF_REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 302: EGO_CUSTOMIZATION_EXT ect

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'
304: and name_query.language = USERENV('LANG')
305: and name_query.customization_application_id = level_id_query.customization_application_id
306: and name_query.customization_code = level_id_query.customization_code

Line 339: EGO_CUSTOMIZATION_EXT ect

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'
341: and name_query.language = USERENV('LANG')
342: and name_query.customization_application_id = level_id_query.customization_application_id
343: and name_query.customization_code = level_id_query.customization_code

Line 372: EGO_CUSTOMIZATION_EXT ect

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'
374: and name_query.language = USERENV('LANG')
375: and name_query.customization_application_id = level_id_query.customization_application_id
376: and name_query.customization_code = level_id_query.customization_code

Line 408: EGO_CUSTOMIZATION_EXT ect

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'
410: and name_query.language = USERENV('LANG')
411: and name_query.customization_application_id = level_id_query.customization_application_id
412: and name_query.customization_code = level_id_query.customization_code

Line 553: EGO_CUSTOMIZATION_EXT

549: AND CUSTOMIZATION_CODE IN (
550: SELECT
551: CUSTOMIZATION_CODE
552: FROM
553: EGO_CUSTOMIZATION_EXT
554: WHERE
555: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
556: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
557: AND REGION_CODE = X_REGION_CODE

Line 597: INSERT INTO EGO_CUSTOMIZATION_EXT

593: X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
594: X_END_DATE_ACTIVE => X_END_DATE_ACTIVE
595: );
596:
597: INSERT INTO EGO_CUSTOMIZATION_EXT
598: (
599: CUSTOMIZATION_APPLICATION_ID,
600: CUSTOMIZATION_CODE,
601: REGION_APPLICATION_ID,

Line 723: EGO_CUSTOMIZATION_EXT

719: AND CUSTOMIZATION_CODE IN (
720: SELECT
721: CUSTOMIZATION_CODE
722: FROM
723: EGO_CUSTOMIZATION_EXT
724: WHERE
725: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
726: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
727: AND REGION_CODE = X_REGION_CODE

Line 761: EGO_CUSTOMIZATION_EXT

757:
758: --Now we try to update the results format
759:
760: UPDATE
761: EGO_CUSTOMIZATION_EXT
762: SET
763: RF_CUSTOMIZATION_APPL_ID = X_RF_CUSTOMIZATION_APPL_ID,
764: RF_CUSTOMIZATION_CODE = X_RF_CUSTOMIZATION_CODE,
765: RF_REGION_APPLICATION_ID = X_RF_REGION_APPLICATION_ID,

Line 865: EGO_CUSTOMIZATION_EXT

861: );
862:
863: DELETE
864: FROM
865: EGO_CUSTOMIZATION_EXT
866: WHERE
867: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
868: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
869: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1460: INSERT INTO EGO_CUSTOMIZATION_EXT

1456:
1457:
1458: END IF;
1459:
1460: INSERT INTO EGO_CUSTOMIZATION_EXT
1461: (
1462: CUSTOMIZATION_APPLICATION_ID,
1463: CUSTOMIZATION_CODE,
1464: REGION_APPLICATION_ID,

Line 1871: DELETE FROM EGO_CUSTOMIZATION_EXT

1867: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1868: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1869: AND REGION_CODE = X_REGION_CODE;
1870:
1871: DELETE FROM EGO_CUSTOMIZATION_EXT
1872: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1873: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1874: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1875: AND REGION_CODE = X_REGION_CODE;