APPS.AD_FILE_UTIL dependencies on AD_TIMESTAMPS

Line 810: -- Inserts/updates a row in AD_TIMESTAMPS corresponding to the

806: -- Procedure
807: -- update_timestamp
808: --
809: -- Purpose
810: -- Inserts/updates a row in AD_TIMESTAMPS corresponding to the
811: -- specified row type and attribute.
812: --
813: -- Arguments
814: -- in_type The row type

Line 827: -- Updates/Inserts the row in AD_TIMESTAMPS for the specified

823: (in_type in varchar2,
824: in_attribute in varchar2,
825: in_timestamp in date)
826: --
827: -- Updates/Inserts the row in AD_TIMESTAMPS for the specified
828: -- type and attribute
829: --
830: is
831: begin

Line 835: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||

831: begin
832: --
833: -- First try to update
834: --
835: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||
836: 'set timestamp = '||in_timestamp||
837: 'where type = '||in_type||
838: 'and attribute = '||in_attribute||'):(';
839: begin

Line 840: update ad_timestamps

836: 'set timestamp = '||in_timestamp||
837: 'where type = '||in_type||
838: 'and attribute = '||in_attribute||'):(';
839: begin
840: update ad_timestamps
841: set timestamp = in_timestamp
842: where type = in_type
843: and attribute = in_attribute;
844: exception

Line 857: 'insert into ad_timestamps'||

853: --
854: -- Insert if no rows updated
855: --
856: ad_file_util.error_buf := 'update_timestamp('||
857: 'insert into ad_timestamps'||
858: '(type, attribute, timestamp)'||
859: 'values ('||in_type||', '||in_attribute||
860: ', '||in_timestamp||'):(';
861:

Line 863: insert into ad_timestamps

859: 'values ('||in_type||', '||in_attribute||
860: ', '||in_timestamp||'):(';
861:
862: begin
863: insert into ad_timestamps
864: (type, attribute, timestamp)
865: values (in_type, in_attribute, in_timestamp);
866: exception
867: when others then