APPS.AD_FILE_UTIL dependencies on AD_TIMESTAMPS

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

872: -- Procedure
873: -- update_timestamp
874: --
875: -- Purpose
876: -- Inserts/updates a row in AD_TIMESTAMPS corresponding to the
877: -- specified row type and attribute.
878: --
879: -- Arguments
880: -- in_type The row type

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

889: (in_type in varchar2,
890: in_attribute in varchar2,
891: in_timestamp in date)
892: --
893: -- Updates/Inserts the row in AD_TIMESTAMPS for the specified
894: -- type and attribute
895: --
896: is
897: begin

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

897: begin
898: --
899: -- First try to update
900: --
901: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||
902: 'set timestamp = '||in_timestamp||
903: 'where type = '||in_type||
904: 'and attribute = '||in_attribute||'):(';
905: begin

Line 906: update ad_timestamps

902: 'set timestamp = '||in_timestamp||
903: 'where type = '||in_type||
904: 'and attribute = '||in_attribute||'):(';
905: begin
906: update ad_timestamps
907: set timestamp = in_timestamp
908: where type = in_type
909: and attribute = in_attribute;
910: exception

Line 923: 'insert into ad_timestamps'||

919: --
920: -- Insert if no rows updated
921: --
922: ad_file_util.error_buf := 'update_timestamp('||
923: 'insert into ad_timestamps'||
924: '(type, attribute, timestamp)'||
925: 'values ('||in_type||', '||in_attribute||
926: ', '||in_timestamp||'):(';
927:

Line 929: insert into ad_timestamps

925: 'values ('||in_type||', '||in_attribute||
926: ', '||in_timestamp||'):(';
927:
928: begin
929: insert into ad_timestamps
930: (type, attribute, timestamp)
931: values (in_type, in_attribute, in_timestamp);
932: exception
933: when others then