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 855: AK_CUSTOMIZATIONS_PKG.DELETE_ROW

851: AND RF_REGION_CODE = X_REGION_CODE;
852:
853: IF (l_count = 0) THEN
854:
855: AK_CUSTOMIZATIONS_PKG.DELETE_ROW
856: (
857: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
858: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
859: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 930: FROM ak_customizations_tl

926: ) IS
927:
928: CURSOR c_get_last_update_info IS
929: SELECT last_updated_by, last_update_date
930: FROM ak_customizations_tl
931: WHERE customization_application_id = p_customization_application_id
932: AND customization_code = p_customization_code
933: AND region_application_id = p_region_application_id
934: AND region_code = p_region_code

Line 937: l_last_update_date ak_customizations.last_update_date%TYPE;

933: AND region_application_id = p_region_application_id
934: AND region_code = p_region_code
935: AND USERENV('LANG') IN (language, source_lang);
936:
937: l_last_update_date ak_customizations.last_update_date%TYPE;
938: l_last_updated_by ak_customizations.last_updated_by%TYPE;
939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;

Line 938: l_last_updated_by ak_customizations.last_updated_by%TYPE;

934: AND region_code = p_region_code
935: AND USERENV('LANG') IN (language, source_lang);
936:
937: l_last_update_date ak_customizations.last_update_date%TYPE;
938: l_last_updated_by ak_customizations.last_updated_by%TYPE;
939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;

Line 939: l_verticalization_id ak_customizations.verticalization_id%TYPE;

935: AND USERENV('LANG') IN (language, source_lang);
936:
937: l_last_update_date ak_customizations.last_update_date%TYPE;
938: l_last_updated_by ak_customizations.last_updated_by%TYPE;
939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;

Line 940: l_localization_code ak_customizations.localization_code%TYPE;

936:
937: l_last_update_date ak_customizations.last_update_date%TYPE;
938: l_last_updated_by ak_customizations.last_updated_by%TYPE;
939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;

Line 941: l_org_id ak_customizations.org_id%TYPE;

937: l_last_update_date ak_customizations.last_update_date%TYPE;
938: l_last_updated_by ak_customizations.last_updated_by%TYPE;
939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;

Line 942: l_site_id ak_customizations.site_id%TYPE;

938: l_last_updated_by ak_customizations.last_updated_by%TYPE;
939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;

Line 943: l_responsibility_id ak_customizations.responsibility_id%TYPE;

939: l_verticalization_id ak_customizations.verticalization_id%TYPE;
940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;
947: l_start_date_active ak_customizations.start_date_active%TYPE;

Line 944: l_web_user_id ak_customizations.web_user_id%TYPE;

940: l_localization_code ak_customizations.localization_code%TYPE;
941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;
947: l_start_date_active ak_customizations.start_date_active%TYPE;
948: l_end_date_active ak_customizations.end_date_active%TYPE;

Line 945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;

941: l_org_id ak_customizations.org_id%TYPE;
942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;
947: l_start_date_active ak_customizations.start_date_active%TYPE;
948: l_end_date_active ak_customizations.end_date_active%TYPE;
949:

Line 946: l_customization_level_id ak_customizations.customization_level_id%TYPE;

942: l_site_id ak_customizations.site_id%TYPE;
943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;
947: l_start_date_active ak_customizations.start_date_active%TYPE;
948: l_end_date_active ak_customizations.end_date_active%TYPE;
949:
950: BEGIN

Line 947: l_start_date_active ak_customizations.start_date_active%TYPE;

943: l_responsibility_id ak_customizations.responsibility_id%TYPE;
944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;
947: l_start_date_active ak_customizations.start_date_active%TYPE;
948: l_end_date_active ak_customizations.end_date_active%TYPE;
949:
950: BEGIN
951:

Line 948: l_end_date_active ak_customizations.end_date_active%TYPE;

944: l_web_user_id ak_customizations.web_user_id%TYPE;
945: l_default_customization_flag ak_customizations.default_customization_flag%TYPE;
946: l_customization_level_id ak_customizations.customization_level_id%TYPE;
947: l_start_date_active ak_customizations.start_date_active%TYPE;
948: l_end_date_active ak_customizations.end_date_active%TYPE;
949:
950: BEGIN
951:
952: OPEN C_get_last_update_info;

Line 984: FROM ak_customizations

980: ,l_default_customization_flag
981: ,l_customization_level_id
982: ,l_start_date_active
983: ,l_end_date_active
984: FROM ak_customizations
985: WHERE CUSTOMIZATION_APPLICATION_ID = p_customization_application_id
986: AND CUSTOMIZATION_CODE = p_customization_code
987: AND REGION_APPLICATION_ID = p_region_application_id
988: AND REGION_CODE = p_region_code

Line 991: AK_CUSTOMIZATIONS_PKG.UPDATE_ROW

987: AND REGION_APPLICATION_ID = p_region_application_id
988: AND REGION_CODE = p_region_code
989: AND CUSTOMIZATION_LEVEL_ID = p_customization_level_id;
990:
991: AK_CUSTOMIZATIONS_PKG.UPDATE_ROW
992: (
993: X_CUSTOMIZATION_APPLICATION_ID => p_customization_application_id,
994: X_CUSTOMIZATION_CODE => p_customization_code,
995: X_REGION_APPLICATION_ID => p_region_application_id,

Line 1913: l_last_update_login ak_customizations.last_update_login%TYPE;

1909: ,x_return_status OUT NOCOPY VARCHAR2
1910: ,x_msg_data OUT NOCOPY VARCHAR2
1911: ) IS
1912:
1913: l_last_update_login ak_customizations.last_update_login%TYPE;
1914: l_last_update_date ak_customizations.last_update_date%TYPE;
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

Line 1914: l_last_update_date ak_customizations.last_update_date%TYPE;

1910: ,x_msg_data OUT NOCOPY VARCHAR2
1911: ) IS
1912:
1913: l_last_update_login ak_customizations.last_update_login%TYPE;
1914: l_last_update_date ak_customizations.last_update_date%TYPE;
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

Line 1915: l_last_updated_by ak_customizations.last_updated_by%TYPE;

1911: ) IS
1912:
1913: l_last_update_login ak_customizations.last_update_login%TYPE;
1914: l_last_update_date ak_customizations.last_update_date%TYPE;
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