APPS.CZ_UIOA_PVT dependencies on CZ_UI_IMAGES

Line 1944: INSERT INTO CZ_UI_IMAGES

1940: --
1941: PROCEDURE refresh_UI_Images(p_ui_def_id IN NUMBER, p_master_template_id IN NUMBER) IS
1942: BEGIN
1943:
1944: INSERT INTO CZ_UI_IMAGES
1945: (UI_DEF_ID
1946: ,MASTER_TEMPLATE_FLAG
1947: ,IMAGE_USAGE_CODE
1948: ,IMAGE_FILE

Line 1962: FROM CZ_UI_IMAGES a

1958: ,DELETED_FLAG
1959: ,G_NO_FLAG
1960: ,ENTITY_CODE
1961: ,-UID
1962: FROM CZ_UI_IMAGES a
1963: WHERE ui_def_id=p_master_template_id
1964: AND deleted_flag=G_NO_FLAG AND
1965: NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES
1966: WHERE ui_def_id=p_ui_def_id AND

Line 1965: NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES

1961: ,-UID
1962: FROM CZ_UI_IMAGES a
1963: WHERE ui_def_id=p_master_template_id
1964: AND deleted_flag=G_NO_FLAG AND
1965: NOT EXISTS(SELECT NULL FROM CZ_UI_IMAGES
1966: WHERE ui_def_id=p_ui_def_id AND
1967: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
1968: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);
1969: /*

Line 1970: UPDATE CZ_UI_IMAGES a

1966: WHERE ui_def_id=p_ui_def_id AND
1967: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
1968: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);
1969: /*
1970: UPDATE CZ_UI_IMAGES a
1971: SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES
1972: WHERE ui_def_id=p_master_template_id AND
1973: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
1974: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG )

Line 1971: SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES

1967: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
1968: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG);
1969: /*
1970: UPDATE CZ_UI_IMAGES a
1971: SET IMAGE_FILE=(SELECT IMAGE_FILE FROM CZ_UI_IMAGES
1972: WHERE ui_def_id=p_master_template_id AND
1973: IMAGE_USAGE_CODE=a.IMAGE_USAGE_CODE AND
1974: ENTITY_CODE=a.ENTITY_CODE AND deleted_flag=G_NO_FLAG )
1975: WHERE ui_def_id=p_ui_def_id AND deleted_flag=G_NO_FLAG;