eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_SEARCH_FWK_PUB dependencies on AK_CUSTOMIZATIONS

Line 540: AK_CUSTOMIZATIONS

536:
537: IF(X_DEFAULT_CUSTOMIZATION_FLAG = 'Y') THEN
538:
539: UPDATE
540: AK_CUSTOMIZATIONS
541: SET
542: DEFAULT_CUSTOMIZATION_FLAG = 'N'
543: WHERE
544: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID

Line 571: AK_CUSTOMIZATIONS_PKG.INSERT_ROW

567: l_current_user := g_current_user_id;
568: END IF;
569:
570:
571: AK_CUSTOMIZATIONS_PKG.INSERT_ROW
572: (
573: X_ROWID => l_rowid,
574: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
575: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,

Line 710: AK_CUSTOMIZATIONS

706:
707: IF( X_DEFAULT_CUSTOMIZATION_FLAG = 'Y') THEN
708:
709: UPDATE
710: AK_CUSTOMIZATIONS
711: SET
712: DEFAULT_CUSTOMIZATION_FLAG = 'N'
713: WHERE
714: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID

Line 735: AK_CUSTOMIZATIONS_PKG.UPDATE_ROW

731: );
732: END IF;
733:
734:
735: AK_CUSTOMIZATIONS_PKG.UPDATE_ROW
736: (
737: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
738: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
739: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 823: AK_CUSTOMIZATIONS_PKG.DELETE_ROW

819: AND RF_REGION_CODE = X_REGION_CODE;
820:
821: IF (l_count = 0) THEN
822:
823: AK_CUSTOMIZATIONS_PKG.DELETE_ROW
824: (
825: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
826: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
827: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 898: FROM ak_customizations_tl

894: ) IS
895:
896: CURSOR c_get_last_update_info IS
897: SELECT last_updated_by, last_update_date
898: FROM ak_customizations_tl
899: WHERE customization_application_id = p_customization_application_id
900: AND customization_code = p_customization_code
901: AND region_application_id = p_region_application_id
902: AND region_code = p_region_code

Line 905: l_last_update_date ak_customizations.last_update_date%TYPE;

901: AND region_application_id = p_region_application_id
902: AND region_code = p_region_code
903: AND USERENV('LANG') IN (language, source_lang);
904:
905: l_last_update_date ak_customizations.last_update_date%TYPE;
906: l_last_updated_by ak_customizations.last_updated_by%TYPE;
907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;

Line 906: l_last_updated_by ak_customizations.last_updated_by%TYPE;

902: AND region_code = p_region_code
903: AND USERENV('LANG') IN (language, source_lang);
904:
905: l_last_update_date ak_customizations.last_update_date%TYPE;
906: l_last_updated_by ak_customizations.last_updated_by%TYPE;
907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;

Line 907: l_verticalization_id ak_customizations.verticalization_id%TYPE;

903: AND USERENV('LANG') IN (language, source_lang);
904:
905: l_last_update_date ak_customizations.last_update_date%TYPE;
906: l_last_updated_by ak_customizations.last_updated_by%TYPE;
907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;

Line 908: l_localization_code ak_customizations.localization_code%TYPE;

904:
905: l_last_update_date ak_customizations.last_update_date%TYPE;
906: l_last_updated_by ak_customizations.last_updated_by%TYPE;
907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;

Line 909: l_org_id ak_customizations.org_id%TYPE;

905: l_last_update_date ak_customizations.last_update_date%TYPE;
906: l_last_updated_by ak_customizations.last_updated_by%TYPE;
907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;

Line 910: l_site_id ak_customizations.site_id%TYPE;

906: l_last_updated_by ak_customizations.last_updated_by%TYPE;
907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;

Line 911: l_responsibility_id ak_customizations.responsibility_id%TYPE;

907: l_verticalization_id ak_customizations.verticalization_id%TYPE;
908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;
915: l_start_date_active ak_customizations.start_date_active%TYPE;

Line 912: l_web_user_id ak_customizations.web_user_id%TYPE;

908: l_localization_code ak_customizations.localization_code%TYPE;
909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;
915: l_start_date_active ak_customizations.start_date_active%TYPE;
916: l_end_date_active ak_customizations.end_date_active%TYPE;

Line 913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;

909: l_org_id ak_customizations.org_id%TYPE;
910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;
915: l_start_date_active ak_customizations.start_date_active%TYPE;
916: l_end_date_active ak_customizations.end_date_active%TYPE;
917:

Line 914: l_customization_level_id ak_customizations.customization_level_id%TYPE;

910: l_site_id ak_customizations.site_id%TYPE;
911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;
915: l_start_date_active ak_customizations.start_date_active%TYPE;
916: l_end_date_active ak_customizations.end_date_active%TYPE;
917:
918: BEGIN

Line 915: l_start_date_active ak_customizations.start_date_active%TYPE;

911: l_responsibility_id ak_customizations.responsibility_id%TYPE;
912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;
915: l_start_date_active ak_customizations.start_date_active%TYPE;
916: l_end_date_active ak_customizations.end_date_active%TYPE;
917:
918: BEGIN
919:

Line 916: l_end_date_active ak_customizations.end_date_active%TYPE;

912: l_web_user_id ak_customizations.web_user_id%TYPE;
913: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
914: l_customization_level_id ak_customizations.customization_level_id%TYPE;
915: l_start_date_active ak_customizations.start_date_active%TYPE;
916: l_end_date_active ak_customizations.end_date_active%TYPE;
917:
918: BEGIN
919:
920: OPEN C_get_last_update_info;

Line 952: FROM ak_customizations

948: ,l_default_customization_flag
949: ,l_customization_level_id
950: ,l_start_date_active
951: ,l_end_date_active
952: FROM ak_customizations
953: WHERE CUSTOMIZATION_APPLICATION_ID = p_customization_application_id
954: AND CUSTOMIZATION_CODE = p_customization_code
955: AND REGION_APPLICATION_ID = p_region_application_id
956: AND REGION_CODE = p_region_code

Line 959: AK_CUSTOMIZATIONS_PKG.UPDATE_ROW

955: AND REGION_APPLICATION_ID = p_region_application_id
956: AND REGION_CODE = p_region_code
957: AND CUSTOMIZATION_LEVEL_ID = p_customization_level_id;
958:
959: AK_CUSTOMIZATIONS_PKG.UPDATE_ROW
960: (
961: X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
962: X_CUSTOMIZATION_CODE => p_customization_code,
963: X_REGION_APPLICATION_ID => p_region_application_id,

Line 1881: l_last_update_login ak_customizations.last_update_login%TYPE;

1877: ,x_return_status OUT NOCOPY VARCHAR2
1878: ,x_msg_data OUT NOCOPY VARCHAR2
1879: ) IS
1880:
1881: l_last_update_login ak_customizations.last_update_login%TYPE;
1882: l_last_update_date ak_customizations.last_update_date%TYPE;
1883: l_last_updated_by ak_customizations.last_updated_by%TYPE;
1884:
1885: CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS

Line 1882: l_last_update_date ak_customizations.last_update_date%TYPE;

1878: ,x_msg_data OUT NOCOPY VARCHAR2
1879: ) IS
1880:
1881: l_last_update_login ak_customizations.last_update_login%TYPE;
1882: l_last_update_date ak_customizations.last_update_date%TYPE;
1883: l_last_updated_by ak_customizations.last_updated_by%TYPE;
1884:
1885: CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS
1886: SELECT last_updated_by, last_update_date

Line 1883: l_last_updated_by ak_customizations.last_updated_by%TYPE;

1879: ) IS
1880:
1881: l_last_update_login ak_customizations.last_update_login%TYPE;
1882: l_last_update_date ak_customizations.last_update_date%TYPE;
1883: l_last_updated_by ak_customizations.last_updated_by%TYPE;
1884:
1885: CURSOR c_get_last_update_info (cp_property_name IN VARCHAR2) IS
1886: SELECT last_updated_by, last_update_date
1887: FROM ak_custom_regions_tl