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 833: EGO_CUSTOMIZATION_EXT

829: );
830:
831: DELETE
832: FROM
833: EGO_CUSTOMIZATION_EXT
834: WHERE
835: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
836: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
837: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 1428: INSERT INTO EGO_CUSTOMIZATION_EXT

1424:
1425:
1426: END IF;
1427:
1428: INSERT INTO EGO_CUSTOMIZATION_EXT
1429: (
1430: CUSTOMIZATION_APPLICATION_ID,
1431: CUSTOMIZATION_CODE,
1432: REGION_APPLICATION_ID,

Line 1839: DELETE FROM EGO_CUSTOMIZATION_EXT

1835: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1836: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1837: AND REGION_CODE = X_REGION_CODE;
1838:
1839: DELETE FROM EGO_CUSTOMIZATION_EXT
1840: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1841: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1842: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1843: AND REGION_CODE = X_REGION_CODE;