APPS.CZ_UIOA_PVT dependencies on CZ_UI_IMAGES

Line 2006: INSERT INTO CZ_UI_IMAGES

2002: --
2003: PROCEDURE refresh_UI_Images(p_ui_def_id IN NUMBER, p_master_template_id IN NUMBER) IS
2004: BEGIN
2005:
2006: INSERT INTO CZ_UI_IMAGES
2007: (UI_DEF_ID
2008: ,MASTER_TEMPLATE_FLAG
2009: ,IMAGE_USAGE_CODE
2010: ,IMAGE_FILE

Line 2024: FROM CZ_UI_IMAGES a

2020: ,DELETED_FLAG
2021: ,G_NO_FLAG
2022: ,ENTITY_CODE
2023: ,-UID
2024: FROM CZ_UI_IMAGES a
2025: WHERE ui_def_id=p_master_template_id
2026: AND deleted_flag=G_NO_FLAG AND
2027: NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES
2028: WHERE ui_def_id=p_ui_def_id AND

Line 2027: NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES

2023: ,-UID
2024: FROM CZ_UI_IMAGES a
2025: WHERE ui_def_id=p_master_template_id
2026: AND deleted_flag=G_NO_FLAG AND
2027: NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES
2028: WHERE ui_def_id=p_ui_def_id AND
2029: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
2030: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);
2031: /*

Line 2032: UPDATE CZ_UI_IMAGES a

2028: WHERE ui_def_id=p_ui_def_id AND
2029: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
2030: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);
2031: /*
2032: UPDATE CZ_UI_IMAGES a
2033: SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES
2034: WHERE ui_def_id=p_master_template_id AND
2035: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
2036: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG )

Line 2033: SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES

2029: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
2030: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);
2031: /*
2032: UPDATE CZ_UI_IMAGES a
2033: SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES
2034: WHERE ui_def_id=p_master_template_id AND
2035: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
2036: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG )
2037: WHERE ui_def_id=p_ui_def_id AND deleted_flag=G_NO_FLAG;