1893:
1894: begin
1895: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1896: into db_luby, db_ludate
1897: from FND_HISTOGRAM_COLS
1898: where APPLICATION_ID = appl_id
1899: and TABLE_NAME = x_table_name
1900: and COLUMN_NAME = x_column_name;
1901:
1901:
1902: if (upload_test(f_luby, f_ludate, db_luby,
1903: db_ludate, X_CUSTOM_MODE)) then
1904:
1905: update FND_HISTOGRAM_COLS set
1906: PARTITION = x_partition,
1907: HSIZE = x_hsize,
1908: LAST_UPDATED_BY = f_luby,
1909: LAST_UPDATE_DATE = f_ludate,
1913: and COLUMN_NAME = x_column_name;
1914: end if;
1915: exception
1916: when no_data_found then
1917: insert into FND_HISTOGRAM_COLS (
1918: APPLICATION_ID,
1919: TABLE_NAME,
1920: COLUMN_NAME,
1921: PARTITION,
1984:
1985: begin
1986: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1987: into db_luby, db_ludate
1988: from FND_HISTOGRAM_COLS
1989: where APPLICATION_ID = appl_id
1990: and TABLE_NAME = x_table_name
1991: and COLUMN_NAME = x_column_name
1992: and OWNER =x_mview_owner;
1994:
1995: if (upload_test(f_luby, f_ludate, db_luby,
1996: db_ludate, X_CUSTOM_MODE)) then
1997:
1998: update FND_HISTOGRAM_COLS set
1999: PARTITION = x_partition,
2000: HSIZE = x_hsize,
2001: LAST_UPDATED_BY = f_luby,
2002: LAST_UPDATE_DATE = f_ludate,
2007: and OWNER =x_mview_owner;
2008: end if;
2009: exception
2010: when no_data_found then
2011: insert into FND_HISTOGRAM_COLS (
2012: APPLICATION_ID,
2013: TABLE_NAME,
2014: COLUMN_NAME,
2015: PARTITION,